倾我所有，求段程序；初学java，憋了三天；明天交货，交不出来，会被炒掉；将来有分，一定复赠！

Question

从Excel文件读取数据写入Oracle.

Answer 1

public void readexel(String filename)
{
Connection c = null;
Statement stmnt = null;
try
{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
c = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=" + filename);
stmnt = c.createStatement();
String query = "Select * from [Sheet1$]" ;
ResultSet rs = stmnt.executeQuery( query );while( rs.next() )
{
System.out.println( rs.getString(1) );
}
}
catch( Exception e )
{
System.err.println( e );
}
}
从excel读数据。

Answer 2

import java.sql.Connection; 
import java.sql.Statement; 
import java.sql.ResultSet; 
import java.sql.DriverManager; 
import java.sql.PreparedStatement; 
import java.sql.SQLException; public class InsertData {         public static void main(String[] args){ 
                Connection myConnSDB = null; 
                PreparedStatement psInsertData=null; 
                int InsertData=0; 
                //Regist Oracle JDBC Driver 
                try { 
                        DriverManager.registerDriver(new oracle.jdbc.OracleDriver()); 
                        myConnSDB= 
                                DriverManager.getConnection( 
                                        "jdbc:oracle:thin:@127.0.0.1:1521:MYDB", 
                                        "user", 
                                        "user");                         myConnSDB.setAutoCommit(false);                 } catch (SQLException e) { 
                        e.printStackTrace(); 
                }                 try{ 
                        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
                        Connection con = DriverManager.getConnection( "jdbc:odbc:Book1","","" ); 
                        Statement st = con.createStatement(); 
                        ResultSet rs = st.executeQuery( "SELECT * FROM [Sheet1$]" ); 
                        psInsertData= 
                                                                 myConnSDB.prepareStatement(" INSERT INTO TMP_TABLE"+                                                                                                                        " (ACTION_ID,TIMESTAMP,USERID,USERNAME,ISSUE,ACTION)"+                                                                                                                        "  VALUES "+                                                                                                                        " (?,?,?,?,?,?) ");                 
                               while (rs.next()) { 
                                        psInsertData.clearParameters(); 
                                        psInsertData.setString(1,rs.getString(1)); 
                                        psInsertData.setString(2,rs.getString(2)); 
                                        psInsertData.setString(3,rs.getString(3)); 
                                        psInsertData.setString(4,rs.getString(4)); 
                                        psInsertData.setString(5,rs.getString(5)); 
                                        psInsertData.setString(6,rs.getString(6)); 
                                        InsertData=InsertData+psInsertData.executeUpdate();                                                             } 
                        System.out.println(""+InsertData); 
                        st.close(); 
                        con.close(); 
                }catch (Exception ex) 
           { 
                   System.err.print("Exception: "); 
                   System.err.println(ex.getMessage()); 
                   ex.printStackTrace(); 
           } finally 
                   { 
                         try 
                         { 
                                if (psInsertData!= null) 
                           { 
                                psInsertData.close(); 
                           } 
                                if (myConnSDB != null) 
                           { 
                                 myConnSDB.close(); 
                           } 
        
        
                         } catch (SQLException e) 
                         { 
                           e.printStackTrace(); 
                         } 
                   } 
                } 
        } 

Answer 3

是large object 的问题
这种问题 俯拾即是了

Answer 4

把一个excel做一个object 呵呵 

Answer 5

推荐采用一些框架 完成，这样简化了细节 方案也成熟 如spring2.0 对 大数据对象 很好操作

Answer 6

刚好写过一个，但要记得下载jxl，这个程序只能从excel读取数据，写入数据库靠你自己完成了，完成不了应该也可以忽悠一下了，祝楼主好运import java.io.*;
import jxl.*;
import jxl.write.*;public class importExcel { public static void main(String args[]) {
try {
Workbook book = Workbook.getWorkbook(new File("f://ddd.xls"));
// 获得第一个工作表对象
Sheet sheet = book.getSheet(0);
// 得到第一列第一行的单元格
Cell cell1 = sheet.getCell(0, 0);
String field1 = cell1.getContents();

Cell cell2 = sheet.getCell(1, 0);
String field2 = cell2.getContents();

// System.out.print(sheet.getRows());

int rows=sheet.getRows();

for(int i=0;i<rows;i++){

String name = sheet.getCell(0, i).getContents();
String fuzeren = sheet.getCell(1, i).getContents();
String adress = sheet.getCell(2, i).getContents();

System.out.println(name+","+fuzeren+","+adress);
}

book.close();
} catch (Exception e) {
System.out.println(e);
} }
}

Answer 7

我来晚了，不然可以救你了，用poi 就可以了。

Answer 8

这种现成的东西很多啊,楼主不要自己琢磨了
http://www.10zhizui.cn

Answer 9

http://www.10zhizui.cnimport   java.sql.Connection;   
import   java.sql.Statement;   
import   java.sql.ResultSet;   
import   java.sql.DriverManager;   
import   java.sql.PreparedStatement;   
import   java.sql.SQLException;   public   class   InsertData   {                   public   static   void   main(String[]   args){   
                                Connection   myConnSDB   =   null;   
                                PreparedStatement   psInsertData=null;   
                                int   InsertData=0;   
                                //Regist   Oracle   JDBC   Driver   
                                try   {   
                                                DriverManager.registerDriver(new   oracle.jdbc.OracleDriver());   
                                                myConnSDB=   
                                                                DriverManager.getConnection(   
                                                                                "jdbc:oracle:thin:@127.0.0.1:1521:MYDB ",   
                                                                                "user ",   
                                                                                "user ");                                                   myConnSDB.setAutoCommit(false);                                   }   catch   (SQLException   e)   {   
                                                e.printStackTrace();   
                                }                                   try{   
                                                Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver ");   
                                                Connection   con   =   DriverManager.getConnection(   "jdbc:odbc:Book1 ", " ", " "   );   
                                                Statement   st   =   con.createStatement();   
                                                ResultSet   rs   =   st.executeQuery(   "SELECT   *   FROM   [Sheet1$] "   );   
                                                psInsertData=   
                                                                                                                                  myConnSDB.prepareStatement( "   INSERT   INTO   TMP_TABLE "+                                                                                                                                                                                                                                                 "   (ACTION_ID,TIMESTAMP,USERID,USERNAME,ISSUE,ACTION) "+                                                                                                                                                                                                                                                 "     VALUES   "+                                                                                                                                                                                                                                                 "   (?,?,?,?,?,?)   ");                                   
                                                              while   (rs.next())   {   
                                                                                psInsertData.clearParameters();   
                                                                                psInsertData.setString(1,rs.getString(1));   
                                                                                psInsertData.setString(2,rs.getString(2));   
                                                                                psInsertData.setString(3,rs.getString(3));   
                                                                                psInsertData.setString(4,rs.getString(4));   
                                                                                psInsertData.setString(5,rs.getString(5));   
                                                                                psInsertData.setString(6,rs.getString(6));   
                                                                                InsertData=InsertData+psInsertData.executeUpdate();                                                                                                                           }   
                                                System.out.println( " "+InsertData);   
                                                st.close();   
                                                con.close();   
                                }catch   (Exception   ex)   
                      {   
                                      System.err.print( "Exception:   ");   
                                      System.err.println(ex.getMessage());   
                                      ex.printStackTrace();   
                      }   finally   
                                      {   
                                                  try   
                                                  {   
                                                                if   (psInsertData!=   null)   
                                                      {   
                                                                psInsertData.close();   
                                                      }   
                                                                if   (myConnSDB   !=   null)   
                                                      {   
                                                                  myConnSDB.close();   
                                                      }   
                
                
                                                  }   catch   (SQLException   e)   
                                                  {   
                                                      e.printStackTrace();   
                                                  }   
                                      }   
                                }   
                }