目录
我的jsp代码如下
<%@page import="java.sql.*" %>
<%@ page import="java.nio.charset.StandardCharsets" %>
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>登录信息处理界面</title>
</head>
<body>
<%
String username = new String(request.getParameter("username").getBytes(StandardCharsets.ISO_8859_1), StandardCharsets.UTF_8);
String password = new String(request.getParameter("password").getBytes(StandardCharsets.ISO_8859_1), StandardCharsets.UTF_8);
Connection conn = null;
Statement st = null;
ResultSet rs = null;
/*处理用户名为空的情况,重定向回登录界面*/
if (username.equals("")) {
response.sendRedirect("http://localhost:8080/EIMS/login/login.jsp");
} else if (password.equals("")) {
response.sendRedirect("http://localhost:8080/EIMS/login/login.jsp");
}
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/eims?characterEncoding=UTF-8";
conn = DriverManager.getConnection(url, "root", "root");
st = conn.createStatement();
String sql = "select * from user where username = '" + username + "' and password = '" + password + "'";
rs = st.executeQuery(sql);
if (rs.next()) {
response.sendRedirect("http://localhost:8080/EIMS/main/main.jsp");
} else {
response.sendRedirect("http://localhost:8080/EIMS/login/login.jsp");
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (rs != null) rs.close();
if (st != null) st.close();
if (conn != null) conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
%>
</body>
</html>
代码没有错误
但是导入jar包导错了地方
一开始我在项目下创建了一个lib文件夹将jar包放入
问题
但是这样导入报错,提示找不到"com.mysql.jdbc.Driver"
但是我明明导入了jar包,还是找不到
然后我开始搜索,终于在一篇文章中找到解决方法
解决方法
将jar包放入WEB-INF下面
终于,这个问题解决了
希望这个方法能够帮到你