基于springboot的新生报到网站 源码+数据库（毕业设计）

package com.example.springboot.controller; import cn.hutool.core.collection.CollUtil; import cn.hutool.core.date.DateUtil; import cn.hutool.core.date.Quarter; import cn.hutool.core.util.StrUtil; import cn.hutool.poi.excel.ExcelReader; import cn.hutool.poi.excel.ExcelUtil; import cn.hutool.poi.excel.ExcelWriter; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.example.springboot.config.interceptor.AuthAccess; import com.example.springboot.controller.dto.UserDTO; import com.example.springboot.controller.dto.UserPasswordDTO; import com.example.springboot.entity.Dormitory; import com.example.springboot.entity.User; import com.example.springboot.exception.ServiceException; import com.example.springboot.service.IArriveschoolService; import com.example.springboot.service.IDormitoryService; import com.example.springboot.service.IUserService; import com.example.springboot.common.Constants; import com.example.springboot.common.Result; import org.springframework.beans.factory.annotation.Value; import org.springframework.web.bind.annotation.*; import org.springframework.web.multipart.MultipartFile; import javax.annotation.Resource; import javax.servlet.ServletOutputStream; import javax.servlet.http.HttpServletResponse; import java.io.InputStream; import java.net.URLEncoder; import java.util.Date; import java.util.List; /** * <p> * 前端控制器 * </p> * * @author * @since 2022-01-26 */ @RestController @RequestMapping("/user") public class UserController { @Resource private IUserService userService; @Resource private IArriveschoolService arriveschoolService; @Resource private IDormitoryService dormitoryService; @PostMapping("/login") public Result login(@RequestBody UserDTO userDTO) { String username = userDTO.getUsername(); String password = userDTO.getPassword(); if (StrUtil.isBlank(username) || StrUtil.isBlank(password)) { return Result.error(Constants.CODE_400, "参数错误"); } UserDTO dto = userService.login(userDTO); return Result.success(dto); } @PostMapping("/register") public Result register(@RequestBody UserDTO userDTO) { String username = userDTO.getUsername(); String password = userDTO.getPassword(); if (StrUtil.isBlank(username) || StrUtil.isBlank(password)) { return Result.error(Constants.CODE_400, "参数错误"); } userDTO.setNickname(userDTO.getUsername()); return Result.success(userService.register(userDTO)); } // 新增或者更新 @PostMapping public Result save(@RequestBody User user) { String username = user.getUsername(); if (StrUtil.isBlank(username)) { return Result.error(Constants.CODE_400, "参数错误"); } if (StrUtil.isBlank(user.getNickname())) { user.setNickname(username); } if (user.getId() != null) { user.setPassword(null); } else { if (user.getPassword() == null) { user.setPassword("123"); } } // Integer dormid = user.getDormid(); // Dormitory byId = dormitoryService.getById(dormid); // if(null != byId){ // user.setDormaddress(byId.getAddress()); // int total = byId.getExisttotal() + 1; // if(total > byId.getTotal()){ // return Result.error("400","该宿舍已经住满，不能增加住宿"); // } // byId.setExisttotal(byId.getExisttotal() + 1); // dormitoryService.updateById(byId); // } return Result.success(userService.saveOrUpdate(user)); } // 新增或者更新 @PostMapping("/saveDorm") public Result saveDorm(@RequestBody User user) { Integer dormid = user.getDormid(); Dormitory byId = dormitoryService.getById(dormid); if(null != byId){ user.setDormaddress(byId.getAddress()); int total = byId.getExisttotal() + 1; if(total > byId.getTotal()){ return Result.error("400","该宿舍已经住满，不能增加住宿"); } byId.setExisttotal(byId.getExisttotal() + 1); dormitoryService.updateById(byId); } return Result.success(userService.saveOrUpdate(user)); } /** * 修改密码 * * @param userPasswordDTO * @return */ @PostMapping("/password") public Result password(@RequestBody UserPasswordDTO userPasswordDTO) { userService.updatePassword(userPasswordDTO); return Result.success(); } @AuthAccess @PutMapping("/reset") public Result reset(@RequestBody UserPasswordDTO userPasswordDTO) { if (StrUtil.isBlank(userPasswordDTO.getUsername()) || StrUtil.isBlank(userPasswordDTO.getPhone())) { throw new ServiceException("-1", "参数异常"); } QueryWrapper<User> queryWrapper = new QueryWrapper<>(); queryWrapper.eq("username", userPasswordDTO.getUsername()); queryWrapper.eq("phone", userPasswordDTO.getPhone()); List<User> list = userService.list(queryWrapper); if (CollUtil.isNotEmpty(list)) { User user = list.get(0); user.setPassword("123"); userService.updateById(user); } else { return Result.error("-1", "未找到用户"); } return Result.success(); } @DeleteMapping("/{id}") public Result delete(@PathVariable Integer id) { return Result.success(userService.removeById(id)); } @PostMapping("/unDorm/{id}") public Result unDorm(@PathVariable Integer id) { User user = userService.getById(id); String isdorm = user.getIsdorm(); if("未住宿".equals(isdorm)){ return Result.error("400","未分配住宿，不能取消住宿"); } Integer dormid = user.getDormid(); Dormitory byId = dormitoryService.getById(dormid); byId.setExisttotal(byId.getExisttotal() - 1); dormitoryService.updateById(byId); user.setDormaddress(""); user.setIsdorm("未住宿"); user.setDormid(null); userService.updateDormIdNull(user.getId()); return Result.success(userService.updateById(user)); } @PostMapping("/del/batch") public Result deleteBatch(@RequestBody List<Integer> ids) { return Result.success(userService.removeByIds(ids)); } @GetMapping public Result findAll() { return Result.success(userService.list()); } @GetMapping("/{id}") public Result findOne(@PathVariable Integer id) { return Result.success(userService.getById(id)); } @GetMapping("/username/{username}") public Result findByUsername(@PathVariable String username) { QueryWrapper<User> queryWrapper = new QueryWrapper<>(); queryWrapper.eq("username", username); return Result.success(userService.getOne(queryWrapper)); } @GetMapping("/page") public Result findPage(@RequestParam Integer pageNum, @RequestParam Integer pageSize, @RequestParam(defaultValue = "") String username, @RequestParam(defaultValue = "") String role, @RequestParam(defaultValue = "") String email, @RequestParam(defaultValue = "") String address) { QueryWrapper<User> queryWrapper = new QueryWrapper<>(); queryWrapper.orderByDesc("id"); if (!"".equals(username)) { queryWrapper.like("username", username); } i