Statement stmt = conn.creatStatement();
String sql1 = "select ...";
ResultSet rs = stmt.executeQuery(sql1);stmt = conn.createStatement();
String sql2 = "select ......";
rs = stmt.executeQuery(sql2);Notice:when you want to use a Statement more than one time,write "stmt = conn.createStatement();" before each using position.
String sql1 = "select ...";
ResultSet rs = stmt.executeQuery(sql1);stmt = conn.createStatement();
String sql2 = "select ......";
rs = stmt.executeQuery(sql2);Notice:when you want to use a Statement more than one time,write "stmt = conn.createStatement();" before each using position.
解决方案 »
- 大家现在都用什么技术!
- web services安全么?如何控制服务端发布的信息只让某些人才可以接收?
- 请问怎么在jsp页面做分页????
- 中文图片无法显示的问题
- The requested resource (/TomcatSample/HelloWorld) is not available. 急急,这个小问题已经有两天了!!!
- 学习JSP是不是必须要学JavaScript,有没有替代方式?
- 想学习开发jsp,请指定基础入门,谢谢了!
- 在servlet中出现这样的错误???
- 为什么编译不了啊?
- 求大神,谁知道有一种工具,可以一键生成将Java web项目的多余代码都能删除掉的工具
- html怎么和jsp通讯?
- 一个经常碰见的错误,求助!
String sql1 = "select ...";
ResultSet rs1 = stmt.executeQuery(sql1);//stmt = conn.createStatement();
String sql2 = "select ......";
ResultSet rs2 = stmt.executeQuery(sql2);There still existing some mistake.
because you didn't write "stmt = conn.createStatement();" before using it,so the result is that your object "rs1"'s value is ruined.
但是运行的时候有时会提示“用尽的ResultSet”
有时很正常
象那种意外的情况,到底“用尽的ResultSet”是什么意思
用的是象
if(rst!=null){}
else{}
运行时候如果是进入if还能正常
但如果进入的是else就不正常
这个rst记录集有点鬼异