Shiro-授权

一、shiro授权

 

 

 有的没有权限

1、 在ShiroUserMapper.xml中新增内容 

 <select id="getRolesByUserId" resultType="java.lang.String" parameterType="java.lang.Integer">
    select r.roleid from t_shiro_user u,t_shiro_user_role ur,t_shiro_role r
    where u.userid = ur.userid and ur.roleid = r.roleid
      and u.userid = #{userid}
  </select>
  <select id="getPersByUserId" resultType="java.lang.String" parameterType="java.lang.Integer">
    select p.permission from t_shiro_user u,t_shiro_user_role ur,t_shiro_role_permission rp,t_shiro_permission p
    where u.userid = ur.userid and ur.roleid = rp.roleid and rp.perid = p.perid
      and u.userid = #{userid}
  </select>

2、Service层（ShiroUserMapper）

public Set<String> getRolesByUserId(@Param("userid")Integer userid);

public Set<String> getPersByUserId(@Param("userid")Integer