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
代码如下
- List item
<%@ page contentType=“text/html; charset=gb2312” language=“java” import=“java.sql." %>
<%@ page import="java.util.”%>
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”/>
<%
}
%>
}
自行百度了好久没能解决,求大佬给解答一下。