求addBatch和executeBatch的用法!
vibra 2003-04-20 11:59:25 我在bean中的代码如下
public void addBatch(String sql) {
try {
conn.setAutoCommit(false);
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
stmt.addBatch(sql);
}
catch (SQLException ex) {
System.out.print("aq.Exception" + ex.getMessage());
}
}
public void executeBatch() {
try {
stmt.executeBatch();
conn.setAutoCommit(true);
}
catch (SQLException ex) {
System.out.print("aq.Exception" + ex.getMessage());
}
}
在jsp中调用,执行几个更新语句时只能更新最后那个,这是为什么?