基于javaweb+jsp的员工薪资工资管理系统

        Map result = new HashMap();
        result.put("list", list);
        result.put("totalCount", totalCount);
        return result;
    }
}
package com.demo.servlet;

import com.demo.util.Util;
import com.demo.service.DeptService;
import com.demo.service.impl.DeptServiceImpl;
import com.demo.vo.Dept;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.Serializable;
import java.util.HashMap;
import java.util.List;
import java.util.Map;


    @Override
    public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request, response);//Get请求和Post请求的处理是一样的，所以把request、response转交给Post方法就好
    }

            PreparedStatement ps = c.prepareStatement(sql);
            
            ps.setString(1, vo.getSalaryName());
            ps.setString(2, vo.getSalaryNo());
            ps.setString(3, vo.getSalaryMonth());
            ps.setString(4, vo.getSalaryMoney());
            ps.setString(5, vo.getSalaryJiaban());
            ps.setString(6, vo.getSalaryBonus());
            ps.setString(7, vo.getSalaryText());
            ps.execute();
            ps.close();
            c.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    //@Override
    public void update(Salary vo) {
        String sql = "update `t_salary` set `salary_name` = ? ,`salary_no` = ? ,`salary_month` = ? ,`salary_money` = ? ,`salary_jiaban` = ? ,`salary_bonus` = ? ,`salary_text` = ?  where `id` = ?";
        try {
            Connection c = Util.getConnection();
            PreparedStatement ps = c.prepareStatement(sql);

                layer.open({
                    type: 2,
                    area: ['800px', '550px'],
                    fixed: false, //不固定
                    maxmin: true,
                    content: 'employee_add.jsp'
                });
            } else {
                //layer.alert('这是工具栏右侧自定义的一个图标按钮');
            }
        });
        //搜索
        let $ = layui.$, active = {
            reload: function () {
                let url = 'EmployeeServlet?action=list&keyword=' + $('#search_keyword').val() + '&searchColumn=' + $('#searchColumn').val();
                //执行重载
                table.reload('myTable', {
                    url: url,
                    page: {

            Dept vo = new Dept();
            //取出页面传进来的各个数据，并设置到Dept对象的属性里
            vo.setDeptName(Util.decode(request, "deptName"));
            vo.setDeptLoc(Util.decode(request, "deptLoc"));
            vo.setDeptCount(Util.decode(request, "deptCount"));
            vo.setDeptLeader(Util.decode(request, "deptLeader"));
            vo.setDeptText(Util.decode(request, "deptText"));
            DeptService deptService = new DeptServiceImpl();
            //调用Service层增加方法（add），增加记录
            deptService.add(vo);
            this.redirectList(request, response);
        } else if ("delete".equals(action)) {//删除
            //取出表要删除的部门记录的主键
            long id = Long.parseLong(Util.decode(request, "id"));
            DeptService deptService = new DeptServiceImpl();
            //调用Service层删除方法（delete），将对应的记录删除
            deptService.delete(id);
            this.redirectList(request, response);
        } else if ("edit".equals(action)) {//修改
            //取出页面传进来的各个数据，并设置到Dept对象的属性里

import com.demo.vo.Employee;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;


public class EmployeeDAOImpl implements EmployeeDAO {

    //@Override

        int green = minColor + random.nextInt(maxColor - minColor);
        //  获得蓝色的随机颜色值
        int blue = minColor + random.nextInt(maxColor - minColor);
        return new Color(red, green, blue);
    }
}
package com.demo.dao.impl;

import com.demo.util.Util;
import com.demo.dao.EmployeeDAO;
import com.demo.vo.Employee;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;

<%@ page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>


    
    
    
    
    

    //@Override
    public void update(User vo) {
        String sql = "update `t_user` set `username` = ? ,`password` = ? ,`real_name` = ? ,`user_sex` = ? ,`user_phone` = ? ,`user_text` = ? ,`user_type` = ?  where `id` = ?";
        try {
            Connection c = Util.getConnection();
            PreparedStatement ps = c.prepareStatement(sql);
            
            ps.setString(1, vo.getUsername());
            ps.setString(2, vo.getPassword());
            ps.setString(3, vo.getRealName());
            ps.setString(4, vo.getUserSex());
            ps.setString(5, vo.getUserPhone());
            ps.setString(6, vo.getUserText());
            ps.setString(7, vo.getUserType());
            ps.setLong(8, vo.getId());
            ps.execute();

        //  保存minColor最大不会超过255
        if (maxColor > 255)
            maxColor = 255;
        //  获得红色的随机颜色值
        int red = minColor + random.nextInt(maxColor - minColor);
        //  获得绿色的随机颜色值
        int green = minColor + random.nextInt(maxColor - minColor);
        //  获得蓝色的随机颜色值
        int blue = minColor + random.nextInt(maxColor - minColor);
        return new Color(red, green, blue);
    }
}
package com.demo.dao.impl;

import com.demo.util.Util;
import com.demo.dao.EmployeeDAO;
import com.demo.vo.Employee;

运行环境

Java≥6、Tomcat≥7.0、MySQL≥5.5

开发工具

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

技术框架

JavaWeb JavaBean JSP MVC MySQL Tomcat Javascript Layui Ajax

基础JSP+Servlet或JSP+SSM(Spring、SpringMVC、MyBatis)框架或JSP+SSM+Maven(pom.xml)框架或SpringBoot…均可

适用

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

功能说明

登录、注册、退出、用户模块、公告模块、部门模块、员工模块、工资模块的增删改查管理