使用JDBC进行批处理
i);
st.setString(2, "123" + i);
st.setString(3, "aaa" + i + "@sina.com");
st.setDate(4,new java.sql.Date(new java.util.Date().getTime()));
?
st.addBatch();
if(i%1000==0){
st.executeBatch();
st.clearBatch();
}
}
st.executeBatch();
/** * 批量执行混合模式的SQL、有预定义的，还有静态的 */ public static void exeBatchMixedSQL() { Connection conn = null; try { conn = DBToolkit.getConnection(); String sql = "insert into testdb.book (kind, name) values (?,?)"; PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setString(1, "java"); pstmt.setString(2, "jjjj"); pstmt.addBatch(); //添加一次预定义参数 pstmt.setString(1, "ccc"); pstmt.setString(2, "dddd"); pstmt.addBatch(); //再添加一次预定义参数 //添加一次静态SQL pstmt.addBatch("update testdb.book set kind = 'JAVA' where kind='java'"); //批量执行预定义SQL pstmt.executeBatch(); } catch (SQLException e) { e.printStackTrace(); } finally { DBToolkit.closeConnection(conn); } } ??