日期:2014-05-16  浏览次数:20412 次

sql 批量处理 JDBC
con.setAutoCommit(false);

String delSQL1="delete from tb_czxs_user1 where iddel="+id1+"";
String delSQL2="delete from tb_czxs_user2 where iddel="+id2+"";

stmt.addBatch(delSQL1);
stmt.addBatch(delSQL2);

stmt.executeBatch();

con.commit();
con.setAutoCommit(true);