目录

问题 

解决方法

我的jsp代码如下

<%@page import="java.sql.*" %>
<%@ page import="java.nio.charset.StandardCharsets" %>
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>



    
    


<%
    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();
        }

    }
%>

代码没有错误

但是导入jar包导错了地方

一开始我在项目下创建了一个lib文件夹将jar包放入

问题 

但是这样导入报错，提示找不到"com.mysql.jdbc.Driver"

但是我明明导入了jar包，还是找不到

然后我开始搜索，终于在一篇文章中找到解决方法

解决方法

将jar包放入WEB-INF下面

终于，这个问题解决了

希望这个方法能够帮到你