| 发表于:2007-03-27 10:12:3110楼 得分:0 |
package drexcel; 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 inputexcel { public static void main(string[] args) throws instantiationexception, illegalaccessexception, classnotfoundexception { connection myconnsdb = null; preparedstatement psinsertdata = null; int insertdata = 0; // regist oracle jdbc driver string classforname = "oracle.jdbc.driver.oracledriver "; string url = "jdbc:oracle:thin:@127.0.0.1:1521:mydb ";//127.0.0.1:1521:mydb string user = "dtsc ";//10.118.15.4:1521:dtgjscdb string password = "dtsc "; try { class.forname(classforname).newinstance(); myconnsdb = drivermanager.getconnection(url, user, password); //statement stmt = con.createstatement(resultset.type_scroll_sensitive,resultset.concur_updatable); system.out.println( "dddddd "); } 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(); } } } } | | |
|