# 持久层接口
public interface SysUserMapper extends BaseMapper<SysUser> {
/**
* 分页查询
* @param page
* @param sysUser
* @return
*/
IPage<SysUser> selectPage(Page<SysUser> page, @Param("u") SysUser sysUser);
}
# 持久层映射
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ychen.security.mapper.SysUserMapper">
<select id="selectPage" resultType="SysUser">
SELECT
`id`,
`username`,
`password`,
`is_account_non_expired`,
`is_account_non_locked`,
`is_credentials_non_expired`,
`is_enabled`,
`nick_name`,
`mobile`,
`email`,
`create_date`,
`update_date`
FROM
sys_user
WHERE `is_enabled` = 1
<if test="u.username != null and u.username !=''">
AND username LIKE CONCAT('%', #{u.username}, '%')
</if>
<if test="u.mobile != null and u.mobile !=''">
AND mobile = ${u.mobile}
</if>
</select>
</mapper>
# 业务层接口
public interface SysUserService extends IService<SysUser> {
/**
* 分页查询用户信息
* @param page 分页对象
* @param sysUser 查询条件
* @return
*/
IPage<SysUser> selectPage(Page<SysUser> page, SysUser sysUser);
}
# 业务层实现
@Service
public class SysUserServiceImpl extends ServiceImpl<SysUserMapper, SysUser> implements SysUserService {
@Override
public IPage<SysUser> selectPage(Page<SysUser> page, SysUser sysUser) {
return baseMapper.selectPage(page, sysUser);
}
}
# 控制层接口
@Controller
@RequestMapping("/user")
public class SysUserController {
@Autowired
private SysUserService sysUserService;
/**
* 分页查询用户列表
* @param page 分页对象: size, current
* @param sysUser 查询条件 : username, mobile
* @return
*/
@PreAuthorize("hasAuthority('sys:user:list')")
@GetMapping("/page")
@ResponseBody
public MengxueguResult page(Page<SysUser> page, SysUser sysUser) {
return MengxueguResult.ok(sysUserService.selectPage(page, sysUser));
}
}
# 控制层接口
@Autowired
private SysRoleService sysRoleService;
@PreAuthorize("hasAnyAuthority('sys:user:add', 'sys:user:edit')")
@GetMapping(value={"/form", "/form/{id}"})
public String form(@PathVariable(required = false) Long id, Model model) {
// 1, 查询用户信息，包含了用户所拥有的角色
SysUser user = sysUserService.findById(id);
model.addAttribute("user", user);
// 2, 查询出所有角色信息 sys_role
List<SysRole> roleList = sysRoleService.list();
model.addAttribute("roleList", roleList);
return HTML_PREFIX + "user-form";
}
# 业务层接口
/**
* 1. 用户id查询用户信息 sys_user
* 2. 用户id查询所拥有的角色
* @param id
* @return
*/
SysUser findById(Long id);
# 业务层实现
@Autowired
SysRoleMapper sysRoleMapper;
/**
* 1. 用户id查询用户信息 sys_user
* 2. 用户id查询所拥有的角色
* @param id
* @return
*/
@Override
public SysUser findById(Long id) {
if(id == null) {
return new SysUser();
}
// 1. 用户id查询用户信息 sys_user
SysUser sysUser = baseMapper.selectById(id);
// 2. 用户id查询所拥有的角色
List<SysRole> roleList = sysRoleMapper.findByUserId(id);
sysUser.setRoleList(roleList);
return sysUser;
}
# 角色持久层接口
/**
* 通过用户id查询所拥有的角色
* @param userId 用户id
* @return 查询到信息集合
*/
List<SysRole> findByUserId(@Param("userId")Long userId);
# 角色持久层映射
<select id="findByUserId" resultType="SysRole">
SELECT
r.*
FROM
sys_role r
JOIN sys_user_role ur ON r.id = ur.role_id
JOIN sys_user u ON ur.user_id = u.id
WHERE
u.id = #{userId}
</select>
# 持久层接口
/**
* 通过用户id删除用户角色表中的所有记录
* @param userId
* @return
*/
boolean deleteUserRoleByUserId(@Param("userId") Long userId);
/**
* 保存用户角色关系表数据
* @param userId 用户id
* @param roleIds 角色ids
* @return
*/
boolean saveUserRole(@Param("userId") Long userId,@Param("roleIds") List<Long> roleIds);
# 持久层映射
<!--通过用户id删除用户角色关系表数据-->
<delete id="deleteUserRoleByUserId">
DELETE FROM sys_user_role where user_id = #{userId}
</delete>
<insert id="saveUserRole">
INSERT INTO sys_user_role(user_id, role_id) VALUES
<foreach collection="roleIds" item="item" index="index" separator=",">
(#{userId}, #{item})
</foreach>
</insert>
# 业务层实现，重写saveOrUpdate方法
@Transactional //开启事务
@Override
public boolean saveOrUpdate(SysUser entity) {
if(entity != null && entity.getId() == null) {
//新增设置默认密码1234
entity.setPassword(PASSWORD_DEFAULT);
}
entity.setUpdateDate(new Date());
// 1.更新或者保存操作
boolean flag = super.saveOrUpdate(entity);
if(flag) {
// 2. 先删除用户角色表中的数据
baseMapper.deleteUserRoleByUserId(entity.getId());
// 3. 再新增到用户角色表中
if(CollectionUtils.isNotEmpty(entity.getRoleIds())) {
baseMapper.saveUserRole(entity.getId(), entity.getRoleIds());
}
}
return true;
}
# 控制层接口
@PreAuthorize("hasAnyAuthority('sys:user:add', 'sys:user:edit')")
@RequestMapping(method = {RequestMethod.POST, RequestMethod.PUT}, value = "")
public String saveOrUpdate(SysUser sysUser) {
// 1. 保存到用户表, 要将选择的角色保存到用户角色中间表
sysUserService.saveOrUpdate(sysUser);
return "redirect:/user";
}
# 业务层接口
boolean deleteById(Long id);
# 业务层实现
@Override
public boolean deleteById(Long id) {
// 1. 查询用户信息
SysUser sysUser = baseMapper.selectById(id);
// 2. 再更新用户信息，将状态更新为已删除
sysUser.setEnabled(false);
sysUser.setUpdateDate(new Date());
baseMapper.updateById(sysUser);
return true;
}
# 控制层接口
@PreAuthorize("hasAuthority('sys:user:delete')")
@DeleteMapping("/{id}")
public MengxueguResult deleteById(@PathVariable Long id) {
// 假删除，只做更新
sysUserService.deleteById(id);
return MengxueguResult.ok();
}
