基于javaweb+mysql的ssm+maven学生考勤管理系统(java+ssm+poi导出+easyui+jfreechart+maven+mysql+jsp)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSM+Maven学生考勤管理系统(java+ssm+poi导出+easyui+jfreechart+maven+mysql+jsp)
这个项目适合SSM框架的初学者(涉及大量增删改查,很适合初学者)以及对Shiro安全框架和Poi技术感兴趣的同学。
项目功能:
用户管理功能(登录、退出登录、增加用户、编辑用户、删除用户、多条件查询用户、上传用户头像、修改个人密码);角色管理功能(添加角色、编辑角色、删除角色、查询角色);权限管理功能(添加权限、编辑权限、删除权限、多条件查询权限);缺勤管理功能(添加缺勤、编辑缺勤、删除缺勤、多条件查询缺勤、导出Excel、柱形图显示缺勤情况)。
应用技术:Jsp + SSM + Shiro + Poi(Excel表格) + JFreeChart(柱形图) + Easyui
运行环境:eclipse/IDEA + MySQL5.7 + Maven3.6.3 + JDK1.8 + Tomcat8.5
DefaultCategoryDataset dataset = new DefaultCategoryDataset();
dataset.addValue(total, "缺勤次数", "累计");
dataset.addValue(totalByMonth, "缺勤次数", "本月");
dataset.addValue(totalByWeek, "缺勤次数", "本周");
dataset.addValue(totalByDay, "缺勤次数", "今天");
JFreeChart chart= ChartFactory.createBarChart3D("缺勤情况统计柱形图(根据缺勤情况发生时间记录)", "时间", "缺勤次数", dataset,
PlotOrientation.VERTICAL, true, true, true);
CategoryPlot plot=chart.getCategoryPlot();
// 设置网格背景颜色
plot.setBackgroundPaint(Color.WHITE);
// 设置网格竖线颜色
plot.setDomainGridlinePaint(Color.PINK);
// 设置网格横线颜色
plot.setRangeGridlinePaint(Color.PINK);
// 显示每个柱的数值,并修改该数值的字体属性
BarRenderer3D renderer=new BarRenderer3D();
renderer.setBaseItemLabelGenerator(new StandardCategoryItemLabelGenerator());
renderer.setBaseItemLabelsVisible(true);
renderer.setBasePositiveItemLabelPosition(new ItemLabelPosition(ItemLabelAnchor.OUTSIDE12, TextAnchor.BASELINE_LEFT));
renderer.setItemLabelAnchorOffset(10D);
// 设置平行柱的之间距离
renderer.setItemMargin(0.4);
plot.setRenderer(renderer);
String fileName= ServletUtilities.saveChartAsPNG(chart, 1250, 665, null, session);
return fileName;
}
}
Integer totalByWeek = allAbsencesByWeek.stream().map(Absence::getNum).reduce(0, Integer::sum);
//获取本月所有缺勤情况
List<Absence> allAbsencesByMonth = absenceService.findAllAbsencesByMonth();
Integer totalByMonth = allAbsencesByMonth.stream().map(Absence::getNum).reduce(0, Integer::sum);
//获取所有缺勤情况
Map<String, Object> queryMap = new HashMap<>();
List<Absence> allAbsences = absenceService.findAllAbsences(queryMap);
Integer total = allAbsences.stream().map(Absence::getNum).reduce(0, Integer::sum);
//搭建缺勤情况统计柱形图表
DefaultCategoryDataset dataset = new DefaultCategoryDataset();
dataset.addValue(total, "缺勤次数", "累计");
dataset.addValue(totalByMonth, "缺勤次数", "本月");
dataset.addValue(totalByWeek, "缺勤次数", "本周");
dataset.addValue(totalByDay, "缺勤次数", "今天");
JFreeChart chart= ChartFactory.createBarChart3D("缺勤情况统计柱形图(根据缺勤情况发生时间记录)", "时间", "缺勤次数", dataset,
PlotOrientation.VERTICAL, true, true, true);
CategoryPlot plot=chart.getCategoryPlot();
// 设置网格背景颜色
plot.setBackgroundPaint(Color.WHITE);
// 设置网格竖线颜色
plot.setDomainGridlinePaint(Color.PINK);
// 设置网格横线颜色
plot.setRangeGridlinePaint(Color.PINK);
// 显示每个柱的数值,并修改该数值的字体属性
BarRenderer3D renderer=new BarRenderer3D();
renderer.setBaseItemLabelGenerator(new StandardCategoryItemLabelGenerator());
renderer.setBaseItemLabelsVisible(true);
renderer.setBasePositiveItemLabelPosition(new ItemLabelPosition(ItemLabelAnchor.OUTSIDE12, TextAnchor.BASELINE_LEFT));
renderer.setItemLabelAnchorOffset(10D);
// 设置平行柱的之间距离
renderer.setItemMargin(0.4);
plot.setRenderer(renderer);
String fileName= ServletUtilities.saveChartAsPNG(chart, 1250, 665, null, session);
return fileName;
}
}
/**
* 权限添加操作
* @param authority
* @return
*/
@RequestMapping(value = "/add", method = RequestMethod.POST)
@ResponseBody
public ResponseVo<Boolean> add(Authority authority){
return authorityService.add(authority);
}
/**
* 权限编辑操作
* @param authority
* @return
*/
@RequestMapping(value = "/edit", method = RequestMethod.POST)
@ResponseBody
public ResponseVo<Boolean> edit(Authority authority){
return authorityService.edit(authority);
}
/**
* 权限删除操作
* @param ids
* @return
*/
@RequestMapping(value="/delete",method = RequestMethod.POST)
@ResponseBody
public ResponseVo<Boolean> delete(String ids){
return authorityService.delete(ids);
}
}
queryMap.put("endTime", StringUtil.getFormatterDate(endTime, "yyyy-MM-dd HH:mm:ss"));
queryMap.put("offset", page.getOffset());
queryMap.put("pageSize", page.getRows());
ret.put("rows", absenceService.findAllAbsences(queryMap));
ret.put("total", absenceService.getAllTotals(queryMap));
return ret;
}
/**
* 缺勤情况添加操作
* @param absence
* @param userNo
* @param time
* @return
*/
@RequestMapping(value = "/add", method = RequestMethod.POST)
@ResponseBody
public ResponseVo<Boolean> add(Absence absence, String userNo, String time){
return absenceService.add(absence, userNo, time);
}
/**
* 缺勤情况编辑操作
* @param absence
* @param userNo
* @param time
* @return
*/
@RequestMapping(value = "/edit", method = RequestMethod.POST)
@ResponseBody
public ResponseVo<Boolean> edit(Absence absence, String userNo, String time){
return absenceService.edit(absence, userNo, time);
}
/**
* 缺勤情况删除操作
* @param ids
* @return
*/
@RequestMapping(value="/delete",method = RequestMethod.POST)
@ResponseBody
public ResponseVo<Boolean> delete(String ids){
return absenceService.delete(ids);
}
/**
* 缺勤情况导出Excel操作
* @param page
* @param startTime
* @param endTime
* @param user
* @return
*/
@RequestMapping(value = "/export_excel", method = RequestMethod.POST)
@RequestMapping(value = "/list", method = RequestMethod.POST)
@ResponseBody
public Map<String, Object> list(Page page, String startTime, String endTime, User user){
Map<String, Object> ret = new HashMap<String, Object>();
Map<String, Object> queryMap = new HashMap<String, Object>();
queryMap.put("userNo", user.getUserNo());
queryMap.put("username", user.getUsername());
if(!StringUtil.isEmpty(startTime))
queryMap.put("startTime", StringUtil.getFormatterDate(startTime, "yyyy-MM-dd HH:mm:ss"));
if(!StringUtil.isEmpty(endTime))
queryMap.put("endTime", StringUtil.getFormatterDate(endTime, "yyyy-MM-dd HH:mm:ss"));
queryMap.put("offset", page.getOffset());
queryMap.put("pageSize", page.getRows());
ret.put("rows", absenceService.findAllAbsences(queryMap));
ret.put("total", absenceService.getAllTotals(queryMap));
return ret;
}
/**
* 缺勤情况添加操作
* @param absence
* @param userNo
* @param time
* @return
*/
@RequestMapping(value = "/add", method = RequestMethod.POST)
@ResponseBody
public ResponseVo<Boolean> add(Absence absence, String userNo, String time){
return absenceService.add(absence, userNo, time);
}
/**
* 缺勤情况编辑操作
* @param absence
* @param userNo
* @param time
* @return
*/
@RequestMapping(value = "/edit", method = RequestMethod.POST)
@ResponseBody
public ResponseVo<Boolean> edit(Absence absence, String userNo, String time){
return absenceService.edit(absence, userNo, time);
}
/**
* 缺勤情况删除操作
* @param ids
* @return
*/
@RequestMapping(value="/delete",method = RequestMethod.POST)
@ResponseBody
public ResponseVo<Boolean> delete(String ids){
return absenceService.delete(ids);
return ResponseVo.successByMsg(true, "修改个人密码成功!");
}
}
/**
* @QQ 823208782
* @WX yjqi12345678
*/
/**
* 缺勤情况控制器
*/
@Controller
@RequestMapping("/absence")
public class AbsenceController {
*/
@RequestMapping(value="/list",method = RequestMethod.GET)
public ModelAndView list(ModelAndView model){
model.setViewName("role/list");
return model;
}
/**
* 角色列表信息获取
* @return
*/
@RequestMapping(value="/list",method = RequestMethod.POST)
@ResponseBody
public Map<String,Object> list(Page page, String name){
Map<String, Object> ret = new HashMap<String, Object>();
Map<String, Object> queryMap = new HashMap<String, Object>();
queryMap.put("name",name);
queryMap.put("offset", page.getOffset());
queryMap.put("pageSize", page.getRows());
ret.put("rows", roleService.findAllRoles(queryMap));
ret.put("total", roleService.getAllTotals(queryMap));
return ret;
}
/**
* 角色添加操作
* @param role
* @return
*/
@RequestMapping(value="/add",method = RequestMethod.POST)
@ResponseBody
public ResponseVo<Boolean> add(Role role){
return roleService.add(role);
}
/**
* 角色编辑操作
* @param role
* @return
*/
@RequestMapping(value="/edit",method = RequestMethod.POST)
@ResponseBody
public ResponseVo<Boolean> edit(Role role){
return roleService.edit(role);
//统一表单验证
CodeMsg validate = ValidateEntityUtil.validate(user);
if(!validate.getCode().equals(CodeMsg.SUCCESS.getCode())){
return ResponseVo.errorByMsg(validate);
}
//验证用户手机号
CodeMsg validatePhone = StringUtil.validatePhone(user.getPhone());
if(!validatePhone.getCode().equals(CodeMsg.SUCCESS.getCode())){
return ResponseVo.errorByMsg(validatePhone);
}
//判断学号/学工号是否重复
if(isUserNoExist(user.getUserNo(), 0L)){
return ResponseVo.errorByMsg(CodeMsg.USERNO_IS_ALREADY_EXIST);
}
//设置盐
String salt = ShiroUtil.getSalt(user.getRoleId());
user.setSalt(salt);
//给密码加密
user.setPassword(ShiroUtil.getMd5(user.getPassword(), salt));
//往数据库添加数据
if(userDao.addUser(user) <= 0){
return ResponseVo.errorByMsg(CodeMsg.USER_ADD_ERROR);
}
return ResponseVo.successByMsg(true,"添加用户成功!");
}
@Override
public ResponseVo<Boolean> edit(User user) {
Boolean passwdIsEdit = true; //判断密码是否被修改
if(user == null){
return ResponseVo.errorByMsg(CodeMsg.DATA_ERROR);
}
//判断密码有没有被修改
if(StringUtil.isEmpty(user.getPassword())){
//没被修改,说明密码为空,先设置个默认密码通过下面表单验证
user.setPassword("123456");
passwdIsEdit = false; //密码没修改
}
//统一表单验证
CodeMsg validate = ValidateEntityUtil.validate(user);
}
/**
* @QQ 823208782
* @WX yjqi12345678
*/
/**
* 角色控制器
*/
@Controller
@RequestMapping("/role")
public class RoleController {
@Autowired
private RoleService roleService;
/**
* 角色列表页面
* @param model
* @return
*/
@RequestMapping(value="/list",method = RequestMethod.GET)
public ModelAndView list(ModelAndView model){
if(user.getId().longValue() == id.longValue())return false; //不存在
return true; //存在
}
@Override
public ResponseVo<Boolean> delete(String ids) {
if(StringUtil.isEmpty(ids)){
return ResponseVo.errorByMsg(CodeMsg.DATA_ERROR);
}
String[] splitIds = ids.split(",");
for(String id : splitIds){
User findUser = userDao.findUserById(Long.valueOf(id));
//删除用户打卡详情相关数据
attendanceItemDao.deleteAttendanceByUserNo(findUser.getUserNo());
}
//删除对应缺勤记录
absenceDao.deleteByUserId(ids);
//删除用户
if(userDao.deleteUser(ids) <=0 ){
return ResponseVo.errorByMsg(CodeMsg.USER_DELETE_ERROR);
}
//更新打卡数据
List<Attendance> attendanceList = attendanceDao.findAllAttendance(new HashMap<>());
for(Attendance attendance : attendanceList){
//获取此打卡所有打卡详情数据
List<AttendanceItem> attendanceItemList = attendanceItemDao.getAttendanceItemListByAttendanceId(attendance.getId());
//获取此打卡所有已打卡的详情数据
List<AttendanceItem> finishAttendanceItemList = attendanceItemList.stream()
.filter(e->e.getFinish().equals(AttendanceFinishEnum.YES.getCode())).collect(Collectors.toList());
attendance.setTotalNum(finishAttendanceItemList.size());
attendance.setNowNum(finishAttendanceItemList.size());
attendanceDao.editAttendance(attendance);
}
return ResponseVo.successByMsg(true,"删除用户成功!");
}
@Override
public ResponseVo<Boolean> modifyPasswd(String prePasswd, String newPasswd, String rePasswd) {
//判断原密码是否为空
if(StringUtil.isEmpty(prePasswd)){
return ResponseVo.errorByMsg(CodeMsg.USER_PREPASSWD_EMPTY);
}
//判断新密码是否为空
return ret;
}
/**
* 用户添加操作
* @return
*/
@RequestMapping(value="/add",method = RequestMethod.POST)
@ResponseBody
public ResponseVo<Boolean> add(User user){
log.info("接收添加用户时的User信息:{}",user);
return userService.add(user);
}
/**
* 用户编辑操作
* @param user
* @return
*/
@RequestMapping(value="/edit",method = RequestMethod.POST)
@ResponseBody
public ResponseVo<Boolean> edit(User user){
log.info("接收编辑用户时的User信息:{}",user);
return userService.edit(user);
}
/**
* 删除用户操作
* @param ids
* @return
*/
@RequestMapping(value="/delete",method = RequestMethod.POST)
@ResponseBody
public ResponseVo<Boolean> delete(String ids){
return userService.delete(ids);
}
/**
* 修改用户个人密码操作
* @param prePasswd
* @param newPasswd
* @param rePasswd
* @return
*/
@RequestMapping(value="/modify_passwd",method = RequestMethod.POST)
@ResponseBody
public ResponseVo<Boolean> modifyPasswd(String prePasswd, String newPasswd, String rePasswd){
return userService.modifyPasswd(prePasswd, newPasswd, rePasswd);
}
/**
* @QQ 823208782
* @WX yjqi12345678
*/
/**
* 缺勤情况控制器
*/
@Controller
@RequestMapping("/absence")
public class AbsenceController {
private static AbsenceService absenceService;
@Autowired
public AbsenceController(AbsenceService absenceService) {
AbsenceController.absenceService = absenceService;
}
/**
* 缺勤情况列表页面
* @param model
* @return
*/
@RequestMapping(value = "/list", method = RequestMethod.GET)
public ModelAndView list(ModelAndView model){
model.setViewName("absence/list");
return model;
}
/**
* 缺勤情况列表信息获取
* @param page
* @param startTime
* @param endTime
* @param user
* @return
*/
@RequestMapping(value = "/list", method = RequestMethod.POST)
@ResponseBody
public Map<String, Object> list(Page page, String startTime, String endTime, User user){
Map<String, Object> ret = new HashMap<String, Object>();
Map<String, Object> queryMap = new HashMap<String, Object>();
queryMap.put("userNo", user.getUserNo());
queryMap.put("username", user.getUsername());
if(!StringUtil.isEmpty(startTime))
queryMap.put("startTime", StringUtil.getFormatterDate(startTime, "yyyy-MM-dd HH:mm:ss"));
if(!StringUtil.isEmpty(endTime))
queryMap.put("endTime", StringUtil.getFormatterDate(endTime, "yyyy-MM-dd HH:mm:ss"));
queryMap.put("offset", page.getOffset());
File savePathFile = new File(savePath);
if(!savePathFile.exists()){
//若不存在改目录,则创建目录
savePathFile.mkdir();
}
String filename = new Date().getTime()+"."+suffix;
log.info("保存Excel的路径:{}",savePath + filename);
try {
//将文件保存至指定目录
excel.transferTo(new File(savePath + filename));
}catch (Exception e) {
e.printStackTrace();
return ResponseVo.errorByMsg(CodeMsg.SAVE_FILE_EXCEPTION);
}
String filepath = "../resources/upload/" + StringUtil.getFormatterDate(new Date(), "yyyyMMdd") + "/" + filename;
return ResponseVo.successByMsg(filepath, "Excel文件上传成功!");
}
/**
* 系统统一的图片查看方法
* @param filename
* @return
*/
@RequestMapping(value="/view_photo")
@ResponseBody
public ResponseEntity<?> viewPhoto(@RequestParam(name="filename",required=true)String filename){
String uploadPhotoPath = RuntimeConstant.BASE_UPLOAD_FILE_PATH;
String fileDate = StringUtil.getFileDate(filename); //取得文件路径中的日期部分
log.info("文件路径中日期部分:{}",fileDate);
filename = "\\" + filename.substring(filename.lastIndexOf("/") + 1); //取得文件名
Resource resource = resourceLoader.getResource("file:" + uploadPhotoPath + fileDate + filename);
log.info("查看图片路径:{}",uploadPhotoPath + fileDate + filename);
try {
return ResponseEntity.ok(resource);
} catch (Exception e) {
return ResponseEntity.notFound().build();
}
}
}
/**
* 权限删除操作
* @param ids
* @return
*/
@RequestMapping(value="/delete",method = RequestMethod.POST)
@ResponseBody
public ResponseVo<Boolean> delete(String ids){
return authorityService.delete(ids);
}
}
/**
* @QQ 823208782
* @WX yjqi12345678
*/
/**
* 角色控制器
*/
@Controller
*/
@RequestMapping(value = "/view_item", method = RequestMethod.POST)
@ResponseBody
public List<AttendanceItem> getAttendanceItemByAttendanceId(AttendanceItem attendanceItem){
return attendanceService.getAttendanceItemByAttendanceId(attendanceItem);
}
/**
* 打卡操作
* @param attendance
* @return
*/
@RequestMapping(value = "/finish", method = RequestMethod.POST)
@ResponseBody
public ResponseVo<Boolean> finishAttendance(Attendance attendance){
return attendanceService.finishAttendance(attendance);
}
/**
* 导出缺勤数据操作
* @param attendance
* @return
*/
@RequestMapping(value = "/export_absence", method = RequestMethod.POST)
@ResponseBody
public ResponseVo<Boolean> exportAbsence(Attendance attendance){
return attendanceService.exportAbsence(attendance);
}
}
/**
* @QQ 823208782
* @WX yjqi12345678
//验证用户手机号
CodeMsg validatePhone = StringUtil.validatePhone(user.getPhone());
if(!validatePhone.getCode().equals(CodeMsg.SUCCESS.getCode())){
return ResponseVo.errorByMsg(validatePhone);
}
if(!passwdIsEdit){
//如果密码没被修改
User userById = userDao.findUserById(user.getId());
user.setPassword(userById.getPassword());
user.setSalt(userById.getSalt());
}else{
//如果密码被修改
String salt = ShiroUtil.getSalt(user.getRoleId());
String md5 = ShiroUtil.getMd5(user.getPassword(), salt);
user.setSalt(salt);
user.setPassword(md5);
}
//判断学号/学工号是否重复
if(isUserNoExist(user.getUserNo(), user.getId())){
return ResponseVo.errorByMsg(CodeMsg.USERNO_IS_ALREADY_EXIST);
}
//更新数据库数据
if(userDao.editUser(user) <= 0){
return ResponseVo.errorByMsg(CodeMsg.USER_EDIT_ERROR);
}
return ResponseVo.successByMsg(true,"编辑用户成功!");
}
@Override
public boolean isUserNoExist(String userNo, Long id) {
User user = userDao.findUserByUserNo(userNo.trim());
if(user == null)return false; //不存在
if(user.getId().longValue() == id.longValue())return false; //不存在
return true; //存在
}
@Override
public ResponseVo<Boolean> delete(String ids) {
if(StringUtil.isEmpty(ids)){
return ResponseVo.errorByMsg(CodeMsg.DATA_ERROR);
}
String[] splitIds = ids.split(",");
for(String id : splitIds){
User findUser = userDao.findUserById(Long.valueOf(id));
//删除用户打卡详情相关数据
attendanceItemDao.deleteAttendanceByUserNo(findUser.getUserNo());
}
//删除对应缺勤记录
absenceDao.deleteByUserId(ids);
//删除用户
if(userDao.deleteUser(ids) <=0 ){
return ResponseVo.errorByMsg(CodeMsg.USER_DELETE_ERROR);
}
//更新打卡数据
String path = request.getContextPath();
String savePath = RuntimeConstant.BASE_UPLOAD_FILE_PATH + StringUtil.getFormatterDate(new Date(), "yyyyMMdd") + "\\";
File savePathFile = new File(savePath);
if(!savePathFile.exists()){
//若不存在改目录,则创建目录
savePathFile.mkdir();
}
String filename = new Date().getTime()+"."+suffix;
log.info("保存图片的路径:{}",savePath + filename);
try {
//将文件保存至指定目录
photo.transferTo(new File(savePath + filename));
}catch (Exception e) {
e.printStackTrace();
return ResponseVo.errorByMsg(CodeMsg.SAVE_FILE_EXCEPTION);
}
String filepath = "../resources/upload/" + StringUtil.getFormatterDate(new Date(), "yyyyMMdd") + "/" + filename;
return ResponseVo.successByMsg(filepath, "图片上传成功!");
}
/**
* 上传Excel文件统一处理
* @param excel
* @param request
* @return
*/
@RequestMapping(value="/upload_excel",method=RequestMethod.POST)
@ResponseBody
public ResponseVo<String> uploadExcel(MultipartFile excel, HttpServletRequest request){
if(excel == null){
return ResponseVo.errorByMsg(CodeMsg.EXCEL_EMPTY);
}
//检查上传文件大小
if(excel.getSize() > 10*1024*1024) {
return ResponseVo.errorByMsg(CodeMsg.FILE_SURPASS_MAX_SIZE);
}
//获取文件后缀
String suffix = excel.getOriginalFilename().substring(excel.getOriginalFilename().lastIndexOf(".")+1, excel.getOriginalFilename().length());
if(!StringUtil.isExcel(suffix)){
return ResponseVo.errorByMsg(CodeMsg.EXCEL_FORMAT_NOT_CORRECT);