递归加载菜单树

时间:2022-06-01 12:46:17

1.创建数据库表

create table system_resource
(
    id                   bigint(11)   not null primary key auto_increment comment id,
    resource_name        varchar(20)  not null comment 资源名称,
    resource_name_cn varchar(20) not null comment 资源中文名,
    resource_parent_name varchar(20)  null comment 父级资源名称,
    resource_url         varchar(100) null comment 资源路径,
    resource_icon varchar(100) comment 资源图标,
    create_time          timestamp    not null default 0000-00-00 00:00:00 comment 创建时间,
    update_time          timestamp    not null default current_timestamp on update current_timestamp comment 修改时间
) charset = utf8mb4 comment 角色资源表;
create trigger resource_insert
    before insert
    on system_resource
    for each row set new.create_time = now();

插入测试数据:

递归加载菜单树

 

 然后java代码加载菜单树:

新建一个菜单的bean对象,用来存放加载出来的菜单:

package com.whx.gxrsms.bean;

import lombok.Data;
import lombok.experimental.Accessors;

import java.io.Serializable;
import java.util.List;

/**
 * @author ZhaoShuai
 * @company lihfinance.com
 * @date Create in 2020/3/3
 **/
@Data
@Accessors(chain = true)
public class MenuTree implements Serializable {

    private static final long serialVersionUID = 1L;

    private Long id;

    private String name;

    private String title;

    private String icon;

    private String href;

    private List<MenuTree> list;
}

使用mybatis和通用mapper来写dao层,这一块就不写出来了,直接写主要方法:

@Override
    public List<MenuTree> getMenuTree() {
        /*加载出所有的菜单*/
        List<SystemResource> resources = resourceMapper.select(new SystemResource());
        /*筛选出所有的第一级菜单*/
        List<MenuTree> menuTrees = resources.parallelStream().filter(r -> StringUtils.isEmpty(r.getResourceParentName()))
                .map(this::convertResource)
                .collect(Collectors.toList());
        /*加载出所有的子菜单*/
        List<SystemResource> childResource = resources.parallelStream()
                .filter(f -> !StringUtils.isEmpty(f.getResourceParentName()))
                .collect(Collectors.toList());
        /*生成菜单树*/
        menuTrees = menuTrees.parallelStream().map(m -> recursiveMenu(m, childResource)).collect(Collectors.toList());

        return menuTrees;
    }
    /**
     * @company lihfinance.com
     * @author create by ZhaoShuai in 2020/3/3
     *  递归生成菜单树
     * @param menuTree, resources
     * @return com.whx.gxrsms.bean.MenuTree
     **/
    private MenuTree recursiveMenu(MenuTree menuTree, List<SystemResource> resources) {
        List<MenuTree> childMenu = resources.parallelStream()
                .filter(r -> menuTree.getName().equals(r.getResourceParentName()))
                .map(this::convertResource).collect(Collectors.toList());
        if (!childMenu.isEmpty()) {
            childMenu = childMenu.parallelStream().map(m -> recursiveMenu(m, resources)).collect(Collectors.toList());
        }
        menuTree.setList(childMenu);
        return menuTree;
    }

    /**
     * @company lihfinance.com
     * @author create by ZhaoShuai in 2020/3/3
     *  将资源转换为菜单类
     * @param
     * @return
     **/
    private MenuTree convertResource(SystemResource resource) {
        MenuTree tree = new MenuTree();
        tree.setId(resource.getId());
        tree.setName(resource.getResourceName());
        tree.setTitle(resource.getResourceNameCn());
        tree.setHref(resource.getResourceUrl());
        tree.setIcon(resource.getResourceIcon());
        return tree;
    }

然后配置controller,访问调用该方法:

 @RequestMapping("/getMenuTree")
    @ResponseBody
    public Result getMenuTree() {
        Result result = Result.success();

        List<MenuTree> menuTrees = loginService.getMenuTree();
        result.setData(menuTrees);
        return result;
    }

页面展示结果为:

{"code":200,"msg":"操作成功","data":[{"id":1,"name":"system.manager","title":"系统管理","icon":"aaa","href":null,"list":[{"id":2,"name":"save.resource","title":"添加资源","icon":"bbb","href":"/gxrsms/resource.html","list":[]},{"id":3,"name":"role.manager","title":"角色管理","icon":null,"href":null,"list":[{"id":5,"name":"role.add","title":"添加角色","icon":"","href":"/gxrsms/role/insert","list":[]}]},{"id":4,"name":"user.manager","title":"用户管理","icon":null,"href":null,"list":[{"id":6,"name":"user.add","title":"添加用户","icon":"","href":"/gxrsms/user/insert","list":[]}]}]},{"id":7,"name":"dept.manager","title":"部门管理","icon":"ccc","href":null,"list":[{"id":8,"name":"dept.add","title":"添加部门","icon":"","href":"/gxrsms/dept/insert","list":[]}]}]}

这就是我们要加载的菜单树了,json格式化后可以清楚的看出层级结构。