67,513
社区成员
发帖
与我相关
我的任务
分享
try {
Class.forName(Config.getDB_DRIVER());
Connection conn = DriverManager.getConnection(Config.getDB_CONN(),
Config.getDB_USER(), Config.getDB_PWD());
// conn.setAutoCommit(false);
String sql = "insert into T_user values(?,?)";
PreparedStatement pstmt = null;
for (int i = 0; i < 100; i++) {
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, "|ddd" + i);
pstmt.setString(2, "ddsds");
pstmt.addBatch();
if(i % 20 == 0 || i == 99){
pstmt.executeBatch();
}
}
conn.commit();
pstmt.close();
conn.close();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}