Java Web项目慧心人力资源管理系统

最新推荐文章于 2025-08-27 19:17:55 发布

您好_Ae

最新推荐文章于 2025-08-27 19:17:55 发布

阅读量691

点赞数 30

CC 4.0 BY-SA版权

文章标签： java 前端数据库

本文链接：https://blog.csdn.net/2401_89678804/article/details/145081697

图5 添加成功后首页刷新数据

5、点击每行最后删除功能时弹出提示框,用户确认后删除该行数据并刷新最新员工数据，如图6所示。

图6 删除确认提示窗口

图7 删除后刷新数据

6、点击每行更新链接后跳转到更新页面,更新界面显示出要修改的员工信息，更新成功后跳转到首页显示最新数据，如图8、9所示：

图8 更新员工数据

图9 更新后刷新数据

三、数据库设计

===========

创建数据库（HRDB）。
创建员工信息表（TB_EMP），结构如下。

字段名	说明	字段类型	长度	备注
id	员工编号	int		主键，自增，增量为1
name	员工姓名	varchar	50	不能为空
gender	员工性别	varchar	50	不能为空
birthday	员工生日	varchar	50	不能为空
phone	手机号码	varchar	11	不能为空

四、具体要求及推荐实现步骤

=================

创建数据库，创建员工信息表，添加测试数据（至少添加4条测试数据）。
创建web工程并创建各个包，导入工程所需的jar文件。
创建Employee实体类。
创建BaseDAO工具类使用JDBC完成数据表数据的增删改查。创建Servlet相关类完成功能对应的用户请求处理。
编写JSP页面进行数据展示，以及新增、修改的界面。

五、评分标准

==========

题目：慧心人力资源管理系统
5	数据库（提交数据库脚本）
	5	创建数据库及添加测试数据
5	正确创建和编写实体类，包含所有属性及方法
2	正确创建BaseDao类，包含获取连接及关闭资源方法
35	正确创建EmployeeDAO类或者EmployeeMapper接口，使用jdbc
	10	正确创建查询数据返回集合的方法
	5	正确创建删除数据的方法
	10	正确创建更新数据的方法
	10	正确创建新增数据的方法
30	Servlet相关处理类
	10	正确创建处理全部数据查询查询请求Servlet类，web.xml中请求映射配置或注解正确
	5	正确创建处理新增数据请求Servlet类，web.xml中请求映射配置或注解正确
	5	正确创建处理删除数据请求Servlet类，web.xml中请求映射配置或注解正确
	5	正确创建处理更新数据时单个数据查询请求Servlet类，web.xml中请求映射配置或注解正确
	5	正确创建处理数据更新请求Servlet类，web.xml中请求映射配置或注解正确
18	JSP相关页面
	10	展示所有数据页面 7分显示统计信息3分
	3	修改员工信息页面
	5	新增员工信息页面
5	总体编程技术
	2	编码命名规范
	3	程序正常运行，无异常
总分		100分

六、实现代码

======

1、目录结构：

2、使用到的包：

3、Java代码：

util

BaseDao.java

package util;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.util.Properties;

public class BaseDao {

private static String url=“jdbc:mysql://localhost:3306/hrdb?useUnicode=true&characterEncoding=UTF-8&useSSL=false”;

private static String userName=“root”;

private static String password=“root”;

private static String driver=“com.mysql.jdbc.Driver”;

private static Connection connection;

private static Properties properties = new Properties();

static{

try {

Class.forName(driver);

} catch (ClassNotFoundException e) {

e.printStackTrace();

}

public static Connection getConnection(){

try {

if(connection==null||connection.isClosed()){

connection = DriverManager.getConnection(url,userName,password);

}

} catch (SQLException e) {

e.printStackTrace();

}

return connection;

}

public static void close(Connection connection) throws Exception {

try {

if (connection != null) {

connection.close();

}

} catch (Exception e) {

e.printStackTrace();

throw new Exception();

}

public static void main(String[] args) {

System.out.println(getConnection());

}

entity

TbEmp.java

package entity;

import java.io.Serializable;

public class TbEmp implements Serializable{

private static final long serialVersionUID = 1L;

private Integer id;

private String name;

private String gender;

private String birthday;

private String phone;

public TbEmp() {

super();

}

@Override

public String toString() {

return “TbEmp [id=” + id + “, name=” + name + “, gender=” + gender + “, birthday=” + birthday + “, phone=”

phone + “]”;

}

public TbEmp(Integer id, String name, String gender, String birthday, String phone) {

super();

this.id = id;

this.name = name;

this.gender = gender;

this.birthday = birthday;

this.phone = phone;

}

public Integer getId() {

return id;

}

public void setId(Integer id) {

this.id = id;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public String getGender() {

return gender;

}

public void setGender(String gender) {

this.gender = gender;

}

public String getBirthday() {

return birthday;

}

public void setBirthday(String birthday) {

this.birthday = birthday;

}

public String getPhone() {

return phone;

}

public void setPhone(String phone) {

this.phone = phone;

}

mapper

EmpMapper.java

package mapper;

import java.util.List;

import entity.TbEmp;

public interface EmpMapper {

//查询所有

List queryAll();

//添加

int addEmp(TbEmp tbEmp);

//更新

int updateEmp(TbEmp tbEmp);

//删除

int del(int id);

}

service

EmpService.java

package service;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;

import com.mysql.jdbc.Connection;

import entity.TbEmp;

import mapper.EmpMapper;

import util.BaseDao;

public class EmpService implements EmpMapper {

@Override

public List queryAll() {

Connection conn = null;

String sql = null;

try {

sql = “select * from tb_emp”;

conn = (Connection) BaseDao.getConnection();

PreparedStatement ps = conn.prepareStatement(sql);

ResultSet resultSet = ps.executeQuery();

ArrayList arrayList = new ArrayList();

while (resultSet.next()) {

TbEmp tbEmp = new TbEmp();

tbEmp.setId(resultSet.getInt(“id”));

tbEmp.setName(resultSet.getString(“name”));

tbEmp.setGender(resultSet.getString(“gender”));

tbEmp.setBirthday(resultSet.getString(“birthday”));

tbEmp.setPhone(resultSet.getString(“phone”));

arrayList.add(tbEmp);

}

if (arrayList.size() > 0) {

return arrayList;

}

} catch (Exception e) {

e.printStackTrace();

} finally {

try {

conn.close();

} catch (SQLException e) {

e.printStackTrace();

}

return null;

}

@Override

public int addEmp(TbEmp tbEmp) {

Connection connection = null;

try {

String sql = “insert into tb_emp(name,gender,birthday,phone) values(?,?,?,?)”;

connection = (Connection) BaseDao.getConnection();

PreparedStatement ps = connection.prepareStatement(sql);

ps.setString(1, tbEmp.getName());

ps.setString(2, tbEmp.getGender());

ps.setString(3, tbEmp.getBirthday());

ps.setString(4, tbEmp.getPhone());

int add = ps.executeUpdate();

if (add > 0) {

return add;

}

} catch (Exception e) {

e.printStackTrace();

} finally {

try {

connection.close();

} catch (SQLException e) {

e.printStackTrace();

}

return 0;

}

@Override

public int updateEmp(TbEmp tbEmp) {

Connection connection = null;

try {

String sql = “update tb_emp set name='” + tbEmp.getName() + “‘,gender=’” + tbEmp.getGender()

“‘,birthday=’” + tbEmp.getBirthday() + “‘,phone=’” + tbEmp.getPhone() + “’ where id='”
tbEmp.getId() + “'”;

System.out.println(sql);

connection = (Connection) BaseDao.getConnection();

PreparedStatement ps = connection.prepareStatement(sql);

int update = ps.executeUpdate();

if (update > 0) {

return update;

}

} catch (Exception e) {

}

return 0;

}

@Override

public int del(int id) {

Connection connection = null;

String sql = null;

try {

sql = “delete from tb_emp where id=” + id;

connection = (Connection) BaseDao.getConnection();

PreparedStatement ps = connection.prepareStatement(sql);

int delUpdate = ps.executeUpdate();

if (delUpdate > 0) {

return delUpdate;

}

} catch (Exception e) {

e.printStackTrace();

} finally {

try {

connection.close();

} catch (SQLException e) {

e.printStackTrace();

}

return 0;

}

controller

EmpController.java

package controller;

import java.util.List;

import entity.TbEmp;

import mapper.EmpMapper;

import service.EmpService;

public class EmpController {

EmpMapper empMapper=new EmpService();

public List allInfoList(){

List queryAll = empMapper.queryAll();

return queryAll;

}

//添加

public int addEmp(TbEmp tbEmp){

return empMapper.addEmp(tbEmp);

}

//更新

public int updataEmp(TbEmp tbEmp){

return empMapper.updateEmp(tbEmp);

}

//删除

public int delInfo(int id){

return empMapper.del(id);

}

servlet

EmpShowServlet.java

package servlet;

import java.io.IOException;

import java.util.List;

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 javax.servlet.http.HttpSession;

import controller.EmpController;

import entity.TbEmp;

@WebServlet(“/EmpShowServlet”)

public class EmpShowServlet extends HttpServlet {

private static final long serialVersionUID = 1L;

public EmpShowServlet() {

super();

}

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

doPost(request, response);

}

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

request.setCharacterEncoding(“utf-8”);

response.setCharacterEncoding(“utf-8”);

EmpController controller=new EmpController();

List tbemp = controller.allInfoList();

HttpSession session = request.getSession();

session.setAttribute(“empsList”, tbemp);

request.getRequestDispatcher(“main.jsp”).forward(request, response);

}

AddEmpServlet.java

package servlet;

import java.io.IOException;

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 controller.EmpController;

import entity.TbEmp;

@WebServlet(“/AddEmpServlet”)

public class AddEmpServlet extends HttpServlet {

private static final long serialVersionUID = 1L;

public AddEmpServlet() {

super();

}

protected void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

doPost(request, response);

}

protected void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

request.setCharacterEncoding(“utf-8”);

response.setCharacterEncoding(“utf-8”);

EmpController controller = new EmpController();

String name = request.getParameter(“name”);

String gender = request.getParameter(“gender”);

String birthday = request.getParameter(“birthday”);

String phone = request.getParameter(“phone”);

TbEmp emp = new TbEmp(0, name, gender, birthday, phone);

int addEmp = controller.addEmp(emp);

if (addEmp > 0) {

response.sendRedirect(“EmpShowServlet”);

}

DelServlet.java

package servlet;

import java.io.IOException;

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 controller.EmpController;

@WebServlet(“/DelServlet”)

public class DelServlet extends HttpServlet {

private static final long serialVersionUID = 1L;

public DelServlet() {

super();

}

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

doPost(request, response);

}

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

EmpController controller=new EmpController();

String id=request.getParameter(“id”);

int id1=Integer.parseInt(id);

int del = controller.delInfo(id1);

if (del>0) {

response.sendRedirect(“EmpShowServlet”);

}

UpdatEmpServlet.java

package servlet;

import java.io.IOException;

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 controller.EmpController;

import entity.TbEmp;

@WebServlet(“/UpdatEmpServlet”)

public class UpdataEmpServlet extends HttpServlet {

private static final long serialVersionUID = 1L;

public UpdataEmpServlet() {

super();

}

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

doPost(request, response);

}

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

request.setCharacterEncoding(“utf-8”);

response.setCharacterEncoding(“utf-8”);

EmpController controller=new EmpController();

Integer id= Integer.parseInt(request.getParameter(“id”).toString());

String name = request.getParameter(“name”);

String gender = request.getParameter(“gender”);

String birthday = request.getParameter(“birthday”);

String phone = request.getParameter(“phone”);

TbEmp emp=new TbEmp(id,name,gender,birthday,phone);

System.out.println(emp.toString());

int updatEmp = controller.updataEmp(emp);

if (updatEmp>0) {

response.sendRedirect(“EmpShowServlet”);

}

4、HTML代码：

main.jsp

<%@page import=“entity.TbEmp”%>

<%@page import=“java.util.List”%>

<%@ page language=“java” contentType=“text/html; charset=utf-8”

pageEncoding=“utf-8”%>

<%@ taglib uri=“http://java.sun.com/jsp/jstl/core” prefix=“c”%>

慧心人力资源管理系统

style=“font-size: 1.6rem; height: 50px; font-weight: bold;”>人力资源管理

员工编号员工姓名员工性别员工生日员工手机操作

List empsList = (List) session.getAttribute(“empsList”);

int i = 0;

<c:forEach items=“${empsList}” var=“emp”>

${emp.id } ${emp.name } ${emp.gender } ${emp.birthday } ${emp.phone }

value=“更新” /> <input type=“button” οnclick=“del(${emp.id })”

value=“删除” />

</c:forEach>

共计<%=empsList.size() + 1%>条数据

新增

style=“width: 500px; height: 400px; border: 1px solid #000; background-color: white; display: none; position: absolute; left: 40%; top: 10%;”

id=“UpdataDiv”>

style=“text-align: left;” width=“400” height=“200”>

style=“font-size: 1.6rem; height: 50px; font-weight: bold;”>更新员工信息

员工姓名：员工性别：男

女

员工生日：

value=“” />

员工号码：

type=“button” value=“取消” class=“updata2”>

Java Web项目 慧心人力资源管理系统

util

entity

mapper

service

controller

servlet

main.jsp

Java Web项目慧心人力资源管理系统