角色查询该角色下的权限树不论多少子节点都能查出来通过mybatits查询方式

你的名字 2021-05-03 03:42 259阅读 0赞

### 查询到的结果 ###

{ 
        "code": 1,
        "data": { 
            "menuTreeList": [
                { 
                    "id": 1,
                    "menuList": [
                        { 
                            "id": 5,
                            "menuList": [],
                            "menuName": "用户添加",
                            "parent": 1,
                            "pathUrl": "user/add",
                            "perms": "user:add"
                        },
                        { 
                            "id": 6,
                            "menuList": [],
                            "menuName": "用户编辑",
                            "parent": 1,
                            "pathUrl": "user/update",
                            "perms": "user:update"
                        },
                        { 
                            "id": 7,
                            "menuList": [],
                            "menuName": "用户删除",
                            "parent": 1,
                            "pathUrl": "user/delete",
                            "perms": "user:delete"
                        },
                        { 
                            "id": 8,
                            "menuList": [],
                            "menuName": "用户列表",
                            "parent": 1,
                            "pathUrl": "user/list",
                            "perms": "user:list"
                        }
                    ],
                    "menuName": "用户",
                    "parent": 0
                },
                { 
                    "id": 2,
                    "menuList": [
                        { 
                            "id": 9,
                            "menuList": [],
                            "menuName": "角色添加",
                            "parent": 2,
                            "pathUrl": "role/add",
                            "perms": "role:add"
                        },
                        { 
                            "id": 10,
                            "menuList": [],
                            "menuName": "角色编辑",
                            "parent": 2,
                            "pathUrl": "role/update",
                            "perms": "role:update"
                        },
                        { 
                            "id": 11,
                            "menuList": [],
                            "menuName": "角色删除",
                            "parent": 2,
                            "pathUrl": "role/delete",
                            "perms": "role:delete"
                        },
                        { 
                            "id": 12,
                            "menuList": [],
                            "menuName": "角色列表",
                            "parent": 2,
                            "pathUrl": "role/list",
                            "perms": "role:list"
                        }
                    ],
                    "menuName": "角色",
                    "parent": 0
                },
                { 
                    "id": 3,
                    "menuList": [
                        { 
                            "id": 13,
                            "menuList": [],
                            "menuName": "菜单添加",
                            "parent": 3,
                            "pathUrl": "menu/add",
                            "perms": "menu:add"
                        },
                        { 
                            "id": 14,
                            "menuList": [],
                            "menuName": "菜单编辑",
                            "parent": 3,
                            "pathUrl": "menu/update",
                            "perms": "menu:update"
                        },
                        { 
                            "id": 15,
                            "menuList": [],
                            "menuName": "菜单删除",
                            "parent": 3,
                            "pathUrl": "menu/delete",
                            "perms": "menu:delete"
                        },
                        { 
                            "id": 16,
                            "menuList": [],
                            "menuName": "菜单列表",
                            "parent": 3,
                            "pathUrl": "menu/list",
                            "perms": "menu:list"
                        }
                    ],
                    "menuName": "菜单",
                    "parent": 0
                },
                { 
                    "id": 4,
                    "menuList": [
                        { 
                            "id": 17,
                            "menuList": [],
                            "menuName": "信息添加",
                            "parent": 4,
                            "pathUrl": "msg/add",
                            "perms": "msg:add"
                        },
                        { 
                            "id": 18,
                            "menuList": [],
                            "menuName": "信息编辑",
                            "parent": 4,
                            "pathUrl": "msg/update",
                            "perms": "msg:update"
                        },
                        { 
                            "id": 19,
                            "menuList": [],
                            "menuName": "信息删除",
                            "parent": 4,
                            "pathUrl": "msg/delete",
                            "perms": "msg:delete"
                        },
                        { 
                            "id": 20,
                            "menuList": [],
                            "menuName": " 信息列表",
                            "parent": 4,
                            "pathUrl": "msg/list",
                            "perms": "msg:list"
                        }
                    ],
                    "menuName": "信息",
                    "parent": 0
                }
            ],
            "roleId": 1,
            "roleName": "admin"
        },
        "msg": "请求成功"
    }

![表结构][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4MDgyMzA0_size_16_color_FFFFFF_t_70]

### 菜单表实体类 ###

@Data
    public class Menu implements Serializable { 
        @TableId(value = "id", type = IdType.AUTO)
        private Integer id;
    
        private Integer parent;
    
        @TableField("menuName")
        private String menuName;
    
        @TableField("pathUrl")
        private String pathUrl;
    
        private String perms;
    }

@Data
    public class MenuTree extends Menu { 
    
        private List<Menu> menuList;
    }

@Data
    public class RoleMenuInfo { 
    
        private Integer roleId;
    
        private String roleName;
    
        private List<MenuTree> menuTreeList;
    }

<resultMap id="RoleMenuMap" type="com.niezhiliang.security.demo.entity.RoleMenuInfo">
            <id column="id" jdbcType="INTEGER" property="roleId" />
            <result column="roleName" jdbcType="VARCHAR" property="roleName" />
            <collection property="menuTreeList" javaType="java.util.ArrayList" column="roleId=id" select="getMenu">
    
            </collection>
        </resultMap>
        
        <resultMap id="ParentMenu" type="com.niezhiliang.security.demo.entity.MenuTree">
            <id column="id" jdbcType="INTEGER" property="id" />
            <result column="parent" jdbcType="INTEGER" property="parent" />
            <result column="menuName" jdbcType="VARCHAR" property="menuName" />
            <result column="pathUrl" jdbcType="VARCHAR" property="pathUrl" />
            <result column="perms" jdbcType="VARCHAR" property="perms" />
            
            <collection property="menuList" javaType="java.util.ArrayList" column="{roleId=rId,id=id}" select="getChildMenu">
            </collection>
        </resultMap>
    
        
        <select id="selectSubMenu" resultMap="RoleMenuMap">
           select * from role where id = #{roleId}
        </select>
    
        
        <select id="getMenu" resultMap="ParentMenu">
           select * from menu m left join role_menu r on m.id = r.mid where r.rid = #{roleId} and m.parent = 0
        </select>
    
    
        
        <select id="getChildMenu" resultMap="ParentMenu">
       	   select * from menu m left join role_menu r on m.id = r.mId where r.rId = #{roleId} and m.parent = #{id}
        </select>

然后直接查询就出来啦。

//文章开头查询到的结果就是角色为1的用户的权限
    127.0.0.1:8080/menu/list?roleId=1

demo地址：[https://github.com/niezhiliang/spring-boot-security-demo][https_github.com_niezhiliang_spring-boot-security-demo]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4MDgyMzA0_size_16_color_FFFFFF_t_70]: /images/20210502/67bc7781db284bddb35d38ca45762f4a.png
[https_github.com_niezhiliang_spring-boot-security-demo]: https://github.com/niezhiliang/spring-boot-security-demo