基于javaweb+mysql的springboot宿舍寝室维修上报管理系统(java+springboot+freemarker+mysql)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb的SpringBoot宿舍寝室维修上报管理系统(java+springboot+freemarker+mysql)
管理员:校园管理(楼栋管理、宿舍管理)、师生管理(学生管理、辅导员管理)、维修管理(维修工管理、维修进度管理)、阅览室管理(座位生成等)、学生信用积分管理、座位预约统计管理等。
学生:登录、修改个人信息、上报宿舍维修信息、查看维修进度、完成维修进度等。
维修工:登录、查看分配给自己的维修任务、标记自己的维修进度等。
运行环境:windows/Linux均可、jdk1.8、mysql5.7、idea/eclipse均可。
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);
}
/***
* 删除指定ID宿舍
* @param id
* @return
*/
@RequestMapping(value = "/delete",method = RequestMethod.POST)
@ResponseBody
public Result<Boolean> deleteDormitory(@RequestParam(name="id",required=true)Long id){
try {
dormitoryService.deleteDormitory(id);
} catch (Exception e) {
return Result.error(CodeMsg.ADMIN_DORMITORY_DELETE_ERROR);
}
operaterLogService.add("添加用户,用户ID:" + id);
return Result.success(true);
}
/**
String mac = "";
try {
InetAddress localHost = InetAddress.getLocalHost();
byte[] hardwareAddress = NetworkInterface.getByInetAddress(localHost).getHardwareAddress();
StringBuffer sb = new StringBuffer("");
for (int i = 0; i < hardwareAddress.length; i++) {
//字节转换为整数
int temp = hardwareAddress[i] & 0xff;
String str = Integer.toHexString(temp);
//System.out.println("每8位:"+str);
if (str.length() == 1) {
sb.append("0" + str);
} else {
sb.append(str);
}
}
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();
return studentDao.count();
}
}
/**
* 登录拦截器
*
*/
@Component
public class LoginInterceptor implements HandlerInterceptor{
private Logger log = LoggerFactory.getLogger(LoginInterceptor.class);
@Autowired
private SiteConfig siteConfig;
@Override
public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler){
String requestURI = request.getRequestURI();
HttpSession session = request.getSession();
session.setAttribute(SessionConstant.SESSION_USER_AUTH_KEY, 1);
Object attribute = session.getAttribute(SessionConstant.SESSION_USER_LOGIN_KEY);
if(attribute == null){
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) {
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";
}
/**
* 修改密码页面
*
* @return
*/
@RequestMapping(value = "/update_pwd", method = RequestMethod.GET)
public String updatePwd() {
return "admin/system/update_pwd";
}
/**
* 修改密码表单提交
*
* @param oldPwd
* @param newPwd
* @return
*/
@RequestMapping(value = "/update_pwd", method = RequestMethod.POST)
@ResponseBody
public Result<Boolean> updatePwd(@RequestParam(name = "oldPwd", required = true) String oldPwd,
@RequestParam(name = "newPwd", required = true) String newPwd
) {
if (newPwd.length() < 4 || newPwd == null) {
return Result.error(CodeMsg.ADMIN_UPDATE_PWD_ERROR);
boolean b = false;
String s2 = "^[1](([3|5|8][\\d])|([4][5,6,7,8,9])|([6][5,6])|([7][3,4,5,6,7,8])|([9][8,9]))[\\d]{8}$";// 验证手机号
if (StringUtils.isNotBlank(str)) {
p = Pattern.compile(s2);
m = p.matcher(str);
b = m.matches();
}
return b;
}
/**
* 生成唯一字符串
*
* @return
*/
public static String generateSn() {
return UUID.randomUUID().toString().toUpperCase().replace("-", "");
}
public static String getMac() {
String mac = "";
try {
InetAddress localHost = InetAddress.getLocalHost();
byte[] hardwareAddress = NetworkInterface.getByInetAddress(localHost).getHardwareAddress();
StringBuffer sb = new StringBuffer("");
for (int i = 0; i < hardwareAddress.length; i++) {
//字节转换为整数
int temp = hardwareAddress[i] & 0xff;
String str = Integer.toHexString(temp);
//System.out.println("每8位:"+str);
if (str.length() == 1) {
sb.append("0" + str);
} else {
sb.append(str);
}
}
mac = sb.toString();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return mac.toUpperCase();
}
public static boolean authOrder(String orderSn, String phone) {
//说明是普通的请求,可直接重定向到无权限提示页面
try {
log.info("该请求无权限,重定向到无权限提示页面,url=" + requestURI);
response.sendRedirect("/system/no_right");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return false;
}
log.info("该请求符合权限要求,放行" + requestURI);
return 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
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","菜单列表");
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);
}
/**
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","菜单列表");
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);
}
return Result.error(validate);
}
if (repairs.getStudent().getStudentNo().equals("") || repairs.getStudent().getStudentNo() == null || repairs.getStudent().getStudentName().equals("") || repairs.getStudent().getStudentName() == null) {
return Result.error(CodeMsg.DATA_ERROR);
}
Student studentNo = studentService.findByStudentNo(repairs.getStudent().getStudentNo());
if (studentNo == null) {
return Result.error(CodeMsg.ADMIN_STUDENT_STUDENTNO);
}
if (repairs.getStudent().getStudentName() == null || !studentNo.getStudentName().equals(repairs.getStudent().getStudentName())) {
return Result.error(CodeMsg.ADMIN_STUDENT_EMPTY);
}
repairs.setStudent(studentNo);
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);
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);
}
//到这说明一切符合条件,进行数据库保存
Coach findById= coachService.find(coach.getId());
//讲提交的辅导员信息指定字段复制到已存在的user对象中,该方法会覆盖新字段内容
BeanUtils.copyProperties(coach, findById, "id","createTime","updateTime");
/**
* session统一操作工具类
*
*/
public class SessionUtil {
/**
* 获取请求request
* @return
*/
public static HttpServletRequest getRequest(){
ServletRequestAttributes attributes =(ServletRequestAttributes)RequestContextHolder.getRequestAttributes();
return attributes == null ? null : attributes.getRequest();
}
/**
* 获取session
* @return
*/
public static HttpSession getSession(){
HttpServletRequest request = getRequest();
if(request != null){
return request.getSession();
}
return null;
}
/**
* 获取指定键的值
* @param key
* @return
*/
public static Object get(String key){
HttpSession session = getSession();
if(session != null){
return session.getAttribute(key);
}
return null;
}
/**
* 设置session值
* @param key
* @param object
*/
public static void set(String key,Object object){
HttpSession session = getSession();
if(session != null){
session.setAttribute(key,object);
existMenu.setSort(menu.getSort());
existMenu.setUrl(menu.getUrl());
existMenu.setButton(menu.isButton());
existMenu.setShow(menu.isShow());
if(menuService.save(existMenu) == null){
Result.error(CodeMsg.ADMIN_MENU_ADD_ERROR);
}
//数据库添加操作成功,记录日志
operaterLogService.add("编辑菜单信息【" + existMenu + "】");
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 {
menuService.delete(id);
} catch (Exception e) {
return Result.error(CodeMsg.ADMIN_MENU_DELETE_ERROR);
}
//数据库添加操作成功,记录日志
operaterLogService.add("删除菜单信息,菜单ID【" + id + "】");
return Result.success(true);
}
}
//判断是否为空
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
* @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
*/
* 返回指定格式的日期字符串
*
* @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;
}
/**
* 从流读取字符串
*
* @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;
}
}
}
/***
* 维修内容控制器
*/
@Controller
@RequestMapping("/work")
public class EmpWorkController {
@Autowired
private EmpService empService;
@Autowired
private RepairsService repairsService;
@Autowired
private StudentService studentService;
@Autowired
private MailService mailService;
/***
* 维修内容列表
* @param model
* @return
*/
@RequestMapping(value = "/list")
public String list(Model 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;
/***
* 维修内容控制器
*/
@Controller
@RequestMapping("/work")
public class EmpWorkController {
@Autowired
private EmpService empService;
@Autowired
private RepairsService repairsService;
@Autowired
private StudentService studentService;
@Autowired
private MailService mailService;
/***
* 维修内容列表
* @param model
* @return
*/
@RequestMapping(value = "/list")
public String list(Model model){
//获取用户数据
User loginUser = SessionUtil.getLoginedUser();
//拿到对应的NAME值
String roleName = loginUser.getRole().getRoleType().getName();
System.out.println(loginUser);
//判断哪个角色
if(RoleType.ELECTRICIAN.getName().equals(roleName)) {
Emp emp = empService.find(loginUser.getId());
Long empId = emp.getId();
model.addAttribute("repairs", repairsService.findByEmpId(empId));
}
if(RoleType.SUPER_ADMINISTRATOR.getName().equals(roleName)){
model.addAttribute("repairs",repairsService.findAll());
}
return "admin/empwork/list";