JAVA实现Excel表数据导入ORACLE数据库.docVIP

在一个JAVA应用中，如果要把己知的一张Excel表数据导入一个己知的ORACLE表中，可以根据ODBC读取这张Excel表等操作来完成相关功能。具体代码如下： public class InsertData { public static void main(String[] args) { Connection myConnSDB = null; PreparedStatement psInsertData = null; int InsertData = 0; try { Class.forName(oracle.jdbc.driver.OracleDriver); myConnSDB = DriverManager.getConnection( jdbc:oracle:thin:@02:1521:ORCL, system, ORCL); System.out.println(myConnSDB); } catch (Exception 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 test1 + (NAME,PASS) + VALUES + (?,?) ); while (rs.next()) { psInsertData.clearParameters(); psInsertData.setString(1, rs.getString(1)); psInsertData.setString(2, rs.getString(2)); 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(); } } }} 在一个WEB应用中,根据一个Excel表，一个ORACLE表，导入ORACLE中，这里用到了连接池，jxl.jar和commons-dbutils-1.1.jar。 1.TOMCAT中连接池的代码如下： Context path=/ElsToOra docBase=E:\workspace\ExcelToOraChang\WebRoot debug=0Resource name=oracleds auth=Container type=javax.sql.DataSource driverClassName=oracle.jdbc.driver.OracleDriver url=jdbc:oracle:thin:@02:1521:ORCL username=system password=ORCL maxActive=20 maxIdle=10 maxWait=-1 //Context 2.业务连接代码如下： package test; import java.io.File;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatem