員工信息管理系統(tǒng)
一、項(xiàng)目介紹
1、項(xiàng)目用到的技術(shù)棧
- 開發(fā)工具:idea
- 語言:java、js、html+ajax
- 數(shù)據(jù)庫:MySQL
- 服務(wù)器:Tomcat
- 框架:mybatis、jQuery、layui
2、項(xiàng)目實(shí)現(xiàn)功能
- 管理員、部門負(fù)責(zé)人、員工登錄和退出功能以及用戶注冊(cè)功能(根據(jù)不同的賬號(hào)密碼進(jìn)入不同的頁面,注冊(cè)頁面以及登錄都有校驗(yàn)
- 管理員可查看公司內(nèi)部所有人員信息,增刪改查員工信息,部門信息,工資調(diào)整、員工請(qǐng)假信息
- 部門負(fù)責(zé)人可以查看公司內(nèi)部人員信息,本部門內(nèi)人員的請(qǐng)假信息,審批本部門請(qǐng)假信息、增刪改查本部門內(nèi)的員工信息、管理部門內(nèi)員工工資信息
- 普通職員可以查看所有員工信息,查詢工資、修改密碼、實(shí)現(xiàn)請(qǐng)假功能
3、實(shí)現(xiàn)過程
- 寫需求分析,畫ER圖
- 搭建基本結(jié)構(gòu)
- 構(gòu)建MVC框架
- 編寫代碼
二、項(xiàng)目展示
1、登錄界面以及用戶注冊(cè)界面
-
用戶登錄
-
用戶注冊(cè)界面
2、員工可實(shí)現(xiàn)功能
-
員工界面首頁
-
員工請(qǐng)假頁面
-
員工查詢工資
3、管理員可實(shí)現(xiàn)功能
-
管理員界面首頁
-
管理員查看部門信息
-
管理員查看所有人員賬號(hào)密碼
-
管理員查看請(qǐng)假信息
-
管理員修改信息(修改時(shí)信息回顯)
4. 部門負(fù)責(zé)人實(shí)現(xiàn)功能
-
查詢所有員工信息
-
查詢本部門員工信息(可修改)
-
本部門請(qǐng)假信息
三、項(xiàng)目代碼
-
項(xiàng)目基本結(jié)構(gòu)
-
數(shù)據(jù)庫表
-
dept表字段:
-
emp表字段:
-
leavetable表字段
-
sal表字段
-
user表字段
文章來源:http://www.zghlxwxcb.cn/news/detail-500312.html
-
-
部分代碼文章來源地址http://www.zghlxwxcb.cn/news/detail-500312.html
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 { //調(diào)用service查詢 List<Emp> emps = userService.empSelectAll(); //將集合轉(zhuǎn)換為JSON數(shù)據(jù) String jsonString = JSON.toJSONString(emps); //響應(yīng)數(shù)據(jù) response.setContentType("text/json;charset=utf-8"); response.getWriter().write(jsonString); } //添加員工信息 public void addEmpServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //1.接受數(shù)據(jù),request.getParameter 不能接受JSON數(shù)據(jù) //獲取請(qǐng)求體數(shù)據(jù) BufferedReader br = request.getReader(); String readLine = br.readLine(); //將json字符串轉(zhuǎn)化為Java對(duì)象 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 { //調(diào)用service添加 userService.addUser(user); System.out.println(user); userService.addEmp(emp); //響應(yīng)成功標(biāo)識(shí) 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)); //將集合轉(zhuǎn)換為JSON數(shù)據(jù) String jsonString = JSON.toJSONString(emp); //響應(yīng)數(shù)據(jù) response.setContentType("text/json;charset=utf-8"); response.getWriter().write(jsonString); } //更新員工信息 public void updateEmpServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //1.接受數(shù)據(jù),request.getParameter 不能接受JSON數(shù)據(jù) //獲取請(qǐng)求體數(shù)據(jù) BufferedReader br = request.getReader(); String readLine = br.readLine(); //將json字符串轉(zhuǎn)化為Java對(duì)象 Emp emp = JSON.parseObject(readLine, Emp.class); //調(diào)用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(); //將集合轉(zhuǎn)換為JSON數(shù)據(jù) String jsonString = JSON.toJSONString(depts); //響應(yīng)數(shù)據(jù) response.setContentType("text/json;charset=utf-8"); response.getWriter().write(jsonString); } //添加部門信息 public void addDeptServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //1.接受數(shù)據(jù),request.getParameter 不能接受JSON數(shù)據(jù) //獲取請(qǐng)求體數(shù)據(jù) BufferedReader br = request.getReader(); String readLine = br.readLine(); //將json字符串轉(zhuǎn)化為Java對(duì)象 Dept dept = JSON.parseObject(readLine, Dept.class); //調(diào)用service添加 System.out.println(dept); userService.addDept(dept); //響應(yīng)成功標(biāo)識(shí) response.getWriter().write("addDeptSuccess"); } //通過部門編號(hào)查詢部門信息 public void selectDeptByIdServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String deptNo = request.getParameter("deptNo"); Dept dept = userService.selectDeptByDeptNo(Integer.parseInt(deptNo)); //將集合轉(zhuǎn)換為JSON數(shù)據(jù) String jsonString = JSON.toJSONString(dept); //響應(yīng)數(shù)據(jù) response.setContentType("text/json;charset=utf-8"); response.getWriter().write(jsonString); } //修改部門信息 public void updateDeptServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //1.接受數(shù)據(jù),request.getParameter 不能接受JSON數(shù)據(jù) //獲取請(qǐng)求體數(shù)據(jù) BufferedReader br = request.getReader(); String readLine = br.readLine(); //將json字符串轉(zhuǎn)化為Java對(duì)象 Dept dept = JSON.parseObject(readLine, Dept.class); System.out.println(dept); //調(diào)用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(); //將集合轉(zhuǎn)換為JSON數(shù)據(jù) String jsonString = JSON.toJSONString(sals); //響應(yīng)數(shù)據(jù) 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)); //將集合轉(zhuǎn)換為JSON數(shù)據(jù) 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; //響應(yīng)數(shù)據(jù) response.setContentType("text/json;charset=utf-8"); response.getWriter().write(json); } //修改員工薪資 public void updateSalServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //1.接受數(shù)據(jù),request.getParameter 不能接受JSON數(shù)據(jù) //獲取請(qǐng)求體數(shù)據(jù) BufferedReader br = request.getReader(); String readLine = br.readLine(); //將json字符串轉(zhuǎn)化為Java對(duì)象 Sal sal = JSON.parseObject(readLine, Sal.class); System.out.println(sal); //調(diào)用service添加 userService.updateSal(sal); response.getWriter().write("updateSalSuccess"); } //當(dāng)修改的員工薪資不存在時(shí)添加該員工的信息到數(shù)據(jù)庫中 public void addSalServlet(HttpServletRequest request, HttpServletResponse response) throws IOException { //1.接受數(shù)據(jù),request.getParameter 不能接受JSON數(shù)據(jù) //獲取請(qǐng)求體數(shù)據(jù) BufferedReader br = request.getReader(); String readLine = br.readLine(); //將json字符串轉(zhuǎn)化為Java對(duì)象 Sal sal = JSON.parseObject(readLine, Sal.class); //調(diào)用service添加 System.out.println(sal); userService.addSal(sal); //響應(yīng)成功標(biāo)識(shí) 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) { //響應(yīng)數(shù)據(jù) 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(); //將集合轉(zhuǎn)換為JSON數(shù)據(jù) String jsonString = JSON.toJSONString(leaves); //響應(yīng)數(shù)據(jù) response.setContentType("text/json;charset=utf-8"); response.getWriter().write(jsonString); } // //查詢所有的員工信息 // public void mainSelectEmpServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // //調(diào)用service查詢 // List<Emp> emps = userService.mainSelectEmp(); // //將集合轉(zhuǎn)換為JSON數(shù)據(jù) // String jsonString = JSON.toJSONString(emps); // //響應(yīng)數(shù)據(jù) // response.setContentType("text/json;charset=utf-8"); // response.getWriter().write(jsonString); // } //通過部門編號(hào)查詢員工信息 public void mainSelectEmpByDeptNoServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String deptNo = request.getParameter("deptNo"); //調(diào)用service查詢 List<Emp> emps = userService.mainSelectEmpByDeptNo(Integer.parseInt(deptNo)); //將集合轉(zhuǎn)換為JSON數(shù)據(jù) String jsonString = JSON.toJSONString(emps); //響應(yīng)數(shù)據(jù) response.setContentType("text/json;charset=utf-8"); response.getWriter().write(jsonString); } //通過負(fù)責(zé)人編號(hào)查詢請(qǐng)假信息 public void selectLeavesByIdServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String eid = request.getParameter("eid"); List<Leave> leaves = userService.selectLeavesById(Integer.parseInt(eid)); //將集合轉(zhuǎn)換為JSON數(shù)據(jù) String jsonString = JSON.toJSONString(leaves); //響應(yīng)數(shù)據(jù) 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)); //將集合轉(zhuǎn)換為JSON數(shù)據(jù) String jsonString = JSON.toJSONString(sal); //響應(yīng)數(shù)據(jù) response.setContentType("text/json;charset=utf-8"); response.getWriter().write(jsonString); } //通過id查詢自己的請(qǐng)假信息 public void empSelectLeavesByIdServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String eid = request.getParameter("eid"); List<Leave> leaves = userService.empSelectLeavesById(Integer.parseInt(eid)); //將集合轉(zhuǎn)換為JSON數(shù)據(jù) String jsonString = JSON.toJSONString(leaves); //響應(yīng)數(shù)據(jù) response.setContentType("text/json;charset=utf-8"); response.getWriter().write(jsonString); } //添加請(qǐng)假信息 public void addLeaveServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String deptNo = request.getParameter("deptNo"); //1.接受數(shù)據(jù),request.getParameter 不能接受JSON數(shù)據(jù) //獲取請(qǐng)求體數(shù)據(jù) BufferedReader br = request.getReader(); String readLine = br.readLine(); //將json字符串轉(zhuǎn)化為Java對(duì)象 Leave leave = JSON.parseObject(readLine, Leave.class); //調(diào)用service添加 userService.addLeave(leave); leave.setDeptNo(Integer.parseInt(deptNo)); System.out.println(leave); System.out.println(deptNo); //響應(yīng)成功標(biāo)識(shí) response.getWriter().write("addLeaveSuccess"); } //通過id修改密碼 public void changePasswordServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //獲取請(qǐng)求體數(shù)據(jù) BufferedReader br = request.getReader(); String readLine = br.readLine(); //將json字符串轉(zhuǎn)化為Java對(duì)象 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); //響應(yīng)數(shù)據(jù) response.getWriter().write("changeSuccess"); } } public void selectAllPasswordServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { List<User> users = userService.selectAllPassword(); //將集合轉(zhuǎn)換為JSON數(shù)據(jù) String jsonString = JSON.toJSONString(users); //響應(yīng)數(shù)據(jù) 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); //將集合轉(zhuǎn)換為JSON數(shù)據(jù) String jsonString = JSON.toJSONString(emps); //響應(yīng)數(shù)據(jù) 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); //將集合轉(zhuǎn)換為JSON數(shù)據(jù) String jsonString = JSON.toJSONString(emps); //響應(yīng)數(shù)據(jù) 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); //將集合轉(zhuǎn)換為JSON數(shù)據(jù) String jsonString = JSON.toJSONString(emps); //響應(yīng)數(shù)據(jù) 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); //將集合轉(zhuǎn)換為JSON數(shù)據(jù) String jsonString = JSON.toJSONString(emps); //響應(yīng)數(shù)據(jù) 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); //將集合轉(zhuǎn)換為JSON數(shù)據(jù) String jsonString = JSON.toJSONString(emps); //響應(yīng)數(shù)據(jù) 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); //將集合轉(zhuǎn)換為JSON數(shù)據(jù) String jsonString = JSON.toJSONString(emps); //響應(yīng)數(shù)據(jù) 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); //將集合轉(zhuǎn)換為JSON數(shù)據(jù) String jsonString = JSON.toJSONString(emps); //響應(yīng)數(shù)據(jù) 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); //將集合轉(zhuǎn)換為JSON數(shù)據(jù) String jsonString = JSON.toJSONString(emps); //響應(yīng)數(shù)據(jù) 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); //將集合轉(zhuǎn)換為JSON數(shù)據(jù) String jsonString = JSON.toJSONString(emps); //響應(yīng)數(shù)據(jù) response.setContentType("text/json;charset=utf-8"); response.getWriter().write(jsonString); } }
到了這里,關(guān)于Javaweb實(shí)現(xiàn)員工信息管理系統(tǒng)的文章就介紹完了。如果您還想了解更多內(nèi)容,請(qǐng)?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章,希望大家以后多多支持TOY模板網(wǎng)!