错误代码:
stmt=conn.createStatement();
rs=stmt.executeQuery("SELECT* FROM test");
rs2=stmt.executeUpdate("DELETE FROM test WHERE id="+rs.getInt(1));
错误提示:Operation not allowed after ResultSet closed
原因:The object used for executing a static SQL statement and returning the results it produces.
By default, only one ResultSet object per Statement object can be open at the same time. Therefore,
if the reading of one ResultSet object is interleaved with the reading of another, each must have
been generated by different Statement objects. All execution methods in the Statement interface implicitly
close a statment's current ResultSet object if an open one exists.
解决方法:
1.就多创建几个stmt,一个stmt对应一个rs;
stmt=conn.createStatement();
stmt2=conn.createStatement();
rs=stmt.executeQuery("SELECT* FROM test");
rs2=stmt2.executeUpdate("DELETE FROM test WHERE id="+rs.getInt(1));
2.若用一个stmt对应多个rs的话,那只能得到一个rs后就操作,处理完第一个rs后再处理其他的.
stmt=conn.createStatement();
rs=stmt.executeQuery("SELECT* FROM test");
rs的操作
rs2=stmt.executeUpdate("DELETE FROM test WHERE id="+rs.getInt(1));
rs2的操作
上述的第2种情况中,在对rs的操作中如果要对它的结果rs.next()进行executeUpdate之类操作的话,只有另外创建stmt,如:
stmt = conn.createStatement();
stmtup = conn.createStatement();
rs = stmt.executeQuery("SELECT * FROM temp_info WHERE flag=1");
while(rs.next()){
stmtup.executeUpdate("INSERT INTO dest_info(num,name) VALUES('"+rs.getString("num").toString()+"','"+rs.getString("name").toString()+"'");
}
stmt=conn.createStatement();
rs=stmt.executeQuery("SELECT* FROM test");
rs2=stmt.executeUpdate("DELETE FROM test WHERE id="+rs.getInt(1));
错误提示:Operation not allowed after ResultSet closed
原因:The object used for executing a static SQL statement and returning the results it produces.
By default, only one ResultSet object per Statement object can be open at the same time. Therefore,
if the reading of one ResultSet object is interleaved with the reading of another, each must have
been generated by different Statement objects. All execution methods in the Statement interface implicitly
close a statment's current ResultSet object if an open one exists.
解决方法:
1.就多创建几个stmt,一个stmt对应一个rs;
stmt=conn.createStatement();
stmt2=conn.createStatement();
rs=stmt.executeQuery("SELECT* FROM test");
rs2=stmt2.executeUpdate("DELETE FROM test WHERE id="+rs.getInt(1));
2.若用一个stmt对应多个rs的话,那只能得到一个rs后就操作,处理完第一个rs后再处理其他的.
stmt=conn.createStatement();
rs=stmt.executeQuery("SELECT* FROM test");
rs的操作
rs2=stmt.executeUpdate("DELETE FROM test WHERE id="+rs.getInt(1));
rs2的操作
上述的第2种情况中,在对rs的操作中如果要对它的结果rs.next()进行executeUpdate之类操作的话,只有另外创建stmt,如:
stmt = conn.createStatement();
stmtup = conn.createStatement();
rs = stmt.executeQuery("SELECT * FROM temp_info WHERE flag=1");
while(rs.next()){
stmtup.executeUpdate("INSERT INTO dest_info(num,name) VALUES('"+rs.getString("num").toString()+"','"+rs.getString("name").toString()+"'");
}