vue框架 element导航菜单el-submenu 简单使用方法--以侧边栏举例

1、目标

实现动态增删菜单栏的效果，所以要在数据库中建表

2 、建表

2.1、表样式

2.2、表数据

3、实体类

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.util.List;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class PcMenu {
    private Integer id;
    private String name;//菜单名称
    private Integer parentId;//父级
    private String link;//前端链接
    private Integer status;//1:正常 0：禁用
    private String icon;//图标
    private List<PcMenu> childrenMenu;//子菜单
}

4、sql语句

 <select id="queryUserMenu" resultType="com.woniu.pc.entity.PcMenu">
    SELECT id, name, link, parentid, icon
    FROM t_pc_menu
</select>

5 、前端

<template>
  <el-container style="height: 100%" bcak>
    <el-header height="100px" style="background-color: cadetblue"> Header </el-header>
    <el-container>
      <el-aside width="200px" style="background-color: rgb(84, 92, 100)">
        <el-menu
          router
          class="el-menu-vertical-demo"
          background-color="#545c64"
          text-color="#fff"
          active-text-color="#ffd04b">
          <!-- 一级菜单循环体是el-submenu 二级菜单循环体是el-menu-item -->
          <!-- index  key 必须要转成字符串，不然控制台会报错-->
          <el-submenu :index="menu.id+''" v-for="menu in menuList" :key="menu.id">
            <template slot="title">
              <i :class="menu.icon"></i>
              <span>{{ menu.name }}</span>
            </template>
            <el-menu-item :index="c.link" v-for="c in menu.childrenMenu" :key="c.id+''">
              {{ c.name }}
            </el-menu-item>
          </el-submenu>
        </el-menu>
      </el-aside>
      <el-main style="background-color: rgb(255, 255, 255)">
        <router-view></router-view>
      </el-main>
    </el-container>
  </el-container>
</template>

<script>
  export default {
    data() {
      return {
        menuList: [],
      };
    },
    methods: {
      //查询用户拥有的菜单
      queryUserMenu() {
        this.$axios.get("api/employee/queryUserMenu").then((res) => {
          console.log(res.data);
          if (res.data.code == 200) {
            this.menuList = res.data.data;
          }
        });
      },
    },
    created() {
      this.queryUserMenu();
    },
  };
</script>

<style scope></style>

6、后端

    
    public ResponseDate<?> queryMenuByAdmin() {

        List<PcMenu> menuList = pcAdminMapper.queryMenuByAdmin();
        // 循环找出所有父菜单
        List<PcMenu> parentMenu = getMenus(menuList);
        return new ResponseDate<>().ok(parentMenu);

    }

    // 组织菜单 
    private List<PcMenu> getMenus(List<PcMenu> menuList) {
		// 循环找出所有的父菜单
        List<PcMenu> parentMenu = menuList.stream().filter(menu -> menu.getParentId() == null).collect(Collectors.toList());

        for (PcMenu m : parentMenu) {
            List<PcMenu> children = new ArrayList<>();
            for (PcMenu mm : menuList) {
                if (m.getId().equals(mm.getParentId())) {
                    children.add(mm);
                }
            }
            m.setChildrenMenu(children);
        }
        return parentMenu;
    }