web学习记录16

今天来实战建民老师发的2019年考试试题
在 IDE 中创建一个 Maven 项目，项目的基本目录结构如下：
src/main/java：用于存放 Java 源代码，包括 Servlet、JavaBean、DAO等各类类
src/main/resources：放置配置文件
src/main/webapp：Web 相关资源目录，包含 HTML、CSS、JavaScript 文件以及 WEB-INF 文件夹
pom.xml（如果是 Maven 项目）：用于管理项目依赖，添加 Servlet、JSP、JDBC
建表
员工基本信息表
CREATE TABLE employee_basic_info (
job_id VARCHAR(8) PRIMARY KEY,
name VARCHAR(50) NOT NULL,
sex ENUM('男', '女') NOT NULL,
birthday VARCHAR(10) NOT NULL,
department VARCHAR(50) NOT NULL,
role ENUM('员工', '部门经理') NOT NULL,
password VARCHAR(50) NOT NULL
);
部门基本信息表
CREATE TABLE department_basic_info (
department_id VARCHAR(2) PRIMARY KEY,
department_name VARCHAR(50) UNIQUE NOT NULL
);
INSERT INTO department_basic_info (department_id, department_name)
VALUES ('01', '办公室'), ('02', '财务部门'), ('03', '销售部门'), ('04', '生产一部'), ('05', '生产二部'), ('06', '生产三部');
考勤记录表
CREATE TABLE attendance_record (
id INT PRIMARY KEY AUTO_INCREMENT,
attendance_time DATETIME NOT NULL,
job_id VARCHAR(8) NOT NULL,
name VARCHAR(50) NOT NULL,
sex ENUM('男', '女') NOT NULL,
birthday VARCHAR(10) NOT NULL,
department VARCHAR(50) NOT NULL,
attendance_type ENUM('上班', '下班') NOT NULL
);
配置数据库的连接
db.url=jdbc:mysql://localhost:3306/employee_attendance?useSSL=false&serverTimezone=UTC
db.username=your_username
db.password=your_password
JavaBean 设计
员工信息
public class Employee {
private String jobId;
private String name;
private String sex;
private String birthday;
private String department;
private String role;
private String password;

// 生成对应的 getter 和 setter 方法
public String getJobId() {
    return jobId;
}

public void setJobId(String jobId) {
    this.jobId = jobId;
}

public String getName() {
    return name;
}

public void setName(String name) {
    this.name = name;
}

// 其他属性的 getter 和 setter 方法依次类推
//...

}
部门信息
public class Department {
private String departmentId;
private String departmentName;

// 生成对应的 getter 和 setter 方法
public String getDepartmentId() {
    return departmentId;
}

public void setDepartmentId(String departmentId) {
    this.departmentId = departmentId;
}

public String getDepartmentName() {
    return departmentName;
}

public void setDepartmentName(String departmentName) {
    this.departmentName = departmentName;
}

}
考勤记录
public class AttendanceRecord {
private int id;
private Date attendanceTime;
private String jobId;
private String name;
private String sex;
private String birthday;
private String department;
private String attendanceType;

// 生成对应的 getter 和 setter 方法
public int getId() {
    return id;
}

public void setId(int id) {
    this.id = id;
}

public Date getAttendanceTime() {
    return attendanceTime;
}

public void setAttendanceTime(Date attendanceTime) {
    this.attendanceTime = attendanceTime;
}

// 其他属性的 getter 和 setter 方法依次类推
//...

}