public List> treeWhile(String goodsTypeId){
List> list = jdbcTemplate.queryForList("select goodsTypeId ,typeName from PS_GoodsType where fatherId = " + goodsTypeId);
List> tree = new ArrayList>();
if(list.size()>0){
for(Map map : list){
Map treeMap = new HashMap();
treeMap.put("id", map.get("goodsTypeId"));
treeMap.put("text", map.get("typeName"));
List> children = treeWhile(map.get("goodsTypeId").toString());
treeMap.put("children", children);
tree.add(treeMap);
}
}
return tree;
}
需要有一个 fatherId 字段来记录他的父节点是谁
goodsTypeId 是我查询的那张表的ID