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

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ÃæÊÔÌ⣨8£©

123¡¢Éè¼Æ4¸öỊ̈߳¬ÆäÖÐÁ½¸öÏß³Ìÿ´Î¶ÔjÔö¼Ó1£¬ÁíÍâÁ½¸öÏ̶߳Ôjÿ´Î¼õÉÙ1¡£Ð´³ö³ÌÐò¡£
ÒÔϳÌÐòʹÓÃÄÚ²¿ÀàʵÏÖỊ̈߳¬¶ÔjÔö¼õµÄʱºòûÓп¼ÂÇ˳ÐòÎÊÌâ¡£
public class ThreadTest1{
   private int j;
   public static void main(String args[]){
ThreadTest1 tt=new ThreadTest1();
Inc inc=tt. ......

JavaÖ®@SuppressWarnings

ÓÃÁËÕâ¸ö£¬MyEclipseÀï¾Í²»»á±¨ÄÇЩ¾¯¸æÁË£¬¿´ÆðÀ´Æ¯ÁÁ¶àÁË
³£Óõģº
@SuppressWarnings("unchecked"),·ºÐÍ
@SuppressWarnings("deprecation"), deprecated·½·¨
@SuppressWarnings(value={"deprecation","unchecked"}) ˫ѡ
@SuppressWarnings("serial"), ÐòÁл¯
......

java½âÎöXMLµÄËÄÖÖ·½·¨

XMLÏÖÔÚÒѾ­³ÉΪһÖÖͨÓõÄÊý¾Ý½»»»¸ñʽ,ËüµÄƽ̨ÎÞ¹ØÐÔ,ÓïÑÔÎÞ¹ØÐÔ,ϵͳÎÞ¹ØÐÔ,¸øÊý¾Ý¼¯³ÉÓë½»»¥´øÀ´Á˼«´óµÄ·½±ã¡£¶ÔÓÚXML±¾ÉíµÄÓ﷨֪ʶÓë¼¼Êõϸ½Ú,ÐèÒªÔĶÁÏà¹ØµÄ¼¼ÊõÎÄÏ×,ÕâÀïÃæ°üÀ¨µÄÄÚÈÝÓÐDOM(Document Object Model),DTD(Document Type Definition),SAX(Simple API for XML),XSD(Xml Schema Definition),XSLT(Exten ......

Java ¼¯ºÏ Ḭ̈߳²È«


Ḭ̈߳²È«µÄ¼¯ºÏ°üº¬2¸öÎÊÌâ   
1.¶àÏ̲߳¢·¢ÐÞ¸ÄÒ» ¸ö ¼¯ºÏ Ôõô°ì£¿   
2.Èç¹ûµü´úµÄ¹ý³ÌÖР¼¯ºÏ ±»ÐÞ¸ÄÁËÔõô°ì£¿   
    a.Ò»¸öÏß³ÌÔÚµü´ú£¬ÁíÒ»¸öÏß³ÌÔÚÐÞ¸Ä   
    b.ÔÚͬһ¸öÏß³ÌÄÚÓÃͬһ¸öµü´úÆ÷¶ ......

java Îļþ¶Áд_FileInputStream_File

package test;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
public class Test {
 public static void main(String arg[]) {
  String fileName = "E:\\share\\test.txt";
  File file = new File(fileName);
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ