Java递归查询树形结构（导航菜单目录）

树形结构

1. 数据库表 admin_menu
   

2. dao层sql

@Mapper
@Repository
public interface MenuMapper extends BaseMapper<AdminMenu> {

    @Select({"select * from admin_menu where fid=#{fid}"})
    List<AdminMenu> findByfid(@Param("fid") int fid);
}

3. 创建实体类

package com.example.diandujava.entity.DataBase;

import java.util.List;

/**
 * 菜单
 */
public class AdminMenu {

  private long id;
  private String title;
  private long fid;
  private String url;
  private long auth;
  private long sort;
  private long show;
  private String icon;
  private long level;
  private String component;
  private String router;
  //加一个放子级的
  private  List<AdminMenu> children;
//get set 省略

}

4. 定义service层

/**
     * 查询所有菜单
     * @return 所有菜单
     */
    public ReturnMsg findMenus(){

        ReturnMsg msg = new ReturnMsg();
        try {
            List<AdminMenu> menus= getMenusList(0);
            msg.setMsg("查询成功");
            msg.setData(menus);
            msg.setCode(1);
        }catch (Exception e) {
            msg.setMsg("查询失败");
            msg.setCode(0);
        }
        return msg;

    }

    /**
     * 递归查询菜单
     * @param fid 父级ID
     * @return
     */
    private List<AdminMenu> getMenusList(Integer fid){

        //根据传入ID查出
        List<AdminMenu> menus = menuMapper.findByfid(fid);

        AdminMenu menu1 =new AdminMenu();
        for (int i = 0; i < menus.size(); i++) {
            menu1.setId(menus.get(i).getId());
            Integer id=Integer.parseInt(String.valueOf(menu1.getId()));
            List<AdminMenu>dtos=getMenusList(id);
            menus.get(i).setChildren(dtos);
        }

        return menus;
    }

5. controller层实现

	@GetMapping("/index")
    public ReturnMsg findmenu(){return menuService.findMenus();}

6. postman测试