java链接excel

   import   java.io.*;   
   import   java.sql.*;   
     
   public   class   TestExcel{   
   public   static   void   main(String[]   args){   
   try{   
   //Load   JDBC   driver   
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");   
   String   dbUrl   =   "jdbc:odbc:driver={Microsoft Excel Driver (*.xls)};DBQ=D:\\123.xls";   
     

   Connection   con   =   DriverManager.getConnection(dbUrl,"","");         
   Statement   state   =   con.createStatement();    
   String   sql   =   "Select   *   From   [sheet1$]";   
   ResultSet   rs   =   state.executeQuery(sql);   
   if(   rs   !=   null   ){   
       while(   rs.next()   ){   
       System.out.println(rs.getString(1)+"\t"+rs.getString(2)+"\t"+rs.getString(3));   
       }   
       rs.close();   
   }   
   state.close();   
   con.close();   
   }catch(Exception   e){e.printStackTrace();}   
   }   
   }//

评论

1 楼 diaoxiong45 2010-03-16  

所用到的jar包是什么?我现在急需用..