Java源码社

基于javaweb的JSP+Servlet工资管理系统(java+servlet+jsp+mysql+tomcat)

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

121924401401

131924401401

141924401401

151924401401

161924401401

171924401401

181924401401

基于javaweb的JSP+Servlet工资管理系统(java+servlet+jsp+mysql+tomcat)

登录：
admin 123456

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
    }
    req.getRequestDispatcher("/WEB-INF/jsp/employStatus/editInfo.jsp").forward(req, resp);
    break;
}
case "/status/retrieve": {
    String queryDepartment = req.getParameter("staffDepartment");
    String queryMonth = req.getParameter("month");
    String queryName = req.getParameter("name");
    if(queryMonth.equals("所有月份")){
        if(queryDepartment.equals("所有部门")){
            if(queryName.equals("所有员工")){
                List<Status> statuses = service.getAllStatuses();
                req.setAttribute("statuses", statuses);
            }else{
                List<Status> statuses = service.getStatusByName(queryName);
                req.setAttribute("statuses", statuses);
            }
        }else{
            if(queryName.equals("所有员工")){
                List<Status> statuses = service.getStatusByDepartment(queryDepartment);
                req.setAttribute("statuses", statuses);
            }else{
                List<Status> statuses = service.getStatusesByDepartmentAndName(queryDepartment, queryName);
                req.setAttribute("statuses", statuses);
            }
        }
    }else{
        if(queryDepartment.equals("所有部门")){
            if(queryName.equals("所有员工")){
                List<Status> statuses = service.getStatusByMonth(Integer.parseInt(queryMonth));
                req.setAttribute("statuses", statuses);
            }else{
                Status status = service.getStatusByNameAndMonth(queryName,Integer.parseInt(queryMonth));
                req.setAttribute("status", status);
            }
        }else{
            if(queryName.equals("所有员工")){
                List<Status> statuses = service.getStatusesByDepartmentAndMonth(queryDepartment,Integer.parseInt(queryMonth));
                req.setAttribute("statuses", statuses);
            }else{
                List<Status> statuses = service.getStatusesByNameMonthAndDepartment(queryName,Integer.parseInt(queryMonth),queryDepartment);
                req.setAttribute("statuses", statuses);
            }
        }
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33


@WebServlet({"/salary", "/salary/retrieve"})
public class SalaryServlet extends HttpServlet {

    private SalaryService service = new SalaryService();

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        HttpSession session = req.getSession();
        String path = req.getServletPath();
        switch (path){
            case "/salary":{
                List<Salary> salaries = service.getAllSalaries();
                req.setAttribute("salaries", salaries);
                req.getRequestDispatcher("/WEB-INF/jsp/salary/salaryInfo.jsp").forward(req, resp);
                break;
            }
            case "/salary/retrieve": {
                String queryDepartment = req.getParameter("department");
                String queryMonth = req.getParameter("month");
                String queryName = req.getParameter("name");
                if(queryMonth.equals("所有月份")){
                    if(queryDepartment.equals("所有部门")){
                        if(queryName.equals("所有员工")){
                            List<Salary> salaries = service.getAllSalaries();
                            req.setAttribute("salaries", salaries);
                        }else{
                            List<Salary> salaries = service.getSalariesByName(queryName);
                            req.setAttribute("salaries", salaries);
                        }
                    }else{
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
                } else {
                    errMessage = "员工工作信息参数格式错误！";
                }
                if (errMessage != null) {
                    session.setAttribute("errMessage", errMessage);
                }
                resp.sendRedirect("/status/info");
                break;
            }
            case "/status/save":
            case "/status/create/save":{
                Status status = new Status();
                status.setMonth(Integer.parseInt(req.getParameter("month")));
                status.setName(req.getParameter("name"));
                status.setAttendDay(Integer.parseInt(req.getParameter("attendDay")));
                status.setSubsidyDay(Integer.parseInt(req.getParameter("subsidyDay")));
                String errMessage = service.UpdateStatus(status);
                System.out.println(errMessage);
                if (errMessage == null) {
                    session.setAttribute("message", "员工工作信息保存成功！");
                } else {
                    session.setAttribute("errMessage", errMessage);
                }
                resp.sendRedirect("/status/info");
                break;
            }
            case "/status/info":
                req.getRequestDispatcher("/WEB-INF/jsp/message.jsp").forward(req, resp);
                break;
        }
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        doGet(req, resp);
    }
}


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
private StatusService service = new StatusService();

@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
    req.setCharacterEncoding("utf-8");
    HttpSession session = req.getSession();
    String path = req.getServletPath();
    switch (path){
        case "/status":{
            List<Status> statuses = service.getAllStatuses();
            req.setAttribute("statuses", statuses);
            req.getRequestDispatcher("/WEB-INF/jsp/employStatus/statusInfo.jsp").forward(req, resp);
            break;
        }
        case "/status/create":{
            session.removeAttribute("status");
            Object obj = session.getAttribute("status");
            System.out.println(obj);
            if (obj == null){
                Status status = new Status();
                session.setAttribute("status",status);
            }
            req.getRequestDispatcher("/WEB-INF/jsp/employStatus/editInfo.jsp").forward(req, resp);
            break;
        }
        case "/status/retrieve": {
            String queryDepartment = req.getParameter("staffDepartment");
            String queryMonth = req.getParameter("month");
            String queryName = req.getParameter("name");
            if(queryMonth.equals("所有月份")){
                if(queryDepartment.equals("所有部门")){
                    if(queryName.equals("所有员工")){
                        List<Status> statuses = service.getAllStatuses();
                        req.setAttribute("statuses", statuses);
                    }else{
                        List<Status> statuses = service.getStatusByName(queryName);
                        req.setAttribute("statuses", statuses);
                    }
                }else{
                    if(queryName.equals("所有员工")){
                        List<Status> statuses = service.getStatusByDepartment(queryDepartment);
                        req.setAttribute("statuses", statuses);
                    }else{
                        List<Status> statuses = service.getStatusesByDepartmentAndName(queryDepartment, queryName);
                        req.setAttribute("statuses", statuses);
                    }
                }
            }else{
                if(queryDepartment.equals("所有部门")){
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
            req.setAttribute("staffs", staffs);
        }
    }
    req.getRequestDispatcher("/WEB-INF/jsp/staff/info.jsp").forward(req, resp);
    break;
}
case "/staff/update":
case "/staff/delete": {
    String errMessage = null;
    String idStr = req.getParameter("id");
    if (idStr != null && idStr.matches("[0-9]+")) {
        Staff staff = service.getStaff(Integer.parseInt(idStr));
        if (staff == null) {
            errMessage = "没有指定编号的员工！";
        } else {
            if ("/staff/update".equals(path)) {
                session.setAttribute("staff", staff);
                req.getRequestDispatcher("/WEB-INF/jsp/staff/editInfo.jsp").forward(req, resp);
            } else {
                errMessage = service.deleteStaff(staff.getId());
                if (errMessage == null) {
                    session.setAttribute("message", "员工信息删除成功！");
                }
            }
        }
    } else {
        errMessage = "员工设定参数格式错误！";
    }
    if (errMessage != null) {
        session.setAttribute("errMessage", errMessage);
    }
    resp.sendRedirect("/staff/info");
    break;
}
case "/staff/save": {
    Staff staff = new Staff();
    staff.setId(Integer.parseInt(req.getParameter("id")));
    staff.setName(req.getParameter("name"));
    staff.setStaffDepartment(req.getParameter("staffDepartment"));
    staff.setStaffDuty(req.getParameter("staffDuty"));
    String errMessage = service.UpdateStaff(staff);
    System.out.println(errMessage);
    if (errMessage == null) {
        session.setAttribute("message", "员工信息保存成功！");
    } else {
        session.setAttribute("errMessage", errMessage);
    }
    resp.sendRedirect("/staff/info");
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
    }
}



@WebServlet({"/staff", "/staff/create", "/staff/delete", "/staff/update", "/staff/retrieve", "/staff/save", "/staff/info"})
public class StaffServlet extends HttpServlet {

    private StaffService service = new StaffService();

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        HttpSession session = req.getSession();
        String path = req.getServletPath();
        switch (path){
            case "/staff":{
                List<Staff> staffs = service.getAllStaffs();
                req.setAttribute("staffs", staffs);
                req.getRequestDispatcher("/WEB-INF/jsp/staff/info.jsp").forward(req, resp);
                break;
            }
            case "/staff/create":{
                session.removeAttribute("staff");
                Object obj = session.getAttribute("staff");
                if (obj == null){
                    Staff staff = new Staff();
                    session.setAttribute("staff",staff);
                }
                req.getRequestDispatcher("/WEB-INF/jsp/staff/editInfo.jsp").forward(req, resp);
                break;
            }
            case "/staff/retrieve": {
                String queryDepartment = req.getParameter("staffDepartment");
                //System.out.println(queryDepartment);
                String queryName = req.getParameter("name");
                if(queryDepartment.equals("所有部门")){
                    if(queryName.equals("所有员工")){
                        List<Staff> staffs = service.getAllStaffs();
                        req.setAttribute("staffs", staffs);

项目链接：
https://javayms.github.io?id=111924401401201kw
https://javayms.pages.dev?id=111924401401201kw