1.首先,了解我们的需求,需要展示的格式是:
然后了解我们的数据库结构
数据库中顶级节点的父节点为空,即PARENTORGID为空,其余的节点的PARENTORGID都为父亲节点的id
2.下面开始进行后台编码实现
方法为,首先再数据库中查询出所有组织结构的数据,数据格式为List<Map<String,Object>>形式,首先遍历,将顶级节点的数据设置好,然后再以顶级节点的id,数据库查询出的数据,为参数,递归查询子节点,实现代码如下
最后返回给前端的数据,为json串的形式,方便前端ESAYUi的combotree的树形数据展现
@RequestMapping("/load/department")
@ResponseBody
public String department(Model model) {
List<Map<String, Object>> listmap = imsCompanyProjectService.orgList();
List<Map<String, Object>> returnList = new ArrayList<Map<String, Object>>();
for (Map<String, Object> dataMap : listmap) {
Map<String, Object> mapArr = new HashMap<String, Object>(16);
if (dataMap.get("PARENTORGID") == null) {
mapArr.put("id", dataMap.get("ID"));
mapArr.put("text", dataMap.get("NAME"));
mapArr.put("code", dataMap.get("CODE"));
mapArr.put("data", dataMap.get("NAME"));
mapArr.put("children", menuChild((String) dataMap.get("ID"), listmap));
returnList.add(mapArr);
}
}
net.sf.json.JSONArray json = net.sf.json.JSONArray.fromObject(returnList);
return json.toString();
}
/**
* 递归获取孩子节点
* @param id
* @param listmap
* @return
*/
private List<Map<String, Object>> menuChild(String id, List<Map<String, Object>> listmap) {
List<Map<String, Object>> lists = new ArrayList<Map<String, Object>>();
for (Map<String, Object> dataMap2 : listmap) {
Map<String, Object> childArray = new HashMap<String, Object>(16);
if (id.equals(dataMap2.get("PARENTORGID"))) {
childArray.put("id", dataMap2.get("ID"));
childArray.put("text", dataMap2.get("NAME"));
childArray.put("code", dataMap2.get("CODE"));
childArray.put("data", dataMap2.get("NAME"));
childArray.put("children", menuChild((String) dataMap2.get("ID"), listmap));
lists.add(childArray);
}
}
return lists;
}