å®ç°æè·¯:
ç´æ¥ä»Excelæ件è£
æ¢æXMLæ件æ¯å¯ä»¥å®ç°ç,è¿éæéç¨ä¸ä¸ªä¸é´è£
æ¢,ä¹å°±æ¯å
å®ç°excelæ件å
容æ¾å
¥å®ç°è®¾è®¡å¥½çaccessæ°æ®åºæ件ä¸,ç¶ååä»accessä¸è¯»åè®°å½åéxmlæ件ä¸,å 为æè¿éçå®é
é®é¢æ¯æå¤ä¸ªexcel表,æ¯ä¸ªè¡¨ä¸åæå¤ä¸ªsheetå·¥ä½è,è¿æ ·æå
导å
¥æ°æ®åºä¸,ä¹æ¹ä¾¿ä¿®æ¹åå¤ç.
è¿æ ·,éè¦å两个类:
XlsToAccessç±»,ç¨æ¥å®ç°ä»excelæä»¶æ ¹æ®äºå
约å®çæ ¼å¼,æç
§æ°æ®åºè®¾è®¡å段åæ¾è¿å»
AccessToXmlç±»,ç¨æ¥å®ç°ä»accessæ件æ°æ®åºä¸çè®°å½æ约å®æ ¼å¼åå°xmlæ件ä¸å»
ç¶åè¿éè¦ä¸ä¸ªä¸»è¿è¡çªå£ç±»XlsToXml,è¿ä¸ªç±»æ们使ç¨eclipseæ件SWT Designeræ¥å®æ
æåæå·¥ç¨ææJARå
,åç¨NativeJå°Jarå
çæ为å¯æ§è¡çexeæ件
å¼åå·¥å
·:
Eclipse3.1.2 for window
SWT Designer5.0.0 for Eclipse3.1.x
NativeJç¼è¯å¯æ§è¡æ件
å¼åç¯å¢:Microsoft Windows XP sp2 Home æè
Professional
å
¶ä»:
åå¤excelæ件,æ¾å°D:/tempä¸,åå为test.xls
åå¤accessæ件,设计表å为custom,å个å段,åæ¯ææ¬ç±»å,å段åå¯ä»¥èªå·±å®,å¨xmlæ件ä¸ä¼ç¨å段åä½ä¸ºèç¹å,åæ ·æ¾å°D:/tempä¸,åå为test.mdb
æ工建ç«ä¸ä¸ªODBC,å¨ç³»ç»DSNä¸å»ºç«ä¸ä¸ªå为asimaçæ°æ®æº,æ°æ®åºæ件就æåD:/tempçtest.mdb
éè¦å®è£
ä¸ä¸ªJRE runtimeè¿è¡ç¯å¢,è¿ä¸ªå¯ä»¥ä»Sunå
¬å¸ç½ç«ä¸ä¸å°
1. å®è£
Eclipse3.1.2
å 为Eclipse3.1.Xçæ¬è¦æ±çJavaçæ¬æ¯1.4.1å以ä¸ï¼å¦æè¿è¡Eclipse.exeç³»ç»æ示é误ï¼å¦å¾
é£ä¹å¯ä»¥å¨Eclipse.exeç®å½ä¸æ°å»ºä¸ä¸ªauto.batï¼å
容为ï¼
set JAVA_HOME=c:/java1.4.2/ï¼
set PATH=c:/java1.4.2/bin/;
eclipse.exe
è¿æ ·ç´æ¥è¿è¡auto.batæ件就å¯ä»¥è¿è¡eclipseäº
2. å®è£
Eclipseæ件SWT Designer_v5.0.0
ä»ç½ç«å°åï¼
http://www.swt-designer.comå¯ä»¥ä¸è½½å°å¯¹åºçæ¬ï¼è§£ååçç®å½pluginsä¸ç两个åç®å½ï¼åå«å¤å¶å°Eclipseçfeaturesåpluginsç®å½ä¸è¿æ ·å°±å¯ä»¥äº(æè
åèeclipseæ件çå®è£
)
æå¼Eclipseï¼File->New->otherä¸æ们å¯ä»¥çå°Designer项ï¼é£ä¹è¯´æè¿ä¸ªæ件å®è£
æåäºï¼å¦æçä¸å°ï¼å°è¯å¨auto.batå¨Eclipseåå å
¥åæ°cleanï¼å³eclipse -cleanï¼ï¼éè¦è¿è¡æ³¨åï¼å¦ææºå¨ä¸è½ä¸ç½ï¼å°ä¸å°æ³¨åè¿çæºå¨ä¸æC:/Documents and Settings/[username]/Instantiations.licenseå¤å¶ç²è´´å°å¯¹åºçç®å½ä¸
3. æ°å»ºä¸ä¸ªSWT/JFace Java Projectå·¥ç¨
æå¼Eclipseï¼File->New->Otherï¼å¨å¼¹åºççªå£ä¸æ¾å°Designerï¼è¿è¯´æå®è£
ä¸è¿°æ件æåï¼ï¼åéæ©SWT/JFace Java Project
å¨ProjectNameä¸è¾å
¥xlstoxmlï¼ç¶åå¨Project layoutä¸éæ©Create separate source and output folders(è¿æ ·å¯ä»¥æjavaæ件åclassæ件å离å¼ï¼æ¹ä¾¿æ们对æºä»£ç çå¤ç)
Next->ï¼ç¶åfinishï¼å³è¾¹çèµæºè¯å¾ä¸å¦å¾
4. æ·»å å 个读åexcelååxmléè¦çjarå
å¨xlstoxml项ç®ä¸æ°å»ºä¸ä¸ªfolderï¼åålibï¼å¨æ¤folderä¸importå个jarå
ï¼éæ©Archive fileï¼ï¼åå«æ¯jdom.jarï¼çæxmléè¦ä½¿ç¨çï¼ï¼ä¸ä¸ªæä½excel表çjarå
ï¼
poi-3.0-alpha1-20050704.jarãpoi-contrib-3.0-alpha1-20050704.jarã
poi-scratchpad-3.0-alpha1-20050704.jarï¼ï¼è¿ä¸æ¥ä¸ä¸å®éè¦å¯¼å
¥å°æ°å»ºçlibä¸æ¥ï¼è¿æ ·åå¢åªæ¯è½æ¹ä¾¿ç®¡çèªå·±çè¿äºlibå
ï¼ä»¥ä¸æä½ææ¯å
³é®ï¼
å¨xlstoxml项ç®ä¸ï¼å³é®->Build Path->Add External Archivesï¼ï¼ä¹å¯ä»¥å¨Librariesä¸ï¼ç¹ä¸Add External JARSâ¦ï¼å å
¥è¿å个jarå
ï¼è¿å¾å
³é®
5. å建packageå
ï¼å»ºç«classæ件
å®æexcelæ件转æ¢æxmlæ ¼å¼çæ件ï¼æè·¯æ¯å°excelæ件ä¸çå
容读å
¥å°Accessæ件ä¸ï¼ç¶ååä»Accessæ件ä¸åå
¥å°xmlæ件éï¼é£ä¹é¤äºä¸»è¿è¡çªå£ç±»å¤ï¼è¿éè¦è¿ä¸ªç±»åå«å®æ以ä¸ä¸¤æ¥
å¨srcç®å½ä¸å³é®->New->Packageï¼å¨æ°å¼¹åºççªå£ä¸Nameè¾å
¥com.asimaï¼ç¶ååå¨æ¤packageä¸å³é®->New->Classï¼æ°å¼¹åºççªå£ä¸Nameå¤è¾å
¥XlsToAccessï¼ä¸è¦å¾épublic static void main(String[] args)ï¼ç¶åfinish
ææ¤æ¹æ³å建ç«ä¸ä¸ªç±»åå为åAccessToXml
6. å建Application Window
å¨com.asimaä¸å³é®->New->Designer->SWT->Application Windowï¼å¼¹åºçNameä¸è¾å
¥XlsToXmlï¼å¾épublic static main() methodï¼finish