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

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”>