java毕业设计 基于SpringBoot+Mybatis的学生宿舍管理系统的设计与实现+详细文档+全部资料（优秀项目）.zip

package com.egao.common.system.controller; import cn.hutool.core.util.StrUtil; import cn.hutool.poi.excel.ExcelReader; import cn.hutool.poi.excel.ExcelUtil; import com.alibaba.fastjson.JSON; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.egao.common.core.annotation.OperLog; import com.egao.common.core.web.*; import com.egao.common.core.utils.CoreUtil; import com.egao.common.system.entity.DictionaryData; import com.egao.common.system.entity.Organization; import com.egao.common.system.entity.Role; import com.egao.common.system.entity.User; import com.egao.common.system.service.DictionaryDataService; import com.egao.common.system.service.OrganizationService; import com.egao.common.system.service.RoleService; import com.egao.common.system.service.UserService; import org.apache.shiro.authz.annotation.RequiresPermissions; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.transaction.annotation.Transactional; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.*; import org.springframework.web.multipart.MultipartFile; import javax.servlet.http.HttpServletRequest; import java.io.IOException; import java.util.ArrayList; import java.util.Collections; import java.util.List; /** * 用户管理 * Created by wangfan on 2018-12-24 16:10 */ @Controller @RequestMapping("/sys/user") public class UserController extends BaseController { @Autowired private UserService userService; @Autowired private DictionaryDataService dictionaryDataService; @Autowired private RoleService roleService; @Autowired private OrganizationService organizationService; @RequiresPermissions("sys:user:view") @RequestMapping() public String view(Model model) { model.addAttribute("sexList", dictionaryDataService.listByDictCode("sex")); model.addAttribute("organizationTypeList", dictionaryDataService.listByDictCode("organization_type")); model.addAttribute("rolesJson", JSON.toJSONString(roleService.list())); return "system/user.html"; } /** * 个人中心 */ @RequestMapping("/info") public String userInfo(Model model) { model.addAttribute("user", userService.getFullById(getLoginUserId())); model.addAttribute("sexList", dictionaryDataService.listByDictCode("sex")); return "index/user-info.html"; } /** * 分页查询用户 */ @OperLog(value = "用户管理", desc = "分页查询") @RequiresPermissions("sys:user:list") @ResponseBody @RequestMapping("/page") public PageResult<User> page(HttpServletRequest request) { PageParam<User> pageParam = new PageParam<>(request); pageParam.setDefaultOrder(null, new String[]{"create_time"}); return userService.listPage(pageParam); } /** * 查询全部用户 */ @OperLog(value = "用户管理", desc = "查询全部") @RequiresPermissions("sys:user:list") @ResponseBody @RequestMapping("/list") public JsonResult list(HttpServletRequest request) { PageParam<User> pageParam = new PageParam<>(request); List<User> records = userService.listAll(pageParam.getNoPageParam()); return JsonResult.ok().setData(pageParam.sortRecords(records)); } /** * 根据id查询用户 */ @OperLog(value = "用户管理", desc = "根据id查询") @RequiresPermissions("sys:user:list") @ResponseBody @RequestMapping("/get") public JsonResult get(Integer id) { PageParam<User> pageParam = new PageParam<>(); pageParam.put("userId", id); List<User> records = userService.listAll(pageParam.getNoPageParam()); return JsonResult.ok().setData(pageParam.getOne(records)); } /** * 添加用户 */ @OperLog(value = "用户管理", desc = "添加", param = false, result = true) @RequiresPermissions("sys:user:save") @ResponseBody @RequestMapping("/save") public JsonResult save(@RequestBody User user) { user.setState(0); user.setPassword(userService.encodePsw(user.getPassword())); if (userService.saveUser(user)) { return JsonResult.ok("添加成功"); } return JsonResult.error("添加失败"); } /** * 修改用户 */ @OperLog(value = "用户管理", desc = "修改", param = false, result = true) @RequiresPermissions("sys:user:update") @ResponseBody @RequestMapping("/update") public JsonResult update(@RequestBody User user) { user.setState(null); // 状态不能修改 user.setPassword(null); // 密码不能修改 user.setUsername(null); // 账号不能修改 if (userService.updateUser(user)) { return JsonResult.ok("修改成功"); } return JsonResult.error("修改失败"); } /** * 删除用户 */ @OperLog(value = "用户管理", desc = "删除", result = true) @RequiresPermissions("sys:user:remove") @ResponseBody @RequestMapping("/remove") public JsonResult remove(Integer id) { if (userService.removeById(id)) { return JsonResult.ok("删除成功"); } return JsonResult.error("删除失败"); } /** * 批量修改用户 */ @OperLog(value = "用户管理", desc = "批量修改", param = false, result = true) @RequiresPermissions("sys:user:update") @ResponseBody @RequestMapping("/updateBatch") public JsonResult updateBatch(@RequestBody BatchParam<User> batchParam) { // 不能修改的字段 batchParam.getData().setPassword(null); batchParam.getData().setState(null); batchParam.getData().setUsername(null); batchParam.getData().setPhone(null); batchParam.getData().setEmail(null); if (batchParam.update(userService, "user_id")) { return JsonResult.ok("修改成功"); } return JsonResult.error("修改失败"); } /** * 批量删除用户 */ @OperLog(value = "用户管理", desc = "批量删除", result = true) @RequiresPermissions("sys:user:remove") @ResponseBody @RequestMapping("/deleteBatch") public JsonResult deleteBatch(@RequestBody List<Integer> ids) { if (userService.removeByIds(ids)) { return JsonResult.ok("删除成功"); } return JsonResult.error("删除失败"); } /** * 修改用户状态 */ @OperLog(value = "用户管理", desc = "修改状态", result = true) @RequiresPermissions("sys:user:update") @ResponseBody @RequestMapping("/state/update") public JsonResult updateState(Integer id, Integer state) { if (state == null || (state != 0 && state != 1)) { return JsonResult.error("状态值不正确"); } User user = new User(); user.setUserId(id); user.setState(state); if (userService.updateById(user)) { return JsonResult.ok("修改成功"); } return JsonResult.error("修改失败"); } /** * 批量修改用户状态 */ @OperLog(value = "用户管理", desc = "批量修改状态", result = true) @RequiresPermissions("sys:user:update") @ResponseBody @RequestMapping("/state/updateBatch") public JsonResult updateStateBatch(@RequestBody BatchParam<User> batchParam) { User user = new User(); user.setState(batchParam.getData().getState()); if (user.getState() == null || (user.getState() != 0 && user.getState() != 1)) { return JsonResult.error("状态值不正确"); } if (batchParam.update(userService, "user_id")) { return JsonResult.ok("修改成功"); } return JsonResult.error("修改失败"); } /** * 重置密码 */ @OperLog(val