RBAC基础角色用户菜单权限管理

àì夳堔傛蜴生んèń 2024-04-18 14:18 89阅读 0赞

用户表

![20190907220333630.png][]

角色表

![20190907220409340.png][]

用户-多角色表-关系表(某一个用户的多个角色) 一个用户多个角色

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxODI3MjQ1NTYz_size_16_color_FFFFFF_t_70][]

菜单表

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxODI3MjQ1NTYz_size_16_color_FFFFFF_t_70 1][]

角色\_多菜单\_关系表(某一个角色对应的对个菜单集合)

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxODI3MjQ1NTYz_size_16_color_FFFFFF_t_70 2][]

/// 当前用户的菜单权限   取出 (张三-开发的菜单 并集 张三-测试的菜单)去重

---1.查询用户的信息-根据用户名密码
    select * from  user where username='zhangsan' and password='123456';
    ---2.根据用户userid查询当前用户的角色列表
    select * from user_roles 
    left join role on user_roles.roleid = role.id
    where userid='1'
    ---3.根据roleid查询当前角色的菜单集
    select * from role
    LEFT JOIN role_menus on role.id= role_menus.roleid
    left join menu on role_menus.menuid = menu.id
    where roleid='2'

[20190907220333630.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/cc877e0a84414101b1fbc11e1d7bb24f.png
[20190907220409340.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/27ee4fd718d94559b50f6525c7c8adda.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxODI3MjQ1NTYz_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/c28c9547ccd747a4b0cd60a3cc5ff951.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxODI3MjQ1NTYz_size_16_color_FFFFFF_t_70 1]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/711caca201074fcbb3b82b75c9d8725c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxODI3MjQ1NTYz_size_16_color_FFFFFF_t_70 2]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/4f601e8e2f7a439faf208e093e1d1e97.png