Java²Ù×÷excel
×î½ü¹«Ë¾ÒªÇó°ÑexcelµÄÊý¾Ýµ¼Èëµ½Êý¾Ý¿âÖÐÈ¥¡£µ±Ê±Ã»ÔõôÏë¾ÍÖ±½ÓÓÃjava.sql°üϵÄÀà°ÑÊý¾Ý¶Á³öÀ´È»ºóÆ´×°³ÉsqlÓï¾ä£¬Ë³ÀûÍê³ÉÁËÈÎÎñ¡£ºóÀ´ÓõÚÈý·½²å¼þʵÏÖÁ˶Á£¬Ð´£¬ÐÞ¸ÄexcelÎļþ¡£ ÏÖÔÚÄóöÀ´¾ÍºÍ´ó¼Ò·ÖÏí¡£Ï£ÍûÄܹ»ÔÚijÖ̶ֳÈÉϰï´ó¼Ò½â¾öһЩʵ¼ÊÎÊÌâ¡£
µÚÈý·½×é¼þ¿ÉÒÔÔÚ´ËÏÂÔØ£ºhttp://nexcel.sourceforge.net/
Ê×ÏÈÎÒÃÇÏÈÓÃJdbc-OdbcÇÅÁ¬½ÓexcelÎļþ£º
ÏÈÅäÖúÃÊý¾ÝÔ´(ÎҵIJÙ×÷ϵͳÊÇWindows 7Ó¢Îİ棬¿ÉÄܺʹó¼ÒµÄ²»Ò»Ñù)£º¹ÜÀí¹¤¾ß£¨Administrative Tools£©->Êý¾ÝÔ´£¨Data Source ODBC£©->Ìí¼Ó£¨Add£©£¬Ñ¡Ôñ Microsoft do Driver Excel->Íê³É£¨Finish£©->ÌîдÊý¾ÝÔ´Ãû£¨Data Source Name£©->Ñ¡Ôñ¹¤×÷±¡(Select Workbook)ÕÒµ½ÄãµÄexcelÎļþ¾Í¿ÉÒÔÁË¡£ÕâÀï²»¶à˵ÁË£¬´ó¼Ò¿ÉÒÔ²éÕÒÏà¹Ø×ÊÁÏ¡£ÏÂÃæÊÇÎҵIJâÊÔ´úÂ룺
public static void readXLSByJdbcOdbc() {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
//ÕâÀïʹÓÃJdbcOdbcÇÅ
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//newΪÊý¾ÝÔ´Ãû
conn = DriverManager.getConnection("jdbc:odbc:test");
//±íÃ÷ÒªÓÃ[$]À¨ÆðÀ´£¬data¶ÔÓ¦µÄÊÇexcelÖÐsheetÃû
ps = conn.prepareStatement("select * from [Person$]");
rs = ps.executeQuery();
while(rs.next()) {
System.out.println(rs.getLong("uid") + "\t" + rs.getString("Óû§Ãû") + "\t" + rs.getString("pwd"));
}
&n
Ïà¹ØÎĵµ£º
Javaѧϰ´ÓÈëÃŵ½¾«Í¨
Ò»¡¢ JDK (Java Development Kit)
JDKÊÇÕû¸öJavaµÄºËÐÄ£¬°üÀ¨ÁËJavaÔËÐл·¾³£¨Java Runtime Envirnment£©£¬Ò»¶ÑJava¹¤¾ßºÍJava»ù´¡µÄÀà¿â(rt.jar)¡£²»ÂÛʲôJavaÓ¦Ó÷þÎñÆ÷ʵÖʶ¼ÊÇÄÚÖÃÁËij¸ö°æ±¾µÄJDK¡£Òò´ËÕÆÎÕJDKÊÇѧºÃJavaµÄµÚÒ»²½¡£×îÖ÷Á÷µÄJ ......
Ò»£º×¼±¸ www.savarese.org download
1. rocksaw-1.0.0-src.tar.gz
2. vserv-tcpip-0.9.2-src.tar.gz
¶þ£º±àÒëÔ´ÎļþµÃµ½jar°ü ʹÓÃAnt
1. build vserv-tcpip-0.9.2-src
ÔÚvserv-tcpip-0.9.2Ŀ¼ÏÂÃæ½¨Ò»¸ötestsĿ¼£¬È»ºóÔÚcmd´°¿ÚϽøÈë ......
ÀàµÄ³õʼ»¯ºÍ¶ÔÏó³õʼ»¯ÊÇ JVM ¹ÜÀíµÄÀàÐÍÉúÃüÖÜÆÚÖзdz£ÖØÒªµÄÁ½¸ö»·½Ú£¬Google ÁËÒ»±éÍøÂ磬ÓйØÀà×°ÔØ»úÖÆµÄÎÄÕµ¹ÊDz»ÉÙ£¬È»¶øÀà³õʼ»¯ºÍ¶ÔÏó³õʼ»¯µÄÎÄÕ²¢²»¶à£¬ÌرðÊÇ´Ó×Ö½ÚÂëºÍ JVM ²ã´ÎÀ´·ÖÎöµÄÎÄÕ¸üÊÇÏÊÓÐËù¼û¡£
±¾ÎÄÖ÷Òª¶ÔÀàºÍ¶ÔÏó³õʼ»¯È«¹ý³Ì½øÐзÖÎö£¬Í¨¹ýÒ»¸öʵ¼ÊÎÊÌâÒýÈ룬½«Ô´´úÂëת»»³É JVM ×Ö½ÚÂëºó£¬ ......
Ḭ̈߳²È«µÄ¼¯ºÏ°üº¬2¸öÎÊÌâ
1.¶àÏ̲߳¢·¢ÐÞ¸ÄÒ» ¸ö ¼¯ºÏ Ôõô°ì£¿
2.Èç¹ûµü´úµÄ¹ý³ÌÖÐ ¼¯ºÏ ±»ÐÞ¸ÄÁËÔõô°ì£¿
a.Ò»¸öÏß³ÌÔÚµü´ú£¬ÁíÒ»¸öÏß³ÌÔÚÐÞ¸Ä
b.ÔÚͬһ¸öÏß³ÌÄÚÓÃͬһ¸öµü´úÆ÷¶ ......