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 ......
ΪÁË˵Ã÷Õâ¸öÎÊÌâÏȸø´ó¼Ò³ö¸öÎÊÌâ°É£º
Çë¿´´úÂ룺
public abstract class A {
public A() {
initMethod();
}
public abstract void initMethod();
}
public class B extends A {
static String staticStr = "static1";
private String testStr = "Test1";
/*
* (non-Javadoc)
*
* @see A#in ......
Ó¦ÓóÌÐò·þÎñÆ÷ÊÇÒ»¸ö Java ½ø³Ì£¬ËüÐèÒª Java ÐéÄâ»ú£¨JVM£©²ÅÄÜÔËÐÐÒÔ¼°Ö§³ÖËüËùÔËÐÐµÄ Java Ó¦ÓóÌÐò¡£ÔÚÅäÖÃÓ¦ÓóÌÐò·þÎñÆ÷µÄ¹ý³ÌÖУ¬¿ÉÒÔ¶ÔÉèÖýøÐÐ΢µ÷ÒÔ¸ÄÉÆϵͳ¶Ô JVM µÄʹÓ÷½Ê½¡£
¹ØÓÚ±¾ÈÎÎñ
JVM Ϊ»ùÓÚ Java µÄÓ¦ÓóÌÐòÌṩÁËÔËÐÐʱִÐл·¾³¡£WebSphere Application Server ÊÇ JVM ÔËÐÐʱ»·¾³Óë»ùÓÚ Java µÄ ......
ÒòΪÏîÄ¿ÓиöÐèÇó£¬ÒªÇóÄܹ»ÔÚij¸öÔ¤¶¨Ê±¼ä¶ÔÌض¨±¨±í½øÐÐ×Ô¶¯´òÓ¡¡£±¨±íµÄÐÎʽÖ÷ÒªÊÇexcel¡£Èç¹ûÊÇc++»òÕßc#ʲôµÄ£¬¼òÖ±ÊÇС²ËÒ»µú¡£¿Éϧ£¬Æ«Æ«ÊÇjavaʵÏÖ¡£²¢ÇÒ£¬ÕâÓÖ²»Í¬ÓÚ³£¼ûµÄÒ³ÃæÊÖ¹¤´òÓ¡£¬¿ÉÒÔͨ¹ýjavascriptµ÷ÓôòÓ¡»úÀ´ÊµÏÖ¡£ÓÚÊǺõ£¬¿ªÊ¼ÃþË÷ÈçºÎʵÏָù¦ÄÜ¡£
Ê×Ï ......
Ḭ̈߳²È«µÄ¼¯ºÏ°üº¬2¸öÎÊÌâ
1.¶àÏ̲߳¢·¢ÐÞ¸ÄÒ» ¸ö ¼¯ºÏ Ôõô°ì£¿
2.Èç¹ûµü´úµÄ¹ý³ÌÖÐ ¼¯ºÏ ±»ÐÞ¸ÄÁËÔõô°ì£¿
a.Ò»¸öÏß³ÌÔÚµü´ú£¬ÁíÒ»¸öÏß³ÌÔÚÐÞ¸Ä
b.ÔÚͬһ¸öÏß³ÌÄÚÓÃͬһ¸öµü´úÆ÷¶ ......