[問題] Jsp RecordSet問題
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
推
10/09 18:17, , 1F
10/09 18:17, 1F
→
10/09 18:18, , 2F
10/09 18:18, 2F
→
10/09 18:23, , 3F
10/09 18:23, 3F
討論串 (同標題文章)
以下文章回應了本文:
完整討論串 (本文為第 1 之 2 篇):