result set closed 报错

xiaowangsa 2013-04-09 03:20:35
代码如下:
最开始我两个SQL语句共用的st,报这个错误,查了一下,CSDN上有人说不能共用,就改了,
结果还是报这个错误,请大家指点一下是什么原因。
Connection conn = null;
PreparedStatement st = null;
PreparedStatement st2=null;
ResultSet rs = null;

String cust_name=null;
int logintm=0;
StringBuffer sql = new StringBuffer();
try {
conn = DBHelp.getConn();
sql.append("select cust_name,logintm from custinfo where cust_code=? and cust_pw=?");
st = conn.prepareStatement(sql.toString());
st.setString(1, username);
st.setString(2, password);
rs=st.executeQuery();
while(rs.next()){
cust_name=rs.getString("cust_name");
logintm=rs.getInt("logintm");
logintm=logintm+1;
sql.setLength(0);
sql.append("update dzyc_custinfo set logintm=? where nation_code=?");
st2=conn.prepareStatement(sql.toString());
st2.setInt(1, logintm);
st2.setString(2, username);
st2.executeUpdate();
flag=1;
}
} catch (Exception e) {
e.printStackTrace();
}finally{
DBHelp.closeObject(rs);
DBHelp.closeObject(st);
DBHelp.closeObject(st2);
DBHelp.closeObject(conn);
}
...全文
190 4 打赏 收藏 转发到动态 举报
写回复
用AI写文章
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
tianma630 2013-04-15
  • 打赏
  • 举报
回复
lz下次发帖前还是先百度下吧 http://www.iteye.com/topic/882651
xiaowangsa 2013-04-15
  • 打赏
  • 举报
回复
虽然没有影响总体运行,还是希望得到解决,继续求分析。
xiaowangsa 2013-04-12
  • 打赏
  • 举报
回复
7 CST] 0000001c SystemErr R com.ibm.db2.jcc.b.SqlException: Invalid operation: result set closed [13-4-12 21:25:54:937 CST] 0000001c SystemErr R at com.ibm.db2.jcc.b.rc.mb(rc.java:3413) [13-4-12 21:25:54:937 CST] 0000001c SystemErr R at com.ibm.db2.jcc.b.rc.c(rc.java:290) [13-4-12 21:25:54:937 CST] 0000001c SystemErr R at com.ibm.db2.jcc.b.rc.next(rc.java:277) [13-4-12 21:25:54:937 CST] 0000001c SystemErr R at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.next(WSJdbcResultSet.java:3120) [13-4-12 21:25:54:937 CST] 0000001c SystemErr R at com.servlets.LoginServlet.doPost(LoginServlet.java:55) [13-4-12 21:25:54:953 CST] 0000001c SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:738) [13-4-12 21:25:54:953 CST] 0000001c SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:831) [13-4-12 21:25:54:953 CST] 0000001c SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1443) [13-4-12 21:25:54:968 CST] 0000001c SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:790) [13-4-12 21:25:54:968 CST] 0000001c SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:443) [13-4-12 21:25:54:968 CST] 0000001c SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:175) [13-4-12 21:25:54:968 CST] 0000001c SystemErr R at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91) [13-4-12 21:25:54:968 CST] 0000001c SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:859) [13-4-12 21:25:54:968 CST] 0000001c SystemErr R at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1557) [13-4-12 21:25:54:968 CST] 0000001c SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:173) [13-4-12 21:25:54:968 CST] 0000001c SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:455) [13-4-12 21:25:54:968 CST] 0000001c SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:384) [13-4-12 21:25:54:968 CST] 0000001c SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83) [13-4-12 21:25:54:968 CST] 0000001c SystemErr R at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165) [13-4-12 21:25:54:968 CST] 0000001c SystemErr R at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) [13-4-12 21:25:54:968 CST] 0000001c SystemErr R at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161) [13-4-12 21:25:54:968 CST] 0000001c SystemErr R at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138) [13-4-12 21:25:54:968 CST] 0000001c SystemErr R at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:202) [13-4-12 21:25:54:968 CST] 0000001c SystemErr R at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:766) [13-4-12 21:25:54:968 CST] 0000001c SystemErr R at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:896) [13-4-12 21:25:54:968 CST] 0000001c SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1527)
STEEL-CHINA 2013-04-11
  • 打赏
  • 举报
回复
把出错的异常拿出来。

50,499

社区成员

发帖
与我相关
我的任务
社区描述
Java相关技术讨论
javaspring bootspring cloud 技术论坛(原bbs)
社区管理员
  • Java相关社区
  • 小虚竹
  • 谙忆
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧