员工信息管理系统

一、项目介绍

1、项目用到的技术栈

1. 开发工具：idea
2. 语言：java、js、html+ajax
3. 数据库：MySQL
4. 服务器：Tomcat
5. 框架：mybatis、jQuery、layui

2、项目实现功能

1. 管理员、部门负责人、员工登录和退出功能以及用户注册功能（根据不同的账号密码进入不同的页面，注册页面以及登录都有校验
2. 管理员可查看公司内部所有人员信息，增删改查员工信息，部门信息，工资调整、员工请假信息
3. 部门负责人可以查看公司内部人员信息，本部门内人员的请假信息，审批本部门请假信息、增删改查本部门内的员工信息、管理部门内员工工资信息
4. 普通职员可以查看所有员工信息，查询工资、修改密码、实现请假功能

3、实现过程

1. 写需求分析，画ER图
2. 搭建基本结构
3. 构建MVC框架
4. 编写代码

二、项目展示

1、登录界面以及用户注册界面

1. 用户登录

2. 用户注册界面

2、员工可实现功能

1. 员工界面首页

2. 员工请假页面

3. 员工查询工资

3、管理员可实现功能

1. 管理员界面首页

2. 管理员查看部门信息

3. 管理员查看所有人员账号密码

4. 管理员查看请假信息

5. 管理员修改信息（修改时信息回显）

4. 部门负责人实现功能

1. 查询所有员工信息

2. 查询本部门员工信息（可修改）

3. 本部门请假信息

三、项目代码

1. 项目基本结构

2. 数据库表

   1. dept表字段：

   2. emp表字段：

   3. leavetable表字段

   4. sal表字段

   5. user表字段

3. 部分代码

   package eims.web.servlet;
   
   import com.alibaba.fastjson.JSON;
   import eims.pojo.*;
   import eims.service.impl.UserServiceImpl;
   
   import javax.crypto.spec.PSource;
   import javax.servlet.ServletException;
   import javax.servlet.annotation.WebServlet;
   import javax.servlet.http.HttpServletRequest;
   import javax.servlet.http.HttpServletResponse;
   import java.io.BufferedReader;
   import java.io.IOException;
   import java.nio.charset.StandardCharsets;
   import java.util.List;
   import java.util.Objects;
   
   @WebServlet("/works/*")
   public class UserServlet extends BaseServlet {
       private UserServiceImpl userService = new UserServiceImpl();
   
       //查询所有的员工信息
       public void selectAllEmpServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           //调用service查询
           List<Emp> emps = userService.empSelectAll();
           //将集合转换为JSON数据
           String jsonString = JSON.toJSONString(emps);
           //响应数据
           response.setContentType("text/json;charset=utf-8");
           response.getWriter().write(jsonString);
       }
   
       //添加员工信息
       public void addEmpServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
   
           //1.接受数据，request.getParameter 不能接受JSON数据
           //获取请求体数据
           BufferedReader br = request.getReader();
           String readLine = br.readLine();
           //将json字符串转化为Java对象
           Emp emp = JSON.parseObject(readLine, Emp.class);
           User user = JSON.parseObject(readLine, User.class);
           String name = emp.getName();
           String phone =emp.getPhone();
           String username=user.getUsername();
           String password= user.getPassword();
           if (Objects.equals(username, "")){
               response.getWriter().write("user");
           }else if (username.trim().equals("")){
               response.getWriter().write("user");
           } else if (Objects.equals(name, "")) {
               response.getWriter().write("name");
           } else if (phone.length()!=11) {
               response.getWriter().write("phone");
           } else if (phone.equals("")) {
               response.getWriter().write("phone1");
           } else if (Objects.equals(password, "")) {
               response.getWriter().write("password");
           } else {
               //调用service添加
               userService.addUser(user);
               System.out.println(user);
               userService.addEmp(emp);
               //响应成功标识
               response.getWriter().write("success");
           }
       }
   
       //删除员工信息
       public void deleteServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           String id = request.getParameter("id");
           Emp emp = new Emp();
           User user = new User();
           emp.setEid(Integer.parseInt(id));
           user.setEid(Integer.parseInt(id));
           userService.delete1(user);
           userService.delete2(emp);
           response.getWriter().write("deleteSuccess");
       }
   
       //通过id查询员工信息
       public void selectEmpByIdServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           String id = request.getParameter("id");
           Emp emp = userService.selectEmpById(Integer.parseInt(id));
           //将集合转换为JSON数据
           String jsonString = JSON.toJSONString(emp);
           //响应数据
           response.setContentType("text/json;charset=utf-8");
           response.getWriter().write(jsonString);
       }
   
       //更新员工信息
       public void updateEmpServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           //1.接受数据，request.getParameter 不能接受JSON数据
           //获取请求体数据
           BufferedReader br = request.getReader();
           String readLine = br.readLine();
           //将json字符串转化为Java对象
           Emp emp = JSON.parseObject(readLine, Emp.class);
           //调用service添加
           userService.updateEmp(emp);
           int eid = emp.getEid();
           int deptno = emp.getDeptno();
           User user = JSON.parseObject(readLine, User.class);
           System.out.println(user);
           userService.updateUserDeptNo(user);
   
           response.getWriter().write("updateEmpSuccess");
       }
   
       //查询所有部门信息
       public void selectAllDeptServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           List<Dept> depts = userService.deptSelectAll();
           //将集合转换为JSON数据
           String jsonString = JSON.toJSONString(depts);
           //响应数据
           response.setContentType("text/json;charset=utf-8");
           response.getWriter().write(jsonString);
       }
   
       //添加部门信息
       public void addDeptServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           //1.接受数据，request.getParameter 不能接受JSON数据
           //获取请求体数据
           BufferedReader br = request.getReader();
           String readLine = br.readLine();
           //将json字符串转化为Java对象
           Dept dept = JSON.parseObject(readLine, Dept.class);
           //调用service添加
           System.out.println(dept);
           userService.addDept(dept);
           //响应成功标识
           response.getWriter().write("addDeptSuccess");
       }
   
       //通过部门编号查询部门信息
       public void selectDeptByIdServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           String deptNo = request.getParameter("deptNo");
           Dept dept = userService.selectDeptByDeptNo(Integer.parseInt(deptNo));
           //将集合转换为JSON数据
           String jsonString = JSON.toJSONString(dept);
           //响应数据
           response.setContentType("text/json;charset=utf-8");
           response.getWriter().write(jsonString);
       }
   
       //修改部门信息
       public void updateDeptServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           //1.接受数据，request.getParameter 不能接受JSON数据
           //获取请求体数据
           BufferedReader br = request.getReader();
           String readLine = br.readLine();
           //将json字符串转化为Java对象
           Dept dept = JSON.parseObject(readLine, Dept.class);
           System.out.println(dept);
           //调用service添加
           userService.updateDept(dept);
           response.getWriter().write("updateDeptSuccess");
       }
   
       //逻辑删除部门信息
       public void deleteDeptServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           String deptNo = request.getParameter("deptNo");
           Dept dept = new Dept();
           dept.setDeptNo(Integer.parseInt(deptNo));
           userService.updateIsDeleteDept(dept);
           response.getWriter().write("deleteDeptSuccess");
       }
   
       //逻辑删除后添加部门信息
       public void deleteDeptAfterAddServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           String deptNo = request.getParameter("deptNo");
           Dept dept = new Dept();
           if (userService.selectDeptByDeptNo(Integer.parseInt(deptNo)) != null) {
               dept.setDeptNo(Integer.parseInt(deptNo));
               userService.updateAddIsDeleteDept(dept);
               response.getWriter().write("deleteDeptAfterAddSuccess");
           } else {
               response.getWriter().write("isNOtExist");
           }
       }
   
       //查询所有职工工资信息
       public void selectAllSalServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           List<Sal> sals = userService.selectAllSal();
           //将集合转换为JSON数据
           String jsonString = JSON.toJSONString(sals);
           //响应数据
           response.setContentType("text/json;charset=utf-8");
           response.getWriter().write(jsonString);
       }
   
       //通过员工id查询工资信息
       public void selectSalByIdServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           String eid = request.getParameter("eid");
           Sal sal = userService.selectSalById(Integer.parseInt(eid));
           Emp emp = userService.selectEmpById(Integer.parseInt(eid));
           //将集合转换为JSON数据
           String jsonString = JSON.toJSONString(sal);
           String jsonString1 = JSON.toJSONString(emp);
   
           if (jsonString.equals("null")) {
               jsonString = "{\"eid\":" + emp.getEid() + ",\"salary\":0}";
           }
           int index1 = jsonString1.indexOf("}");
           int index2 = jsonString.lastIndexOf("{");
           String s = jsonString.substring(index2 + 1);
           String s1 = jsonString1.substring(0, index1);
           String json = s1 + "," + s;
           //响应数据
           response.setContentType("text/json;charset=utf-8");
           response.getWriter().write(json);
       }
   
       //修改员工薪资
       public void updateSalServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           //1.接受数据，request.getParameter 不能接受JSON数据
           //获取请求体数据
           BufferedReader br = request.getReader();
           String readLine = br.readLine();
           //将json字符串转化为Java对象
           Sal sal = JSON.parseObject(readLine, Sal.class);
           System.out.println(sal);
           //调用service添加
           userService.updateSal(sal);
           response.getWriter().write("updateSalSuccess");
       }
   
       //当修改的员工薪资不存在时添加该员工的信息到数据库中
       public void addSalServlet(HttpServletRequest request, HttpServletResponse response) throws IOException {
           //1.接受数据，request.getParameter 不能接受JSON数据
           //获取请求体数据
           BufferedReader br = request.getReader();
           String readLine = br.readLine();
           //将json字符串转化为Java对象
           Sal sal = JSON.parseObject(readLine, Sal.class);
           //调用service添加
           System.out.println(sal);
           userService.addSal(sal);
           //响应成功标识
           response.getWriter().write("addSalSuccess");
       }
   
       public void selectSalByIdServlet2(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           String eid = request.getParameter("eid");
           if (userService.selectSalById(Integer.parseInt(eid)) == null) {
               //响应数据
               response.setContentType("text/json;charset=utf-8");
               response.getWriter().write("addSalById");
           } else {
               response.setContentType("text/json;charset=utf-8");
               response.getWriter().write("isExist");
           }
       }
   
       public void selectAllLeavesServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           List<Leave> leaves = userService.selectAllLeaves();
           //将集合转换为JSON数据
           String jsonString = JSON.toJSONString(leaves);
           //响应数据
           response.setContentType("text/json;charset=utf-8");
           response.getWriter().write(jsonString);
       }
   
       //    //查询所有的员工信息
   //    public void mainSelectEmpServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
   //        //调用service查询
   //        List<Emp> emps = userService.mainSelectEmp();
   //        //将集合转换为JSON数据
   //        String jsonString = JSON.toJSONString(emps);
   //        //响应数据
   //        response.setContentType("text/json;charset=utf-8");
   //        response.getWriter().write(jsonString);
   //    }
       //通过部门编号查询员工信息
       public void mainSelectEmpByDeptNoServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           String deptNo = request.getParameter("deptNo");
           //调用service查询
           List<Emp> emps = userService.mainSelectEmpByDeptNo(Integer.parseInt(deptNo));
           //将集合转换为JSON数据
           String jsonString = JSON.toJSONString(emps);
           //响应数据
           response.setContentType("text/json;charset=utf-8");
           response.getWriter().write(jsonString);
       }
   
       //通过负责人编号查询请假信息
       public void selectLeavesByIdServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           String eid = request.getParameter("eid");
           List<Leave> leaves = userService.selectLeavesById(Integer.parseInt(eid));
           //将集合转换为JSON数据
           String jsonString = JSON.toJSONString(leaves);
           //响应数据
           response.setContentType("text/json;charset=utf-8");
           response.getWriter().write(jsonString);
       }
   
       public void leaveIsAgreeServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           String id = request.getParameter("id");
           System.out.println(id);
           userService.leaveIsAgreeServlet(Integer.parseInt(id));
           response.getWriter().write("isAgree");
       }
   
       public void leaveIsNotAgreeServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           String id = request.getParameter("id");
           System.out.println(id);
           userService.leaveIsNotAgreeServlet(Integer.parseInt(id));
           response.getWriter().write("isNotAgree");
       }
   
       //通过id查询自己的薪资信息
       public void selectSalaryByIdServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           String eid = request.getParameter("eid");
           Sal sal = userService.selectSalaryById(Integer.parseInt(eid));
           //将集合转换为JSON数据
           String jsonString = JSON.toJSONString(sal);
           //响应数据
           response.setContentType("text/json;charset=utf-8");
           response.getWriter().write(jsonString);
       }
   
       //通过id查询自己的请假信息
       public void empSelectLeavesByIdServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           String eid = request.getParameter("eid");
           List<Leave> leaves = userService.empSelectLeavesById(Integer.parseInt(eid));
           //将集合转换为JSON数据
           String jsonString = JSON.toJSONString(leaves);
           //响应数据
           response.setContentType("text/json;charset=utf-8");
           response.getWriter().write(jsonString);
       }
   
       //添加请假信息
       public void addLeaveServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           String deptNo = request.getParameter("deptNo");
           //1.接受数据，request.getParameter 不能接受JSON数据
           //获取请求体数据
           BufferedReader br = request.getReader();
           String readLine = br.readLine();
           //将json字符串转化为Java对象
           Leave leave = JSON.parseObject(readLine, Leave.class);
           //调用service添加
           userService.addLeave(leave);
           leave.setDeptNo(Integer.parseInt(deptNo));
           System.out.println(leave);
           System.out.println(deptNo);
           //响应成功标识
           response.getWriter().write("addLeaveSuccess");
       }
   
       //通过id修改密码
       public void changePasswordServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           //获取请求体数据
           BufferedReader br = request.getReader();
           String readLine = br.readLine();
           //将json字符串转化为Java对象
           User user1 = JSON.parseObject(readLine, User.class);
           int eid = user1.getEid();
           String oldpassword = user1.getOldpassword();
           String newpassword = user1.getNewpassword();
           String newpassword2 = user1.getNewpassword2();
           User user = userService.selectUserById(eid);
           System.out.println(user.getPassword());
           if (!oldpassword.equals(user.getPassword())) {
               response.getWriter().write("err");
           } else if (!newpassword2.equals(newpassword)) {
               response.getWriter().write("new_err");
           } else {
               userService.updateNewPassword(user1);
               //响应数据
               response.getWriter().write("changeSuccess");
           }
       }
   
       public void selectAllPasswordServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           List<User> users = userService.selectAllPassword();
           //将集合转换为JSON数据
           String jsonString = JSON.toJSONString(users);
           //响应数据
           response.setContentType("text/json;charset=utf-8");
           response.getWriter().write(jsonString);
       }
   
       public void changepsd2Servlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           String eid = request.getParameter("eid");
           userService.changepsd2(Integer.parseInt(eid));
           response.getWriter().write("success");
       }
   
       public void searchName(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           String name = request.getParameter("name");
           //解决中文乱码问题
           name = new String(name.getBytes(StandardCharsets.ISO_8859_1), StandardCharsets.UTF_8);
           List<Emp> emps = userService.searchName(name);
           //将集合转换为JSON数据
           String jsonString = JSON.toJSONString(emps);
           //响应数据
           response.setContentType("text/json;charset=utf-8");
           response.getWriter().write(jsonString);
       }
   
       public void searchEid(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           String eid = request.getParameter("eid");
           //解决中文乱码问题
           List<Emp> emps = userService.searchEid(eid);
           //将集合转换为JSON数据
           String jsonString = JSON.toJSONString(emps);
           //响应数据
           response.setContentType("text/json;charset=utf-8");
           response.getWriter().write(jsonString);
       }
   
       public void searchDept(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           String dept = request.getParameter("dept");
           //解决中文乱码问题
           dept = new String(dept.getBytes(StandardCharsets.ISO_8859_1), StandardCharsets.UTF_8);
           List<Emp> emps = userService.searchDept(dept);
           //将集合转换为JSON数据
           String jsonString = JSON.toJSONString(emps);
           //响应数据
           response.setContentType("text/json;charset=utf-8");
           response.getWriter().write(jsonString);
       }
   
       public void searchDeptName(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           String dept = request.getParameter("dept");
           //解决中文乱码问题
           dept = new String(dept.getBytes(StandardCharsets.ISO_8859_1), StandardCharsets.UTF_8);
           String name = request.getParameter("name");
           //解决中文乱码问题
           name = new String(name.getBytes(StandardCharsets.ISO_8859_1), StandardCharsets.UTF_8);
           List<Emp> emps = userService.searchDeptName(name, dept);
           //将集合转换为JSON数据
           String jsonString = JSON.toJSONString(emps);
           //响应数据
           response.setContentType("text/json;charset=utf-8");
           response.getWriter().write(jsonString);
       }
   
       public void searchAddress(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           String address = request.getParameter("address");
           //解决中文乱码问题
           address = new String(address.getBytes(StandardCharsets.ISO_8859_1), StandardCharsets.UTF_8);
           List<Emp> emps = userService.searchAddress(address);
           //将集合转换为JSON数据
           String jsonString = JSON.toJSONString(emps);
           //响应数据
           response.setContentType("text/json;charset=utf-8");
           response.getWriter().write(jsonString);
       }
   
       public void searchDeptAddress(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           String address = request.getParameter("address");
           //解决中文乱码问题
           address = new String(address.getBytes(StandardCharsets.ISO_8859_1), StandardCharsets.UTF_8);
           String dept = request.getParameter("dept");
           //解决中文乱码问题
           dept = new String(dept.getBytes(StandardCharsets.ISO_8859_1), StandardCharsets.UTF_8);
           List<Emp> emps = userService.searchDeptAddress(address, dept);
           //将集合转换为JSON数据
           String jsonString = JSON.toJSONString(emps);
           //响应数据
           response.setContentType("text/json;charset=utf-8");
           response.getWriter().write(jsonString);
       }
   
       public void searchAge(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           String age = request.getParameter("age");
           //解决中文乱码问题
           age = new String(age.getBytes(StandardCharsets.ISO_8859_1), StandardCharsets.UTF_8);
           List<Emp> emps = userService.searchAge(age);
           //将集合转换为JSON数据
           String jsonString = JSON.toJSONString(emps);
           //响应数据
           response.setContentType("text/json;charset=utf-8");
           response.getWriter().write(jsonString);
       }
   
       public void searchAgeName(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           String age = request.getParameter("age");
           //解决中文乱码问题
           age = new String(age.getBytes(StandardCharsets.ISO_8859_1), StandardCharsets.UTF_8);
           String name = request.getParameter("name");
           //解决中文乱码问题
           name = new String(name.getBytes(StandardCharsets.ISO_8859_1), StandardCharsets.UTF_8);
           List<Emp> emps = userService.searchAgeName(age, name);
           //将集合转换为JSON数据
           String jsonString = JSON.toJSONString(emps);
           //响应数据
           response.setContentType("text/json;charset=utf-8");
           response.getWriter().write(jsonString);
       }
   
       public void searchAgeAddress(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
           String age = request.getParameter("age");
           //解决中文乱码问题
           age = new String(age.getBytes(StandardCharsets.ISO_8859_1), StandardCharsets.UTF_8);
           String address = request.getParameter("address");
           //解决中文乱码问题
           address = new String(address.getBytes(StandardCharsets.ISO_8859_1), StandardCharsets.UTF_8);
           List<Emp> emps = userService.searchAgeAddress(age, address);
           //将集合转换为JSON数据
           String jsonString = JSON.toJSONString(emps);
           //响应数据
           response.setContentType("text/json;charset=utf-8");
           response.getWriter().write(jsonString);
       }
   }