sql = "select * from component_list";
rs=stmt.executeQuery(sql);
sql1 = "select * from express_list where account_name = '"+userName+"' and status = '已请求'";
rs1=stmt.executeQuery(sql1);
req.setAttribute("rs_artbut",rs);
req.setAttribute("rs_artbut1",rs1);
RequestDispatcher view_rec = req.getRequestDispatcher("rec.jsp");
view_rec.forward(req,resp);
default :
out.println("error");
break;
out.println("</table>");
rs.close();
rs1.close();
stmt.close();
conn.close();
浏览器打印错误为:org.apache.jasper.JasperException: javax.servlet.ServletException: java.sql.SQLException: Operation not allowed after ResultSet closed
http://blog.csdn.net/sku0923/article/details/1722370
看看这篇博客
RequestDispatcher 是一个转发器,也就是说结果集会跟随其传递到jsp页面,你这里贸然的关掉,就有可能出现sqlEcxeption了。
建议改改再试试吧。