基于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均可。
mac = sb.toString();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return mac.toUpperCase();
}
public static boolean authOrder(String orderSn, String phone) {
Map<String, String> headerParaMap = new HashMap<String, String>();
String mac = getMac();
String paramToken = DESUtil.encrypt(orderSn, mac + "#" + orderSn + "#" + phone);
headerParaMap.put("paramToken", paramToken);
String timeToken = DESUtil.encrypt("muyi_ylrc", System.currentTimeMillis() + "");
headerParaMap.put("timeToken", timeToken);
String sendPost = HttpUtil.sendPost("http://120.25.120.129:8081/order_auth/verify", headerParaMap, "orderSn=" + orderSn + "&phone=" + phone + "&mac=" + mac);
JSONObject parseObject = JSONObject.parseObject(sendPost);
if (parseObject.getIntValue("code") != CodeMsg.SUCCESS.getCode()) {
return false;
}
return true;
}
public static String readFileToString(File file) {
String string = "";
if (file != null) {
try {
BufferedReader br = new BufferedReader(new FileReader(file));
String line = null;
while ((line = br.readLine()) != null) {
string += line;
string += line;
}
br.close();
} catch (Exception e) {
// TODO: handle exception
}
}
return string;
}
}
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);
}
/**
* 系统验证码公用控制器
*
*/
@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);
String generatorVCode = cpachaUtil.generatorVCode();
//将生成的验证码放入session,以供放后面程序的验证使用
request.getSession().setAttribute(method, generatorVCode);
log.info("验证码成功生成,method=" + method + ",value=" + generatorVCode);
try {
ImageIO.write(cpachaUtil.generatorRotateVCodeImage(generatorVCode, true), "gif", response.getOutputStream());
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
/**
* 公用的上传类
*
*/
@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;
return Result.error(CodeMsg.ADMIN_USE_NO_EXIST);
}
if(userService.isExistUsername(user.getUsername(), user.getId())){
return Result.error(CodeMsg.ADMIN_USERNAME_EXIST);
}
//到这说明一切符合条件,进行数据库保存
User findById = userService.find(user.getId());
//讲提交的用户信息指定字段复制到已存在的user对象中,该方法会覆盖新字段内容
BeanUtils.copyProperties(user, findById, "id","createTime","updateTime");
if(userService.save(findById) == null){
return Result.error(CodeMsg.ADMIN_USE_EDIT_ERROR);
}
operaterLogService.add("编辑用户,用户名:" + user.getUsername());
return Result.success(true);
}
/**
* 删除用户
* @param id
* @return
*/
@RequestMapping(value="/delete",method=RequestMethod.POST)
@ResponseBody
public Result<Boolean> delete(@RequestParam(name="id",required=true)Long id){
try {
userService.delete(id);
} catch (Exception e) {
return Result.error(CodeMsg.ADMIN_USE_DELETE_ERROR);
}
operaterLogService.add("添加用户,用户ID:" + id);
return Result.success(true);
}
}
/**
* 权限统一管理拦截器
*
*/
@Component
public class AuthorityInterceptor implements HandlerInterceptor{
private Logger log = LoggerFactory.getLogger(AuthorityInterceptor.class);
@Override
public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler){
String requestURI = request.getRequestURI();
User loginedUser = SessionUtil.getLoginedUser();
log.info("进入权限控制拦截器" + requestURI);
List<Menu> authorities = loginedUser.getRole().getAuthorities();
//authorities.stream().forEach(System.out::println);
if(!MenuUtil.isExistUrl(requestURI, authorities)){
//进入这里,表示权限不存在,首先判断是否是ajax请求
if(StringUtil.isAjax(request)){
//表示是ajax请求
try {
log.info("该请求无权限,已ajax方式返回提示,url=" + requestURI);
response.setCharacterEncoding("UTF-8");
response.getWriter().write(JSON.toJSONString(CodeMsg.ADMIN_NO_RIGHT));
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return false;
* @return
*/
@RequestMapping(value = "/index")
public String index(Model model) {
model.addAttribute("operatorLogs", operaterLogService.findLastestLog(10));
model.addAttribute("userTotal", userService.total());
model.addAttribute("operatorLogTotal", operaterLogService.total());
model.addAttribute("databaseBackupTotal", 0);
model.addAttribute("onlineUserTotal", SessionListener.onlineUserCount);
model.addAttribute("showTipsText", showTipsText);
model.addAttribute("showTipsUrlText", showTipsUrlText);
model.addAttribute("showTipsUtl", showTipsUtl);
model.addAttribute("showTipsBtnText", showTipsBtnText);
return "admin/system/index";
}
/**
* 注销登录
*
* @return
*/
@RequestMapping(value = "/logout")
public String logout() {
User loginedUser = SessionUtil.getLoginedUser();
if (loginedUser != null) {
SessionUtil.set(SessionConstant.SESSION_USER_LOGIN_KEY, null);
}
return "redirect:login";
}
/**
* 无权限提示页面
*
* @return
*/
@RequestMapping(value = "/no_right")
public String noRight() {
return "admin/system/no_right";
}
/**
* 修改用户个人信息
*
* @return
*/
@RequestMapping(value = "/update_userinfo", method = RequestMethod.GET)
public String updateUserInfo() {
return "admin/system/update_userinfo";
}
/**
* 修改个人信息保存
*
if (Objects.nonNull(repairsSave)) {
//查询维修工的Id
Emp emp = new Emp();
Emp emailEmp = new Emp();
if (Objects.nonNull(freeEmp)) {
emp.setId(freeEmp);
repairsSave.setEmp(emp);
repairsService.updateEmpId(repairsSave);
emailEmp = empService.find(emp.getId());
// mailService.send(emailEmp.getEmail(), "任务发配", Objects.nonNull(repairsSave.getRemark()) ? repairsSave.getRemark() : "有任务,需快速完成");
return Result.success(true);
}
if (leastEmp != null) {
emp.setId(leastEmp);
repairsSave.setEmp(emp);
repairsService.updateEmpId(repairsSave);
emailEmp = empService.find(emp.getId());
//mailService.send(emailEmp.getEmail(), "任务发配", Objects.nonNull(repairsSave.getRemark()) ? repairsSave.getRemark() : "有任务,需快速完成");
}
}
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("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);
}
operaterLogService.add("添加宿舍,宿舍号:" + dormitory.getRoomNo());
return Result.success(true);
}
/**
* 后台菜单管理控制器
*
*/
@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","菜单列表");
try {
repairsService.delete(id);
} catch (Exception e) {
return Result.error(CodeMsg.ADMIN_ROLE_DELETE_ERROR);
}
return Result.success(true);
}
/**
* 添加页面
*
* @param
* @return
*/
@RequestMapping(value = "/add", method = RequestMethod.GET)
public String add(Model model, HttpServletRequest request) {
Student admin_stu = (Student) request.getSession().getAttribute("admin_stu");
List<Emp> emps = empService.findByBuilding(admin_stu.getDormitory().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);
return "admin/repairs/add";
}
/**
* 维修上报表单处理
*
* @param
* @return
*/
@RequestMapping(value = "/add", method = RequestMethod.POST)
@ResponseBody
public Result<Boolean> add(Repairs repairs) {
Dormitory repairsDormitory = repairs.getDormitory();
Dormitory dormitory = dormitoryService.find(repairsDormitory.getId());
Long id = dormitory.getBuilding().getId();
int code = repairs.getEmpType().getCode();
List<Repairs> empType = repairsService.findByDormitoryIdAndEmpTypeAndStatus(dormitory.getId(), EmpType.getEmpByCode(code), 0);
/**
* 菜单添加提交表单处理
* @param menu
* @return
*/
@RequestMapping(value="/add",method=RequestMethod.POST)
@ResponseBody
public Result<Boolean> add(Menu menu){
if(menu == null){
Result.error(CodeMsg.DATA_ERROR);
}
//用统一验证实体方法验证是否合法
CodeMsg validate = ValidateEntityUtil.validate(menu);
if(validate.getCode() != CodeMsg.SUCCESS.getCode()){
return Result.error(validate);
}
if(menu.getParent() != null){
if(menu.getParent().getId() == null){
menu.setParent(null);
}
}
//表示验证都通过,开始添加数据库
if(menuService.save(menu) == null){
Result.error(CodeMsg.ADMIN_MENU_ADD_ERROR);
}
//数据库添加操作成功,记录日志
operaterLogService.add("添加菜单信息【" + menu + "】");
return Result.success(true);
}
/**
* 菜单编辑页面
* @param model
* @param id
* @return
*/
@RequestMapping(value="/edit",method=RequestMethod.GET)
public String eidt(Model model,@RequestParam(name="id",required=true)Long id){
List<Menu> findAll = menuService.findAll();
model.addAttribute("title","菜单列表");
model.addAttribute("topMenus",MenuUtil.getTopMenus(findAll));
model.addAttribute("secondMenus",MenuUtil.getSecondMenus(findAll));
model.addAttribute("menu",menuService.find(id));
return "admin/menu/edit";
/****
* 宿舍信息管理控制器
*
*/
@Controller
@RequestMapping("/dormitory")
public class DormitoryController {
@Autowired
private DormitoryService dormitoryService;
@Autowired
private BuildingService buildingService;
@Autowired
private OperaterLogService operaterLogService;
/***
* 宿舍列表
* @param model
* @return
*/
@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 "admin/coach/add";
}
/**
* 辅导员添加表单提交处理
* @param coach
* @return
*/
@RequestMapping(value="/add",method=RequestMethod.POST)
@ResponseBody
public Result<Boolean> add(Coach coach){
//用统一验证实体方法验证是否合法
CodeMsg validate = ValidateEntityUtil.validate(coach);
if(validate.getCode() != CodeMsg.SUCCESS.getCode()){
return Result.error(validate);
}
//判断辅导员名是否存在
if(coachService.isExistname(coach.getName(), 0l)){
return Result.error(CodeMsg.COACH_ADD_EXIST_ERROR);
}
//到这说明一切符合条件,进行数据库新增
if(coachService.save(coach) == null){
return Result.error(CodeMsg.COACH_ADD_ERROR);
}
operaterLogService.add("添加辅导员,辅导员名:" + coach.getName());
return Result.success(true);
}
/**
* 辅导员编辑页面
* @param model
* @return
*/
@RequestMapping(value="/edit",method=RequestMethod.GET)
public String edit(Model model,@RequestParam(name="id",required=true)Long id){
Coach coach = coachService.find(id);
model.addAttribute("coach", coachService.find(id));
return "admin/coach/edit";
}
/**
* 编辑辅导员信息表单提交处理
* @param coach
* @return
*/
@RequestMapping(value="/edit",method=RequestMethod.POST)
@ResponseBody
public Result<Boolean> edit(Coach coach){
//用统一验证实体方法验证是否合法
CodeMsg validate = ValidateEntityUtil.validate(coach);
if(validate.getCode() != CodeMsg.SUCCESS.getCode()){
return Result.error(validate);
}
*/
@RequestMapping("/system")
@Controller
public class SystemController {
@Autowired
private OrderAuthService orderAuthService;
@Autowired
private OperaterLogService operaterLogService;
@Autowired
private StudentService studentService;
@Autowired
private UserService userService;
@Autowired
private EmpService empService;
@Value("${show.tips.text}")
private String showTipsText;
@Value("${show.tips.url.text}")
private String showTipsUrlText;
@Value("${show.tips.btn.text}")
private String showTipsBtnText;
@Value("${show.tips.url}")
private String showTipsUtl;
private Logger log = LoggerFactory.getLogger(SystemController.class);
/**
* 登录页面
*
* @param
* @param model
* @return
*/
@RequestMapping(value = "/login", method = RequestMethod.GET)
public String login(Model model) {
return "admin/system/login";
}
/**
/**
* 修改用户个人信息
*
* @return
*/
@RequestMapping(value = "/update_userinfo", method = RequestMethod.GET)
public String updateUserInfo() {
return "admin/system/update_userinfo";
}
/**
* 修改个人信息保存
*
* @param user
* @return
*/
@RequestMapping(value = "/update_userinfo", method = RequestMethod.POST)
public String updateUserInfo(User user) {
User loginedUser = SessionUtil.getLoginedUser();
Role role = loginedUser.getRole();
if (role.getRoleType() == RoleType.ELECTRICIAN) {
Emp emp = empService.find(loginedUser.getId());
emp.setEmail(user.getEmail());
emp.setMobile(user.getMobile());
emp.setHeadPic(user.getHeadPic());
empService.save(emp);
loginedUser.setEmail(user.getEmail());
loginedUser.setMobile(user.getMobile());
loginedUser.setHeadPic(user.getHeadPic());
} else if (role.getRoleType() == RoleType.STUDENT) {
Student student = studentService.findByID(loginedUser.getId());
student.setEmail(user.getEmail());
student.setMobile(user.getMobile());
student.setHeadPic(user.getHeadPic());
studentService.save(student);
loginedUser.setEmail(user.getEmail());
loginedUser.setMobile(user.getMobile());
loginedUser.setHeadPic(user.getHeadPic());
} else {
loginedUser.setEmail(user.getEmail());
loginedUser.setMobile(user.getMobile());
loginedUser.setHeadPic(user.getHeadPic());
userService.save(loginedUser);
}
//更新session里的值
SessionUtil.set(SessionConstant.SESSION_USER_LOGIN_KEY, loginedUser);
return "redirect:update_userinfo";
}
log.info("用户还未登录或者session失效,重定向到登录页面,当前URL=" + requestURI);
//首先判断是否是ajax请求
if(StringUtil.isAjax(request)){
//表示是ajax请求
try {
response.setCharacterEncoding("UTF-8");
response.getWriter().write(JSON.toJSONString(CodeMsg.USER_SESSION_EXPIRED));
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return false;
}
//说明是普通的请求,可直接重定向到登录页面
//用户还未登录或者session失效,重定向到登录页面
try {
response.sendRedirect("/system/login");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return false;
}
log.info("该请求符合登录要求,放行" + requestURI);
if(!StringUtil.isAjax(request)){
//若不是ajax请求,则将菜单信息放入页面模板变量
User user = (User)attribute;
List<Menu> authorities = user.getRole().getAuthorities();
request.setAttribute("userTopMenus", MenuUtil.getTopMenus(authorities));
List<Menu> secondMenus = MenuUtil.getSecondMenus(user.getRole().getAuthorities());
request.setAttribute("userSecondMenus", secondMenus);
request.setAttribute("userThirdMenus", MenuUtil.getChildren(MenuUtil.getMenuIdByUrl(requestURI,secondMenus),authorities));
request.setAttribute("siteName", siteConfig.getSiteName());
request.setAttribute("siteUrl", siteConfig.getSiteUrl());
}
return true;
}
}