sql
第一步
select * from user u
left join user_role ur on u.id = ur.user_id
where u.id = 1
第二部 查询用户对应角色
select * from user u
left join user_role ur on u.id = ur.user_id
left join role r on ur.role_id = r.id
where u.id = 1
第三步查询角色和权限的关系
select * from user u
left join user_role ur on u.id = ur.user_id
left join role r on ur.role_id = r.id
left join role_permission rp on r.id = rp.role_id
第四步某用户的角色和权限
select * from user u
left join user_role ur on u.id = ur.user_id
left join role r on ur.role_id = r.id
left join role_permission rp on r.id = rp.role_id
left join permission p on rp.permission_id = p.id
where u.id = 1
自定义过滤器
shiroConfig里ShiroFilterFactoryBean
