Question

JSP如何同时使用两个ResultSet

我想同时使用两个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

请问这是什么原因啊

Answer 1

试试：
Connection Con1 = DriverManager.getConnection("jdbc:odbc:try");
Connection Con2 = DriverManager.getConnection("jdbc:odbc:try");
Statement Stmt1 = Con1.createStatement();
Statement Stmt2 = Con2.createStatement();