java.sql.SQLException: After end of result set
我已经声明两个Statment了啊,为什么ResultSet结果集还是关闭了?代码如下
PreparedStatement pstmt =conn.prepareStatement(sql);
Statement stmt=conn.createStatement();
Statement stmt2=conn.createStatement();
ResultSet rssumkm1=stmt.executeQuery(sql1);
ResultSet rs=pstmt.executeQuery();
ResultSet rs2=stmt2.executeQuery(sql2);
rs2.last();
while(rs.next())
{
Jixiao jx=new Jixiao();
jx.setId(rs.getInt(1));
jx.setDay(rs.getString(2));
jx.setClasst(rs.getString(3));
jx.setStarttingtime(rs.getInt(4));
jx.setFinishtime(rs.getInt(5));
jx.setOrigin(rs.getString(6));
jx.setFinish(rs.getString(7));
jx.setStartkm(rs.getInt(8));
jx.setFinishkm(rs.getInt(9));
jx.setKm(rs.getInt(10));
jx.setAllowance(rs.getInt(11));
list.add(jx);
}
rssumkm1.next();
request.setAttribute("sumkm", (rssumkm1.getString(1)));
System.out.println((rssumkm1.getString(1)));
rs.last();
rs2.next();
request.setAttribute("sumAllowance", (rs2.getString(1)));
request.setAttribute("list", list);
request.getRequestDispatcher("Showlist.jsp").forward(request, response);
报错的代码是这句 request.setAttribute("sumAllowance", (rs2.getString(1))); 这句代码以上都执行了。