纯代码

//<%@ page contentType="text/html;charset=UTF-8" language="java" %>

用户登录

用户名：

身份: 老人 管理员 监护人

密码：




<% if (request.getParameter("error")!= null && request.getParameter("error").equals("1")) { %>

用户名、身份或密码错误，请重新输入

<% } %>

// //package come;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

@WebServlet("/DengluServlet")
public class DengluServlet extends HttpServlet {

@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    String name = request.getParameter("Name");
    String role = request.getParameter("role");
    String password = request.getParameter("password");

    try {
        // 加载数据库驱动（根据你的MySQL版本可能需要调整）
        Class.forName("com.mysql.cj.jdbc.Driver");
        // 建立数据库连接
        Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/ygkaoqin", "root", "12345");
        String sql = "SELECT * FROM xinxi WHERE Name =? AND role =? AND password =?";
        PreparedStatement preparedStatement = connection.prepareStatement(sql);
        preparedStatement.setString(1, name);
        preparedStatement.setString(2, role);
        preparedStatement.setString(3, password);
        ResultSet resultSet = preparedStatement.executeQuery();

        if (resultSet.next()) {
            if ("老人".equals(role)) {
                response.sendRedirect("EmployeeFunction.jsp");
            } else if ("监护人".equals(role)) {
                response.sendRedirect("ManagerFunction.jsp");
            } else if ("管理员".equals(role)) {
                response.sendRedirect("AdminFunction.jsp");
            }
        } else {
            response.sendRedirect("index.jsp?error=1");// 登录失败，返回登录页面并可以显示错误信息
        }

        resultSet.close();
        preparedStatement.close();
        connection.close();
    } catch (ClassNotFoundException | SQLException e) {
        e.printStackTrace();
    }
}

}//
//
package yg;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

@WebServlet("/ModifyPasswordServlet")
public class ModifyPasswordServlet extends HttpServlet {

@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    String oldPassword = request.getParameter("oldPassword");
    String newPassword = request.getParameter("newPassword");
    String newPasswordConfirm = request.getParameter("newPasswordConfirm");
    String name = (String) request.getSession().getAttribute("name");

    try {
        // 加载数据库驱动（根据你的MySQL版本可能需要调整）
        Class.forName("com.mysql.cj.jdbc.Driver");
        // 建立数据库连接
        Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/ygkaoqin", "root", "12345");
        String sql = "SELECT password FROM xinxi WHERE Name =?";
        PreparedStatement preparedStatement = connection.prepareStatement(sql);
        preparedStatement.setString(1, name);
        ResultSet resultSet = preparedStatement.executeQuery();

        if (resultSet.next()) {
            if (oldPassword.equals(resultSet.getString("password"))) {
                if (newPassword.equals(newPasswordConfirm)) {
                    sql = "UPDATE xinxi SET password =? WHERE Name =?";
                    preparedStatement = connection.prepareStatement(sql);
                    preparedStatement.setString(1, newPassword);
                    preparedStatement.setString(1, name);
                    preparedStatement.executeUpdate();
                    response.sendRedirect("EmployeeFunction.jsp");
                } else {
                    response.sendRedirect("ModifyPassword.jsp?error=2");// 新密码不一致
                }
            } else {
                response.sendRedirect("ModifyPassword.jsp?error=1");// 旧密码错误
            }
        }

        resultSet.close();
        preparedStatement.close();
        connection.close();
    } catch (ClassNotFoundException | SQLException e) {
        e.printStackTrace();
    }
}

}//
//<%@ page contentType="text/html;charset=UTF-8" language="java" %>