基于javaweb的员工出差请假考勤管理系统(java+jsp+layui+html+servlet+mysql)

基于javaweb的员工出差请假考勤管理系统(java+jsp+layui+html+servlet+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

基于javaweb+mysql的员工出差请假考勤管理系统(java+JSP+LayUI+HTML+servlet+Mysql)

项目介绍

本项目为后台管理系统；

管理员角色包含以下功能：

登录,首页,考勤记录增删改查,假期申请记录增删改查,出差申请记录增删改查,加班申请记录增删改查,调休申请,考勤查询,查看考勤详情,员工管理增删改查等功能。

环境需要

1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可 4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS；  5.数据库：MySql 5.7版本； 6.是否Maven项目：否；

技术栈

HTML+JSP+CSS+JavaScript+LayUI+Servlet+Mysql

使用说明

1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven; 若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行； 3. 将项目中c3p0-config.xml与utils/C3P0Utils.java配置文件中的数据库配置改为自己的配置; 4. 运行项目，输入http://localhost:8080/kaoqin 登录 管理员账号/密码：admin/123456

员工管理控制层：

@RestController

@RequestMapping(“/employee”)

@CrossOrigin

@Slf4j

public class EmployeeController {

@Autowired

private EmployeeService employeeService;

@Autowired

private DepartmentService departmentService;

@Autowired

private JobService jobService;

@Autowired

private EduLevelMapper eduLevelMapper;

@Autowired

private EmployeeMapper employeeMapper;

/**

• 搜索接口

*/

@GetMapping(“/search”)

public Result search(@RequestParam(name = “name”, required = false,defaultValue = “”) String name,

@RequestParam(name = “current”, required = false, defaultValue = “1”) Integer current,

@RequestParam(name = “size”, required = false, defaultValue = “10”) Integer size) {

return employeeService.list(current, size, name);

/**

• 分页查询接口

• @param current

• @param size

• @return

*/

@GetMapping(“/list”)

public Result list(@RequestParam(name = “current”, required = false, defaultValue = “1”) Integer current,

@RequestParam(name = “size”, required = false, defaultValue = “10”) Integer size) {

return employeeService.list(current, size, null);

/**

• 根据id获取员工具体信息

• @param id

• @return

*/

@GetMapping(“/getUserById”)

public EmployeeDTO getUserAllInfoById(@RequestParam(name = “id”) Integer id) {

return employeeService.getUserById(id);

/**

• 根据员工获取信息

• @param id

• @return

*/

@GetMapping(“/getEmployeeById”)

public Employee getUserById(@RequestParam(name = “id”) Integer id) {

return employeeMapper.selectById(id);

/**

• 增加员工接口

• @param employee

• @return

*/

@PostMapping(“/add”)

public Map<String, Object> addUser(@RequestBody Employee employee) {

log.info(employee.toString());

return employeeService.add(employee);

/**

• 更新用户

• @param employee

• @return

*/

@PostMapping(“/update”)

public Map<String, Object> updateUser(@RequestBody Employee employee) {

log.info(employee.toString());

return employeeService.update(employee);

/**

• 删除用户

• @param id

• @return

*/

@GetMapping(“/delete”)

public Result deleteEmployeeById(@RequestParam(name = “id”) Integer id) {

return employeeService.deleteEmployeeById(id);

/**

• 辞退员工

• @param id

• @return

*/

@GetMapping(“/dismiss”)

public Map<String, Object> dismissEmployeeById(@RequestParam(name = “id”) Integer id) {

return employeeService.dismissEmployeeById(id);

/**

• 得到所以工作，部门，学历信息

• @return

*/

@GetMapping(“/otherInfo”)

public Result getAllOtherInfo() {

Map<String, Object> info = new HashMap<>();

info.put(“departments”, departmentService.selectAll());

info.put(“jobs”, jobService.selectAll());

info.put(“eduLevels”, eduLevelMapper.selectList(null));

return Result.success(info);

@GetMapping(“/map”)

public Result getMap() {

return employeeService.getMap();

登录管理业务处理层：

@Service

public class AuthServiceImpl implements AuthService {

@Autowired

private EmployeeMapper employeeMapper;

@Override

public Result login(String email, String password) {

//先用邮箱查询是否有这个员工

LambdaQueryWrapper queryWrapper = new LambdaQueryWrapper<>();

queryWrapper.eq(Employee::getEmail, email);

// queryWrapper.eq(Employee::getPassword, password);

Employee employee = employeeMapper.selectOne(queryWrapper);

//判断员工是否存在

if (employee == null) {

return Result.failure(ResponseCode.USER_NOT_FOUND);

} else {

//判断密码是否正确

if (!employee.getPassword().equals(password)) {

return Result.failure(ResponseCode.PASSWORD_ERROR);

// 生成token

String token = UUID.randomUUID().toString();

LoginDTO loginDTO = new LoginDTO();

if (employee.getAuthority() == 1) {

loginDTO.setSuper(true);

} else {

loginDTO.setSuper(false);

loginDTO.setToken(token);

loginDTO.setUserId(employee.getId());

return Result.success(loginDTO);

部门管理控制层：

@Service

public class DepartmentServiceImpl implements DepartmentService {

@Autowired

private DepartmentMapper departmentMapper;

@Autowired

private DeptManagerMapper deptManagerMapper;

@Autowired

private EmployeeMapper employeeMapper;

@Override

public List selectAll() {

List departmentDTOS = departmentMapper.selectAll();

for (DepartmentDTO departmentDTO : departmentDTOS) {

LambdaQueryWrapper queryWrapper = new LambdaQueryWrapper<>();

queryWrapper.eq(DeptManager::getDeptId, departmentDTO.getId());

DeptManager deptManager = deptManagerMapper.selectOne(queryWrapper);

// fixes bug #空指针异常, 如果部门没有经理, 会抛出空指针异常

if (deptManager != null) {

EmployeeDTO manager = employeeMapper.getUserById(deptManager.getEmpId());

departmentDTO.setManager(manager);

return departmentDTOS;

@Override

public Map<String, Object> add(Map<String, Object> map) {

//先查询是否有部门

String name = (String) map.get(“name”);

Integer managerId = Integer.parseInt((String) map.get(“managerId”));

LambdaQueryWrapper wrapper = new LambdaQueryWrapper<>();

wrapper.eq(Department::getName, name);

Integer count = departmentMapper.selectCount(wrapper);

if (count != 0) {

map.put(“code”, 511);

map.put(“message”, “部门存在”);

return map;

//查询经理是否存在

LambdaQueryWrapper wrapper1 = new LambdaQueryWrapper<>();

wrapper1.eq(Employee::getId, managerId);

Integer count1 = employeeMapper.selectCount(wrapper1);

if (count1 == 0) {

map.put(“code”, 404);

map.put(“message”, “用户不存在”);

return map;

//定义返回结果

Map<String, Object> resultMap = new HashMap<>();

Department department = new Department();

department.setIntro((String) map.get(“descriiption”));

department.setName((String) map.get(“name”));

//插入部门

int i = departmentMapper.insert(department);

//部门经理表

DeptManager deptManager = new DeptManager();

deptManager.setDeptId(department.getId());

deptManager.setEmpId(managerId);

int insert = deptManagerMapper.insert(deptManager);

if (i !=0 ) {

map.put(“code”, 200);

map.put(“message”, “添加成功”);

return map;

} else {

map.put(“code”, 500);

map.put(“message”, “添加失败”);

return map;

---