JDBC连接oracle数据库，并实现批量插入

/** 数据库连接和批量插入*/try {

//java驱动程序

Class.forName("oracle.jdbc.driver.OracleDriver");

} catch (Exception e) {

e.printStackTrace();

}

Connection conn = DriverManager.getConnection(

"jdbc:oracle:thin:@10.122.35.41:11521/hbdw", "hbdw","hbdw_hbdw_35_41");  //(IP:端口号/实例名,“数据库用户名”,“数据库密码”);

Statement st = conn.createStatement();

String sql1 = "INSERT INTO P_WARNVALUE(WARNINDEX_ID,MONITOER_VALUE,MONITOER_NEWVALUE)VALUES(?,?,?)";

PreparedStatement ps = conn.prepareStatement(sql1);

final int batchSize = 1000;                                                     //批量大小设置为1000

//下面插入数据库在方法里面

ps.setInt(1, Integer.parseInt(rs.getString(1)));

ps.setString(2, item.get("subsId")+"");

ps.setString(3, item.get(rs.getString(2))+"");

ps.addBatch();

if(++oo%batchSize==0){

     ps.executeBatch();

}

//批量插入最后不够一千条插入

ps.executeBatch();

ps.close();

st.close();

conn.close();