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

it2023-09-09  72

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 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”/> <% } %> }

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

最新回复(0)