菜单模块实现

最终展现结果:

数据库:

Dao:

    // 这里为什么使用map存储数据，有什么优势劣势？
    // 方便 提高开发效率
    /**
     * 查询所有菜单信息 以及菜单对应的上级菜单名称
     * @return
     */

    List<Map<String,Object>> findObjects();
}

Mapper:

    <!--
    查询所有菜单以及菜单相对应的上级菜单名称
    -->
    <select id="findObjects" resultType="map">


        /*方案一 : 嵌套查询*/
        <!--
        select c.*,(select p.name
                    from sys_menus p
                    where c.parentId = p.id
                    ) parentName
         from sys_menus c
         -->

         /*方案二 : 多表查询 关联查询 自关联*/
        select c.*,p.name parentName
        from sys_menus c left join sys_menus p
        on c.parentId = p.id
    </select>

测试:

 @Autowired
    private SysMenuDao sysMenuDao;

    @Test
    void Test1(){
        List<Map<String, Object>> objects = sysMenuDao.findObjects();
        objects.forEach(map -> {
            System.out.println(map);
        });

    }

输出:

{modifiedTime=2020-01-12 14:11:15.0, name=系统管理, createdTime=2017-07-12 15:15:59.0, permission=, id=8, sort=8, type=1, url=请求路径, createdUser=admin}
{modifiedTime=2020-04-28 14:55:33.0, parentName=系统管理, name=日志管理, createdTime=2017-07-12 15:15:59.0, permission=sys:log:view, id=25, sort=25, type=1, url=log/log_list, parentId=8, createdUser=admin}
{modifiedTime=2020-01-12 14:10:10.0, parentName=系统管理, name=用户管理, createdTime=2017-07-12 15:15:59.0, permission=sys:user:view, id=45, sort=45, type=1, url=user/user_list, parentId=8, createdUser=admin}
{modifiedTime=2020-01-12 14:10:28.0, parentName=系统管理, name=菜单管理, createdTime=2017-07-12 15:15:59.0, permission=sys:menu:view, id=46, sort=46, type=1, url=menu/menu_list, parentId=8, createdUser=admin}
{modifiedTime=2020-01-12 14:10:48.0, parentName=系统管理, name=角色管理, createdTime=2017-07-12 15:15:59.0, permission=sys:role:view, id=47, sort=47, type=1, url=role/role_list, parentId=8, createdUser=admin}
{modifiedTime=2020-01-12 14:21:29.0, parentName=菜单管理, name=查询, createdTime=2017-07-13 16:33:41.0, permission=sys:menu:view, id=115, sort=1, type=2, url=menu/doFindObjects, parentId=46}
{modifiedTime=2020-01-12 14:21:56.0, parentName=菜单管理, name=添加, createdTime=2017-07-13 16:34:02.0, permission=sys:menu:add, id=116, sort=2, type=2, url=menu/doSaveObject, parentId=46}
{modifiedTime=2020-01-12 14:22:12.0, parentName=菜单管理, name=修改, createdTime=2017-07-13 16:34:25.0, permission=sys:menu:update, id=117, sort=3, type=2, url=menu/doUpdateObject, parentId=46}
{modifiedTime=2020-01-12 14:22:41.0, parentName=菜单管理, name=删除, createdTime=2017-07-13 16:34:46.0, permission=sys:menu:delete, id=118, sort=4, type=2, url=role/doDeleteObject, parentId=46}
{modifiedTime=2020-01-12 14:23:05.0, parentName=角色管理, name=查询, createdTime=2017-07-13 16:35:26.0, permission=sys:role:view, id=120, sort=1, type=2, url=role/doFindPageObjects, parentId=47}
{modifiedTime=2020-01-12 14:20:45.0, parentName=用户管理, name=新增, createdTime=2017-07-21 11:11:34.0, permission=sys:user:add, id=126, sort=2, type=2, url=user/doSaveObject, parentId=45}
{modifiedTime=2020-01-12 14:21:05.0, parentName=用户管理, name=修改, createdTime=2017-07-21 11:11:56.0, permission=sys:user:update, id=127, sort=3, type=2, url=user/doUpdateObject, parentId=45}
{modifiedTime=2020-01-12 14:23:29.0, parentName=角色管理, name=添加, createdTime=2017-07-21 11:14:24.0, permission=sys:role:add, id=128, sort=2, type=2, url=role/doSaveObject, parentId=47}
{modifiedTime=2020-01-12 14:23:44.0, parentName=角色管理, name=修改, createdTime=2017-07-21 11:14:48.0, permission=sys:role:update, id=129, sort=3, type=2, url=role/doUpdateObject, parentId=47}
{modifiedTime=2020-01-12 14:24:05.0, parentName=角色管理, name=删除, createdTime=2017-07-21 11:15:09.0, permission=sys:role:delete, id=130, sort=4, type=2, url=role/doDeleteObject, parentId=47}
{modifiedTime=2020-01-12 09:34:58.0, parentName=用户管理, name=禁用启用, createdTime=2020-01-12 09:34:58.0, permission=sys:user:update, id=137, sort=123, type=2, url=user/doValidById, parentId=45}
{modifiedTime=2020-05-09 14:35:48.0, parentName=系统管理, name=修改密码, createdTime=2020-05-09 14:35:48.0, permission=sys_pwd_edit, id=145, sort=17, type=1, url=user/pwd_edit, parentId=8}
{modifiedTime=2020-05-09 14:38:32.0, name=商品管理, createdTime=2020-05-09 14:38:32.0, permission=sys:goods:view, id=146, sort=19, type=1, url=}
{modifiedTime=2020-05-09 14:39:46.0, parentName=商品管理, name=基础管理, createdTime=2020-05-09 14:39:46.0, permission=sys:goods:view, id=147, sort=22, type=1, url=goods/goodles_list, parentId=146}
{modifiedTime=2020-05-09 14:40:34.0, parentName=商品管理, name=类目管理, createdTime=2020-05-09 14:40:34.0, permission=goods:category:view, id=148, sort=23, type=1, url=category/category_list, parentId=146}