——————————DescriptionStart——————————
运行环境
Java≥8、MySQL≥5.7、Node.js≥14
开发工具
后端：eclipse/idea/myeclipse/sts等均可配置运行
前端：WebStorm/VSCode/HBuilderX等均可
❗没学过node.js的不要搞前后端分离项目
适用
课程设计，大作业，毕业设计，项目练习，学习演示等
功能说明
基于javaweb的SpringBoot公司日常考勤系统(java+springboot+mybaits+vue+elementui+mysql)
项目介绍
基于Springboot + vue实现的公司日常考勤系统
系统包含员工和管理员两个角色
员工：登录、个人中心、通知公告管理、员工管理、部门信息管理、考勤基点管理、员工工资管理等功能
管理员：登录、个人中心、通知公告管理、员工管理、部门信息管理、考勤基点管理、员工请假管理、员工考勤管理、员工工资管理等功能
环境需要
1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。
2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA;
3.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS；
4.数据库：MySql 5.7/8.0版本均可；
5.是否Maven项目：是；
技术栈
后端：SpringBoot+Mybaits
前端：Vue+elementui
使用说明
项目运行：
使用Navicat或者其它工具，在mysql中创建对应sql文件名称的数据库，并导入项目的sql文件；
使用IDEA/Eclipse/MyEclipse导入项目，导入成功后请执行maven clean;maven install命令；
将项目中application.yml配置文件中的数据库配置改为自己的配置;
运行项目，在浏览器中输入地址：
登录页面
http://localhost:8080/springbootqi5ww/admin/dist/index.html
管理员：abo 密码 abo
员工账户：员工1 密码：123456
注意项目文件路径中不能含有中文、空格、特殊字符等，否则图片会上传不成功。
登录页面展示：
文档展示：
通知公告展示：
员工考勤页面：
员工管理展示页面：
员工请假展示：
考勤信息展示：
部门信息展示：
员工工资展示：
——————————CodeStart——————————
用户管理控制层：
@RestController
@RequestMapping(“/user”)
public class AccountController {
@Autowired
private UserService userService;
@Autowired
private DataService dataService;
/**
注册
@param user
@return
*/
@PostMapping(“/register”)
public String register(@RequestBody User user) {
String username = user.getUsername();
String choice = user.getChoice();
String checkChoice = dataService.getChoice(username);
if(checkChoice.equals(“empty”)) {
// 学生信息不存在，请核对信息或者先进行录入
return “empty”;
}else {
if(choice.equals(checkChoice)) {
// 学生姓名和学号与真实对应，可进行注册
return userService.insertUser(user);
}else {
// 选择用户错误
return “error”;
/**
登录
@param user
@return
*/
@PostMapping(“/login”)
public String login(@RequestBody User user) {
String username = user.getUsername();
String password = user.getPassword();
String check = user.getChoice();
User test = userService.findAllByUsername(username);
if(test != null){
String choice = test.getChoice();
String encrypassword = test.getPassword();
if (check.equals(choice)) {
String matches = userService.matchesEncoder(password, encrypassword);
return matches;
}else {
return “check”;
}else {
if(username.equals(“admin”)||username.equals(“Admin”)){
return userService.loginAdmin(user);
} else {
return “empty”;
/**
通过旧密码或者验证码修改密码
@param user
@return
*/
@PostMapping(“/updatePassword”)
public String updatePassword(@RequestBody User user) {
String username = user.getUsername();
String check = user.getChoice();//前端输入的密码或验证码
String newpassword = user.getPassword();
User test = userService.findAllByUsername(username);
if(test != null){
String oldpassword = test.getPassword();
String oldverifyCode = test.getVerifyCode();
String passwordMatches =userService.matchesEncoder(check, oldpassword);
String verifyCodeMatches =userService.matchesEncoder(check, oldverifyCode);
if(passwordMatches.equals(“success”)||verifyCodeMatches.equals(“success”)) {
userService.updatePassword(username,newpassword);
return “success”;
else {
return “error”;
}else {
return “empty”;
/**
通过验证码修改邮箱
@param user
@return
*/
@PostMapping(“/changeEmial”)
public String changeEmial(@RequestBody User user){
String username = user.getUsername();
String email = user.getEmail();
String verifyCode = user.getVerifyCode();
User test = userService.findAllByUsername(username);
if(test != null){
String oldverifyCode = test.getVerifyCode();
String matches =userService.matchesEncoder(verifyCode, oldverifyCode);
if(matches.equals(“success”)) {
userService.updateEmail(username, email);
return “success”;
}else {
return “error”;
}else {
return “empty”;
/**
发送邮箱并获取验证码
@param user
@return
*/
@PostMapping(“/getCheckemail”)
public String sendCodeToMail(@RequestBody User user){
String username = user.getUsername();
String email = user.getEmail();
String choice = user.getChoice();
User test = userService.findAllByUsername(username);
if(test != null){ //判断用户是否存在
String mailAddress = test.getEmail();
String checkchoice = test.getChoice();
String checkusername = test.getUsername();
if (checkusername.equals(username)&&choice.equals(checkchoice)) {
//根据username获取保存的邮箱
if(email.equals(mailAddress)){ //用户输入邮箱与绑定邮箱一致→发送验证码
try{
//生成验证码
String verifyCode = RandomUtil.getCode();
//邮件主题
String emailTitle = “邮箱验证”;
//邮件内容
String emailContent = “您正在进行邮箱验证，您的验证码为：” + verifyCode
+”\n\n 验证码将于5分钟后失效！”;
//发送邮件
SendMailUtil.sendEmail(mailAddress, emailTitle, emailContent);
/* 将验证码注入数据库 */
userService.updateCode(username, verifyCode);
/* 验证码在指定时间内失效 */
Timer timer = new Timer();
timer.schedule(new TimerTask() {
public void run() {
String RandomCode = RandomUtil.getCode();
userService.updateCode(username, RandomCode);
},300000);//300000ms(300s)即5分钟
return “success”;
}catch(Exception e){
return “error”;
}else{
//邮箱地址错误
return “addressError”;
}else {
//用户或选择用户错误
return “userError”;
}else{
//用户不存在
return “empty”;
/**
按用户名查找单个账号信息
@param username
@return
*/
@GetMapping(“/findAllByUsername/{username}”)
public User findAllByUsername(@PathVariable(“username”) String username) {
return userService.findAllByUsername(username);
/**
分页查询所有账号信息
@param currentPage
@param pageSize
@return
*/
@GetMapping(“findAll/{currentPage}/{pageSize}”)
public Map<String,Object> findAll(@PathVariable(“currentPage”) Integer currentPage, @PathVariable(“pageSize”) Integer pageSize){
PageHelper.startPage(currentPage, pageSize);
Map<String,Object> returnMap=new HashMap<String,Object>();
List
returnMap.put(“content”, list);
list= userService.findAll();
returnMap.put(“content”, list);
return returnMap;
/**
按用户类型查询账号所有信息
@param currentPage
@param pageSize
@param choice
@return
*/
@GetMapping(“findAllByChoice/{currentPage}/{pageSize}/{choice}”)
public Map<String,Object> findAllByChoice(@PathVariable(“currentPage”) Integer currentPage, @PathVariable(“pageSize”) Integer pageSize
, @PathVariable(“choice”) String choice){
PageHelper.startPage(currentPage, pageSize);
Map<String,Object> returnMap=new HashMap<String,Object>();
List
returnMap.put(“content”, list);
list= userService.findAllByChoice(choice);
returnMap.put(“content”, list);
return returnMap;
/**
删除用户信息
@param username
*/
@DeleteMapping(“deleteByUsername/{username}”)
public void deleteByUsername(@PathVariable(“username”) String username) {
userService.deleteByUsername(username);
/**
删除用户信息
@param username
*/
@DeleteMapping(“deleteAll”)
public void deleteByUsername() {
userService.deleteAll();
/**
通过验证码注销账号
@param user
@return
*/
@SuppressWarnings(“unused”)
@PostMapping(“/delUser”)
public String delUserByCode(@RequestBody User user){
String username = user.getUsername();
String email = user.getEmail();
String verifyCode = user.getVerifyCode();
User test = userService.findAllByUsername(username);
if(test != null){
String oldverifyCode = test.getVerifyCode();
String matches =userService.matchesEncoder(verifyCode, oldverifyCode);
if(matches.equals(“success”)) {
userService.deleteByUsername(username);
return “success”;
}else {
return “error”;
}else {
return “empty”;
/**
按姓名模糊查询全部
@param currentPage
@param pageSize
@param realname
@return
*/
@GetMapping(“FuzzyQuery/{currentPage}/{pageSize}/{realname}”)
public Map<String, Object> FuzzyQuery(@PathVariable(“currentPage”) Integer currentPage,
@PathVariable(“pageSize”) Integer pageSize, @PathVariable(“realname”) String realname) {
PageHelper.startPage(currentPage, pageSize);
Map<String, Object> returnMap = new HashMap<String, Object>();
List
returnMap.put(“content”, list);
list = userService.FuzzyQueryByRealname(realname);
returnMap.put(“content”, list);
return returnMap;
/**
按用户类型通过姓名模糊查询
@param currentPage
@param pageSize
@param realname
@param choice
@return
*/
@GetMapping(“FuzzyQuery/{currentPage}/{pageSize}/{realname}/{choice}”)
public Map<String, Object> FuzzyQueryByChoice(@PathVariable(“currentPage”) Integer currentPage,
@PathVariable(“pageSize”) Integer pageSize, @PathVariable(“realname”) String realname,
@PathVariable(“choice”) String choice) {
PageHelper.startPage(currentPage, pageSize);
Map<String, Object> returnMap = new HashMap<String, Object>();
List
returnMap.put(“content”, list);
list = userService.FuzzyQueryByChioce(realname, choice);
returnMap.put(“content”, list);
return returnMap;
申请管理控制层：
@RestController
@RequestMapping(“/leave”)
public class LeaveController {
@Autowired
private LeaveService leaveService;
/**
发送申请表
@param leave
@return
*/
@PostMapping(“/sendLeave”)
public String sendLeave(@RequestBody Leave leave) {
return leaveService.InsertLeave(leave);
/**
修改申请表
@param leave
@return
*/
@PostMapping(“/updateLeave”)
public String updateLeave(@RequestBody Leave leave) {
return leaveService.UpdateLeave(leave);
/**
*查找单个申请表
@param id
@return
*/
@GetMapping(“/findAllById/{id}”)
public Leave findAllByUsername(@PathVariable(“id”) Integer id) {
return leaveService.findAllById(id);
/**
学生查询申请表当前状态
@param username
@return
*/
@GetMapping(“/ShowOwnLeave/{username}”)
public Map<String, Object> ShowOwnLeave(@PathVariable(“username”) String username) {
Map<String, Object> returnMap = new HashMap<String, Object>();
List
Leave ownleave = leaveService.ShowOwnLeave(username);
if(ownleave == null) {
return returnMap;
}else {
returnMap.put(“content”, list);
list.add(ownleave);
returnMap.put(“content”, list);
return returnMap;
/**
查询以往申请记录
@param currentPage
@param pageSize
@param username
@return
*/
@GetMapping(“/ShowOldLeave/{currentPage}/{pageSize}/{username}”)
public Map<String, Object> ShowOldLeave(@PathVariable(“currentPage”) Integer currentPage,
@PathVariable(“pageSize”) Integer pageSize,
@PathVariable(“username”) String username) {
List
Integer size = test.size();//数据库中所有请假信息的总数
PageHelper.startPage(currentPage, pageSize);
Integer total = currentPage * pageSize; //分页可展示的总数
Map<String, Object> returnMap = new HashMap<String, Object>();
List
returnMap.put(“content”, list);
list = leaveService.showAOldLeave(username,total,size);
returnMap.put(“content”, list);
return returnMap;
/**
按审核状态查询以往审核记录
@param currentPage
@param pageSize
@param username
@return
*/
@GetMapping(“/ShowLeave/{currentPage}/{pageSize}/{username}/{state}”)
public Map<String, Object> ShowLeave(@PathVariable(“currentPage”) Integer currentPage,
@PathVariable(“pageSize”) Integer pageSize,
@PathVariable(“username”) String username,
@PathVariable(“state”) String state){
Map<String, Object> returnMap = new HashMap<String, Object>();
List
List
returnMap.put(“content”, list);
list = leaveService.showLeave(username, state);
pagelist = leaveService.startPage(list, currentPage, pageSize);
returnMap.put(“content”, pagelist);
return returnMap;
/**
删除申请表
@param id
*/
@DeleteMapping(“deleteLeave/{id}”)
public void deleteData(@PathVariable(“id”) Integer id) {
leaveService.deleteLeave(id);
/**
查找辅导员管理的班级
@param checkname
@return
*/
@GetMapping(“/findClass/{checkname}”)
public List
List
List
for(int i = 0 ; i < audit.size(); i++) {
String classes = audit.get(i).getClasses();
list.add(classes);
return list;
/**
删除辅导员管理的班级
@param classes
*/
@DeleteMapping(“delClass/{classes}”)
public void delClass(@PathVariable(“classes”) String classes) {
leaveService.delClass(classes);
/**
添加辅导员要管理的班级
@param classes
@param realname
@return
*/
@PostMapping(“/insertClass”)
public String insertClass(@RequestBody Audit aidit) {
return leaveService.insertAudit(aidit);
/**
按班级查找对应的辅导员
@param classes
@return
*/
@GetMapping(“/findCheckname/{classes}”)
public String findCheckname(@PathVariable(“classes”) String classes) {
String checkname = leaveService.FindCheckname(classes);
if(checkname == null) {
return “error”;
} else {
return checkname;
/**
查询需要审核的请假表
@param currentPage
@param pageSize
@param username
@return
*/
@GetMapping(“/showExamLeave/{currentPage}/{pageSize}/{username}”)
public Map<String, Object> showExamLeave(@PathVariable(“currentPage”) Integer currentPage,
@PathVariable(“pageSize”) Integer pageSize,
@PathVariable(“username”) String username) {
PageHelper.startPage(currentPage, pageSize);
Map<String, Object> returnMap = new HashMap<String, Object>();
List
if(list == null) {
return returnMap;
}else {
returnMap.put(“content”, list);
return returnMap;
/**
审核请假表
@param username
@param leave
@return
*/
@PostMapping(“/examLeave/{username}”)
public String examLeave(@PathVariable(“username”) String username,@RequestBody Leave leave) {
String StuUsername = leave.getUsername();
Leave ownleave = leaveService.ShowOwnLeave(StuUsername);
Integer oldId = ownleave.getId();
Integer id = leave.getId();
if(oldId == id) {
return leaveService.examLeave(leave, username);
}else {
return “repeat”;
考勤管理控制层：
@RestController
@RequestMapping(“/attend”)
public class AttendController {
@Autowired
private AttendService attendService;
@Autowired
private DataService dataService;
/**
添加学生考勤信息
@param attend
@return
*/
@PostMapping(“/insertAttend”)
public String insertAttend(@RequestBody Attend attend) {
String username = attend.getUsername();
Attend test = attendService.findAllByUsername(username);
if (test == null) {
return attendService.insertAttend(attend);
} else {
return “repeat”;
/**
按用户类型显示学生考勤信息
@param currentPage
@param pageSize
@param username
@return
*/
@GetMapping(“findAll/{currentPage}/{pageSize}/{username}”)
public Map<String,Object> findAll(@PathVariable(“currentPage”) Integer currentPage,
@PathVariable(“pageSize”) Integer pageSize,
@PathVariable(“username”) String username){
Map<String,Object> returnMap=new HashMap<String,Object>();
Data data = dataService.findAllByUsername(username);
if(data == null) {
return returnMap;
}else {
String choice = data.getChoice();
if(choice.equals(“辅导员”)) {
String realname = data.getRealname();
List
returnMap.put(“content”, list);
list = attendService.findAll(realname);
List
returnMap.put(“content”, pageList);
return returnMap;
}else if(choice.equals(“院领导”)) {
String dept = data.getDept();
List
returnMap.put(“content”, list);
list = attendService.findByDept(dept);
List
returnMap.put(“content”, pageList);
return returnMap;
}else {
List
returnMap.put(“content”, list);
list = attendService.findAll();
List
returnMap.put(“content”, pageList);
return returnMap;
/**
按班级查询
@param currentPage
@param pageSize
@param classes
@return
*/
@GetMapping(“findByClass/{currentPage}/{pageSize}/{classes}/{username}”)
public Map<String,Object> findByClass(@PathVariable(“currentPage”) Integer currentPage,
@PathVariable(“pageSize”) Integer pageSize,
@PathVariable(“classes”) String classes,
@PathVariable(“username”) String username
){
Map<String,Object> returnMap = new HashMap<String,Object>();
Data data = dataService.findAllByUsername(username);
List
int[] arr = {0};
if(data !=null || attend.isEmpty() == false) {
String choice =data.getChoice();
String dept = data.getDept();
if(choice.equals(“院领导”)) {
for(int i = 0; i<attend.size();i++) {
String checkdept = attend.get(i).getDept();
String checkclasses = attend.get(i).getClasses();
if(checkdept.equals(dept)&&checkclasses.equals(classes)) {
arr[0] = 1;
if(arr[0] == 1) {
PageHelper.startPage(currentPage, pageSize);
List
returnMap.put(“content”, list);
list = attendService.findByClass(classes);
returnMap.put(“content”, list);
return returnMap;
}else {
return returnMap;
PageHelper.startPage(currentPage, pageSize);
List
returnMap.put(“content”, list);
list = attendService.findByClass(classes);
returnMap.put(“content”, list);
return returnMap;
return returnMap;
/**
将考勤信息单独传给后端做个人考勤信息柱状图
@param username
@return
*/
@GetMapping(“showChatrStudent/{username}”)
public Integer[] showChatrStudent(@PathVariable(“username”) String username){
return attendService.showChartStudent(username);
/**
将考勤信息单独传给后端做考勤信息饼图图
@param classes
@return
*/
@GetMapping(“showChatrAttend/{classes}”)
public List
return attendService.showChatrAttend(classes);
@GetMapping(“showChatrScore/{classes}”)
public Integer[] showChatrScore(@PathVariable(“classes”) String classes){
return attendService.showChatrScore(classes);
/**
查找单个考勤信息
@param username
@return
*/
@GetMapping(“findAllByUsername/{username}”)
public Attend findAllByUsername(@PathVariable(“username”) String username){
return attendService.findAllByUsername(username);
/**
查找单个考勤信息（表格）
@param username
@return
*/
@GetMapping(“findAllOwn/{username}”)
public Map<String,Object> findAllOwn(@PathVariable(“username”) String username){
Map<String,Object> returnMap = new HashMap<String,Object>();
Attend attend = attendService.findAllByUsername(username);
List
returnMap.put(“content”, list);
if(attend == null) {
return returnMap;
}else {
list.add(attend);
returnMap.put(“content”, list);
return returnMap;
/**
修改考勤信息
@param attend
@return
*/
@PostMapping(“/updateAttend”)
public String updateAttend(@RequestBody Attend attend) {
String username = attend.getUsername();
Attend test = attendService.findAllByUsername(username);
if (test != null) {
attendService.saveAttend(attend);
return “success”;
} else {
return “empty”;
/**
删除考勤信息
@param username
*/
@DeleteMapping(“deleteAttend/{username}”)
public void deleteData(@PathVariable(“username”) String username) {
attendService.delAttend(username);
/**
- 删除全部的考勤信息
*/
@DeleteMapping(“deleteAttend”)
public void deleteData() {
attendService.delAttend();
/**
按姓名模糊查询某一种用户
@param currentPage
@param pageSize
@param realname
@return
*/
@GetMapping(“FuzzyQuery/{currentPage}/{pageSize}/{realname}”)
public Map<String, Object> FuzzyQuery(@PathVariable(“currentPage”) Integer currentPage,
@PathVariable(“pageSize”) Integer pageSize, @PathVariable(“realname”) String realname) {
PageHelper.startPage(currentPage, pageSize);
Map<String, Object> returnMap = new HashMap<String, Object>();
List
returnMap.put(“content”, list);
list = attendService.FuzzyQueryByRealname(realname);
returnMap.put(“content”, list);
return returnMap;
/**
按用户类型通过姓名模糊查询
@param currentPage
@param pageSize
@param realname
@param choice
@return
*/
@GetMapping(“FuzzyQuery/{currentPage}/{pageSize}/{realname}/{classes}”)
public Map<String, Object> FuzzyQueryByChoice(@PathVariable(“currentPage”) Integer currentPage,
@PathVariable(“pageSize”) Integer pageSize, @PathVariable(“realname”) String realname,
@PathVariable(“classes”) String classes) {
PageHelper.startPage(currentPage, pageSize);
Map<String, Object> returnMap = new HashMap<String, Object>();
List
returnMap.put(“content”, list);
list = attendService.FuzzyQueryByChioce(realname, classes);
returnMap.put(“content”, list);
return returnMap;
/**
批量上传excel文件导入用户信息
@param multipartFile
@param request
@return
@throws IOException
*/
@SuppressWarnings(“unused”)
@ResponseBody
@RequestMapping(value = “/fileUpload”)
public String handlerForUpload(@RequestParam(“fileList”) MultipartFile multipartFile, HttpServletRequest request)
throws IOException {
// 判断所上传文件是否存在
List
if (multipartFile.isEmpty()) {
return “error”;
} else {
InputStream in = null;
try {
// 将file转InputStream
in = multipartFile.getInputStream();
} catch (IOException e) {
e.printStackTrace();
// 将InputStream转XLSX对象（即表格对象）
@SuppressWarnings(“resource”)
XSSFWorkbook xssfWorkbook = new XSSFWorkbook(in);
// 获取表格的第一页
XSSFSheet xssfSheet = xssfWorkbook.getSheetAt(0);
// 获取该页有多少数据
int rowNum = xssfSheet.getLastRowNum();
for (int i = 1; i <= rowNum; i++) {
// 获取当前行
XSSFRow xssfRow = xssfSheet.getRow(i);
if(xssfRow == null) {
return “error”;
// 默认纯数字是以double传的，写进据库会变成科学计数法格式的，需要改为以string传进来
xssfRow.getCell(1).setCellType(CellType.STRING);
xssfRow.getCell(2).setCellType(CellType.STRING);
xssfRow.getCell(4).setCellType(CellType.STRING);
xssfRow.getCell(5).setCellType(CellType.STRING);
xssfRow.getCell(6).setCellType(CellType.STRING);
xssfRow.getCell(7).setCellType(CellType.STRING);
// xssfRow.getCell(8).setCellType(CellType.STRING);
// 以此获得该行的所有单元格
// String realname = xssfRow.getCell(0).getStringCellValue();
// String username = xssfRow.getCell(1).getStringCellValue();
// String classes = xssfRow.getCell(2).getStringCellValue();
// String dept = xssfRow.getCell(3).getStringCellValue();
//
//
// String earlyString = xssfRow.getCell(4).getStringCellValue();
// String lateString = xssfRow.getCell(5).getStringCellValue();
// String vacationString = xssfRow.getCell(6).getStringCellValue();
// String truancyString = xssfRow.getCell(7).getStringCellValue();
String realname = xssfRow.getCell(0).toString();
String username = xssfRow.getCell(1).toString();
String classes = xssfRow.getCell(2).toString();
String dept = xssfRow.getCell(3).toString();
String earlyString = xssfRow.getCell(4).toString();
String lateString = xssfRow.getCell(5).toString();
String vacationString = xssfRow.getCell(6).toString();
String truancyString = xssfRow.getCell(7).toString();
// String scoreString = xssfRow.getCell(8).toString();
Integer early = Integer.valueOf(earlyString);
Integer late = Integer.valueOf(lateString);
Integer vacation = Integer.valueOf(vacationString);
Integer truancy = Integer.valueOf(truancyString);
// Integer score = Integer.valueOf(scoreString);
// 将数据写入实体类
// data = new Data();
Attend attend = new Attend();
attend.setRealname(realname);
attend.setUsername(username);
attend.setClasses(classes);
attend.setDept(dept);
attend.setEarly(early);
attend.setLate(late);
attend.setVacation(vacation);
attend.setTruancy(truancy);
// attend.setScore(score);
// 将实体类插入数据库
// dataService.InsertData(data);
String isRepeat = attendService.insertAttend(attend);
test.add(isRepeat);
// System.out.println(“循环监视”);
for(int j = 0;j <test.size();j++ ) {
if(test.get(j).equals(“success”)) {
// System.out.println(test.get(j));
return “success”;
}else {
// System.out.println(test.get(j));
return “repeat”;
return “repeat”;
——————————PayStart——————————
项目链接：
https://javayms.github.io?id=261524512608201my
https://javayms.pages.dev?id=261524512608201my