DBUtil db = new DBUtil();
db.connetAccessDB();
String sql = "select * from item where type = 0";
ResultSet rs = db.getResultSet(sql);
while (rs.next()) { // 错误行
String name = rs.getString("name");
int id = rs.getShort("id"); String sql = "select * from item where type = 1 and fid= " + id;
ResultSet rs1 = db.getResultSet(sql);
while (rs1.next()) {
String name = rs1.getString("name");
}
}
出异常了 java.sql.SQLException: ResultSet is closed
ResultSet is closed 但是这个错误写的应该是你已经关闭了,然后你再执行的下面操作,所以你执行不了!!!
希望能帮到你吧
ResultSet rs1 = db.getResultSet(sql);
while (rs1.next()) {
String name = rs1.getString("name");
}这段代码注释就可以了