基于javaweb+mysql的springboot宿舍寝室维修上报管理系统(java+springboot+freemarker+mysql)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SpringBoot宿舍寝室维修上报管理系统(java+springboot+freemarker+mysql)
管理员:校园管理(楼栋管理、宿舍管理)、师生管理(学生管理、辅导员管理)、维修管理(维修工管理、维修进度管理)、阅览室管理(座位生成等)、学生信用积分管理、座位预约统计管理等。
学生:登录、修改个人信息、上报宿舍维修信息、查看维修进度、完成维修进度等。
维修工:登录、查看分配给自己的维修任务、标记自己的维修进度等。
运行环境:windows/Linux均可、jdk1.8、mysql5.7、idea/eclipse均可。
public String list(Model model, Building building, PageBean<Building> pageBean){
model.addAttribute("title", "楼栋列表");
model.addAttribute("campus", building.getCampus());
model.addAttribute("pageBean", buildingService.findList(building, pageBean));
return "admin/building/list";
}
/**
* 新增楼栋页面
* @param model
* @return
*/
@RequestMapping(value="/add",method=RequestMethod.GET)
public String add(Model model){
model.addAttribute("building", buildingService.findAll());
return "admin/building/add";
}
/**
* 楼栋编辑页面
* @param model
* @return
*/
@RequestMapping(value="/edit",method=RequestMethod.GET)
public String edit(Model model,@RequestParam(name="id",required=true)Long id){
model.addAttribute("building", buildingService.find(id));
return "admin/building/edit";
}
/**
* 楼栋添加表单提交处理
* @param building
* @return
*/
@RequestMapping(value="/add",method=RequestMethod.POST)
@ResponseBody
public Result<Boolean> add(Building building){
//用统一验证实体方法验证是否合法
CodeMsg validate = ValidateEntityUtil.validate(building);
if(validate.getCode() != CodeMsg.SUCCESS.getCode()){
return Result.error(validate);
}
if(buildingService.isExistCampusAndBno(building.getCampus(),building.getBno(), 0L)){
return Result.error(CodeMsg.ADMIN_BUILDING_EXIST);
}
//到这说明一切符合条件,进行数据库新增
if(buildingService.save(building) == null){
return Result.error(CodeMsg.ADMIN_BUILDING_ADD_ERROR);
}
operaterLogService.add("添加楼栋,楼栋校区和楼号:" + building.getCampus()+building.getBno());
@RequestMapping(value = "/list")
public String findAllDormitory(Model model,Dormitory dormitory, PageBean<Dormitory> pageBean){
model.addAttribute("title", "宿舍列表");
model.addAttribute("pageBean", dormitoryService.findList(dormitory, pageBean));
model.addAttribute("roomNo",dormitory.getRoomNo());
return "admin/dormitory/list";
}
/**
* 跳转添加页面
* @return
*/
@RequestMapping(value = "/add",method = RequestMethod.GET)
public String add(Model Model){
Model.addAttribute("buils", buildingService.findAll());
return "admin/dormitory/add";
}
/***
* 添加宿舍
* @param dormitory
* @return
*/
@RequestMapping(value = "/save",method = RequestMethod.POST)
@ResponseBody
public Result<Boolean> add(Dormitory dormitory){
//用统一验证实体方法验证是否合法
CodeMsg validate = ValidateEntityUtil.validate(dormitory);
if(validate.getCode() != CodeMsg.SUCCESS.getCode()){
return Result.error(validate);
}
if(dormitory.getBuilding() == null || dormitory.getBuilding().getId() == null){
return Result.error(CodeMsg.ADMIN_DORMITORY_EMPTY);
}
//判断所属楼栋宿舍号是否存在
if(dormitoryService.isExistRoomNo(dormitory.getBuilding().getId(), dormitory.getRoomNo(),0l)){
return Result.error(CodeMsg.ADMIN_DORMITORY_EXIST);
}
//到这说明一切符合条件,进行数据库新增
if(dormitoryService.saveDormitory(dormitory) == null){
return Result.error(CodeMsg.ADMIN_DORMITORY_ADD_ERROR);
@RequestMapping("/emp")
@Controller
public class EmpController {
private Logger log = LoggerFactory.getLogger(RoleController.class);
@Autowired
private BuildingService buildingService;
@Autowired
private EmpService empService;
@Autowired
private OperaterLogService operaterLogService;
@Autowired
private RoleService roleService;
/**
* 员工列表展示
* @param model
* @param emp
* @param pageBean
* @return
*/
@RequestMapping(value="/list")
public String list(Model model, Emp emp, PageBean<Emp> pageBean){
model.addAttribute("title", "维修工列表");
model.addAttribute("name", emp.getName());
PageBean<Emp> byName = empService.findByName(emp, pageBean);
model.addAttribute("pageBean",byName );
return "admin/emp/list";
}
/**
* 角色添加页面
* @param model
* @return
*/
@RequestMapping(value="/add",method=RequestMethod.GET)
public String add(Model model){
model.addAttribute("buidings", buildingService.findAll());
model.addAttribute("empTypes", EmpType.values());
return "admin/emp/add";
}
/**
* 员工添加提交表单处理
request.setAttribute("siteName", siteConfig.getSiteName());
request.setAttribute("siteUrl", siteConfig.getSiteUrl());
}
return true;
}
}
/**
* 公用的上传类
*
*/
@RequestMapping("/upload")
@Controller
public class UploadController {
@Value("${ylrc.upload.photo.sufix}")
private String uploadPhotoSufix;
@Value("${ylrc.upload.photo.maxsize}")
private long uploadPhotoMaxSize;
private String uploadPhotoPath=System.getProperty("user.dir") + "/src/main/resources/upload/";//文件保存位置
private Logger log = LoggerFactory.getLogger(UploadController.class);
/**
* 图片统一上传类
* @param photo
* @return
*/
@RequestMapping(value="/upload_photo",method=RequestMethod.POST)
@ResponseBody
public Result<String> uploadPhoto(@RequestParam(name="photo",required=true)MultipartFile photo){
existEmp.setHeadPic(emp.getHeadPic());
existEmp.setPassword(emp.getPassword());
if(empService.save(existEmp) == null){
return Result.error(CodeMsg.ADMIN_ROLE_EDIT_ERROR);
}
log.info("编辑角色【"+emp+"】");
operaterLogService.add("编辑角色【"+emp.getName()+"】");
return Result.success(true);
}
/**
* 删除员工信息
* @param
* @param id
* @return
*/
@RequestMapping(value="/delete",method=RequestMethod.POST)
@ResponseBody
public Result<Boolean> delete(@RequestParam(name="id",required=true)Long id){
try {
empService.delete(id);
} catch (Exception e) {
return Result.error(CodeMsg.ADMIN_MENU_DELETE_ERROR);
}
//数据库添加操作成功,记录日志
operaterLogService.add("删除菜单信息,菜单ID【" + id + "】");
return Result.success(true);
}
}
existRole.setRemark(role.getRemark());
existRole.setStatus(role.getStatus());
existRole.setAuthorities(role.getAuthorities());
if(roleService.save(existRole) == null){
return Result.error(CodeMsg.ADMIN_ROLE_EDIT_ERROR);
}
log.info("编辑角色【"+role+"】");
operaterLogService.add("编辑角色【"+role.getName()+"】");
return Result.success(true);
}
/**
* 删除角色
* @param request
* @param id
* @return
*/
@RequestMapping(value="delete",method=RequestMethod.POST)
@ResponseBody
public Result<Boolean> delete(@RequestParam(name="id",required=true)Long id){
try {
roleService.delete(id);
} catch (Exception e) {
// TODO: handle exception
return Result.error(CodeMsg.ADMIN_ROLE_DELETE_ERROR);
}
log.info("编辑角色ID【"+id+"】");
operaterLogService.add("删除角色ID【"+id+"】");
return Result.success(true);
}
}
/**
* 系统验证码公用控制器
*
*/
@Controller
@RequestMapping("/cpacha")
public class CpachaController {
private Logger log = LoggerFactory.getLogger(CpachaController.class);
/**
* 通用验证码生成器
* @param vcodeLength
* @param fontSize
* @param width
* @param height
* @param method
* @param request
* @param response
*/
@RequestMapping(value="/generate_cpacha",method=RequestMethod.GET)
public void generateCpacha(
@RequestParam(name="vl",defaultValue="4")Integer vcodeLength,//vcodeLength,验证码长度
@RequestParam(name="fs",defaultValue="21")Integer fontSize,//fontSize,验证码字体大小
@RequestParam(name="w",defaultValue="98")Integer width,//width,图片宽度
@RequestParam(name="h",defaultValue="33")Integer height,//height,图片高度
@RequestParam(name="method",defaultValue="admin_login")String method,//用来调用此方法的名称,以此名称为键,存入到session中
HttpServletRequest request,
HttpServletResponse response){
CpachaUtil cpachaUtil = new CpachaUtil(vcodeLength,fontSize,width,height);
Long freeEmp = repairsService.findFreeEmpByBuildingAndEmpType(id, code);//查出匹配的空闲的师傅
Long leastEmp = null;
if (Objects.isNull(freeEmp)) {//若没查出空闲的师傅,则查匹配的任务量少的师傅
leastEmp = repairsService.findEmpByBuildingAndEmpType(id, code);
}
if (repairs.getId() != null) {
//用统一验证实体方法验证是否合法
//到这说明一切符合条件,进行数据库保存
Repairs byID = repairsService.findByID(repairs.getId());
//讲提交的用户信息指定字段复制到已存在的user对象中,该方法会覆盖新字段内容
System.out.println(byID + "---------------" + byID.getCreateTime());
BeanUtils.copyProperties(repairs, byID, "id", "createTime", "updateTime");
Emp emp = new Emp();
if (Objects.nonNull(freeEmp)) { //如果查到有空闲的维修师傅
emp.setId(freeEmp);
byID.setEmp(emp);
repairsService.save(byID);
Emp emailEmp = empService.find(freeEmp);
//mailService.send(emailEmp.getEmail(), "任务发配", Objects.nonNull(byID.getRemark()) ? byID.getRemark() : "有任务,需快速完成");
return Result.success(true);
}
//没有空闲的维修师傅就找出任务量最少的维修师傅
if (Objects.isNull(leastEmp)) {
byID.setEmp(null);
} else {
emp.setId(leastEmp);
byID.setEmp(emp);
}
repairsService.save(byID);
if (Objects.nonNull(leastEmp)) {
Emp emailEmp = empService.find(leastEmp);
//mailService.send(emailEmp.getEmail(), "任务发配", Objects.nonNull(byID.getRemark()) ? byID.getRemark() : "有任务,需快速完成");
}
} else {
Repairs repairsSave = repairsService.save(repairs);
if (Objects.nonNull(repairsSave)) {
//查询维修工的Id
/**
* 后台菜单管理控制器
*
*/
@RequestMapping("/menu")
@Controller
public class MenuController {
@Autowired
private MenuService menuService;
@Autowired
private OperaterLogService operaterLogService;
/**
* 菜单列表展示页面
* @param model
* @return
*/
@RequestMapping(value="/list")
public String list(Model model){
List<Menu> findAll = menuService.findAll();
model.addAttribute("title","菜单列表");
model.addAttribute("topMenus",MenuUtil.getTopMenus(findAll));
model.addAttribute("secondMenus",MenuUtil.getSecondMenus(findAll));
model.addAttribute("thirdMenus",MenuUtil.getThirdMenus(findAll));
return "admin/menu/list";
}
/**
* 菜单添加页面
* @param model
* @return
*/
@RequestMapping(value="/add",method=RequestMethod.GET)
public String add(Model model){
List<Menu> findAll = menuService.findAll();
model.addAttribute("title","菜单列表");
@Controller
@RequestMapping("/building")
public class BuildingController {
@Autowired
private BuildingService buildingService;
@Autowired
private OperaterLogService operaterLogService;
/**
* 楼栋列表页面
* @param model
* @param building
* @param pageBean
* @return
*/
@RequestMapping(value="/list")
public String list(Model model, Building building, PageBean<Building> pageBean){
model.addAttribute("title", "楼栋列表");
model.addAttribute("campus", building.getCampus());
model.addAttribute("pageBean", buildingService.findList(building, pageBean));
return "admin/building/list";
}
/**
* 新增楼栋页面
* @param model
* @return
*/
@RequestMapping(value="/add",method=RequestMethod.GET)
/**
* 公用的上传类
*
*/
@RequestMapping("/upload")
@Controller
public class UploadController {
@Value("${ylrc.upload.photo.sufix}")
private String uploadPhotoSufix;
@Value("${ylrc.upload.photo.maxsize}")
private long uploadPhotoMaxSize;
private String uploadPhotoPath=System.getProperty("user.dir") + "/src/main/resources/upload/";//文件保存位置
private Logger log = LoggerFactory.getLogger(UploadController.class);
/**
* 图片统一上传类
* @param photo
* @return
*/
@RequestMapping(value="/upload_photo",method=RequestMethod.POST)
@ResponseBody
public Result<String> uploadPhoto(@RequestParam(name="photo",required=true)MultipartFile photo){
//判断文件类型是否是图片
String originalFilename = photo.getOriginalFilename();
//获取文件后缀
String suffix = originalFilename.substring(originalFilename.lastIndexOf("."),originalFilename.length());
if(!uploadPhotoSufix.contains(suffix.toLowerCase())){
return Result.error(CodeMsg.UPLOAD_PHOTO_SUFFIX_ERROR);
}
if(photo.getSize()/1024 > uploadPhotoMaxSize){
CodeMsg codeMsg = CodeMsg.UPLOAD_PHOTO_ERROR;
codeMsg.setMsg("图片大小不能超过" + (uploadPhotoMaxSize/1024) + "M");
return Result.error(codeMsg);
}
}
}
System.out.println(repairsSave.getId() + "打印Id");
}
return Result.success(true);
}
/**
* 订单修改
*
* @param model
* @param id
* @return
*/
@RequestMapping(value = "/edit", method = RequestMethod.GET)
public String edit(Model model, @RequestParam(name = "id") Long id) {
Repairs repairs = repairsService.findByID(id);
Dormitory repairsDormitory = repairs.getDormitory();
Dormitory dormitory = dormitoryService.find(repairsDormitory.getId());
List<Emp> emps = empService.findByBuilding(dormitory.getBuilding());
List<EmpType> empTypes = emps.stream().map(o -> o.getEmpType()).distinct().collect(Collectors.toList());
//查出所有的宿舍
List<Dormitory> all = dormitoryService.findAll();
//查出所有修理类型
model.addAttribute("empTypes", EmpType.values());
model.addAttribute("dormitorys", all);
model.addAttribute("repairs", repairsService.findByID(id));
return "admin/repairs/edit";
}
/**
* 编辑分配页面
*
* @param
* @return
if (!cpacha.equalsIgnoreCase(attribute.toString())) {
return Result.error(CodeMsg.CPACHA_ERROR);
}
if ("2".equals(type)) {
//表示验证码正确,开始查询数据库,检验密码是否正确
User findByUsername = userService.findByUsername(user.getUsername());
//判断是否为空
if (findByUsername == null) {
return Result.error(CodeMsg.ADMIN_USERNAME_NO_EXIST);
}
//表示用户存在,进一步对比密码是否正确
if (!findByUsername.getPassword().equals(user.getPassword())) {
return Result.error(CodeMsg.ADMIN_PASSWORD_ERROR);
}
//表示密码正确,接下来判断用户状态是否可用
if (findByUsername.getStatus() == User.ADMIN_USER_STATUS_UNABLE) {
return Result.error(CodeMsg.ADMIN_USER_UNABLE);
}
//检查用户所属角色状态是否可用
if (findByUsername.getRole() == null || findByUsername.getRole().getStatus() == Role.ADMIN_ROLE_STATUS_UNABLE) {
return Result.error(CodeMsg.ADMIN_USER_ROLE_UNABLE);
}
//检查用户所属角色的权限是否存在
if (findByUsername.getRole().getAuthorities() == null || findByUsername.getRole().getAuthorities().size() == 0) {
return Result.error(CodeMsg.ADMIN_USER_ROLE_AUTHORITES_EMPTY);
}
//检查一切符合,可以登录,将用户信息存放至session
request.getSession().setAttribute(SessionConstant.SESSION_USER_LOGIN_KEY, findByUsername);
//销毁session中的验证码
request.getSession().setAttribute("admin_login", null);
//将登陆记录写入日志库
operaterLogService.add("用户【" + user.getUsername() + "】于【" + StringUtil.getFormatterDate(new Date(), "yyyy-MM-dd HH:mm:ss") + "】登录系统!");
log.info("用户成功登录,user = " + findByUsername);
} else if ("0".equals(type)) {
//表示验证码正确,开始查询数据库,检验密码是否正确
Student findByStudentNo = studentService.findByStudentNo(user.getUsername());
//判断是否为空
if (findByStudentNo == null) {
return Result.error(CodeMsg.ADMIN_USERNAME_NO_EXIST);
}
//表示用户存在,进一步对比密码是否正确
if (!findByStudentNo.getPassword().equals(user.getPassword())) {
return Result.error(CodeMsg.ADMIN_PASSWORD_ERROR);
}
/**
* 后台角色管理控制器
*
*/
@RequestMapping("/role")
@Controller
public class RoleController {
private Logger log = LoggerFactory.getLogger(RoleController.class);
@Autowired
private MenuService menuService;
@Autowired
private OperaterLogService operaterLogService;
@Autowired
private RoleService roleService;
/**
* 分页搜索角色列表
* @param model
* @param role
* @param pageBean
* @return
*/
@RequestMapping(value="/list")
public String list(Model model,Role role,PageBean<Role> pageBean){
model.addAttribute("title", "角色列表");
model.addAttribute("name", role.getName());
model.addAttribute("pageBean", roleService.findByName(role, pageBean));
//定义主题内容
final String subject="任务完成!";
final String context="任务完成!请查收";
try {
mailService.send(email,subject,context);
} catch (Exception e) {
for (int i = 0; i < 100; i++) {
System.err.println("发送完成邮件给学生!!!");
}
}
}
return Result.success(true);
}
}
@Service
public class StudentService {
@Autowired
private StudentDao studentDao ;
public Student findByID(Long id){
/**
* 使用jpa自带的方法
* studentDao.getOne();当我查询一个不存在的id数据时,直接抛出异常,因为它返回的是一个引用,简单点说就是一个代理对象
* studentDao.findOne() 当我查询一个不存在的id数据时,返回的值是null.
* studentDao.findById(id) ; .findById(id).get()使用时,如果数据库中查询无符合条件的记录便会抛出异常
*/
Optional<Student> byId = studentDao.findById(id);
return byId.isPresent()?byId.get():null;
}
user.setRole(findByStudentNo.getRole());
user.setMobile(findByStudentNo.getMobile());
user.setSex(findByStudentNo.getStudentSex());
user.setId(findByStudentNo.getId());
user.setHeadPic(findByStudentNo.getHeadPic());
//检查一切符合,可以登录,将用户信息存放至session
request.getSession().setAttribute(SessionConstant.SESSION_USER_LOGIN_KEY, user);
request.getSession().setAttribute("admin_login", null);
request.getSession().setAttribute("admin_stu", findByStudentNo);
//将登陆记录写入日志库
operaterLogService.add("用户【" + user.getUsername() + "】于【" + StringUtil.getFormatterDate(new Date(), "yyyy-MM-dd HH:mm:ss") + "】登录系统!");
log.info("用户成功登录,user = " + user);
} else if ("1".equals(type)) {
//表示验证码正确,开始查询数据库,检验密码是否正确
Emp byNumber = empService.findByNumber(user.getUsername());
//判断是否为空
if (byNumber == null) {
return Result.error(CodeMsg.ADMIN_USERNAME_NO_EXIST);
}
//表示用户存在,进一步对比密码是否正确
if (!byNumber.getPassword().equals(user.getPassword())) {
return Result.error(CodeMsg.ADMIN_PASSWORD_ERROR);
}
user.setEmail(byNumber.getEmail());
user.setUsername(byNumber.getName());
user.setPassword(byNumber.getPassword());
user.setRole(byNumber.getRole());
user.setMobile(byNumber.getMobile());
user.setSex(byNumber.getSex());
user.setHeadPic(byNumber.getHeadPic());
user.setRole(byNumber.getRole());
user.setId(byNumber.getId());
//检查一切符合,可以登录,将用户信息存放至session
request.getSession().setAttribute(SessionConstant.SESSION_USER_LOGIN_KEY, user);
request.getSession().setAttribute("admin_login", null);
//将登陆记录写入日志库
operaterLogService.add("用户【" + user.getUsername() + "】于【" + StringUtil.getFormatterDate(new Date(), "yyyy-MM-dd HH:mm:ss") + "】登录系统!");
log.info("用户成功登录,user = " + user);
}
return Result.success(true);
}
/**
* 登录成功后的系统主页
*
* @param model
/**
* 项目通用工具类
*
*/
public class StringUtil {
/**
* 返回指定格式的日期字符串
*
* @param date
* @param formatter
* @return
*/
public static String getFormatterDate(Date date, String formatter) {
SimpleDateFormat sdf = new SimpleDateFormat(formatter);
return sdf.format(date);
}
/**
* 判断请求是否是ajax
*
* @param request
* @return
*/
public static boolean isAjax(HttpServletRequest request) {
String header = request.getHeader("X-Requested-With");
if ("XMLHttpRequest".equals(header)) return true;
return false;