基于javaweb+mysql的springboot+mybatis社区疫情防控人员流动管理系统(java+springboot+ssm+thymeleaf+html+mysql)

基于javaweb+mysql的springboot+mybatis社区疫情防控人员流动管理系统(java+springboot+ssm+thymeleaf+html+mysql)

运行环境

Java≥8、MySQL≥5.7

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

住户、高风险住户、住户出入、访客出入、体温录入、用户等管理

技术框架

SpringBoot SpringMVC MyBatis Shiro Thymeleaf HTML JavaScript Layui……

基于javaweb+mysql的SpringBoot+MyBatis社区疫情防控人员流动管理系统(java+springboot+ssm+thymeleaf+html+mysql)

    }

}

/**

 */
public class CookieUtil {

    /**
     * 设置cookie
     */
    public static void  setCookie(String key, String value, String domain,
                                  HttpServletResponse response) {

    }
    /**
     * 查找cookie
     * @return
     */
    public static String getCookieValue(HttpServletRequest request, String key) {
        Cookie[] cookies= request.getCookies();
        Cookie cookie = null;
        if (cookies != null)
        {
            for (int i = 0; i < cookies.length; i++) {
                if (cookies[i].getName().equals(key))
                {
                    cookie = cookies[i];
                }
            }
        }
        if (cookie != null)
        {
            try {
                return URLDecoder.decode(cookie.getValue(),"UTF-8");
            } catch (UnsupportedEncodingException e) {
                e.printStackTrace();
            }

        }
        return null;

}

/**
 * <p>
 * 地址管理 前端控制器
 * </p>
 *

 */
@RestController
@Api(tags = "地址相关接口")
@RequestMapping("/address")
public class AddressController {

    @Autowired
    private AddressService addressService;

    @GetMapping("/queryAddressByParam")
    public JsonObject queryAddressByParam(@RequestParam("page") Integer currentPage, @RequestParam("limit") Integer limit,
                                          @RequestParam(name = "params", required = false) String queryParams) {
        JsonObject<AddressDto> object = new JsonObject<>();
        if (queryParams != null) {
            JSONObject jsonObject = JSON.parseObject(queryParams);
            String keyword = jsonObject.getString("keyword");

    public String addUserPage() {
        return "page/user/addUser";
    }

    @RequestMapping("/sys/aboutMe")
    public String aboutMePage() {
        return "page/sys/aboutMe";
    }

    @RequestMapping("/feedBack")
    public String feedbackPage() {
        return "page/info/feedBack";
    }

    @RequestMapping("/userSalt")
    public String userSaltPage() {
        return "page/salt/userSalt";
    }

    @RequestMapping("/404")
    public String exceptionPage() {
        return "page/sys/404";
    }

}

/**

 * <p>
 * 主要负责用户的密码找回和注册功能
 */
@Slf4j
@RestController
@RequestMapping("/User")
@Api(tags = "登录相关接口")
public class UserLoginController {
    @Autowired
    private UserService userService;

    //发送验证码
    @PostMapping("/sendSms")
    public Result sendSms(@RequestParam String account,
                          @RequestParam String userPhone) {
        return userService.sendSms(account, userPhone);
    }

    //验证验证码
    @PostMapping("/lookForPwdSubmit")
    public Result lookForPwd(RetrievePwdDto retrievePwdDto) {
        return userService.checkVesCode(retrievePwdDto);
    }

    //重置密码
    @PostMapping("/retrievePwdSubmit")
    public Result retrievePwdSubmit(RetrievePwdDto retrievePwdDto) {

    @PostMapping("/deleteVisitors")
    public Result deleteVistors(Integer[] ids){
        return visitorService.deleteVistors(ids);
    }

    @PostMapping("/updateVisitor")
    public Result updateVistor(VistorDto vistorDto){
        return visitorService.updateVistor(vistorDto);
    }

}

/**
 * <p>
 *  前端控制器
 * </p>
 *

 *
 * 注册码相关
 */
@RestController
@RequestMapping("/Usalt")
@RequiresRoles(value = "admin" , logical = Logical.OR)
public class UsersaltController {
    //添加注册码
    @Autowired
    private UsersaltService usersaltService;

    @GetMapping("/querySaltByParam")
    public JsonObject queryUserByParam(@RequestParam("page")Integer currentPage, @RequestParam("limit")Integer limit)

    private ResidentService residentService;
    @Autowired
    private RecordService recordService;
    @Autowired
    private VisitorService visitorService;
    @Autowired
    private AddressService addressService;

    /**
     * 首页 数据展示
     *
     * 获取住户总数，地址总数，获取今日进出记录数，获取今日访客数
     */
    @PostMapping("datas")
    public Result showDatas(){
        //住户相关
        Result result = residentService.queryResCountl();
        Object data = result.getData();
        //地址相关
        long addTotal = addressService.queryAddressByParam().getTotal();
        //访客相关
        long visTotal = visitorService.queryVistorByParam().getTotal();
        //记录相关
        long recTotal = recordService.queryRecordByParam().getTotal();
        HashMap<String, Object> map = new HashMap<>(10);
        map.put("resCount",data);
        map.put("addCount",addTotal);
        map.put("visCount",visTotal);
        map.put("recCount",recTotal);

        return Result.ok(map);
    }

    /**
     * 首页  统计表
     * 记录的七天变化情况
     */
    @PostMapping("/echarts")
    public Result echarts(){
        /**

    private UserService userService;

    @GetMapping("/queryUserByParam")
    public JsonObject queryUserByParam(@RequestParam("page") Integer currentPage, @RequestParam("limit") Integer limit,
                                       @RequestParam(name = "params", required = false) String queryParams) {
        JsonObject<UserDto> object = new JsonObject<>();
        if (queryParams != null) {
            JSONObject jsonObject = JSON.parseObject(queryParams);
            String keyword = jsonObject.getString("keyword");
            IPage<UserDto> dtoIPage = userService.queryUserByParam(currentPage, limit, keyword);
            object.setCode(0);
            object.setMsg("ok");
            object.setCount(dtoIPage.getTotal());
            object.setData(dtoIPage);
            return object;
        } else {
            IPage<UserDto> dtoIPage = userService.queryUserByParam(currentPage, limit, queryParams);
            object.setCode(0);
            object.setMsg("ok");
            object.setCount(dtoIPage.getTotal());
            object.setData(dtoIPage);
            return object;
        }
    }

    @PostMapping("/addUser")
    public Result addAddress(UserDto userDto) {
        return userService.addUser(userDto);
    }

    @PostMapping("/deleteUser")
    public Result deleteAddress(Integer[] ids) {
        return userService.deleteUser(ids);
    }

    @PostMapping("/updateUser")
    public Result updateUser(UserDto userDto) {
        return userService.updateUser(userDto);
    }

}

/**
 * <p>
 * 前端控制器
 * </p>
 *

 */
@Api(value = "获取菜单", tags = "获取菜单信息接口")
@RestController
@RequestMapping("/menus")
@Slf4j
public class MenuController {

    @Resource
    private MenuService menuService;

    @ApiOperation(value = "通过登录的用户ID获取菜单信息", notes = "通过登录的用户ID获取菜单信息")
    @GetMapping("")
    public String listMenus() {
        //获取当前用户的菜单列表
        UserDto userSession = (UserDto) SecurityUtils.getSubject().getSession().getAttribute("userSession");
        JSONObject jsonObject = new JSONObject();

    @RequestMapping("/welcome")
    public String welcomePage() {
        return "page/sys/welcome";
    }

    @RequestMapping("/lookForPwd")
    public String lookForPwdPage() {
        return "page/sys/lookForPwd";
    }

    @RequestMapping("/register")
    public String registerPage() {
        return "page/sys/register";
    }

    @RequestMapping("/userInfo")
    public String setUserPage() {
        return "page/user/user-setting";
    }

    @RequestMapping("/updatePwd")
    public String updatePwdPage() {
        return "page/user/user-password";
    }

    @RequestMapping("/resident")
    public String residentPage() {
        return "page/residents/resident";
    }

    @RequestMapping("/addResident")
    public String addResidentPage() {
        return "page/residents/addResident";
    }

    @RequestMapping("/perilPage")
    public String perilPage() {
        return "page/residents/peril";
    }

    @RequestMapping("/resCount")

/**
 * @desc: excel导入数据库
 */
@Api(value = "文件上传", tags = "文件上传相关接口")
@RestController
@RequestMapping("/api/excel")
public class ExcelController {
    public static Logger logger = LoggerFactory.getLogger(ExcelController.class);
    @Resource
    private ResidentService residentService;
    @Resource
    private AddressService addressService;

    @PostMapping("/uploadRes")
    public Result upload(@RequestParam MultipartFile file) {
        InputStream fileInputStream = null;
        try {
            fileInputStream = file.getInputStream();
        } catch (IOException e) {
            e.printStackTrace();
            return Result.fail("上传文件异常");
        }
        try {
            EasyExcel.read(fileInputStream, ResidentDto.class, new ExcelListener(residentService)).sheet().doRead();
            return Result.ok("上传文件成功");
        } catch (Exception e) {
            e.printStackTrace();
        }
        return Result.fail("未知错误");
    }

    @PostMapping("/uploadAdd")
    public Result uploadd(@RequestParam MultipartFile file) {
        InputStream fileInputStream = null;
        try {
            fileInputStream = file.getInputStream();
        } catch (IOException e) {
            e.printStackTrace();
            return Result.fail("上传文件异常");

        Subject subject = SecurityUtils.getSubject();
        subject.logout();
        return "redirect:login";
    }
}

/**
 * <p>
 *  前端控制器
 * </p>
 *

 */
@RestController
@RequestMapping("/residents")
@RequiresRoles(value={"user","admin"},logical= Logical.OR)
@Api(value = "住户管理相关接口",tags ="住户管理相关接口" )
public class ResidentController {

    @Autowired
    private ResidentService residentService;

    /**
     * 查找登记信息
     * @param currentPage 当前页
     * @param limit  页面大小
     * @param queryParams 查询条件，可以为null
     * @return
     */
    @GetMapping("/residentsByParams")

        } catch (UnknownAccountException e) {
            return Result.fail("账号不存在！");
        } catch (IncorrectCredentialsException e) {
            return Result.fail("密码错误！");
        } catch (ExcessiveAttemptsException e) {
            return Result.fail("登录失败！");
        }
    }

    //修改密码
    @PostMapping("/pwdSubmit")
    @ResponseBody
    public Result pwdSubmit(HttpServletRequest request, @RequestParam String oldPwd,
                            @RequestParam String newPwd) {
        String account = CookieUtil.getCookieValue(request, "account");
        UserDto user = userService.queryUserDtoByAccount(account);
        String updateUserPwd = userService.updateUserPwd(user.getAccount(), oldPwd, newPwd);
        if ("true".equals(updateUserPwd)) {
            //修改密码后需要将当前用户shiro缓存中的数据清空
            shiroRealm.clearCachedAuthenticationInfo(SecurityUtils.getSubject().getPrincipals());
            //清除授权信息
            shiroRealm.clearCachedAuthorizationInfo(SecurityUtils.getSubject().getPrincipals());
            return Result.ok(user.getUserName() + "密码修改成功");
        } else {
            return Result.fail(updateUserPwd);
        }
    }

    @PostMapping("/infoSubmit")
    @ResponseBody
    public Result infoSubmit(UserDto userDto) {
        Boolean info = userService.updateUserInfo(userDto);
        System.out.println(info);
        if (info) {
            return Result.ok();
        } else {
            return Result.fail("保存个人信息失败！");
        }

    }

    //    用户注销
    @ApiOperation("用户注销方法")
    @GetMapping("/logout")

            return object;
        } else {
            IPage<AddressDto> dtoIPage = addressService.queryAddressByParam(currentPage, limit, queryParams);
            object.setCode(0);
            object.setMsg("ok");
            object.setCount(dtoIPage.getTotal());
            object.setData(dtoIPage);
            return object;
        }
    }

    @PostMapping("/addAddress")
    public Result addAddress(AddressDto addressDto) {
        return addressService.addAddress(addressDto);
    }

    @PostMapping("/deleteAddress")
    public Result deleteAddress(Integer[] ids) {
        return addressService.deleteAddress(ids);
    }

    @PostMapping("/updateAddress")
    public Result updateAddress(AddressDto addressDto) {
        return addressService.updateAddress(addressDto);
    }

}

/**

        return "index";
    }

    @PostMapping("/doLogin")
    @ResponseBody
    public Result doLoginPage(@RequestParam String loginAccount, @RequestParam String password,
                              @RequestParam(defaultValue = "false") Boolean remeber) {
        Subject subject = SecurityUtils.getSubject();
        UsernamePasswordToken token = new UsernamePasswordToken();
        token.setUsername(loginAccount);
        token.setPassword(password.toCharArray());
        //开启RememberMe
        token.setRememberMe(remeber);
        try {
            //进行登录的认证
            subject.login(token);
            //登录认证成功后，将shiro中保存的用户对象取出，放到session中
            String userAccount = (String) subject.getPrincipal();
            UserDto user = userService.queryUserDtoByAccount(userAccount);
            //将用户对象的ID放到session域中
            Session session = SecurityUtils.getSubject().getSession();
            session.setAttribute("userSession", user);
            return Result.ok("登录成功", user);
        } catch (UnknownAccountException e) {
            return Result.fail("账号不存在！");
        } catch (IncorrectCredentialsException e) {
            return Result.fail("密码错误！");
        } catch (ExcessiveAttemptsException e) {
            return Result.fail("登录失败！");
        }
    }

    //修改密码
    @PostMapping("/pwdSubmit")
    @ResponseBody
    public Result pwdSubmit(HttpServletRequest request, @RequestParam String oldPwd,
                            @RequestParam String newPwd) {
        String account = CookieUtil.getCookieValue(request, "account");
        UserDto user = userService.queryUserDtoByAccount(account);
        String updateUserPwd = userService.updateUserPwd(user.getAccount(), oldPwd, newPwd);
        if ("true".equals(updateUserPwd)) {
            //修改密码后需要将当前用户shiro缓存中的数据清空
            shiroRealm.clearCachedAuthenticationInfo(SecurityUtils.getSubject().getPrincipals());
            //清除授权信息

     * 查找cookie
     * @return
     */
    public static String getCookieValue(HttpServletRequest request, String key) {
        Cookie[] cookies= request.getCookies();
        Cookie cookie = null;
        if (cookies != null)
        {
            for (int i = 0; i < cookies.length; i++) {
                if (cookies[i].getName().equals(key))
                {
                    cookie = cookies[i];
                }
            }
        }
        if (cookie != null)
        {
            try {
                return URLDecoder.decode(cookie.getValue(),"UTF-8");
            } catch (UnsupportedEncodingException e) {
                e.printStackTrace();
            }

        }
        return null;
    }

}

/**
 * @desc: 全局异常处理类
 */
@ControllerAdvice
public class GlobalExpection {

/**

 */
@RestController
@RequestMapping("/main")
public class MainController {
    @Autowired
    private ResidentService residentService;
    @Autowired
    private RecordService recordService;
    @Autowired
    private VisitorService visitorService;
    @Autowired
    private AddressService addressService;

    /**
     * 首页 数据展示
     *
     * 获取住户总数，地址总数，获取今日进出记录数，获取今日访客数
     */
    @PostMapping("datas")
    public Result showDatas(){
        //住户相关
        Result result = residentService.queryResCountl();
        Object data = result.getData();
        //地址相关
        long addTotal = addressService.queryAddressByParam().getTotal();
        //访客相关
        long visTotal = visitorService.queryVistorByParam().getTotal();
        //记录相关

    /**
     * 首页  统计表
     * 记录的七天变化情况
     */
    @PostMapping("/echarts")
    public Result echarts(){
        /**
         * 获取当前时间，以及前七天的日期
         */
        String beginTime = null;
        String endTime = null;
        int size = 0;
        Date date = new Date();
        Calendar calendar = Calendar.getInstance();
        calendar.setTime(date);
        SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
        HashMap<String, HashMap<String,Object>> map = new HashMap<>();
        HashMap<String, Object> dataMap = new HashMap<>();
        HashMap<String, Object> dateMap = new HashMap<>();
        ArrayList<Integer> list = new ArrayList<>();
        ArrayList<String> dateList = new ArrayList<>();
        calendar.add(Calendar.DATE,-6);
        beginTime = dateFormat.format(calendar.getTime());
        calendar.add(Calendar.DATE,1);
        endTime= dateFormat.format(calendar.getTime());
        size = recordService.queryRecCountByDate(beginTime, endTime).size();
        dateList.add(beginTime);
        list.add(size);
        for (int i = 0; i < 6; i++) {
            calendar.add(Calendar.DATE,0);
            beginTime = dateFormat.format(calendar.getTime());
            calendar.add(Calendar.DATE,1);
            endTime= dateFormat.format(calendar.getTime());
            size = recordService.queryRecCountByDate(beginTime, endTime).size();
            dateList.add(beginTime);
            list.add(size);
        }
        dateMap.put("data",dateList);
        dateMap.put("type","category");

}

/**

 * <p>
 * 主要负责用户的密码找回和注册功能
 */
@Slf4j
@RestController
@RequestMapping("/User")
@Api(tags = "登录相关接口")
public class UserLoginController {
    @Autowired
    private UserService userService;

    //发送验证码
    @PostMapping("/sendSms")
    public Result sendSms(@RequestParam String account,
                          @RequestParam String userPhone) {
        return userService.sendSms(account, userPhone);
    }

    //验证验证码
    @PostMapping("/lookForPwdSubmit")
    public Result lookForPwd(RetrievePwdDto retrievePwdDto) {
        return userService.checkVesCode(retrievePwdDto);
    }

    //重置密码
    @PostMapping("/retrievePwdSubmit")
    public Result retrievePwdSubmit(RetrievePwdDto retrievePwdDto) {
        System.out.println(retrievePwdDto);
        return userService.updateUserPwd(retrievePwdDto.getAccount(), retrievePwdDto.getNewPwd());