作者forkome (丁丁是个人材)
看板Web_Design
标题[问题] Jsp RecordSet问题
时间Tue Oct 9 15:51:04 2007
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
1F：推 qrtt1:这问题应该在 java 版之类的地方比较合适 10/09 18:17
3F：→ qrtt1:还有在 loop 中印字串也是会拖慢的一个因素 10/09 18:23