树状结构展示(前后端vue+springboot版)

(springboot后端操作)

递归查询数据库中的表数据

 定义实体类

public class Daqimportsys extends baseEntity
{
    private static final long serialVersionUID = 1L;

    
    private Integer id;

    
    private String importsysId;

    
    @Excel(name = "信息名称")
    private String importsysName;

    
    private String importsysZid;

    
    @Excel(name = "责任部门")
    private String importsysBranch;

    
    @Excel(name = "状态")
    private String importsysState;

    
    @Excel(name = "备注")
    private String importsysRemark;

    private List children = new ArrayList<>();

    public List getChildren() {
        return children;
    }

    public void setChildren(List children) {
        this.children = children;
    }

controller 到 service 到 接口实现类（controller和service自己脑补）

@Override
    public List getAllDepartments() {
        List parentId = daqimportsysMapper.getAllDepartmentsByParentId(0);
        return parentId;
    }

mapper.xml中的sql语句和resultmap的编写

        
        
        
        
        
        
        
    

    
        
    

    
        select * from daq_importsys where importsys_zid = #{fid};
    

(vue前端代码)

     vue文件