oracle在批量操作的时候经常遇到这些错误,报错代码示例
for (int i=0;i<=2000;i++) {
String sql = "insert into users(uname,passwd) VALUES(?,?)";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1,"张"+i);
ps.setString(2,"密码"+i);
ps.executeUpdate();
}
这好办,在执行完execute*之后加个close()就可以了
for (int i=0;i<=2000;i++) {
String sql = "insert into users(uname,passwd) VALUES(?,?)";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1,"张"+i);
ps.setString(2,"密码"+i);
ps.executeUpdate();
ps.close(); //加上这句
}