先说一下遇到的问题,表里面存在脏数据,除了有根节点外,还有许多除了根节点外找到不父节点从而和根节点同级的数据,所以在查询显示数据的时候,发现这不是自己想要的那棵树。以下是主要代码,前台使用ztree实现树,后台传list集合到前台。
private List<Map<String, Object>> result = new ArrayList();
private List deviceclasslist = new ArrayList();
//主方法中先查root根节点
List<Map<String, Object>> rootList = jdbcTemplate.queryForList("SELECT \"ID\", \"NAME\", PARENTID FROM DEVICE WHERE PARENTID = 'NULL'");
for(Map<String, Object> map : rootList){
result.add(map);
reback(map, result);
}
//执行到此处的result就是需要的值
//下面将得到的result结果集,筛选出想要的数据,放到集合中供给前台使用
for(int i = 0; i<result.size();i++){
Map<String,Object> map = new HashMap<String, Object>();
String Id = String.valueOf(result.get(i).get("id"));
String name = String.valueOf(result.get(i).get("name"));
String pId = String.valueOf(result.get(i).get("parentid"));
map.put("id", Id);
map.put("name", name);
map.put("pId", pId);
String jsonmap = JSON.toJSONString(map);
deviceclasslist.add(jsonmap);
}
reback方法:
/**
* 此为循环体
* 参数1为父List,参数2为结果List
* 返回值为子List
*/
public void reback(Map<String, Object> fatherMap, List<Map<String, Object>> result){
String fatherId = String.valueOf(fatherMap.get("ID"));
List<Map<String, Object>> childList = jdbcTemplate.queryForList("SELECT \"ID\", \"NAME\", \"PARENTID\" FROM DEVICE WHERE PARENTID = '" + fatherId + "' order by depth, parentid, characteristic, indexnum");
for(Map<String, Object> childMap : childList){
result.add(childMap);
reback(childMap, result);
}
}