servlet传递参数到jsp报错,请帮忙看一下


                                 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了。

建议改改再试试吧。