十字路口球形摄像头:JSP如何同时使用两个ResultSet
来源:百度文库 编辑:高校问答 时间:2024/04/29 21:46:25
我想同时使用两个ResultSet
但一个Statement 只能管理一个ResultSet
于是有人说创建两个Statement就行了
我就写了如下代码:
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection Con = DriverManager.getConnection("jdbc:odbc:try");
Statement Stmt1 = Con.createStatement();
Statement Stmt2 = Con.createStatement();
ResultSet T1 = Stmt1.executeQuery("SELECT * FROM t1");
ResultSet T2 = Stmt2.executeQuery("ESLECT * FROM t2");
结果运行出错
javax.servlet.ServletException: [Microsoft][ODBC SQL Server Driver]连接占线导致另一个 hstmt
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]连接占线导致另一个 hstmt
请问这是什么原因啊
但一个Statement 只能管理一个ResultSet
于是有人说创建两个Statement就行了
我就写了如下代码:
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection Con = DriverManager.getConnection("jdbc:odbc:try");
Statement Stmt1 = Con.createStatement();
Statement Stmt2 = Con.createStatement();
ResultSet T1 = Stmt1.executeQuery("SELECT * FROM t1");
ResultSet T2 = Stmt2.executeQuery("ESLECT * FROM t2");
结果运行出错
javax.servlet.ServletException: [Microsoft][ODBC SQL Server Driver]连接占线导致另一个 hstmt
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]连接占线导致另一个 hstmt
请问这是什么原因啊
试试:
Connection Con1 = DriverManager.getConnection("jdbc:odbc:try");
Connection Con2 = DriverManager.getConnection("jdbc:odbc:try");
Statement Stmt1 = Con1.createStatement();
Statement Stmt2 = Con2.createStatement();