Operation not allowed after ResultSet closed 解决方法

来源：互联网发布：r语言编程代码编辑：程序博客网时间：2024/06/05 06:03

问题出现的原因：

Statement statement = dbConn.createStatement();// 要执行的SQL语句ResultSet rs = statement.executeQuery("select name,salary from workerinfo WHERE salary > 12000");ResultSet rs1 = statement.executeQuery("select name,salary from workerinfo WHERE salary < 12000");while(rs.next()&&rs1.next()){System.out.println( " 工号； " + rs1.getString("salary") +" 姓名："+ rs1.getString("name"));System.out.println( " 工号； " + rs.getString("salary") +" 姓名："+ rs.getString("name"));}

运行这段代码，会报错：Operation not allowed after ResultSet closed

解决办法：

Statement statement = dbConn.createStatement();// 要执行的SQL语句ResultSet rs = statement.executeQuery("select name,salary from workerinfo WHERE salary > 12000");while(rs.next()){ System.out.println( " 工号； " + rs.getString("salary") +" 姓名："+ rs.getString("name"));}ResultSet rs1 = statement.executeQuery("select name,salary from workerinfo WHERE salary < 12000");while(rs1.next()){System.out.println( " 工号； " + rs1.getString("salary") +" 姓名："+ rs1.getString("name")); }

结论：一个statment对应多个rs进行操作。从statment得到的rs，必须马上操作此rs后，才能去得到另外的rs1，再对rs1操作，不能互相交替使用,会引起rs已经关闭错误——Operation not allowed after ResultSet closed.

阅读全文

0 0