比如
Connection con=....;
con.setAutoCommit(false);
Statement st=con.createStatement();
st.executeUpdate("insert into .....");
con.commit();//这句是必须的吗st.addBatch("insert into ....");
st.addBatch("insert into .....");st.executeBatch();con.commit();//执行完executeBatch后,还用执行commit吗忘各位给予解答
Connection con=....;
con.setAutoCommit(false);
Statement st=con.createStatement();
st.executeUpdate("insert into .....");
con.commit();//这句是必须的吗st.addBatch("insert into ....");
st.addBatch("insert into .....");st.executeBatch();con.commit();//执行完executeBatch后,还用执行commit吗忘各位给予解答
已经关闭了自动commit了,当然要手动commit
不加这句还可以。