java.sql.SQLException:运行Tomcat时,在ResultSet关闭后不允许进行操作

所以我在雄猫服务器中收到上述错误。 Web应用程序运行正常,但出现此错误,它导致我进入Java中的一个类的while循环。我看过其他类似的答案,但无法弄清楚我做错了什么。我尝试了多种有意义的解决方案,但还是一样。

这是错误所指向的位置:

while (rs.next()) {

完整代码:

public void doGet(HttpServletRequest request,HttpServletResponse response) throws IOException,ServletException {
        PrintWriter out = response.getWriter();
        String email = request.getParameter("uname");
        String password = request.getParameter("psw");
        boolean val = false;
        try {
            connection = DriverManager.getconnection("removed this path to file");
            Statement select = connection.createStatement();
            ResultSet rs = select.executeQuery("SELECT * FROM users");
            while (rs.next()) {
                if (email.equalsIgnoreCase(rs.getString(1)) && password.equalsIgnoreCase(rs.getString(2))) {
                    connection.close();
                    val = true;

                }
                rs.close();
            }
            if(!val)
            connection.close();

        } catch (Exception e) {
            e.printStackTrace();
        }
        if(val) {
            response.sendRedirect(request.getcontextPath() + "/calculate.jsp");
        }else {
            request.setattribute("name","Wrong username or password!");
            getServletContext().getRequestDispatcher("/index.jsp").forward(request,response);
        }

        out.close();
    }
wolflaw 回答:java.sql.SQLException:运行Tomcat时,在ResultSet关闭后不允许进行操作

暂时没有好的解决方案,如果你有好的解决方案,请发邮件至:iooj@foxmail.com
本文链接:https://www.f2er.com/3077021.html

大家都在问