一张表的自关联存储,后台一次性查询出所有数据,再进行组装
public List<CpLbTreeDto> treeList() {
List<CpLbTreeDto> cpLbTreeDtoList = cpLbDao.treeList();
return buildTree(cpLbTreeDtoList);
}
private List<CpLbTreeDto> buildTree(List<CpLbTreeDto> list) {
if (!CollectionUtils.isEmpty(list)) {
Map<String, CpLbTreeDto> treeDtoTempMap = new LinkedHashMap<>(list.size());
for (CpLbTreeDto menu : list) {
treeDtoTempMap.put(menu.getCode(), menu);
}
CpLbTreeDto root = new CpLbTreeDto();
root.setName("root");
for (CpLbTreeDto treeDto : treeDtoTempMap.values()) {
if (Objects.equals("1", treeDto.getClassLevel())
|| treeDto.getCode().equals(treeDto.getParentCode())
|| treeDto.getCode().equals(treeDto.getTopCode())) {
List<CpLbTreeDto> rootChildren = root.getChildren();
if (rootChildren == null) {
rootChildren = new ArrayList<>();
}
rootChildren.add(treeDto);
root.setChildren(rootChildren);
} else {
CpLbTreeDto cpLbTreeDtoParent = treeDtoTempMap.get(treeDto.getParentCode());
List<CpLbTreeDto> parentChildren = cpLbTreeDtoParent.getChildren();
if (parentChildren == null) {
parentChildren = new ArrayList<>();
}
parentChildren.add(treeDto);
cpLbTreeDtoParent.setChildren(parentChildren);
}
}
return root.getChildren();
}
return null;
}