mybatis plus + layui + spring boot + shiro

mybatis plus + spring boot + shiro：

entity：

package com.aaa.entity;

import com.baomidou.mybatisplus.annotations.TableField;
import lombok.Data;

import java.io.Serializable;
import java.util.Date;

/**
 * <p>
 * 用户信息表
 * </p>
 *
 * @author AAATeacherChen
 * @since 2020-07-09
 */
@Data
public class UserVo  implements  Serializable{

    private static final long serialVersionUID = 1L;

    /**
     * 用户ID
     */
    private Integer userId;
    /**
     * 部门ID
     */
    private Integer deptId;
    /**
     * 登录账号
     */
    private String loginName;
    /**
     * 用户昵称
     */
    private String userName;
    /**
     * 用户邮箱
     */
    private String email;
    /**
     * 手机号码
     */
    private String phonenumber;
    /**
     * 用户性别（0男 1女 2未知）
     */
    private String sex;
    private String avatar;
    /**
     * 密码
     */
    private String password;
    /**
     * 盐加密
     */
    private String salt;
    /**
     * 帐号状态（0正常 1停用）
     */
    private String status;
    /**
     * 删除标志（0代表存在 2代表删除）
     */
    private String delFlag;
    /**
     * 创建者
     */
    private String createBy;
    /**
     * 创建时间
     */
    private Date createTime;
    /**
     * 更新者
     */
    private String updateBy;
    /**
     * 更新时间
     */
    private Date updateTime;
    /**
     * 备注
     */
    private String remark;

    /**
     * 实体多对多
     */
    private Dept dept;
}

dao：

@Mapper
@Repository
//@CacheNamespace(implementation= MybatisCache.class,eviction=MybatisCache.class)
public interface UserDao extends BaseMapper<User> {
    List<UserVo> selectUserVoList(Page<UserVo> pageInfo, @Param("condition")  Map<String ,Object> condition);
    int updateUserColumById(User user);
    int resetPassword(User user);
}

service：

public interface UserService extends IService<User> {

    List<UserVo> selectUserVoList( Page<UserVo> pageInfo, Map<String ,Object> condition);
    boolean saveUserAndSalt(User user);
    boolean updateUserAndSalt(User user);
    boolean resetPassword(User user);

}

Impl：

package com.aaa.service.impl;

import com.aaa.dao.UserRoleDao;
import com.aaa.entity.User;
import com.aaa.dao.UserDao;
import com.aaa.entity.UserRole;
import com.aaa.entity.UserVo;
import com.aaa.service.UserService;
import com.aaa.shiro.ShiroUtil;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.baomidou.mybatisplus.plugins.Page;
import com.baomidou.mybatisplus.service.impl.ServiceImpl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;
import java.util.Map;
import java.util.UUID;

/**
 * <p>
 * 用户信息表 服务实现类
 * </p>
 *
 * @author AAATeacherChen
 * @since 2020-07-09
 */
@Service
public class UserServiceImpl extends ServiceImpl<UserDao, User> implements UserService {
    @Autowired
    private UserDao userDao;
    @Autowired
    private UserRoleDao userRoleDao;


    @Override
    public List<UserVo> selectUserVoList( Page<UserVo> pageInfo, Map<String ,Object> condition) {
        List<UserVo> userVoList = userDao.selectUserVoList(pageInfo, condition);
        return userVoList;
    }

    /**
     * create by: Teacher陈
     * description: 保存用户之前，对密码进行加盐加密
     * create time: 2020/7/23 16:05
     *
     * @return a
     * @Param: null
     */
    @Override
    public boolean saveUserAndSalt(User user) {
        //获取从页面传入的角色id,因为salt是在后台生成，所有由salt属性传入角色id的集合
        String roleIds = user.getSalt();
        //生成随机码作为salt
        String salt = UUID.randomUUID().toString();
        //获取明文密码
        String message = user.getPassword();
        //获取密文密码
        String encryption = ShiroUtil.encryptionBySalt(salt, message);
        //设置user的密码属性
        user.setPassword(encryption);
        //设置user对象的盐值属性
        user.setSalt(salt);
        //将用户保存到数据库
        Integer insert = userDao.insert(user);
        //如果插入成功，并且页面传入的角色id不为空
        return updateRoleUser(user,roleIds);

    }
    @Override
    public boolean updateUserAndSalt(User user) {
        String roleIds = user.getSalt();
        //将用户保存到数据库
        Integer update = userDao.updateUserColumById(user);
        //如果插入成功，并且页面传入的角色id不为空
        if(update>0){
            boolean b = updateRoleUser(user, roleIds);
            if(b){
                return true;
            }
        }

        return false;
    }

    @Override
    public boolean resetPassword(User user) {
        //生成随机码作为salt
        String salt = UUID.randomUUID().toString();
        //获取明文密码
        String message = user.getPassword();
        //获取密文密码
        String encryption = ShiroUtil.encryptionBySalt(salt, message);
        //设置user的密码属性
        user.setPassword(encryption);
        //设置user对象的盐值属性
        user.setSalt(salt);
        //将用户保存到数据库
        Integer reset = userDao.resetPassword(user);
        if(reset>0){
            return true;
        }
        return false;
    }

    /**
     * @create by: Teacher陈
     * @description: 更新用户和角色中间表
     * @create time: 2020/7/19 13:37
     */
    private boolean updateRoleUser(User user,String roleIds) {
        if ( roleIds != null) {
            //删除此用户原有的角色
            Wrapper<UserRole> wrapper = new EntityWrapper();
            wrapper.eq("user_id", user.getUserId());
            userRoleDao.delete(wrapper);
            //添加此用户关联的新角色
            String[] strings = roleIds.split(",");
            for (String string : strings) {
                if (string != null && string != "") {
                    Integer roleID = Integer.parseInt(string);
                    UserRole userRole = new UserRole();
                    userRole.setUserId(user.getUserId());
                    userRole.setRoleId(roleID);
                    userRoleDao.insert(userRole);
                }
            }
            return true;
        }
        return false;
    }
}

controller：

package com.aaa.controller;


import com.aaa.aop.SaveOrUpdateEntityAnn;
import com.aaa.entity.*;
import com.aaa.service.DeptService;
import com.aaa.service.RoleService;
import com.aaa.service.UserService;
import com.aaa.util.MyConstants;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.baomidou.mybatisplus.plugins.Page;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * <p>
 * 用户信息表 前端控制器
 * </p>
 *
 * @author AAATeacherChen
 * @since 2020-07-09
 */
@Controller
@RequestMapping("/user")
public class UserController  extends  BaseController{
    @Autowired
    UserService userService;
    @Autowired
    DeptService deptService;
    @Autowired
    RoleService roleService;
    @RequestMapping("/toShowUser")
    public String toShowUser(Model model){
        //查询所有的部门信息，填充到页面下拉框中
        List<Dept> deptList = deptService.selectList(null);
        //查询所有的角色信息，填充到页面下拉框中
        List<Role> roleList = roleService.selectList(null);

        model.addAttribute("deptList", deptList);
        model.addAttribute("roleList", roleList);
        return "user/showUser";
    }

    /**
     * create by: Teacher陈
     * description: 返回所有的用户信息，包含部门信息
     * create time: 2020/7/20 17:20
     *
     * @Param:
     * @return java.lang.String
     */
    @RequestMapping("/selectAllUser")
    @ResponseBody
    public LayUiTable selectAllUser(HttpSession session,Integer page, Integer limit, String searchLoginName, String searchUserName, String searchPhonenumber){
/*        int sessionTimeout = session.getServletContext().getSessionTimeout();
        System.out.println(sessionTimeout);
        long timeout = SecurityUtils.getSubject().getSession().getTimeout();
        System.out.println(timeout);*/
        LayUiTable table = new LayUiTable();
        //多条件查询所需要的集合
        Map<String ,Object> condition= new HashMap(16);
        Wrapper wrapper = new EntityWrapper();
        //添加模糊查询的条件
        if (null != searchLoginName && !"".equals(searchLoginName)) {
            wrapper.like("login_name", searchLoginName);
            condition.put("login_name", searchLoginName);
        }
        if (null != searchUserName && !"".equals(searchUserName)) {
            condition.put("user_name", searchUserName);
        }
        if (null != searchPhonenumber && !"".equals(searchPhonenumber)) {
            condition.put("phonenumber", searchPhonenumber);
        }
        wrapper.eq("del_flag", 0);
        condition.put("del_flag", 0);
        int userListCount = userService.selectCount(wrapper);
        //如果表中没有数据。则不进行分页查询
        if(userListCount>0){
            //获取当前的系统毫秒数
            long start = System.currentTimeMillis();
            Page<UserVo> pageInfo = new Page(page, limit);
            List<UserVo> userVoList = userService.selectUserVoList(pageInfo,condition);
            //从分页结果中提取list集合
            table.setCode(MyConstants.OPERATION_SUCCESS_CODE);
            table.setMsg(MyConstants.OPERATION_SUCCESS_MESSAGE);
            table.setData(userVoList);
            table.setCount(userListCount);
            long end = System.currentTimeMillis();
           /* System.out.println("============查询花费时间："+(end-start)+"============");*/
        }
        return table;

    }


    /**
     * create by: Teacher陈
     * description: 判断用户名是否存在，存在的话返回false，不存在返回true ,检验添加用户是否重复
     * create time: 2020/7/22 17:08
     * @Param: username
     * @return boolean
     */
    @RequestMapping("/checkUserName")
    @ResponseBody
    public Result checkUserName(String username){
        Wrapper<User> wrapper = new EntityWrapper<>();
        User user = userService.selectOne(wrapper.eq("login_name", username));
        if (user != null) {
           return  super.error(MyConstants.OPERATION_FAIL_CODE, username+"已经被占用");
        }
        return super.success();
    }


    /**
     * create by: Teacher陈
     * description: 保存用户
     * create time: 2020/7/23 15:43
     *
     * @return a
     * @Param: null
    */
    @RequestMapping("/saveUser")
    @ResponseBody
    @SaveOrUpdateEntityAnn(entityClass = User.class)
    public Result saveUser(User user){
        boolean insert = userService.saveUserAndSalt(user);
        if(insert){
            return success();
        }
        return error();
    }
    @RequestMapping("/updateUser")
    @ResponseBody
    @SaveOrUpdateEntityAnn(entityClass = User.class)
    /**
     * @create by: Teacher陈
     * @description: 修改用户
     * @create time: 2020/7/18 19:32
     * @param user
     * @return com.aaa.entity.Result
     */
    public Result updateUser(User user){
        boolean update = userService.updateUserAndSalt(user);
        if(update){
            return success();
        }
        return error();
    }
    /**
     * @create by: Teacher陈
     * @description: 删除用户（逻辑删除）
     * @create time: 2020/7/19 13:44
     */
    @RequestMapping("/deleteUser")
    @ResponseBody
    public Result deleteUser(User user){
        user.setDelFlag("1");
        boolean update = userService.updateById(user);
        if(update){
            return success();
        }
        return error();
    }
    /**
     * @create by: Teacher陈
     * @description: 根据用户id查询自己的角色
     * @create time: 2020/7/18 21:28
     */
    @RequestMapping("/getRoleCheckByUserId")
    @ResponseBody
    public Result getRoleCheckByUserId(Integer userId){
        List<Role> roleUserList = roleService.selectListByUserId(userId);
        List<Role> roleList = roleService.selectList(null);
        Map map = new HashMap();
        for (Role role : roleList) {
            //判断集合包含对象，必须重写equals和hashcode方法
            if(roleUserList.contains(role)){
                map.put(role.getRoleKey(), true);
            }else {
                map.put(role.getRoleKey(), false);
            }
        }
        System.out.println(map.toString());
        return success(map);
    }

    /**
     * @create by: Teacher陈
     * @description: 重置密码
     * @create time: 2020/7/19 15:16
     */
    @RequestMapping("/resetPassword")
    @ResponseBody
    public  Result resetPassword(User user){
        boolean update = userService.resetPassword(user);
        if(update){
            return success();
        }
        return error();
    }
    /**
     * @create by: Teacher陈
     * @description: 批量删除用户
     * @create time: 2020/7/19 15:20
     * @param userList
     * @return Result
     */
    @RequestMapping(value = "/deleteBatchUser")
    @ResponseBody
    public Result deleteBatchUser(@RequestBody List<User> userList) {
        List<User> userListNew = new ArrayList<>();
        //此处是逻辑删除，修改delflag
        for (User user : userList) {
            User userNew = new User();
            userNew.setDelFlag("1");
            userNew.setUserId(user.getUserId());
            userListNew.add(userNew);
        }
        boolean update = userService.updateBatchById(userListNew);
        if (update) {
            return super.success();
        } else {
            return super.error();
        }
    }
    /**
     * 去用户基本信息
     * @param model
     * @param request
     * @return
     */
    @RequestMapping("toUserInfo")
    public String toUserInfo(Model model,  HttpServletRequest request) {
        //获取session的userid
        String remoteUser = request.getRemoteUser();
        String[] split = remoteUser.split(",");
        String[] split1 = split[0].split("=");
        String id = split1[1];
        //转integer类型
        Integer userId = Integer.valueOf(id);
        //根据id查询user列表
        User user = userService.selectById(userId);
        //获取deptid
        Integer deptId = user.getDeptId();
        Dept dept = deptService.selectById(deptId);
        //获取roleid
//        UserController userController = new UserController();
//        Result roleCheckByUserId = userController.getRoleCheckByUserId(userId);
//        model.addAttribute("role", roleCheckByUserId);
        //查询所有的部门信息，填充到页面下拉框中
        List<Dept> deptList = deptService.selectList(null);
        //查询所有的角色信息，填充到页面下拉框中
        List<Role> roleList = roleService.selectList(null);
        model.addAttribute("user", user);
        model.addAttribute("dept", dept);
        model.addAttribute("deptList", deptList);
//        model.addAttribute("roleList", roleList);
        return "/user/userinfo";
    }

    /**
     * 修改基本信息
     * @param user
     * @return
     */
    @RequestMapping("/updateInfo")
    @ResponseBody
    @SaveOrUpdateEntityAnn(entityClass = User.class)
    public Result update(User user){
        user.setPassword(null);
        boolean update = userService.updateById(user);
        if(update){
            return success();
        }
        return error();
    }

    /**
     * 去修改用户基本信息
     * @param model
     * @param request
     * @return
     */
    @RequestMapping("toUpdateUser")
    public String toUpdateUser(Model model,  HttpServletRequest request) {
        //获取session的userid
        String remoteUser = request.getRemoteUser();
        String[] split = remoteUser.split(",");
        String[] split1 = split[0].split("=");
        String id = split1[1];
        Integer userId = Integer.valueOf(id);
        User user = userService.selectById(userId);
        Integer deptId = user.getDeptId();
        //根据id获取部门信息
        Dept dept = deptService.selectById(deptId);
        //查询所有的部门信息，填充到页面下拉框中
        List<Dept> deptList = deptService.selectList(null);
        //查询所有的角色信息，填充到页面下拉框中
        List<Role> roleList = roleService.selectList(null);
        model.addAttribute("user", user);
        model.addAttribute("dept", dept);
        model.addAttribute("deptList", deptList);
        return "/user/userinfoUpdate";
    }

    /**
     * 去修改用户密码
     * @return
     */
    @RequestMapping("toPassUser")
    public String toPasswordUser() {
        return "user/userinfoPassW";
    }

    /**
     * 修改个人密码
     * @param user
     * @param request
     * @return
     */
    @RequestMapping("/PasswordUser")
    @ResponseBody
    public  Result PasswordUser(User user,HttpServletRequest request){
        //获取session的userid
        String remoteUser = request.getRemoteUser();
        String[] split = remoteUser.split(",");
        String[] split1 = split[0].split("=");
        String id = split1[1];
        Integer userId = Integer.valueOf(id);
        //将id传入user中
        user.setUserId(userId);
        boolean update = userService.resetPassword(user);
        if(update){
            return success();
        }
        return error();
    }
}

UserDao.xml：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.aaa.dao.UserDao" >
 <!--<cache type="com.aaa.redis.MybatisCache" eviction="LRU"></cache>-->
    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.aaa.entity.User">
        <id column="user_id" property="userId" />
        <result column="dept_id" property="deptId" />
        <result column="login_name" property="loginName" />
        <result column="user_name" property="userName" />
        <result column="email" property="email" />
        <result column="phonenumber" property="phonenumber" />
        <result column="sex" property="sex" />
        <result column="avatar" property="avatar" />
        <result column="password" property="password" />
        <result column="salt" property="salt" />
        <result column="status" property="status" />
        <result column="del_flag" property="delFlag" />
        <result column="create_by" property="createBy" />
        <result column="create_time" property="createTime" />
        <result column="update_by" property="updateBy" />
        <result column="update_time" property="updateTime" />
        <result column="remark" property="remark" />
    </resultMap>
    <!-- 通用查询映射结果 -->
    <resultMap id="UserDeptResultMap" type="com.aaa.entity.UserVo">
        <id column="user_id" property="userId" />
        <result column="dept_id" property="deptId" />
        <result column="login_name" property="loginName" />
        <result column="user_name" property="userName" />
        <result column="email" property="email" />
        <result column="phonenumber" property="phonenumber" />
        <result column="sex" property="sex" />
        <result column="avatar" property="avatar" />
        <result column="password" property="password" />
        <result column="salt" property="salt" />
        <result column="status" property="status" />
        <result column="del_flag" property="delFlag" />
        <result column="create_by" property="createBy" />
        <result column="create_time" property="createTime" />
        <result column="update_by" property="updateBy" />
        <result column="update_time" property="updateTime" />
        <result column="remark" property="remark" />
        <association property="dept" column="dept_id" javaType="com.aaa.entity.Dept">
            <result column="dept_name" property="deptName"></result>
        </association>
    </resultMap>

    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        user_id AS userId, dept_id AS deptId, login_name AS loginName, user_name AS userName, email, phonenumber, sex, avatar, password, salt, status, del_flag AS delFlag, create_by AS createBy, create_time AS createTime, update_by AS updateBy, update_time AS updateTime, remark
    </sql>
<!--    更新用户表的部分列-->
    <update id="updateUserColumById" parameterType="com.aaa.entity.User">
        update  tbl_user set
        user_name=#{userName},
        dept_id=#{deptId},
        email=#{email},
        phonenumber=#{phonenumber},
        sex=#{sex},
        avatar=#{avatar},
        status=#{status},
        update_by=#{updateBy},
        update_time=#{updateTime},
        remark=#{remark}
        where user_id=#{userId}
    </update>
<!--    重置密码-->
    <update id="resetPassword" parameterType="com.aaa.entity.User">
         update  tbl_user
            set password=#{password},
                salt=#{salt}
            where user_id=#{userId}
    </update>
    <!--多条件查询-->
    <select id="selectUserVoList" resultMap="UserDeptResultMap">
          select u.*,d.dept_name from tbl_user u INNER JOIN tbl_dept d on u.dept_id=d.dept_id
          <where>
              <if test="condition.login_name != null and condition.login_name != ''">
                  AND u.login_name like concat('%', #{condition.login_name},'%')
              </if>
              <if test="condition.user_name != null and condition.user_name != ''">
                  AND u.user_name like concat('%', #{condition.user_name},'%')
              </if>
              <if test="condition.phonenumber != null and condition.phonenumber != ''">
                  AND u.phonenumber like concat('%', #{condition.phonenumber},'%')
              </if>
              <if test="condition.del_flag != null ">
                  AND u.del_flag = #{condition.del_flag}
              </if>
          </where>
    </select>

</mapper>

lay ui：

<!DOCTYPE html>
<html lang="en" xmlns:th="http://www.thymeleaf.org"
      xmlns:shiro="http://www.pollix.at/thymeleaf/shiro">
<head>
    <meta charset="UTF-8">
    <title>用户管理页面</title>
    <link rel="stylesheet" th:href="@{/layui/css/layui.css}">
    <script th:src="@{/layui/layui.js}"></script>
</head>
<body>
<script type="text/html" id="barDemo">
    <a class="layui-btn  layui-btn-normal layui-btn-xs" lay-event="resetPassword">重置密码</a>
    <a class="layui-btn layui-btn-xs" lay-event="edit">编辑</a>
    <a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="delete"
       shiro:hasPermission="system:user:remove">删除</a>
    <!--<a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="delete"  >删除</a>-->
</script>
<form class="layui-form" action="" id="save_user_form" style="display: none">
    <div class="layui-form-item">
        <label class="layui-form-label">登录名</label>
        <div class="layui-input-block">
            <input type="text" name="loginName" id="loginName" required lay-verify="required" placeholder="请输入登录名称"
                   autocomplete="off"
                   class="layui-input">
        </div>
    </div>
    <div class="layui-form-item">
        <label class="layui-form-label">密 码</label>
        <div class="layui-input-block">
            <input type="text" name="password" required lay-verify="required" placeholder="请设置密码" autocomplete="off"
                   class="layui-input">
        </div>
    </div>
    <div class="layui-form-item">
        <label class="layui-form-label">真实姓名</label>
        <div class="layui-input-inline">
            <input type="text" name="userName" required lay-verify="required" placeholder="请输入真实姓名" autocomplete="off"
                   class="layui-input">
        </div>
    </div>
    <div class="layui-form-item">
        <label class="layui-form-label">邮箱</label>
        <div class="layui-input-inline">
            <input type="text" name="email" required lay-verify="email" placeholder="请输入电子邮箱" autocomplete="off"
                   class="layui-input">
        </div>
    </div>
    <div class="layui-form-item">
        <label class="layui-form-label">手机号</label>
        <div class="layui-input-inline">
            <input type="text" name="phonenumber" required lay-verify="required|phone" placeholder="请输入手机号"
                   autocomplete="off"
                   class="layui-input">
        </div>
    </div>
    <div class="layui-form-item">
        <label class="layui-form-label">部门</label>
        <div class="layui-input-block">
            <select name="deptId" lay-verify="required">
                <option th:each="dept:${deptList}" th:value="${dept.deptId}" th:text="${dept.deptName}"></option>
            </select>
        </div>
    </div>

    <div class="layui-form-item">
        <div class="layui-inline">
            <label class="layui-form-label">状态</label>
            <div class="layui-input-block">
                <input type="checkbox" name="status" lay-skin="switch" lay-text="正常|禁用" checked value="0">
            </div>
        </div>
        <div class="layui-inline">
            <label class="layui-form-label">性别</label>
            <div class="layui-input-block">
                <input type="radio" name="sex" value="0" title="男" checked="">
                <input type="radio" name="sex" value="1" title="女">
            </div>
        </div>
    </div>
    <div class="layui-form-item" pane="">
        <label class="layui-form-label">角色</label>
        <div class="layui-input-block">
            <input  th:each="role:${roleList}" name="role" type="checkbox" th:value="${role.roleId}"
                   lay-skin="primary"
                   th:text="${role.roleName}">
        </div>
        <input hidden="hidden" name="salt">
    </div>
    <div class="layui-form-item">
        <label class="layui-form-label">备注</label>
        <div class="layui-input-inline">
            <input type="text" name="remark" required lay-verify="required" placeholder="请输入备注信息" autocomplete="off"
                   class="layui-input">
        </div>
    </div>
    <div class="layui-form-item">
        <div class="layui-input-block">
            <button class="layui-btn" lay-submit lay-filter="formDemo">立即提交</button>
            <button type="reset" class="layui-btn layui-btn-primary">重置</button>
        </div>
    </div>
</form>
<!--===========================================更新用户信息==============================================================-->
<form class="layui-form" action="" id="update_user_form" style="display: none" lay-filter="update_user_form">
    <!--隐藏输入框，保存主键-->
    <div style="margin-top: 2%"></div>
    <input type="hidden" name="userId">
    <input type="hidden" name="loginName">
    <input type="hidden" name="password">
    <div class="layui-form-item">
        <label class="layui-form-label">真实姓名</label>
        <div class="layui-input-inline">
            <input type="text" name="userName" required lay-verify="required" placeholder="请输入真实姓名" autocomplete="off"
                   class="layui-input">
        </div>
    </div>
    <div class="layui-form-item">
        <label class="layui-form-label">邮箱</label>
        <div class="layui-input-inline">
            <input type="text" name="email" required lay-verify="email" placeholder="请输入电子邮箱" autocomplete="off"
                   class="layui-input">
        </div>
    </div>
    <div class="layui-form-item">
        <label class="layui-form-label">手机号</label>
        <div class="layui-input-inline">
            <input type="text" name="phonenumber" required lay-verify="required|phone" placeholder="请输入手机号"
                   autocomplete="off"
                   class="layui-input">
        </div>
    </div>
    <div class="layui-form-item">
        <label class="layui-form-label">部门</label>
        <div class="layui-input-block">
            <select name="deptId" lay-verify="required">
                <option th:each="dept:${deptList}" th:value="${dept.deptId}" th:text="${dept.deptName}"></option>
            </select>
        </div>
    </div>

    <div class="layui-form-item">
        <div class="layui-inline">
            <label class="layui-form-label">状态</label>
            <div class="layui-input-block">
                <input type="checkbox" name="status" lay-skin="switch" lay-text="正常|禁用" checked value="0">
            </div>
        </div>
        <div class="layui-inline">
            <label class="layui-form-label">性别</label>
            <div class="layui-input-block">
                <input type="radio" name="sex" value="0" title="男" checked="">
                <input type="radio" name="sex" value="1" title="女">
            </div>
        </div>
    </div>
    <div class="layui-form-item">
        <label class="layui-form-label">角色</label>
        <div class="layui-input-block">
            <input class="role_check" th:each="role:${roleList}" th:name="${role.roleKey}" type="checkbox"
                   th:value="${role.roleId}"
                   lay-skin="primary" th:text="${role.roleName}">
        </div>
        <input hidden="hidden" name="salt">
    </div>
    <div class="layui-form-item">
        <label class="layui-form-label">备注</label>
        <div class="layui-input-inline">
            <input type="text" name="remark" required lay-verify="required" placeholder="请输入备注信息" autocomplete="off"
                   class="layui-input">
        </div>
    </div>
    <div class="layui-form-item">
        <div class="layui-input-block">
            <button class="layui-btn" lay-submit lay-filter="formUpdateUser">立即提交</button>
            <button type="reset" class="layui-btn layui-btn-primary">重置</button>
        </div>
    </div>
</form>
<!--=========================================重置密码===============================-->
<form class="layui-form" action="" id="reset_password_form" style="display: none" lay-filter="reset_password_form">
    <!--隐藏输入框，保存主键-->
    <input type="hidden" name="userId">
    <div class="layui-form-item">
        <label class="layui-form-label">密码</label>
        <div class="layui-input-inline">
            <input type="text" name="password" required lay-verify="required" placeholder="请输入新密码" autocomplete="off"
                   class="layui-input">
        </div>
    </div>
    <div class="layui-form-item">
        <div class="layui-input-block">
            <button class="layui-btn" lay-submit lay-filter="formResetPassword-flter">立即提交</button>
            <button type="reset" class="layui-btn layui-btn-primary">重置</button>
        </div>
    </div>
</form>
<div class="layui-fluid">
    <!--=============================条件查询==================================-->
    <div class="layui-card" style="padding-top: 30px">
        <form class="layui-form">
            <div class="layui-inline">
                <label class="layui-form-label">登录名</label>
                <div class="layui-input-inline">
                    <input type="text" class="layui-input" id="searchLoginName" name="searchLoginName" placeholder="登录名"
                           width="80px">
                </div>
            </div>
            <div class="layui-inline">
                <label class="layui-form-label">真实姓名</label>
                <div class="layui-input-inline">
                    <input type="text" class="layui-input" id="searchUserName" name="searchUserName"
                           placeholder="真实姓名"
                           width="80px">
                </div>
            </div>
            <div class="layui-inline">
                <label class="layui-form-label">手机号</label>
                <div class="layui-input-inline">
                    <input type="text" class="layui-input" id="searchPhonenumber" name="searchPhonenumber"
                           placeholder="手机号"
                           width="80px">
                </div>
            </div>
            <div class="layui-inline">
                <button class="layui-btn" lay-submit="search_submits" lay-filter="search_filter">查询</button>
                 <button id="search_reset" class="layui-btn layui-btn-primary">重置</button>
            </div>
        </form>
    </div>
    <div class="layui-card">
        <table id="demo" lay-filter="userTable"></table>
    </div>
</div>
<script type="text/html" id="toolbarDemo">
    <div class="layui-btn-container">
        <button class="layui-btn layui-btn-sm" lay-event="addUser">添加</button>
        <button class="layui-btn layui-btn-danger layui-btn-sm" lay-event="deleteBatch">删除</button>
    </div>
</script>
</body>
<script>
    layui.use(['layer', 'form', 'table', 'jquery'], function () {
        var table = layui.table;
        var form = layui.form;
        var $ = layui.jquery;

        //第一个实例
        var myTable = table.render({
            elem: '#demo'
            , id: 'tableReload'//重载数据表格
            , height: 420
            , url: '/user/selectAllUser' //数据接口
            , page: true //开启分页
            , limit: 5//默认一页显示5条数据
            , limits: [5, 10, 15, 20, 50, 100]//默认一页显示5条数据
            , toolbar: '#toolbarDemo'//此处的id是html代码段
            , cols: [
                [ //表头
                    {field: 'userId', title: '用户编号', sort: true, fixed: 'left', checkbox: true}
                    , {field: 'userId', title: '编号',  sort: true, width: '7%',}
                    , {field: 'loginName', title: '登录名', width: '9%',}
                    , {field: 'userName', title: '真实姓名', width: '7%',}
                    , {field: 'phonenumber', title: '手机号'}
                    , {
                    field: 'sex', title: '性别', width: '6%',
                    templet: function (d) {
                        if (d.sex == 0) {
                            return "男"
                        } else {
                            return "女"
                        }
                    }
                }
                    , {
                    field: 'status', title: '状态', width: '6%',
                    templet: function (d) {
                        if (d.status == 0) {
                            return '<button type="button" class="layui-btn layui-btn-xs">正常</button>'
                        } else {
                            return '<button type="button" class="layui-btn layui-btn-xs layui-btn-danger">禁用</button>'
                        }
                    }
                }
                    , {
                    field: 'deptName', title: '部门名称', width: '8%',
                    templet: function (d) {
                        return d.dept.deptName
                    }
                }
                    , {field: 'createTime', title: '创建时间'}
                    , {field: 'updateBy', title: '修改人',  hide: true}
                    , {field: 'updateTime', title: '修改时间',  hide: true}
                    , {field: 'remark', title: '备注', hide: true}
                    , {title: '操作', width: 235, toolbar: '#barDemo'}
                ]]
        });
        //监听头工具栏事件
        table.on('toolbar(userTable)', function (obj) {
            var checkStatus = table.checkStatus(obj.config.id)
                , data = checkStatus.data; //获取选中的数据
            switch (obj.event) {
                case 'addUser':
                    layer.open({
                        title: '添加员工',
                        type: 1,
                        content: $('#save_user_form'),
                        area: ['700px', '530px']
                    });
                    break;
                case 'update':
                    if (data.length === 0) {
                        layer.msg('请选择一行');
                    } else if (data.length > 1) {
                        layer.msg('只能同时编辑一个');
                    } else {
                        layer.alert('编辑 [id]：' + checkStatus.data[0].id);
                    }
                    break;
                case 'deleteBatch':
                    if (data.length === 0) {
                        layer.msg('请选择一行');
                    } else {
                        //对于删除或者是其他敏感操作，一定要让用户确认。
                        layer.confirm('确定要删除吗？', function () {
                            //请求后台批量删除接口
                            $.ajax({
                                url: '/user/deleteBatchUser',
                                dataType: 'json',
                                contentType: "application/json;charset=UTF-8",
                                type: 'POST',
                                data: JSON.stringify(data),//将js对象转成json串传入到后台
                                success: function (result) {
                                    layer.closeAll();//关闭对话框
                                    layer.msg(result.msg);
                                    myTable.reload();//重新加载表格数据
                                }
                            })

                        })

                    }
                    break;
            }
            ;
        });

        //监听保存用户表单的提交
        form.on('submit(formDemo)', function (data) {
            data.field.status = data.field.status ? 0 : 1;
            var checkeds = selectCheckeds("role");
            //盐值在添加的时候没有用处，所以将角色信息放入到盐值中传入后端
            data.field.salt = checkeds;
            console.log(checkeds);
            $.ajax({
                url: '/user/saveUser',
                dataType: 'json',
                type: 'POST',
                data: data.field,
                success: function (result) {
                    layer.closeAll();//关闭对话框
                    layer.msg(result.msg);
                    myTable.reload();//重新加载表格数据
                }
            })
            return false;
        });
        //监听修改用户表单的提交
        form.on('submit(formUpdateUser)', function (data) {
            data.field.status = data.field.status ? 0 : 1;
            var checkeds = selectCheckeds();
            //盐值在添加的时候没有用处，所以将角色信息放入到盐值中传入后端
            data.field.salt = checkeds;
            $.ajax({
                url: '/user/updateUser',
                dataType: 'json',
                type: 'POST',
                data: data.field,
                success: function (result) {
                    layer.closeAll();//关闭对话框
                    layer.msg(result.msg);
                    myTable.reload();//重新加载表格数据
                }
            })
            return false;
        });
        //登录名校验
        $("#loginName").blur(function () {
            var node = this;
            console.log(node)
            $.ajax({
                type: "POST",
                url: "/user/checkUserName",
                async: false, //改为同步请求
                data: {username: node.value},
                dataType: 'json',
                success: function (data) {
                    if (data.code == 0) {
                    } else {
                        node.focus();
                        layer.msg(data.msg, {icon: 5});
                    }
                }
            });
        });

        // 获取选中复选框项
        function selectCheckeds(name) {
            var checkeds = "";
            // 保存用户
            if (name != null) {
                $('input:checkbox[name="' + name + '"]:checked').each(function (i) {
                    if (0 == i) {
                        checkeds = $(this).val();
                    } else {
                        checkeds += ("," + $(this).val());
                    }
                });
            //修改用户
            } else {
                $('.role_check:checked').each(function (i) {
                    if (0 == i) {
                        checkeds = $(this).val();
                    } else {
                        checkeds += ("," + $(this).val());
                    }
                });
            }

            return checkeds;
        }

        //监听查询表单的提交事件
        form.on('submit(search_filter)', function (data) {
            var formData = data.field;
            //数据表格重载
            table.reload('tableReload', {
                page: {
                    curr: 1 //重新从第 1 页开始
                }
                , where: {//这里传参  向后台
                    searchLoginName: formData.searchLoginName,
                    searchUserName: formData.searchUserName,
                    searchPhonenumber: formData.searchPhonenumber
                }
            });
            return false;//false：阻止表单跳转  true：表单跳转
        });
        //监听重置密码表单的提交事件
        form.on('submit(formResetPassword-flter)', function (data) {
            $.ajax({
                url: '/user/resetPassword',
                dataType: 'json',
                type: 'POST',
                data: data.field,
                success: function (result) {
                    layer.closeAll();//关闭对话框
                    layer.msg(result.msg);
                }
            })
            return false;
        });
        //监听行工具事件
        table.on('tool(userTable)', function (obj) { //注：tool 是工具条事件名，userTable 是 table 原始容器的属性 lay-filter="对应的值"
            var data = obj.data //获得当前行数据
            var layEvent = obj.event; //获得 lay-event 对应的值
            if (layEvent === 'detail') {
                layer.msg('查看操作');
            } else if (layEvent === 'delete') {
                layer.confirm('真的删除行么', function (index) {
                    /*  obj.del(); //删除对应行（tr）的DOM结构
                      layer.close(index);*/
                    //向服务端发送删除指令
                    console.log(data);
                    $.ajax({
                        url: '/user/deleteUser',
                        dataType: 'json',
                        type: 'POST',
                        data: {userId: data.userId},
                        success: function (result) {
                            layer.closeAll();//关闭对话框
                            layer.msg(result.msg);
                            myTable.reload();//重新加载表格数据
                        }
                    })
                });
            }  else if (layEvent === 'resetPassword') {
                form.val('reset_password_form', {
                    "userId": data.userId});
                layer.open({
                    title: '重置密码',
                    type: 1,
                    content: $('#reset_password_form'),
                    area: ['400px', '150px']
                });
            } else if (layEvent === 'edit') {

                //将修改前的数据赋值给修改表单
                form.val('update_user_form', {
                    "userId": data.userId
                    , "loginName": data.loginName // "name": "value"
                    , "password": data.orderNum
                    , "userName": data.userName
                    , "email": data.email
                    , "phonenumber": data.phonenumber
                    , "deptId": data.deptId
                    , "status": data.status == 0 ? true : false //开关状态
                    , "sex": data.sex
                    , "remark": data.remark

                });
                //设置checkbox回显
                $.ajax({
                    url: '/user/getRoleCheckByUserId',
                    dataType: 'json',
                    type: 'POST',
                    data: {userId: data.userId},
                    success: function (result) {
                        console.log(result.data)
                        form.val('update_user_form', result.data);
                    }
                });
                layer.open({
                    title: '编辑用户',
                    type: 1,
                    content: $('#update_user_form'),
                    area: ['500px', '480px']
                });
            }
        });
        //点击重置按钮，清除查询关键字，并且重新加载表格数据
        $("#search_reset").on("click",function () {
            $("#searchLoginName").val=null;
            $("#searchUserName").val=null;
            $("#searchPhonenumber").val=null;
            myTable.reload();//重新加载表格数据
        })
    });
</script>
</html>

 application.properties：

spring.datasource.url=jdbc:mysql://localhost:3306/teacher?characterEncoding=utf-8&useSSL=false
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.username=root
#spring.datasource.password=203786
spring.datasource.password=123456
#mybatis.mapper-locations=classpath:mapper/*.xml
mybatis-plus.mapper-locations=classpath:mapper/*.xml
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.jackson.date-format=yyyy-MM-dd HH:mm:ss
spring.jackson.time-zone=GMT+8

#\u65E5\u5FD7 debug info warn error feta
logging.level.com.aaa.dao=debug
#\u5F00\u542Fmybatisplus\u7684\u4E8C\u7EA7\u7F13\u5B58
#mybatis-plus.configuration.cache-enabled=true
#redis\u670D\u52A1\u5668\u7684IP\u5730\u5740
spring.redis.host=192.168.11.100
#redis\u7684\u7AEF\u53E3\u53F7
##spring.redis.port=6379



spring.servlet.multipart.max-file-size=100MB
spring.servlet.multipart.max-request-size=1000MB