[問題] Jsp RecordSet問題

[forkome (丁丁是個人材)]

Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt = conn.createStatement();
String sql1 = "select distinct topic from school";
ResultSet rs1 = stmt.executeQuery(sql1);

while(rs1.next()){

sql2="select dept from school where topic='"+rs1.getString(1)+"'";
rs2 = stmt.executeQuery(sql2);
out.println(rs2.getString(1));
rs2.close();

}

錯誤訊息java.sql.SQLException: [Microsoft
][SQLServer 2000 Driver for JDBC]Object has been closed.

難道stmt不能重覆使用嗎？還是另有原因

小弟把rs1的值當作rs2的搜尋條件，結果不能用


--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 59.120.246.179
推 qrtt1:這問題應該在 java 版之類的地方比較合適
→ qrtt1:http://tinyurl.com/3445hx 另外, 用batch會更有效率
→ qrtt1:還有在 loop 中印字串也是會拖慢的一個因素