在拥有上述案例页面展示的情况下,用JDBC实现后端功能并前后连接。(1)基本信息管理 管理人员的基本信息,包括:增加员工信息、修改基础信息、删除员工信息、查询基础信息;维护部门信息,包括:增加、修改、删除、查询等操作。 (2)人员调动管理 管理人员的调动情况,记录人员的调动历史并提供查询功能。 (3)人员考核管理 管理人员的考核情况,记录人员的考核历史并提供查询功能。 (4)劳资管理 管理人员的劳资分配情况,记录人员的劳资更改历史并提供查询功能。数据库包括人员信息表(编号、姓名、性别、出生年月、民族、地址、部门、薪酬、考核、其他),历史操作记录表(流水编号、操作类型、原始信息、更新信息、变更次数、变更日期、人员编号),部门管理表(编号、一级部门、二级部门)。
时间: 2023-07-10 12:42:54 浏览: 44
好的,这是一个比较复杂的问题,需要详细的解释和代码实现。首先,需要先建立数据库和表格。以下是建立表格的 SQL 代码:
```sql
CREATE TABLE employee (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50) NOT NULL,
gender VARCHAR(10) NOT NULL,
birthdate DATE NOT NULL,
ethnicity VARCHAR(20) NOT NULL,
address VARCHAR(100) NOT NULL,
department VARCHAR(50) NOT NULL,
salary DECIMAL(10, 2) NOT NULL,
assessment VARCHAR(100) NOT NULL,
other VARCHAR(100)
);
CREATE TABLE history (
id INT AUTO_INCREMENT PRIMARY KEY,
type VARCHAR(20) NOT NULL,
original_info VARCHAR(200) NOT NULL,
updated_info VARCHAR(200) NOT NULL,
change_count INT NOT NULL,
change_date DATE NOT NULL,
employee_id INT NOT NULL,
FOREIGN KEY (employee_id) REFERENCES employee(id)
);
CREATE TABLE department (
id INT AUTO_INCREMENT PRIMARY KEY,
level1 VARCHAR(50) NOT NULL,
level2 VARCHAR(50) NOT NULL
);
```
接下来,我们需要编写 Java 代码来连接数据库并实现功能。以下是基本信息管理的代码实现:
```java
import java.sql.*;
public class EmployeeManagement {
// JDBC连接信息
private static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
private static final String DB_URL = "jdbc:mysql://localhost:3306/employee_management";
private static final String USER = "root";
private static final String PASSWORD = "password";
// 添加员工信息
public void addEmployee(String name, String gender, String birthdate, String ethnicity, String address, String department, double salary, String assessment, String other) {
Connection conn = null;
PreparedStatement pstmt = null;
try {
// 连接数据库
Class.forName(JDBC_DRIVER);
conn = DriverManager.getConnection(DB_URL, USER, PASSWORD);
// 插入员工信息
String sql = "INSERT INTO employee (name, gender, birthdate, ethnicity, address, department, salary, assessment, other) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, name);
pstmt.setString(2, gender);
pstmt.setDate(3, Date.valueOf(birthdate));
pstmt.setString(4, ethnicity);
pstmt.setString(5, address);
pstmt.setString(6, department);
pstmt.setDouble(7, salary);
pstmt.setString(8, assessment);
pstmt.setString(9, other);
pstmt.executeUpdate();
System.out.println("员工信息添加成功!");
} catch (Exception e) {
System.out.println("添加员工信息失败!");
e.printStackTrace();
} finally {
// 关闭连接
try {
if (pstmt != null) {
pstmt.close();
}
if (conn != null) {
conn.close();
}
} catch (SQLException se) {
se.printStackTrace();
}
}
}
// 修改员工信息
public void updateEmployee(int id, String name, String gender, String birthdate, String ethnicity, String address, String department, double salary, String assessment, String other) {
Connection conn = null;
PreparedStatement pstmt = null;
try {
// 连接数据库
Class.forName(JDBC_DRIVER);
conn = DriverManager.getConnection(DB_URL, USER, PASSWORD);
// 更新员工信息
String sql = "UPDATE employee SET name=?, gender=?, birthdate=?, ethnicity=?, address=?, department=?, salary=?, assessment=?, other=? WHERE id=?";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, name);
pstmt.setString(2, gender);
pstmt.setDate(3, Date.valueOf(birthdate));
pstmt.setString(4, ethnicity);
pstmt.setString(5, address);
pstmt.setString(6, department);
pstmt.setDouble(7, salary);
pstmt.setString(8, assessment);
pstmt.setString(9, other);
pstmt.setInt(10, id);
pstmt.executeUpdate();
System.out.println("员工信息更新成功!");
} catch (Exception e) {
System.out.println("更新员工信息失败!");
e.printStackTrace();
} finally {
// 关闭连接
try {
if (pstmt != null) {
pstmt.close();
}
if (conn != null) {
conn.close();
}
} catch (SQLException se) {
se.printStackTrace();
}
}
}
// 删除员工信息
public void deleteEmployee(int id) {
Connection conn = null;
PreparedStatement pstmt = null;
try {
// 连接数据库
Class.forName(JDBC_DRIVER);
conn = DriverManager.getConnection(DB_URL, USER, PASSWORD);
// 删除员工信息
String sql = "DELETE FROM employee WHERE id=?";
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, id);
pstmt.executeUpdate();
System.out.println("员工信息删除成功!");
} catch (Exception e) {
System.out.println("删除员工信息失败!");
e.printStackTrace();
} finally {
// 关闭连接
try {
if (pstmt != null) {
pstmt.close();
}
if (conn != null) {
conn.close();
}
} catch (SQLException se) {
se.printStackTrace();
}
}
}
// 查询员工信息
public void queryEmployee(int id) {
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
// 连接数据库
Class.forName(JDBC_DRIVER);
conn = DriverManager.getConnection(DB_URL, USER, PASSWORD);
// 查询员工信息
String sql = "SELECT * FROM employee WHERE id=?";
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, id);
rs = pstmt.executeQuery();
while (rs.next()) {
System.out.println("编号:" + rs.getInt("id"));
System.out.println("姓名:" + rs.getString("name"));
System.out.println("性别:" + rs.getString("gender"));
System.out.println("出生年月:" + rs.getDate("birthdate"));
System.out.println("民族:" + rs.getString("ethnicity"));
System.out.println("地址:" + rs.getString("address"));
System.out.println("部门:" + rs.getString("department"));
System.out.println("薪酬:" + rs.getDouble("salary"));
System.out.println("考核:" + rs.getString("assessment"));
System.out.println("其他:" + rs.getString("other"));
}
} catch (Exception e) {
System.out.println("查询员工信息失败!");
e.printStackTrace();
} finally {
// 关闭连接
try {
if (rs != null) {
rs.close();
}
if (pstmt != null) {
pstmt.close();
}
if (conn != null) {
conn.close();
}
} catch (SQLException se) {
se.printStackTrace();
}
}
}
// 增加部门信息
public void addDepartment(String level1, String level2) {
Connection conn = null;
PreparedStatement pstmt = null;
try {
// 连接数据库
Class.forName(JDBC_DRIVER);
conn = DriverManager.getConnection(DB_URL, USER, PASSWORD);
// 插入部门信息
String sql = "INSERT INTO department (level1, level2) VALUES (?, ?)";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, level1);
pstmt.setString(2, level2);
pstmt.executeUpdate();
System.out.println("部门信息添加成功!");
} catch (Exception e) {
System.out.println("添加部门信息失败!");
e.printStackTrace();
} finally {
// 关闭连接
try {
if (pstmt != null) {
pstmt.close();
}
if (conn != null) {
conn.close();
}
} catch (SQLException se) {
se.printStackTrace();
}
}
}
// 修改部门信息
public void updateDepartment(int id, String level1, String level2) {
Connection conn = null;
PreparedStatement pstmt = null;
try {
// 连接数据库
Class.forName(JDBC_DRIVER);
conn = DriverManager.getConnection(DB_URL, USER, PASSWORD);
// 更新部门信息
String sql = "UPDATE department SET level1=?, level2=? WHERE id=?";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, level1);
pstmt.setString(2, level2);
pstmt.setInt(3, id);
pstmt.executeUpdate();
System.out.println("部门信息更新成功!");
} catch (Exception e) {
System.out.println("更新部门信息失败!");
e.printStackTrace();
} finally {
// 关闭连接
try {
if (pstmt != null) {
pstmt.close();
}
if (conn != null) {
conn.close();
}
} catch (SQLException se) {
se.printStackTrace();
}
}
}
// 删除部门信息
public void deleteDepartment(int id) {
Connection conn = null;
PreparedStatement pstmt = null;
try {
// 连接数据库
Class.forName(JDBC_DRIVER);
conn = DriverManager.getConnection(DB_URL, USER, PASSWORD);
// 删除部门信息
String sql = "DELETE FROM department WHERE id=?";
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, id);
pstmt.executeUpdate();
System.out.println("部门信息删除成功!");
} catch (Exception e) {
System.out.println("删除部门信息失败!");
e.printStackTrace();
} finally {
// 关闭连接
try {
if (pstmt != null) {
pstmt.close();
}
if (conn != null) {
conn.close();
}
} catch (SQLException se) {
se.printStackTrace();
}
}
}
// 查询部门信息
public void queryDepartment(int id) {
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
// 连接数据库
Class.forName(JDBC_DRIVER);
conn = DriverManager.getConnection(DB_URL, USER, PASSWORD);
// 查询部门信息
String sql = "SELECT * FROM department WHERE id=?";
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, id);
rs = pstmt.executeQuery();
while (rs.next()) {
System.out.println("编号:" + rs.getInt("id"));
System.out.println("一级部门:" + rs.getString("level1"));
System.out.println("二级部门:" + rs.getString("level2"));
}
} catch (Exception e) {
System.out.println("查询部门信息失败!");
e.printStackTrace();
} finally {
// 关闭连接
try {
if (rs != null) {
rs.close();
}
if (pstmt != null) {
pstmt.close();
}
if (conn != null) {
conn.close();
}
} catch (SQLException se) {
se.printStackTrace();
}
}
}
}
```
以上是基于 JDBC 实现的基本信息管理功能和部门管理功能的代码。人员调动管理、人员考核管理和劳资管理的实现方式类似,需要自己编写代码实现。