2014实现表数据导入数据库.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.OracleDriverurl=jdbc:oracle:thin:@02:1521:ORCLusername=systempassword=ORCLmaxActive=20maxIdle=10maxWait=-1 //Context 2.业务连接代码如下： package test; import java.io.File;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.ResultSetMetaData;import java.util.List; import javax.naming.Context;i