Operation not allowed after ResultSet closed

Operation not allowed after ResultSet closed

结果集关闭后不允许执行操作
我遇到的情况是要执行两条数据库语句用了同一个连接导致的
例如这样：

DBConn db= new DBConn();
.......
String sql="select * from userTable";
			ResultSet rs=db.executeQuery(sql);
........
rs.close();
db.closeStmt();
db.closeConn();
........
String sql="select* from lyTable";
ResultSet rs=db1.executeQuery(sql);

就会一直报错
解决办法是用一个新的连接执行第二个execute(sql),

DBConn db= new DBConn();
DBConn db1= new DBConn();
.......
ResultSet rs=db.executeQuery(sql);
.......
ResultSet rs=db1.executeQuery(sql);

活到老学到老，一定要注重细节呀