java.sql.SQLException: ResultSet is closed解决方法
来源:互联网 发布:豫章书院知乎 编辑:程序博客网 时间:2024/05/21 22:51
这个小问题弄了半天才恍然大悟……
之前的数据库连接和rs.next()都没问题,在关闭rs前用了三次rs.next(),跟了两次断点没发现那里有问题,而在改关闭连接等的时候用了:
pst.close(); //PreparedStatement pst
rs.close(); //ResultSet rs
conn.close();
问题就出在这儿,PreparedStatment关闭后就把 ResultSet也关了,所以报错 ResultSet is closed。。
要注意pst和rs的关闭顺序。。改为下面就ok:
rs.close();
pst.close();
conn.close();
- java.sql.SQLException: ResultSet is closed解决方法
- java.sql.SQLException: ResultSet is closed解决方法
- Java错误提示-------java.sql.SQLException:ResultSet is closed
- java.sql.SQLException: ResultSet is closed 的一种解决
- java.sql.SQLException: Operation not allowed after ResultSet closed
- java.sql.SQLException: Connection is closed
- ssi批量增加java.sql.SQLException: Connection is closed.
- Cause: java.sql.SQLException: JZ0C0: Connection is already closed
- Play Framework 报错 java.sql.SQLException: Connection is closed!
- 异常—Cause: java.sql.SQLException: Data source is closed
- mySql错误: java.sql.SQLException: Operation not allowed after ResultSet closed
- Caused by: java.sql.SQLException: Operation not allowed after ResultSet closed
- ResultSet is closed!
- ResultSet is closed
- java.sql.SQLException: 关闭的 Resultset: next
- java.sql.SQLException: statement is closed语句被关闭 druid连接池报错
- Caused by: java.sql.SQLException: ResultSet is from UPDATE. No Data.
- SQLException: Operation not allowed after ResultSet closed
- ARM汇编语言(10) CP14
- shell sed的用法
- 读《马云在网商大会上的闭幕演讲》总结
- JAVA的哈希码及hashCode()方法
- 使用JTAG调试Codec Engine算法
- java.sql.SQLException: ResultSet is closed解决方法
- CSDN创始人兼董事长蒋涛:开发者的六大痛点
- 在Davinci开发中需要注意的栈问题
- 获取Ip的工具类
- poj 2184 Cow Exhibition
- MD5加密和二次加密的方法
- TI 达芬奇系列 开发错误解析
- css hack(ie6-9,firefox,chrome,opera,safari)
- Generic Trace Support一览