项目中需要递归查询,简单的写了一个,记录一下。
具体查询sql就不贴出来了,每个业务都不一样,但是都差不多,基本上都是根据父类搜索下面的子类。
public Result selectMarketingLbl() {
Result result = new Result();
List<Map<String, Object>> list = DAO.selectByBaseId("01");// 查询子类sql
list = getDate(list);
result.setBeans(list);
return result;
}
private List<Map<String, Object>> getDate( List<Map<String, Object>> list){
for (Map<String, Object> map: list){
List<Map<String, Object>> childList =
DAO.selectByBaseId((String)map.get("Id"));// 查询子类sql
if (childList != null && !childList.isEmpty()){
getDate(childList);
}
map.put("children", childList);
}
return list;
}
转载请注明出处,谢谢!https://blog.youkuaiyun.com/wanglc7/article/details/81017027