String sql1="select * from 表1";
rs1=stat.executeQuery(sql1);
while (rs1.next()){
out.println("1");
String sql2="select * from 表2";
rs2=stat.executeQuery(sql2);
while(rs2.next()){
out.println("2");
}
}
提示:ResultSet is closed
但是:同样的语句不嵌套,就可以正常运行
String sql1="select * from 表1";
rs1=stat.executeQuery(sql1);
while (rs1.next()){
out.println("1");
}
String sql2="select * from 表2";
rs2=stat.executeQuery(sql2);
while(rs2.next()){
out.println("2");
}
是不是JSP中新开一个结果集,就会把原来的关掉?
---------------------------------------------------------------
我也碰到过这种情况,把Statement stat=cn.createStatement();改为
Statement stat=cn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
Statement stat2=cn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
即可在一个连接中创建多个Statement了。
rs1=stat.executeQuery(sql1);
while (rs1.next()){
out.println("1");
String sql2="select * from 表2";
rs2=stat.executeQuery(sql2);
while(rs2.next()){
out.println("2");
}
}
提示:ResultSet is closed
但是:同样的语句不嵌套,就可以正常运行
String sql1="select * from 表1";
rs1=stat.executeQuery(sql1);
while (rs1.next()){
out.println("1");
}
String sql2="select * from 表2";
rs2=stat.executeQuery(sql2);
while(rs2.next()){
out.println("2");
}
是不是JSP中新开一个结果集,就会把原来的关掉?
---------------------------------------------------------------
我也碰到过这种情况,把Statement stat=cn.createStatement();改为
Statement stat=cn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
Statement stat2=cn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
即可在一个连接中创建多个Statement了。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货