Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

java ʵÏÖxlsÎļþתxml

package com.dongyang;
/*
 * ¶Áxlsдxml
 */
import java.io.FileOutputStream;
 
import java.io.FileInputStream;  
 
import java.io.InputStream;  
import org.jdom.Document;
import org.jdom.Element;
import org.jdom.output.XMLOutputter;
 
import jxl.Cell;  
 
import jxl.Sheet;  
 
import jxl.Workbook;  
 
public class Excel2xml   
 
{  
 
  public static void main(String[] args)   
 
    {  
      Excel2xml e = new Excel2xml();
      e.ret();
    }  
 
  public void ret(){
     
      jxl.Workbook readwb = null;  
     
      try   
      {  
          //¹¹½¨Workbook¶ÔÏó, Ö»¶ÁWorkbook¶ÔÏó  
          //Ö±½Ó´Ó±¾µØÎļþ´´½¨Workbook  
          InputStream instream = new FileInputStream("E:/123.xls");  
          readwb = Workbook.getWorkbook(instream);  
          //SheetµÄϱêÊÇ´Ó0¿ªÊ¼  
          //»ñÈ¡µÚÒ»ÕÅSheet±í  
          Sheet readsheet = readwb.getSheet(0);  
          //»ñÈ¡Sheet±íÖÐËù°üº¬µÄ×ÜÁÐÊý  
          int rsColumns = readsheet.getColumns();  
         //»ñÈ


Ïà¹ØÎĵµ£º

javaÖÐ thisÓ÷¨

±ØÐëÓÃthis¹Ø¼ü×ÖµÄÈýÖÖÇé¿ö:
1.ÎÒÃÇÏëͨ¹ý¹¹Ôì·½·¨½«Íⲿ´«ÈëµÄ²ÎÊý¸³Öµ¸ø³ÉÔ±±äÁ¿,¶ø¹¹Ôì·½·¨µÄÐÎʽ²ÎÊýÓëÀà³ÉÔ±µÄ±äÁ¿ÃûÏàͬ,Õâʱ¾ÍÐèÒªthisÕâ¸ö¹Ø¼ü×ÖÀ´Çø±ð¾Ö²¿±äÁ¿ÓëÀà±äÁ¿;
2.¼ÙÉèÓÐÒ»¸öÈÝÆ÷ÀàºÍÒ»¸ö²¿¼þÀà,ÔÚÈÝÆ÷ÀàµÄij¸ö·½·¨ÖÐÒª´´½¨²¿¼þÀàµÄʵÀý¶ÔÏó,¶ø²¿¼þÀàµÄ¹¹Ôì·½·¨Òª½ÓÊÕÒ»¸ö´ú±íÆäËùÔÚÈÝÆ÷µÄ²ÎÊý,ÕâÊ±Ò²Ò ......

java server2000Á¬½ÓÊý¾Ý¿â

 Ìõ¼þ£ºÒѰ²×°J2SEºÍJ2EE¡£
Microsoft SQL Server 2000 Driver for JDBCÊÇ΢Èí¹«Ë¾Ãâ·ÑÌṩÃâ·ÑÏÂÔØµÄÒ»¸öÈí¼þ£¬Çë·ÃÎÊ£º http://www.microsoft.com/sql/default.asp£¬ÏÂÔØºóÎļþÃûΪ£ºsetup.exe£¬°²×°ºó£¬Ä¬ÈÏ·¾¶ÊÇ£º%Program Files%\Microsoft SQL Server 2000 Driver for JDBC£¬¸ÃĿ¼ÏÂLIBĿ¼ÀïÓÐ3¸öjarÎļþ¡£ ......

javaÈçºÎ´Ó¿ØÖÆÌ¨»ñµÃÒ»ÐÐÊäÈë

  /**
  *
  * @param par
  *            ÈëÁ¦Ãû
  * @return ÈëÁ¦値
  */
 public static String inputfromConsole(String par) {
  System.out.println(par);
  InputStreamReader ......

java¹ýÂËÆ÷¶ÔextÒì²½ÇëÇóÌø×ª

 1.java¹ýÂËÆ÷¶ÔextÒì²½ÇëÇóÌø×ª
Óû§·ÃÎʳ¬Ê±
½â¾öÁ½ÖÖÇé¿öϵÄÓû§·ÃÎʳ¬Ê±¡£
a£©ÆÕͨhttpÇëÇóµÄsession³¬Ê±¡£
b£©Òì²½httpÇëÇóµÄsession³¬Ê±£¬Ê¹ÓÃextºó´ó²¿·ÖµÄ½çÃæË¢Ð¶¼ÊÇÒì²½µÄajaxÇëÇó¡£
²»¹ÜÊÇÄÇÖÖÀàÐ͵ÄhttpÇëÇó×ÜÊÇ¿ÉÒÔÓÉÒ»¸ö¹ýÂËÆ÷À´²¶×½¡£
·ÖÀࣺÆÕͨhttpÇëÇóµÄheader²ÎÊýÖÐûÓÐx-requested-with: ......

java ֪ʶµã×ܽá

//java½âÎö.mdbÎļþµÄ±íÃû¼¯ºÏ 
this.tableList.clear();
  
  conn = null;
  st = null;
  rs = null;
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  String url ="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+dbName;// ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ