用户表接口

1、编辑用户

    /**
     * 修改用户
     * */
    @PutMapping
    public RestResult edit(@Validated @RequestBody SysUserVo user){
        if(UserConstants.NOT_UNIQUE.equals(sysUserService.checkPhoneUnique(user))){
            return RestResult.error("修改用户'"+user.getUserName()+"'失败，手机号已存在");
        }else if(UserConstants.NOT_UNIQUE.equals(sysUserService.checkEmailUnique(user))){
            return RestResult.error("修改用户'"+user.getUserName()+"'失败，邮箱账号已存在");
        }
        user.setUpdateBy("system");
        boolean flag = sysUserService.updateUser(user);
        return toAjax(flag?1:0);
    }

先把当前用户的rolesId删掉，再重新加入sys_user_role表

    @Override
    @Transactional
    public boolean updateUser(SysUserVo user) {
        Long userId = user.getUserId();
        Optional<SysUser> op = sysUserRepository.findById(userId);
        if(!op.isPresent()){
            return false;
        }
        sysUserRepository.deleteUserRoleByUserId(userId);
        SysUser sysUser = op.get();
        BeanUtils.copyPropertiesIgnoreNull(user,sysUser);
        sysUserRepository.save(sysUser);
        insertUserRole(user);
        return null != sysUser.getUserId();
    }

    @Modifying
    @Query(value = " delete from sys_user_role where user_id=:userId ",nativeQuery = true)
    int deleteUserRoleByUserId(@Param("userId") Long userId);