基于java web开发的学生宿舍信息管理系统

package com.example.shiqicha.controller; import com.alibaba.excel.EasyExcel; import com.alibaba.excel.write.metadata.style.WriteCellStyle; import com.alibaba.excel.write.metadata.style.WriteFont; import com.alibaba.excel.write.style.HorizontalCellStyleStrategy; import com.example.shiqicha.bean.Mechanism; import com.example.shiqicha.bean.Page; import com.example.shiqicha.bean.User; import com.example.shiqicha.bean.UserExcel; import com.example.shiqicha.service.UserService; import com.example.shiqicha.tool.ConFig; import com.example.shiqicha.tool.MD5; import com.example.shiqicha.tool.PaginationTool; import com.sun.istack.internal.NotNull; import org.apache.shiro.SecurityUtils; import org.apache.shiro.authc.IncorrectCredentialsException; import org.apache.shiro.authc.UnknownAccountException; import org.apache.shiro.authc.UsernamePasswordToken; import org.apache.shiro.subject.Subject; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.ResponseBody; import org.springframework.web.servlet.ModelAndView; import org.springframework.web.servlet.mvc.support.RedirectAttributes; import javax.servlet.http.Cookie; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import javax.validation.constraints.Size; import java.net.URLEncoder; import java.util.HashMap; import java.util.List; import java.util.Map; /** 系统用户控制层 用户管理 功能接口 登录 注册 * 创建人 * 创建时间 */ @Controller public class UserController { //日志 private static final Logger LOG = LoggerFactory.getLogger(UserController.class); //用户实现层 @Autowired UserService userService; /** * shiro 未登录输入其他地址进行拦截跳转接口 */ @RequestMapping("/index") public String index(Model model) { model.addAttribute("user_name_error","用户名"); model.addAttribute("wrong_password","密码"); return "index.html"; } @RequestMapping("/shouye") public ModelAndView shouye(){ //查询当前登录用户信息 User user = userService.selectCurrentUser(ConFig.GetId()); ModelAndView modelAndView=new ModelAndView("shouye"); System.out.println(user); modelAndView.addObject("user",user); return modelAndView; } /** * 登录接口 * 参数 user_name 用户名 * password 密码 */ @RequestMapping(value = "/SignIn") public String SignIn(@NotNull String user_name, @NotNull String password, Model model, HttpServletResponse response, HttpServletRequest request) { if (user_name==null&&password==null){ model.addAttribute("user_name_error","用户名"); model.addAttribute("wrong_password","密码"); return "index.html"; } //使用shiro编写认证操作 //获取subject Subject subject= SecurityUtils.getSubject(); //MD5加密 String passwordmdMD5 = MD5.string2MD5(password); //封装用户数据 UsernamePasswordToken token=new UsernamePasswordToken(user_name,passwordmdMD5,""); //执行登录方法 try { subject.login(token); //登录成功 List<User> selectidentifier = userService.selectidentifier(ConFig.GetId()); if (selectidentifier.get(0) == null) { Cookie newCookie = new Cookie("JSESSIONID", ""); newCookie.setMaxAge(0); response.addCookie(newCookie); return "index.html"; } //查询当前登录用户信息 User user = userService.selectCurrentUser(ConFig.GetId()); //创建session对象 HttpSession session = request.getSession(); //将用户信息存储到session中 session.setAttribute("user", user); //设置sessiong存储时间 session.setMaxInactiveInterval(24 * 60 * 60); //创建cookie Cookie cookie=new Cookie("JSESSIONID",session.getId()); //设置cookie时间 一天 cookie.setMaxAge(24*60*60); response.addCookie(cookie); model.addAttribute("user", user); model.addAttribute("mechanism_id",user.getUser_mechanism_id()); return "homepage.html"; } catch (UnknownAccountException e) { //登录失败 用户名不存在 model.addAttribute("user_name_error", "用户名错误"); model.addAttribute("wrong_password", "密码"); return "index.html"; } catch (IncorrectCredentialsException e) { //登录失败 密码错误 model.addAttribute("user_name_error", "用户名"); model.addAttribute("wrong_password", "密码错误"); return "index.html"; } } //退出登录 @RequestMapping("/remove") public String remove(HttpSession session, Model model){ session.setAttribute("user",null); model.addAttribute("user_name_error","用户名"); model.addAttribute("wrong_password","密码"); return "index.html"; } /**用户注册机构查询接口 用户注册页面前进入此接口 * 参数 无 * 返回 用户注册页面*/ @RequestMapping("/selectMechanism") public ModelAndView selectMechanism(User user){ try { //机构信息查询接口 List<Mechanism> mechanisms = userService.selectMechanism(ConFig.GetId()); //查询全部权限名称 及其id List<User> selectidentifiers = userService.selectidentifiers(); ModelAndView modelAndView=new ModelAndView("insertuser"); modelAndView.addObject("selectidentifiers",selectidentifiers); modelAndView.addObject("mechanisms",mechanisms); modelAndView.addObject("user",user); return modelAndView; }catch (Exception e){ ModelAndView modelAndView=new ModelAndView("insertuser"); return modelAndView; } } /**用户注册接口 * 参数 jurisdiction_id 权限数组 * user 用户封装类 */ @RequestMapping("/insertuser") public ModelAndView insertuser(int[] jurisdiction_id, User user, RedirectAttributes redirectAttributes){ try { /**先注册用户 获取新注册用户id 在拿用户id和获取来的权限id向用户权限表添加*/ //查询用户名是否已被注册 返回true代表没有注册 返回false代表注册 boolean b = userService.selectUserName(user.getUser_name()); if (b==true&&jurisdiction_id!=null){ //用户注册时间 user.setRegistration_time(ConFig.newDateTime()); //密码加密 user.setPassword(MD5.string2MD5(user.getPassword())); //设置操作人 和 是否删除 删除设置未删除 user.setIs_delete(0); user.setOperator(ConFig.GetId()); //用户添加方法 返回新注册用户id userService.insertuser(user); Map<Integer,Integer> param=new HashMap<>(); for (Integer id:jurisdiction_id)