准备工作：json字符串
[{
"id": 1,
"code": "FLOW_NODE_1",
"name": "环节A",
"children": [{
"id": 2,
"code": "RULE_NODE_1",
"name": "规则A"
}, {
"id": 3,
"code": "RULE_NODE_2",
"name": "规则B"
}, {
"id": 4,
"code": "PARALLEL_NODE_2",
"name": "并行节点",
"children": [{
"id": 5,
"code": "RULE_NODE_3",
"name": "规则C1"
}, {
"id": 6,
"code": "RULE_COLLECTION_1",
"name": "规则集1",
"children": [{
"id": 7,
"code": "RULE_NODE_4",
"name": "规则C21"
}, {
"id": 8,
"code": "RULE_NODE_5",
"name": "规则C22"
}]
}]
}, {
"id": 9,
"code": "MUTUAL_NODE_1",
"name": "互斥节点",
"children": [{
"id": 10,
"code": "RULE_NODE_6",
"name": "规则D1"
}, {
"id": 11,
"code": "RULE_NODE_7",
"name": "规则D2"
}]
}]
}, {
"id": 12,
"code": "FLOW_NODE_2",
"name": "环节B"
}]
这里使用的springboot下FastJson下的API使用例子：
步骤一：加入依赖
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>${fastjson.version}</version>
</dependency>
步骤二：
parse方法的使用：例如把JSON文本parse为JSONObject或者JSONArray
更多参考：https://www.cnblogs.com/sunp823/p/5601399.html
1.根据json树treeId查找json并返回给前端：
controller：
/**
* @param treeId
* @return
*/
@ApiOperation(value="查询树信息", notes="查询树信息")
@RequestMapping(value = "/api/v1/orders/findTree" ,method = RequestMethod.POST)
public Map findTree(@ApiParam(required = true, value = "树id") @RequestParam Integer treeId
){
return ActionHelper.responseOk(categoryTreeService.getJsonTree(treeId));
}
service：
//根据id获取json树
public JSONArray getJsonTree(Integer treeId){
JSONArray jsonTree = JSONArray.parseArray(categoryTreeRepository.selectJsonTree(treeId));
return jsonTree;
}
2.查找指定treeId的json树下对应的key-value的节点信息
controller：
/**
* @param treeId 树id
* @param key key名称
* @param value value值
* @return
*/
@ApiOperation(value="查询节点信息", notes="查询节点信息")
@RequestMapping(value = "/api/v1/orders/findNode" ,method = RequestMethod.POST)
public Map findNode(@ApiParam(required = true, value = "树id") @RequestParam Integer treeId,
@ApiParam(required = true, value = "节点key") @RequestParam String key,
@ApiParam(required = true, value = "节点value") @RequestParam String value
){
return ActionHelper.responseOk(categoryTreeService.getNode(treeId,key,value));
}
service：
//根据节点key-value键值对，获取树下该节点信息
public JSONObject getNode(Integer treeId,String key,String value){
JSONArray jsonTree = JSONArray.parseArray(categoryTreeRepository.selectJsonTree(treeId));
JSONObject node = getNode(jsonTree, key, value,new JSONObject());
return node;
} /**
* 根据单一条件获取节点位置
* @param body 查询目标的主体内容
* @param key 筛选匹配条件条件对应--key
* @param value 筛选匹配条件对应--value
* @param result 缓存查询结果
* @return
*/
public static JSONObject getNode(JSONArray body,String key,Object value,JSONObject result) {
for (int i = 0; i < body.size(); i++) {
JSONObject jsonObject =body.getJSONObject(i);
if (jsonObject.get(key).toString().equals(value.toString())) {
for (Map.Entry<String, Object> entry : jsonObject.entrySet()) {
result.put(entry.getKey(), entry.getValue());
}
}else if(jsonObject.getJSONArray("children")!=null) {
getNode(jsonObject.getJSONArray("children"), key, value,result);
}
}
return result;
}
3.删除指定treeId下的指定key-value的节点
controller:
@ApiOperation(value="删除节点信息", notes="删除节点信息")
@RequestMapping(value = "/api/v1/orders/deldNode" ,method = RequestMethod.POST)
public Map delNode(@ApiParam(required = true, value = "树id") @RequestParam Integer treeId,
@ApiParam(required = true, value = "节点key") @RequestParam String key,
@ApiParam(required = true, value = "节点value") @RequestParam String value
){
return ActionHelper.responseOk(categoryTreeService.delNode(treeId,key,value));
}
service:
//删除json树下指定的节点及其子节点
public JSONObject delNode(Integer treeId,String key,String value){
JSONArray jsonTree = JSONArray.parseArray(categoryTreeRepository.selectJsonTree(treeId));
JSONObject node = getNode(jsonTree, key, value,new JSONObject());
delNode(jsonTree, key, value);
String a=jsonTree.toString();
categoryTreeRepository.updateTree(a,treeId);
return node;
} /**
* 根据单一条件删除节点
* @param body 需要删除的目标主体
* @param key 筛选匹配条件对应的key
* @param value 筛选匹配条件对应的value
*/
public void delNode(JSONArray body,String key,Object value) {
for (int i = 0; i < body.size(); i++) {
JSONObject jsonObject =body.getJSONObject(i);
if (jsonObject.get(key).toString().equals(value.toString())) {
Object obj= body.remove(i);
break;
}else if(jsonObject.getJSONArray("children")!=null) {
delNode(jsonObject.getJSONArray("children"), key, value);
}
} }
mapper:
public interface CategoryTreeRepository extends JpaRepository<CategoryTree,String>, JpaSpecificationExecutor<CategoryTree> {
//根据id获取json树字符串
@Query(value="SELECT jsonTree from catagory_tree where id=?1",nativeQuery=true)
String selectJsonTree(Integer id);
@Modifying
@Transactional
@Query(value="UPDATE catagory_tree SET jsonTree = ?1 WHERE id = ?2",nativeQuery = true)
void updateTree(String jsonTreeStr,Integer id);
}
4.在指定的key-value键值对节点下面添加节点，
目的：children的value为JsonArray格式,在此属性下添加JsonObject节点
依旧走步骤2判断节点是否存在，若存在则：
1.判断此节点下是否存在key为children的属性：
2.如果此节点存在key为children的属性，则在children下指定下标添加节点
3.如果不存在key为children的属性，则添加children，新节点存进children
controller:
@ApiOperation(value="新建节点", notes="根据输入参数创建节点")
@RequestMapping(value = "/tree_data/node/{treeId}", method = RequestMethod.POST)
public Map addOne(@ApiParam(required = true, value = "分类树ID")@PathVariable Integer treeId,
@ApiParam(required = true, value = "节点key") @RequestParam String key,
@ApiParam(required = true, value = "节点value") @RequestParam String value,
@ApiParam(required = true, value = "插入下标") @RequestParam Integer index,
@ApiParam(required = true, value = "节点信息") @RequestBody Map map){
return ActionHelper.responseOk(categoryTreeService.addNode(treeId,key,value,index,map));
}
service:
//在json树下添加节点：
public JSONArray addNode(Integer treeId,String key,Object value,Integer sequ,Map newNodeMap){
JSONArray jsonTree = JSONArray.parseArray(categoryTreeRepository.selectJsonTree(treeId));
Integer nodeId = (Integer)newNodeMap.get("id");
JSONObject node = getNode(jsonTree, "id", nodeId,new JSONObject());
System.out.println(node);
if(!node.isEmpty()){
throw new BadRequestException("此id的节点已存在");
}
//把map转化为JSONObject
JSONObject newNode = new JSONObject(newNodeMap);
addNode(jsonTree,key,value,sequ, newNode);
return jsonTree;
} /**
* 增加节点
* @param jsonArray 需要更新的目标主体
* @param node 增加节点信息
* @param sequ 数组的位置
* @param key 目标主体中的字段名key
* @param value 节点信息与key对应的value
*/
public void addNode(JSONArray jsonArray, String key, Object value, Integer sequ,JSONObject node) {
for (Object obj : jsonArray) {
JSONObject jsonObject = (JSONObject) obj;
JSONArray children = jsonObject.getJSONArray("children");
if (children != null) {
if (value.toString().equals(jsonObject.get(key).toString())) {
if(sequ > children.size()){
//如果下标大于此节点children的长度，则追加
children.add(children.size(), node);
}else{
//在指定位置增加
children.add(sequ-1, node);
}
return;
}
addNode(children,key,value,sequ,node);
} else {
//直接判断是否要在此节点下增加个名为children键值对
if (value.toString().equals(jsonObject.get(key).toString())) {
JSONArray array = new JSONArray();
array.add(node);
jsonObject.put("children", array);
return;
}
}
}
}
5.根据节点id更改节点属性：
涉及API：jsonObject.put(key,value)
依旧先走步骤2查询节点是否存在，若存在则更改属性：
如果更改的属性存在，则覆盖
如果更改的属性不存在，则追加
controller：
@ApiOperation(value="更新节点信息", notes="更新节点信息")
@RequestMapping(value = "/tree_data/node/{treeId}/{id}", method = RequestMethod.PATCH)
public Map updateOne(@ApiParam(required = true, value = "分类树ID")@PathVariable Integer treeId,
@ApiParam(required = true, value = "节点ID")@PathVariable Integer id,
@ApiParam(required = true, value = "节点信息") @RequestBody Map map){
return ActionHelper.responseOk(categoryTreeService.updateNode(treeId,id,map));
}
service:
/**
* 修改单个节点
* @param treeId
* @param nodeId
* @param map
* @return
*/
@Transactional
public JSON updateNode(Integer treeId, Integer nodeId, Map map) {
JSONArray jsonTree = JSONArray.parseArray(categoryTreeRepository.selectJsonTree(treeId));
//查询节点是否存在
if(!getNode(jsonTree, "id", nodeId,new JSONObject()).isEmpty()){
update(jsonTree, "id", nodeId, map);
//更新数据库
String a=jsonTree.toString();
categoryTreeRepository.updateTree(a,treeId);
}else{
throw new BadRequestException("此id的节点不存在");
}
return jsonTree; } /**
* 根据条件更新节点
* @param jsonArray 需要更新的目标主体
* @param key 目标主体中的字段名key
* @param value 更新节点信息与key对应的value
* @param map 更新节点信息
*/
public void update(JSONArray jsonArray, String key, Object value, Map<String,Object> map) {
for (int i = 0; i < jsonArray.size() ; i++) {
JSONObject json=jsonArray.getJSONObject(i);
if(value.toString().equals(json.get(key).toString())){
for (Map.Entry<String,Object> entry : map.entrySet()) {
json.put(entry.getKey(),entry.getValue());
}
break;
}else if(json.getJSONArray("children")!=null) {
update(json.getJSONArray("children"), key, value,map);
}
}
}