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ѧϰ´ÓÈëÃŵ½¾«Í¨
Ò»¡¢ JDK (Java Development Kit)
JDKÊÇÕû¸öJavaµÄºËÐÄ£¬°üÀ¨ÁËJavaÔËÐл·¾³£¨Java Runtime Envirnment£©£¬Ò»¶ÑJava¹¤¾ßºÍJava»ù´¡µÄÀà¿â(rt.jar)¡£²»ÂÛʲôJavaÓ¦Ó÷þÎñÆ÷ʵÖʶ¼ÊÇÄÚÖÃÁËij¸ö°æ±¾µÄJDK¡£Òò´ËÕÆÎÕJDKÊÇѧºÃJavaµÄµÚÒ»²½¡£×îÖ÷Á÷µÄJ ......
±ØÐëÓÃthis¹Ø¼ü×ÖµÄÈýÖÖÇé¿ö:
1.ÎÒÃÇÏëͨ¹ý¹¹Ôì·½·¨½«Íⲿ´«ÈëµÄ²ÎÊý¸³Öµ¸ø³ÉÔ±±äÁ¿,¶ø¹¹Ôì·½·¨µÄÐÎʽ²ÎÊýÓëÀà³ÉÔ±µÄ±äÁ¿ÃûÏàͬ,Õâʱ¾ÍÐèÒªthisÕâ¸ö¹Ø¼ü×ÖÀ´Çø±ð¾Ö²¿±äÁ¿ÓëÀà±äÁ¿;
2.¼ÙÉèÓÐÒ»¸öÈÝÆ÷ÀàºÍÒ»¸ö²¿¼þÀà,ÔÚÈÝÆ÷ÀàµÄij¸ö·½·¨ÖÐÒª´´½¨²¿¼þÀàµÄʵÀý¶ÔÏó,¶ø²¿¼þÀàµÄ¹¹Ôì·½·¨Òª½ÓÊÕÒ»¸ö´ú±íÆäËùÔÚÈÝÆ÷µÄ²ÎÊý,ÕâÊ±Ò²Ò ......
C#´ÓJava¼Ì³Ð¶øÀ´µÄÌØµã
¡¡¡¡Àà:ÔÚC#ÖÐÀàµÄÉêÃ÷ÓëJavaºÜÏàËÆ.ÕâÊǺÏÀíµÄÒòΪ¾Ñ鏿ËßÎÒÃÇJavaÄ£Ð͹¤×÷µÃºÜºÃ.JavaµÄ¹Ø¼ü×ÖimportÒѾ±»Ìæ»»³Éusing,ËüÆðµ½ÁËͬÑùµÄ×÷ÓÃ.Ò»¸öÀ࿪ʼִÐÐµÄÆðµãÊǾ²Ì¬·½·¨Main().ÏÂÃæµÄHello World³ÌÐòչʾÁË»ù±¾µÄÐÎʽ:
¡¡¡¡using System;
¡¡¡¡class Hello
¡¡¡¡{
¡¡¡¡static v ......
µ¥Ì¬¶¨Òå:
SingletonģʽÖ÷Òª×÷ÓÃÊDZ£Ö¤ÔÚJavaÓ¦ÓóÌÐòÖУ¬Ò»¸öÀàClassÖ»ÓÐÒ»¸öʵÀý´æÔÚ¡£
Singletonģʽ¾ÍΪÎÒÃÇÌṩÁËÕâÑùʵÏֵĿÉÄÜ¡£Ê¹ÓÃSingletonµÄºÃ´¦»¹ÔÚÓÚ¿ÉÒÔ½ÚÊ¡Äڴ棬ÒòΪËüÏÞÖÆÁËʵÀýµÄ¸öÊý£¬ÓÐÀûÓÚJavaÀ¬»ø»ØÊÕ£¨garbage col ......
//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;// ......