随笔- 119  文章- 1  评论- 0  阅读- 437 
web学习记录17

今天继续完成建民老师发的2019年试题
DAO 层设计（数据访问对象，用于数据库操作）
员工信息
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Properties;

public class EmployeeDAO {
private static final String DB_URL;
private static final String DB_USERNAME;
private static final String DB_PASSWORD;

static {今天继续完成建民老师发的2019年试题

DAO 层设计（数据访问对象，用于数据库操作）
员工信息
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Properties;

public class EmployeeDAO {
private static final String DB_URL;
private static final String DB_USERNAME;
private static final String DB_PASSWORD;

static {
    Properties properties = new Properties();
    try {
        properties.load(EmployeeDAO.class.getClassLoader().getResourceAsStream("db.properties"));
        DB_URL = properties.getProperty("db.url");
        DB_USERNAME = properties.getProperty("db.username");
        DB_PASSWORD = properties.getProperty("db.password");
    } catch (Exception e) {
        throw new RuntimeException("数据库配置加载失败", e);
    }
}

// 新增员工基本信息
public void addEmployee(Employee employee) {
    try (Connection connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
         PreparedStatement preparedStatement = connection.prepareStatement("INSERT INTO employee_basic_info (job_id, name, sex, birthday, department, role, password) VALUES (?,?,?,?,?,?,?)")) {
        preparedStatement.setString(1, employee.getJobId());
        preparedStatement.setString(2, employee.getName());
        preparedStatement.setString(3, employee.getSex());
        preparedStatement.setString(4, employee.getBirthday());
        preparedStatement.setString(5, employee.getDepartment());
        preparedStatement.setString(6, employee.getRole());
        preparedStatement.setString(7, employee.getPassword());
        preparedStatement.executeUpdate();
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

// 修改员工基本信息（除工号外可修改部分字段）
public void updateEmployee(Employee employee) {
    try (Connection connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
         PreparedStatement preparedStatement = connection.prepareStatement("UPDATE employee_basic_info SET name =?, sex =?, birthday =? WHERE job_id =?")) {
        preparedStatement.setString(1, employee.getName());
        preparedStatement.setString(2, employee.getSex());
        preparedStatement.setString(3, employee.getBirthday());
        preparedStatement.setString(4, employee.getJobId());
        preparedStatement.executeUpdate();
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

// 删除员工基本信息
public void deleteEmployee(String jobId) {
    try (Connection connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
         PreparedStatement preparedStatement = connection.prepareStatement("DELETE FROM employee_basic_info WHERE job_id =?")) {
        preparedStatement.setString(1, jobId);
        preparedStatement.executeUpdate();
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

// 根据工号查询员工信息
public Employee getEmployeeByJobId(String jobId) {
    try (Connection connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
         PreparedStatement preparedStatement = connection.prepareStatement("SELECT * FROM employee_basic_info WHERE job_id =?")) {
        preparedStatement.setString(1, jobId);
        ResultSet resultSet = preparedStatement.executeQuery();
        if (resultSet.next()) {
            Employee employee = new Employee();
            employee.setJobId(resultSet.getString("job_id"));
            employee.setName(resultSet.getString("name"));
            employee.setSex(resultSet.getString("sex"));
            employee.setBirthday(resultSet.getString("birthday"));
            employee.setDepartment(resultSet.getString("department"));
            employee.setRole(resultSet.getString("role"));
            employee.setPassword(resultSet.getString("password"));
            return employee;
        }
        return null;
    } catch (SQLException e) {
        e.printStackTrace();
        return null;
    }
}

// 查询所有员工信息（可用于部门经理查看本部门员工等情况）
public List<Employee> getAllEmployees() {
    List<Employee> employees = new ArrayList<>();
    try (Connection connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
         PreparedStatement preparedStatement = connection.prepareStatement("SELECT * FROM employee_basic_info")) {
        ResultSet resultSet = preparedStatement.executeQuery();
        while (resultSet.next()) {
            Employee employee = new Employee();
            // 设置员工信息属性，同 getEmployeeByJobId 中从 ResultSet 取值并设置属性的过程
            employees.add(employee);
        }
        return employees;
    } catch (SQLException e) {
        e.printStackTrace();
        return null;
    }
}

}
部门信息
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Properties;

public class DepartmentDAO {
private static final String DB_URL;
private static final String DB_USERNAME;
private static final String DB_PASSWORD;

static {
    Properties properties = new Properties();
    try {
        properties.load(DepartmentDAO.class.getClassLoader().getResourceAsStream("db.properties"));
        DB_URL = properties.getProperty("db.url");
        DB_USERNAME = properties.getProperty("db.username");
        DB_PASSWORD = properties.getProperty("db.password");
    } catch (Exception e) {
        throw new RuntimeException("数据库配置加载失败", e);
    }
}

// 新增部门基本信息
public void addDepartment(Department department) {
    try (Connection connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
         PreparedStatement preparedStatement = connection.prepareStatement("INSERT INTO department_basic_info (department_id, department_name) VALUES (?,?)")) {
        preparedStatement.setString(1, department.getDepartmentId());
        preparedStatement.setString(2, department.getDepartmentName());
        preparedStatement.executeUpdate();
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

// 修改部门基本信息（部门名称）
public void updateDepartment(Department department) {
    try (Connection connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
         PreparedStatement preparedStatement = connection.prepareStatement("UPDATE department_basic_info SET department_name =? WHERE department_id =?")) {
        preparedStatement.setString(1, department.getDepartmentName());
        preparedStatement.setString(2, department.getDepartmentId());
        preparedStatement.executeUpdate();
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

// 删除部门基本信息（需判断部门下是否有员工）
public void deleteDepartment(String departmentId) {
    // 先查询该部门是否还有员工，如果有则不允许删除
    if (hasEmployeesInDepartment(departmentId)) {
        return;
    }
    try (Connection connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
         PreparedStatement preparedStatement = connection.prepareStatement("DELETE FROM department_basic_info WHERE department_id =?")) {
        preparedStatement.setString(1, departmentId);
        preparedStatement.executeUpdate();
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

private boolean hasEmployeesInDepartment(String departmentId) {
    try (Connection connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
         PreparedStatement preparedStatement = connection.prepareStatement("SELECT COUNT(*) FROM employee_basic_info WHERE department = (SELECT department_name FROM department_basic_info WHERE department_id =?)")) {
        preparedStatement.setString(1, departmentId);
        ResultSet resultSet = preparedStatement.executeQuery();
        if (resultSet.next()) {
            int count = resultSet.getInt(1);
            return count > 0;
        }
        return false;
    } catch (SQLException e) {
        e.printStackTrace();
        return false;
    }
}

// 查询所有部门信息
public List<Department> getAllDepartments() {
    List<Department> departments = new ArrayList<>();
    try (Connection connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
         PreparedStatement preparedStatement = connection.prepareStatement("SELECT * FROM department_basic_info")) {
        ResultSet resultSet = preparedStatement.executeQuery();
        while (resultSet.next()) {
            Department department = new Department();
            department.setDepartmentId(resultSet.getString("department_id"));
            department.setDepartmentName(resultSet.getString("department_name"));
            departments.add(department);
        }
        return departments;
    } catch (SQLException e) {
        e.printStackTrace();
        return null;
    }
}

// 根据部门编号查询部门信息
public Department getDepartmentById(String departmentId) {
    try (Connection connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
         PreparedStatement preparedStatement = connection.prepareStatement("SELECT * FROM department_basic_info WHERE department_id =?")) {
        preparedStatement.setString(1, departmentId);
        ResultSet resultSet = preparedStatement.executeQuery();
        if (resultSet.next()) {
            Department department = new Department();
            department.setDepartmentId(resultSet.getString("department_id"));
            department.setDepartmentName(resultSet.getString("department_name"));
            return department;
        }
        return null;
    } catch (SQLException e) {
        e.printStackTrace();
        return null;
    }
}

}
考勤记录
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Properties;

public class AttendanceRecordDAO {
private static final String DB_URL;
private static final String DB_USERNAME;
private static final String DB_PASSWORD;

static {
    Properties properties = new Properties();
    try {
        properties.load(AttendanceRecordDAO.class.getClassLoader().getResourceAsStream("db.properties"));
        DB_URL = properties.getProperty("db.url");
        DB_USERNAME = properties.getProperty("db.username");
        DB_PASSWORD = properties.getProperty("db.password");
    } catch (Exception e) {
        throw new RuntimeException("数据库配置加载失败", e);
    }
}

// 新增考勤记录
public void addAttendanceRecord(AttendanceRecord record) {
    try (Connection connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
         PreparedStatement preparedStatement = connection.prepareStatement("INSERT INTO attendance_record (attendance_time, job_id, name, sex, birthday, department, attendance_type) VALUES (?,?,?,?,?,?,?)")) {
        preparedStatement.setTimestamp(1, new java.sql.Timestamp(record.getAttendanceTime().getTime()));
        preparedStatement.setString(2, record.getJobId());
        preparedStatement.setString(3, record.getName());
        preparedStatement.setString(4, record.getSex());
        preparedStatement.setString(5, record.getBirthday());
        preparedStatement.setString(6, record.getDepartment());
        preparedStatement.setString(7, record.getAttendanceType());
        preparedStatement.executeUpdate();
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

Servlet 设计与实现
登录
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;

@WebServlet("/login")
public class LoginServlet extends HttpServlet {
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String jobId = request.getParameter("job_id");
String password = request.getParameter("password");
// 调用 EmployeeDAO 验证用户登录信息，根据角色跳转到相应页面
// 示例代码，实际需完善验证逻辑和页面跳转逻辑
if ("admin".equals(jobId) && "admin123".equals(password)) {
// 管理员登录，跳转到管理员功能页
response.sendRedirect("admin.jsp");
} else {
// 其他角色登录验证逻辑类似，此处省略
response.sendRedirect("error.jsp");
}
}
}
查看个人信息
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;

@WebServlet("/employee/viewInfo")
public class EmployeeViewInfoServlet extends HttpServlet {
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// 获取当前登录员工的工号（假设从 session 中获取）
String jobId = (String) request.getSession().getAttribute("jobId");
// 调用 EmployeeDAO 查询员工信息并设置到 request 中，转发到查看信息页面
// 示例代码，实际需完善查询和转发逻辑
request.setAttribute("employee", new EmployeeDAO().getEmployeeByJobId(jobId));
request.getRequestDispatcher("employee_view_info.jsp").forward(request, response);
}
}
修改个人信息
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;

@WebServlet("/employee/updateInfo")
public class EmployeeUpdateInfoServlet extends HttpServlet {
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// 获取修改后的员工信息，调用 EmployeeDAO 更新信息
// 示例代码，需完善参数获取和更新逻辑，以及错误处理和返回页面逻辑
String jobId = request.getParameter("job_id");
String name = request.getParameter("name");
String sex = request.getParameter("sex");
String birthday = request.getParameter("birthday");
EmployeeDAO dao = new EmployeeDAO();
Employee employee = dao.getEmployeeByJobId(jobId);
if (employee!= null) {
employee.setName(name);
employee.setSex(sex);
employee.setBirthday(birthday);
dao.updateEmployee(employee);
request.setAttribute("message", "个人信息修改成功");
} else {
request.setAttribute("message", "员工不存在，修改失败");
}
request.getRequestDispatcher("employee_update_info_result.jsp").forward(request, response);
}
}
修改个人密码
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;

@WebServlet("/employee/updateInfo")
public class EmployeeUpdateInfoServlet extends HttpServlet {
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// 获取修改后的员工信息，调用 EmployeeDAO 更新信息
// 示例代码，需完善参数获取和更新逻辑，以及错误处理和返回页面逻辑
String jobId = request.getParameter("job_id");
String name = request.getParameter("name");
String sex = request.getParameter("sex");
String birthday = request.getParameter("birthday");
EmployeeDAO dao = new EmployeeDAO();
Employee employee = dao.getEmployeeByJobId(jobId);
if (employee!= null) {
employee.setName(name);
employee.setSex(sex);
employee.setBirthday(birthday);
dao.updateEmployee(employee);
request.setAttribute("message", "个人信息修改成功");
} else {
request.setAttribute("message", "员工不存在，修改失败");
}
request.getRequestDispatcher("employee_update_info_result.jsp").forward(request, response);
}
}
做到这里程序一直报错，没有找到错误原因
Properties properties = new Properties();
try {
properties.load(EmployeeDAO.class.getClassLoader().getResourceAsStream("db.properties"));
DB_URL = properties.getProperty("db.url");
DB_USERNAME = properties.getProperty("db.username");
DB_PASSWORD = properties.getProperty("db.password");
} catch (Exception e) {
throw new RuntimeException("数据库配置加载失败", e);
}
}

// 新增员工基本信息
public void addEmployee(Employee employee) {
    try (Connection connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
         PreparedStatement preparedStatement = connection.prepareStatement("INSERT INTO employee_basic_info (job_id, name, sex, birthday, department, role, password) VALUES (?,?,?,?,?,?,?)")) {
        preparedStatement.setString(1, employee.getJobId());
        preparedStatement.setString(2, employee.getName());
        preparedStatement.setString(3, employee.getSex());
        preparedStatement.setString(4, employee.getBirthday());
        preparedStatement.setString(5, employee.getDepartment());
        preparedStatement.setString(6, employee.getRole());
        preparedStatement.setString(7, employee.getPassword());
        preparedStatement.executeUpdate();
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

// 修改员工基本信息（除工号外可修改部分字段）
public void updateEmployee(Employee employee) {
    try (Connection connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
         PreparedStatement preparedStatement = connection.prepareStatement("UPDATE employee_basic_info SET name =?, sex =?, birthday =? WHERE job_id =?")) {
        preparedStatement.setString(1, employee.getName());
        preparedStatement.setString(2, employee.getSex());
        preparedStatement.setString(3, employee.getBirthday());
        preparedStatement.setString(4, employee.getJobId());
        preparedStatement.executeUpdate();
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

// 删除员工基本信息
public void deleteEmployee(String jobId) {
    try (Connection connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
         PreparedStatement preparedStatement = connection.prepareStatement("DELETE FROM employee_basic_info WHERE job_id =?")) {
        preparedStatement.setString(1, jobId);
        preparedStatement.executeUpdate();
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

// 根据工号查询员工信息
public Employee getEmployeeByJobId(String jobId) {
    try (Connection connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
         PreparedStatement preparedStatement = connection.prepareStatement("SELECT * FROM employee_basic_info WHERE job_id =?")) {
        preparedStatement.setString(1, jobId);
        ResultSet resultSet = preparedStatement.executeQuery();
        if (resultSet.next()) {
            Employee employee = new Employee();
            employee.setJobId(resultSet.getString("job_id"));
            employee.setName(resultSet.getString("name"));
            employee.setSex(resultSet.getString("sex"));
            employee.setBirthday(resultSet.getString("birthday"));
            employee.setDepartment(resultSet.getString("department"));
            employee.setRole(resultSet.getString("role"));
            employee.setPassword(resultSet.getString("password"));
            return employee;
        }
        return null;
    } catch (SQLException e) {
        e.printStackTrace();
        return null;
    }
}

// 查询所有员工信息（可用于部门经理查看本部门员工等情况）
public List<Employee> getAllEmployees() {
    List<Employee> employees = new ArrayList<>();
    try (Connection connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
         PreparedStatement preparedStatement = connection.prepareStatement("SELECT * FROM employee_basic_info")) {
        ResultSet resultSet = preparedStatement.executeQuery();
        while (resultSet.next()) {
            Employee employee = new Employee();
            // 设置员工信息属性，同 getEmployeeByJobId 中从 ResultSet 取值并设置属性的过程
            employees.add(employee);
        }
        return employees;
    } catch (SQLException e) {
        e.printStackTrace();
        return null;
    }
}

}
部门信息
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Properties;

public class DepartmentDAO {
private static final String DB_URL;
private static final String DB_USERNAME;
private static final String DB_PASSWORD;

static {
    Properties properties = new Properties();
    try {
        properties.load(DepartmentDAO.class.getClassLoader().getResourceAsStream("db.properties"));
        DB_URL = properties.getProperty("db.url");
        DB_USERNAME = properties.getProperty("db.username");
        DB_PASSWORD = properties.getProperty("db.password");
    } catch (Exception e) {
        throw new RuntimeException("数据库配置加载失败", e);
    }
}

// 新增部门基本信息
public void addDepartment(Department department) {
    try (Connection connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
         PreparedStatement preparedStatement = connection.prepareStatement("INSERT INTO department_basic_info (department_id, department_name) VALUES (?,?)")) {
        preparedStatement.setString(1, department.getDepartmentId());
        preparedStatement.setString(2, department.getDepartmentName());
        preparedStatement.executeUpdate();
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

// 修改部门基本信息（部门名称）
public void updateDepartment(Department department) {
    try (Connection connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
         PreparedStatement preparedStatement = connection.prepareStatement("UPDATE department_basic_info SET department_name =? WHERE department_id =?")) {
        preparedStatement.setString(1, department.getDepartmentName());
        preparedStatement.setString(2, department.getDepartmentId());
        preparedStatement.executeUpdate();
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

// 删除部门基本信息（需判断部门下是否有员工）
public void deleteDepartment(String departmentId) {
    // 先查询该部门是否还有员工，如果有则不允许删除
    if (hasEmployeesInDepartment(departmentId)) {
        return;
    }
    try (Connection connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
         PreparedStatement preparedStatement = connection.prepareStatement("DELETE FROM department_basic_info WHERE department_id =?")) {
        preparedStatement.setString(1, departmentId);
        preparedStatement.executeUpdate();
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

private boolean hasEmployeesInDepartment(String departmentId) {
    try (Connection connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
         PreparedStatement preparedStatement = connection.prepareStatement("SELECT COUNT(*) FROM employee_basic_info WHERE department = (SELECT department_name FROM department_basic_info WHERE department_id =?)")) {
        preparedStatement.setString(1, departmentId);
        ResultSet resultSet = preparedStatement.executeQuery();
        if (resultSet.next()) {
            int count = resultSet.getInt(1);
            return count > 0;
        }
        return false;
    } catch (SQLException e) {
        e.printStackTrace();
        return false;
    }
}

// 查询所有部门信息
public List<Department> getAllDepartments() {
    List<Department> departments = new ArrayList<>();
    try (Connection connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
         PreparedStatement preparedStatement = connection.prepareStatement("SELECT * FROM department_basic_info")) {
        ResultSet resultSet = preparedStatement.executeQuery();
        while (resultSet.next()) {
            Department department = new Department();
            department.setDepartmentId(resultSet.getString("department_id"));
            department.setDepartmentName(resultSet.getString("department_name"));
            departments.add(department);
        }
        return departments;
    } catch (SQLException e) {
        e.printStackTrace();
        return null;
    }
}

// 根据部门编号查询部门信息
public Department getDepartmentById(String departmentId) {
    try (Connection connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
         PreparedStatement preparedStatement = connection.prepareStatement("SELECT * FROM department_basic_info WHERE department_id =?")) {
        preparedStatement.setString(1, departmentId);
        ResultSet resultSet = preparedStatement.executeQuery();
        if (resultSet.next()) {
            Department department = new Department();
            department.setDepartmentId(resultSet.getString("department_id"));
            department.setDepartmentName(resultSet.getString("department_name"));
            return department;
        }
        return null;
    } catch (SQLException e) {
        e.printStackTrace();
        return null;
    }
}

}
考勤记录
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Properties;

public class AttendanceRecordDAO {
private static final String DB_URL;
private static final String DB_USERNAME;
private static final String DB_PASSWORD;

static {
    Properties properties = new Properties();
    try {
        properties.load(AttendanceRecordDAO.class.getClassLoader().getResourceAsStream("db.properties"));
        DB_URL = properties.getProperty("db.url");
        DB_USERNAME = properties.getProperty("db.username");
        DB_PASSWORD = properties.getProperty("db.password");
    } catch (Exception e) {
        throw new RuntimeException("数据库配置加载失败", e);
    }
}

// 新增考勤记录
public void addAttendanceRecord(AttendanceRecord record) {
    try (Connection connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
         PreparedStatement preparedStatement = connection.prepareStatement("INSERT INTO attendance_record (attendance_time, job_id, name, sex, birthday, department, attendance_type) VALUES (?,?,?,?,?,?,?)")) {
        preparedStatement.setTimestamp(1, new java.sql.Timestamp(record.getAttendanceTime().getTime()));
        preparedStatement.setString(2, record.getJobId());
        preparedStatement.setString(3, record.getName());
        preparedStatement.setString(4, record.getSex());
        preparedStatement.setString(5, record.getBirthday());
        preparedStatement.setString(6, record.getDepartment());
        preparedStatement.setString(7, record.getAttendanceType());
        preparedStatement.executeUpdate();
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

Servlet 设计与实现
登录
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;

@WebServlet("/login")
public class LoginServlet extends HttpServlet {
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String jobId = request.getParameter("job_id");
String password = request.getParameter("password");
// 调用 EmployeeDAO 验证用户登录信息，根据角色跳转到相应页面
// 示例代码，实际需完善验证逻辑和页面跳转逻辑
if ("admin".equals(jobId) && "admin123".equals(password)) {
// 管理员登录，跳转到管理员功能页
response.sendRedirect("admin.jsp");
} else {
// 其他角色登录验证逻辑类似，此处省略
response.sendRedirect("error.jsp");
}
}
}
查看个人信息
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;

@WebServlet("/employee/viewInfo")
public class EmployeeViewInfoServlet extends HttpServlet {
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// 获取当前登录员工的工号（假设从 session 中获取）
String jobId = (String) request.getSession().getAttribute("jobId");
// 调用 EmployeeDAO 查询员工信息并设置到 request 中，转发到查看信息页面
// 示例代码，实际需完善查询和转发逻辑
request.setAttribute("employee", new EmployeeDAO().getEmployeeByJobId(jobId));
request.getRequestDispatcher("employee_view_info.jsp").forward(request, response);
}
}
修改个人信息
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;

@WebServlet("/employee/updateInfo")
public class EmployeeUpdateInfoServlet extends HttpServlet {
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// 获取修改后的员工信息，调用 EmployeeDAO 更新信息
// 示例代码，需完善参数获取和更新逻辑，以及错误处理和返回页面逻辑
String jobId = request.getParameter("job_id");
String name = request.getParameter("name");
String sex = request.getParameter("sex");
String birthday = request.getParameter("birthday");
EmployeeDAO dao = new EmployeeDAO();
Employee employee = dao.getEmployeeByJobId(jobId);
if (employee!= null) {
employee.setName(name);
employee.setSex(sex);
employee.setBirthday(birthday);
dao.updateEmployee(employee);
request.setAttribute("message", "个人信息修改成功");
} else {
request.setAttribute("message", "员工不存在，修改失败");
}
request.getRequestDispatcher("employee_update_info_result.jsp").forward(request, response);
}
}
修改个人密码
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;

@WebServlet("/employee/updateInfo")
public class EmployeeUpdateInfoServlet extends HttpServlet {
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// 获取修改后的员工信息，调用 EmployeeDAO 更新信息
// 示例代码，需完善参数获取和更新逻辑，以及错误处理和返回页面逻辑
String jobId = request.getParameter("job_id");
String name = request.getParameter("name");
String sex = request.getParameter("sex");
String birthday = request.getParameter("birthday");
EmployeeDAO dao = new EmployeeDAO();
Employee employee = dao.getEmployeeByJobId(jobId);
if (employee!= null) {
employee.setName(name);
employee.setSex(sex);
employee.setBirthday(birthday);
dao.updateEmployee(employee);
request.setAttribute("message", "个人信息修改成功");
} else {
request.setAttribute("message", "员工不存在，修改失败");
}
request.getRequestDispatcher("employee_update_info_result.jsp").forward(request, response);
}
}
做到这里程序一直报错，没有找到错误原因

 posted on   敝屣  阅读(1)  评论(0)  编辑  收藏  举报
相关博文：
·  web学习记录18
·  12.23博客 java实战2019年试题
·  公司日常考勤系统#3
·  公司日常考勤系统#4
·  SpringBoot 教程
阅读排行：
· 震惊！C++程序真的从main开始吗？99%的程序员都答错了
· 【硬核科普】Trae如何「偷看」你的代码？零基础破解AI编程运行原理
· 单元测试从入门到精通
· 上周热点回顾（3.3-3.9）
· winform 绘制太阳，地球，月球 运作规律
点击右上角即可分享
微信分享提示