shiro授权角色，权限，加注解开发（三）

1、shiro授权角色、权限

授权,首先我们来看一下图

在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>

Service层

package com.hu.com.hu;

import com.hu.model.ShiroUser;
import org.springframework.stereotype.Repository;

import java.util.Set;

/**
 * @author hu
 * @site www.huguiyun.xzy
 * @company xxx公司
 * @create  2019-10-13 16:35
 */
@Repository
public interface ShiroUserService {
   
    public ShiroUser queryByName(String uname);

    public int add(ShiroUser shiroUser);


    Set<String> getRolesByUserId(Integer uid);

    Set