所以我在雄猫服务器中收到上述错误。 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();
}