# web编程 rs=stmt.executeQuery(sql)；报错

web编程 rs=stmt.executeQuery(sql);报错

type Exception report

message An exception occurred processing JSP page /sql.jsp at line 22

description The server encountered an internal error that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: An exception occurred processing JSP page /sql.jsp at line 22

代码如下

1. List item

<%@ page contentType=“text/html; charset=gb2312” language=“java” import=“java.sql." %>
<%@ page import="java.util.”%>

<% String name = request.getParameter("id"); String pwd = request.getParameter("pwd");

String driver = “com.mysql.cj.jdbc.Driver”;
String url =“jdbc:mysql://localhost:3306/酒店?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT”;
Class.forName(driver);
Connection conn =DriverManager.getConnection(url, “root”, “D20001103”);
Statement stmt=conn.createStatement();
ResultSet rs;
String sql =“select*from user_information where name=’”+name+"’ and password=’"+pwd+"’";

//出错的这一行
rs=stmt.executeQuery(sql);
//

if(rs.next()){
if(rs!=null){
%>
<jsp:forward page=“success.jsp”/>
<%
}
else{
%>
<jsp:forward page=“Untitled-3.html”/>
<%
}
}
else{
%>
<jsp:forward page=“Untitled-3.html”/>
<%
}
%>
}

自行百度了好久没能解决，求大佬给解答一下。