try{
conn.setAutoCommit(false);
Statement stmt=conn.createStatement();
sql1=insert into a (a) VALUES ('a');
stmt.execute(sql1);
sql2=insert into b (b) VALUES ('b');
stmt.execute(sql1);
conn.commit()
}cathc(){
conn.rollback()
}
conn.setAutoCommit(false);
Statement stmt=conn.createStatement();
sql1=insert into a (a) VALUES ('a');
stmt.execute(sql1);
sql2=insert into b (b) VALUES ('b');
stmt.execute(sql1);
conn.commit()
}cathc(){
conn.rollback()
}
stmt.addBatch("insert into b (b) VALUES ('b')");
int[] nResult=stmt.executeBatch();执行成批更新