at com.mysql.jdbc.ResultSetImpl.checkClosed(ResultSetImpl.java:794)
at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7077)
at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)
at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)
at cn.com.Socket.Term.term(Term.java:32)
at cn.com.Socket.ThreadReader.insert_num(ThreadReader.java:141)
at cn.com.Socket.ThreadReader.othernum(ThreadReader.java:126)
at cn.com.Socket.ThreadReader.read(ThreadReader.java:65)
at cn.com.Socket.ThreadReader.Port(ThreadReader.java:39)
at cn.com.Socket.ThreadReader.run(ThreadReader.java:21)
at java.lang.Thread.run(Thread.java:744)
0100ffffff00002b 2018-11-08 13:29:04
java.sql.SQLException: Operation not allowed after ResultSet closed
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.ResultSetImpl.checkClosed(ResultSetImpl.java:794)
at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7077)
at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)
at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)
at cn.com.Socket.Term.term(Term.java:32)
at cn.com.Socket.ThreadReader.insert_num(ThreadReader.java:141)
at cn.com.Socket.ThreadReader.othernum(ThreadReader.java:126)
at cn.com.Socket.ThreadReader.read(ThreadReader.java:65)
at cn.com.Socket.ThreadReader.Port(ThreadReader.java:39)
at cn.com.Socket.ThreadReader.run(ThreadReader.java:21)
at java.lang.Thread.run(Thread.java:744)
0100ffffff00002b 2018-11-08 13:29:04
java.sql.SQLException: Operation not allowed after ResultSet closed
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.ResultSetImpl.checkClosed(ResultSetImpl.java:794)
at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7077)
at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)
at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)
at cn.com.Socket.Term.term(Term.java:32)
at cn.com.Socket.ThreadReader.insert_num(ThreadReader.java:141)
at cn.com.Socket.ThreadReader.othernum(ThreadReader.java:126)
at cn.com.Socket.ThreadReader.read(ThreadReader.java:65)
at cn.com.Socket.ThreadReader.Port(ThreadReader.java:39)
at cn.com.Socket.ThreadReader.run(ThreadReader.java:21)
at java.lang.Thread.run(Thread.java:744)
0100ffffff00002b 2018-11-08 13:29:04
一定要注意,
conn,st ,rs这三个的关系,只有conn连接状态下,执行事务st,才能有rs结果集
如果你的程序执行到了rs=st.executeQuery();
别以为到了这一步,反正rs结果集也获取到了,就可以关闭conn,st了;
因为你的结果集并没有放在集合里面,rs能获取数据的前提仍然是conn连接状态