基于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均可。
* 菜单添加页面
* @param model
* @return
*/
@RequestMapping(value="/add",method=RequestMethod.GET)
public String add(Model model){
List<Menu> findAll = menuService.findAll();
model.addAttribute("title","菜单列表");
model.addAttribute("topMenus",MenuUtil.getTopMenus(findAll));
model.addAttribute("secondMenus",MenuUtil.getSecondMenus(findAll));
return "admin/menu/add";
}
/**
* 菜单添加提交表单处理
* @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);
}
/**
* 菜单编辑页面
} 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;
}
}
* 角色添加页面
* @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";
}
/**
* 员工添加提交表单处理
* @param emp
* @return
*/
@RequestMapping(value="/add",method=RequestMethod.POST)
@ResponseBody
public Result<Boolean> add(Emp emp){
String e = StringUtil.generateSn("E", "");
emp.setNumber(e);
emp.setPassword(emp.getNumber());
if(emp == null){
Result.error(CodeMsg.DATA_ERROR);
}
//用统一验证实体方法验证是否合法
CodeMsg validate = ValidateEntityUtil.validate(emp);
if(validate.getCode() != CodeMsg.SUCCESS.getCode()){
return Result.error(validate);
}
if(emp.getBuilding() == null || emp.getBuilding().getId() == null){
return Result.error(CodeMsg.ADMIN_EMP_BUILDING_EMPTY);
}
//判断用户名是否存在
if(empService.isExistUsername(emp.getNumber(), 0l)){
return Result.error(CodeMsg.ADMIN_EMP_NAME_EXIST);
}
emp.setRole(roleService.findByRoleType(RoleType.ELECTRICIAN));
//表示验证都通过,开始添加数据库
if(empService.save(emp) == null){
Result.error(CodeMsg.ADMIN_EMP_ADD_ERROR);
}
//数据库添加操作成功,记录日志
operaterLogService.add("添加员工信息【" + emp.getName() + "】");
return Result.success(true);
}
* @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);
}
if(coach.getId() == null || coach.getId().longValue() <= 0){
return Result.error(CodeMsg.COACH_EDITID_EXIST_ERROR);
}
if(coachService.isExistname(coach.getName(), coach.getId())){
return Result.error(CodeMsg.COACH_EDITNAME_EXIST_ERROR);
}
*/
@RequestMapping(value = "/edit", method = RequestMethod.GET)
public String edit(Model model, @RequestParam(name = "id") Long id) {
Student byID = studentService.findByID(id);
List<Building> all2 = buildingService.findAll();
List<Dormitory> byBuilding_id = dormitoryService.findByBuilding_Id(byID.getDormitory().getBuilding().getId());
List<Coach> all1 = coachDao.findAll();
model.addAttribute("coachs", all1);
model.addAttribute("dormitorys", byBuilding_id);
model.addAttribute("buildings", all2);
model.addAttribute("student", byID);
return "admin/student/edit";
}
@Autowired
private BuildingService buildingService;
/**
* 角色添加页面
*
* @param
* @return
*/
@RequestMapping(value = "/add", method = RequestMethod.GET)
public String add(Model model) {
//查出所有的宿舍
List<Dormitory> all = dormitoryService.findAll();
//查出所有辅导员
List<Building> all2 = buildingService.findAll();
List<Coach> all1 = coachDao.findAll();
//model.addAttribute("dormitorys",all);
model.addAttribute("coachs", all1);
model.addAttribute("buildings", all2);
return "admin/student/add";
}
@RequestMapping(value = "delete", method = RequestMethod.POST)
@ResponseBody
public Result delete(long id) {
try {
studentService.delete(id);
} catch (Exception e) {
@Autowired
private MailService mailService;
@RequestMapping(value = "/list")
public String list(Model model, Repairs repairs, PageBean<Repairs> pageBean) {
User loginedUser = SessionUtil.getLoginedUser();
Student byID = studentService.findByID(loginedUser.getId());
repairs.setStudent(byID);
model.addAttribute("title", "维修管理");
model.addAttribute("pageBean", repairsService.findByName(repairs, pageBean));
return "admin/repairs/list";
}
@RequestMapping(value = "delete", method = RequestMethod.POST)
@ResponseBody
public Result delete(long id) {
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);
emp.setRole(roleService.findByRoleType(RoleType.ELECTRICIAN));
//表示验证都通过,开始添加数据库
if(empService.save(emp) == null){
Result.error(CodeMsg.ADMIN_EMP_ADD_ERROR);
}
//数据库添加操作成功,记录日志
operaterLogService.add("添加员工信息【" + emp.getName() + "】");
return Result.success(true);
}
/**
* 员工编辑页面
* @param id
* @param model
* @return
*/
@RequestMapping(value="/edit",method=RequestMethod.GET)
public String edit(@RequestParam(name="id",required=true)Long id, Model model){
Emp emp = empService.find(id);
model.addAttribute("emp", emp);
model.addAttribute("buidings", buildingService.findAll());
model.addAttribute("empTypes", EmpType.values());
return "admin/emp/edit";
}
/**
* 员工修改表单提交处理
* @param
* @return
*/
@RequestMapping(value="/edit",method=RequestMethod.POST)
@ResponseBody
public Result<Boolean> edit(Emp emp){
//用统一验证实体方法验证是否合法
CodeMsg validate = ValidateEntityUtil.validate(emp);
if(validate.getCode() != CodeMsg.SUCCESS.getCode()){
return Result.error(validate);
}
Emp existEmp = empService.find(emp.getId());
if(existEmp == null){
return Result.error(CodeMsg.ADMIN_ROLE_NO_EXIST);
}
/**
* 权限统一管理拦截器
*
*/
@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
model.addAttribute("title", "学生列表");
model.addAttribute("name", student.getStudentName());
model.addAttribute("pageBean", studentService.findByName(student, pageBean));
return "admin/student/list";
}
/**
* 学生修改
*
* @param model
* @param id
* @return
*/
@RequestMapping(value = "/edit", method = RequestMethod.GET)
public String edit(Model model, @RequestParam(name = "id") Long id) {
Student byID = studentService.findByID(id);
List<Building> all2 = buildingService.findAll();
List<Dormitory> byBuilding_id = dormitoryService.findByBuilding_Id(byID.getDormitory().getBuilding().getId());
List<Coach> all1 = coachDao.findAll();
model.addAttribute("coachs", all1);
model.addAttribute("dormitorys", byBuilding_id);
model.addAttribute("buildings", all2);
model.addAttribute("student", byID);
return "admin/student/edit";
}
@Autowired
private BuildingService buildingService;
/**
* 角色添加页面
*
* @param
* @return
*/
@RequestMapping(value = "/add", method = RequestMethod.GET)
public String add(Model model) {
//查出所有的宿舍
List<Dormitory> all = dormitoryService.findAll();
//查出所有辅导员
List<Building> all2 = buildingService.findAll();
List<Coach> all1 = coachDao.findAll();
//model.addAttribute("dormitorys",all);
model.addAttribute("coachs", all1);
@RequestMapping(value = "/list")
public String list(Model model, Repairs repairs, PageBean<Repairs> pageBean) {
User loginedUser = SessionUtil.getLoginedUser();
Student byID = studentService.findByID(loginedUser.getId());
repairs.setStudent(byID);
model.addAttribute("title", "维修管理");
model.addAttribute("pageBean", repairsService.findByName(repairs, pageBean));
return "admin/repairs/list";
}
@RequestMapping(value = "delete", method = RequestMethod.POST)
@ResponseBody
public Result delete(long id) {
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";
@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);
}
if(coach.getId() == null || coach.getId().longValue() <= 0){
return Result.error(CodeMsg.COACH_EDITID_EXIST_ERROR);
}
if(coachService.isExistname(coach.getName(), coach.getId())){
return Result.error(CodeMsg.COACH_EDITNAME_EXIST_ERROR);
}
//到这说明一切符合条件,进行数据库保存
Coach findById= coachService.find(coach.getId());
//讲提交的辅导员信息指定字段复制到已存在的user对象中,该方法会覆盖新字段内容
BeanUtils.copyProperties(coach, findById, "id","createTime","updateTime");
if(coachService.save(findById) == null){
return Result.error(CodeMsg.COACH_EDIT_ERROR);
}
operaterLogService.add("编辑辅导员名,辅导员名:" + coach.getName());
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 {
coachService.delete(id);
} catch (Exception e) {
return Result.error(CodeMsg.COACH_DELETE_ERROR);
}
operaterLogService.add("删除辅导员,辅导员ID:" + id);
return Result.success(true);
}
}
/****
* 宿舍信息管理控制器
*
*/
@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
*/
@RequestMapping(value = "/add",method = RequestMethod.GET)
public String add(Model Model){
Model.addAttribute("buils", buildingService.findAll());
return "admin/dormitory/add";
}
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;
}
public List<Student> findAll(){
return studentDao.findAll();
}
public void delete(long id ){
studentDao.deleteById(id);
}
return Result.error(CodeMsg.ADMIN_MAINTENANCE_EXIST);
}
if(repairs.getStatus()==0){
//定义已完成
repairs.setStatus(1);
//收件人的邮箱 主题完成 内容完成任务
//获取收件人
Student byStudentNo = studentService.findByStudentNo(repairs.getStudent().getStudentNo());
String email = byStudentNo.getEmail();
//证明状态是对的,进行修改数据库
repairsService.save(repairs);
//定义主题内容
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){
/**
* 角色修改表单提交处理
* @param request
* @param role
* @return
*/
@RequestMapping(value="/edit",method=RequestMethod.POST)
@ResponseBody
public Result<Boolean> edit(Role role){
//用统一验证实体方法验证是否合法
CodeMsg validate = ValidateEntityUtil.validate(role);
if(validate.getCode() != CodeMsg.SUCCESS.getCode()){
return Result.error(validate);
}
Role existRole = roleService.find(role.getId());
if(existRole == null){
return Result.error(CodeMsg.ADMIN_ROLE_NO_EXIST);
}
existRole.setName(role.getName());
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);
public static boolean isAjax(HttpServletRequest request) {
String header = request.getHeader("X-Requested-With");
if ("XMLHttpRequest".equals(header)) return true;
return false;
}
/**
* 从流读取字符串
*
* @param inputStream
* @return
*/
public static String getStringFromInputStream(InputStream inputStream) {
String string = "";
try {
BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(inputStream, "GB2312"));
String buf = null;
try {
while ((buf = bufferedReader.readLine()) != null) {
string += buf;
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
bufferedReader.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
} catch (Exception e) {
// TODO: handle exception
}
return string;
}
public static Integer getUUIDInOrderId() {
Integer orderId = UUID.randomUUID().toString().hashCode();
orderId = orderId < 0 ? -orderId : orderId; //String.hashCode() 值会为空
return orderId;
}
model.addAttribute("secondMenus",MenuUtil.getSecondMenus(findAll));
model.addAttribute("thirdMenus",MenuUtil.getThirdMenus(findAll));
Role role = roleService.find(id);
model.addAttribute("role", role);
model.addAttribute("authorities",JSONArray.toJSON(role.getAuthorities()).toString());
return "admin/role/edit";
}
/**
* 角色修改表单提交处理
* @param request
* @param role
* @return
*/
@RequestMapping(value="/edit",method=RequestMethod.POST)
@ResponseBody
public Result<Boolean> edit(Role role){
//用统一验证实体方法验证是否合法
CodeMsg validate = ValidateEntityUtil.validate(role);
if(validate.getCode() != CodeMsg.SUCCESS.getCode()){
return Result.error(validate);
}
Role existRole = roleService.find(role.getId());
if(existRole == null){
return Result.error(CodeMsg.ADMIN_ROLE_NO_EXIST);
}
existRole.setName(role.getName());
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) {
*/
public static String getStringFromInputStream(InputStream inputStream) {
String string = "";
try {
BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(inputStream, "GB2312"));
String buf = null;
try {
while ((buf = bufferedReader.readLine()) != null) {
string += buf;
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
bufferedReader.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
} catch (Exception e) {
// TODO: handle exception
}
return string;
}
public static Integer getUUIDInOrderId() {
Integer orderId = UUID.randomUUID().toString().hashCode();
orderId = orderId < 0 ? -orderId : orderId; //String.hashCode() 值会为空
return orderId;
}
public static String generateSn(String prefix, String suffix) {
Calendar now = Calendar.getInstance();
//System.out.println("年: " + now.get(Calendar.YEAR));
String s = getUUIDInOrderId().toString().replace("-", "");
return prefix + now.get(Calendar.YEAR) + s.substring(0, 6).hashCode() + suffix;
}
/**
* 验证输入的邮箱格式是否符合
*
* @param email
* @return 是否合法
*/
public static boolean emailFormat(String email) {
boolean tag = true;
final String pattern1 = "^([a-z0-9A-Z]+[-|\\.]?)+[a-z0-9A-Z]@([a-z0-9A-Z]+(-[a-z0-9A-Z]+)?\\.)+[a-zA-Z]{2,}$";
final Pattern pattern = Pattern.compile(pattern1);
final Matcher mat = pattern.matcher(email);
if (!mat.find()) {
tag = false;
}