java 去除jsonarray里面jsonarray的重复和合并数据

最新推荐文章于 2024-09-20 10:00:57 发布

高尔夫golf

最新推荐文章于 2024-09-20 10:00:57 发布

阅读量2.4w

点赞数 2

分类专栏： Java开发

本文链接：https://blog.csdn.net/konglongaa/article/details/51821493

版权

Java开发专栏收录该内容

259 篇文章 1 订阅

订阅专栏

原来数据如下：

[{"index_id":"19557485","itemid":"70575","time":"1467619020","value":"1"},

{"index_id":"19557442","itemid":"113795","time":"1467619020","value":"1"},

{"index_id":"19557507","itemid":"114227","time":"1467619020","value":"1"},

{"index_id":"19557534","itemid":"114231","time":"1467619020","value":"1"},

{"index_id":"19557534","itemid":"114233","time":"1467619020","value":"1"},

{"index_id":"19557534","itemid":"114237","time":"1467619020","value":"1"},

{"index_id":"19557534","itemid":"114239","time":"1467619020","value":"1"},

{"index_id":"19557593","itemid":"114241","time":"1467619020","value":"1"},

{"index_id":"20118932","itemid":"115778","time":"1467619020","value":"1"},

{"index_id":"11111111","itemid":"222222","time":"1467619020","value":"1"},

{"index_id":"11111111","itemid":"333333","time":"1467619020","value":"1"},

{"index_id":"11111111","itemid":"444444","time":"1467619020","value":"1"},

{"index_id":"11111111","itemid":"555555","time":"1467619020","value":"1"},

{"index_id":"11111111","itemid":"666666","time":"1467619020","value":"1"},

{"index_id":"11111111","itemid":"777777","time":"1467619020","value":"1"},

{"index_id":"19557534","itemid":"1145235","time":"1467619020","value":"1"}]

现在要求合并相同index_id的value值，其实array和list类似，如果遇到list也可用我的方法，新建一个新的arraytemp临时存储json

代码如下：

/**
* 去重复index_id项合并value值
* @param args
*/
public static JSONArray delRepeatIndexid(JSONArray array) {

JSONArray arrayTemp = new JSONArray();

int num = 0;
for(int i = 0;i < array.size();i++){
if(num==0){
arrayTemp.add(array.get(i));
}else{
int numJ = 0;
for(int j = 0;j < arrayTemp.size(); j++){
JSONObject newJsonObjectI = (JSONObject)array.get(i);
JSONObject newJsonObjectJ = (JSONObject)arrayTemp.get(j);
String index_idI = newJsonObjectI.get("index_id").toString();
String valueI = newJsonObjectI.get("value").toString();
String timeI = newJsonObjectI.get("time").toString();
String itemidI = newJsonObjectI.get("itemid").toString();

String index_idJ = newJsonObjectJ.get("index_id").toString();
String valueJ = newJsonObjectJ.get("value").toString();

if(index_idI.equals(index_idJ)){
int newValue = Integer.parseInt(valueI) + Integer.parseInt(valueJ);
arrayTemp.remove(j);
JSONObject newObject = new JSONObject();
newObject.put("index_id", index_idI);
newObject.put("itemid", itemidI);
newObject.put("time", timeI);
newObject.put("value", newValue);
arrayTemp.add(newObject);
break;
}
numJ++;
}
if(numJ-1 == arrayTemp.size()-1){
arrayTemp.add(array.get(i));
}
}

num++;
}
return arrayTemp;
}

输出结果如下：

{"clientip":"10.50.129.11","hostname":"IQSH-D9396","index_gather":[{"hashkey":"","index_id":19557485,"msg_hashkey":"","sourcehost":"","time":1467617940,"type":0,"value":1},{"hashkey":"","index_id":19557442,"msg_hashkey":"","sourcehost":"","time":1467617940,"type":0,"value":1},{"hashkey":"","index_id":19557507,"msg_hashkey":"","sourcehost":"","time":1467617940,"type":0,"value":1},{"hashkey":"","index_id":19557593,"msg_hashkey":"","sourcehost":"","time":1467617940,"type":0,"value":1},{"hashkey":"","index_id":20118932,"msg_hashkey":"","sourcehost":"","time":1467617940,"type":0,"value":1},{"hashkey":"","index_id":11111111,"msg_hashkey":"","sourcehost":"","time":1467617940,"type":0,"value":6},{"hashkey":"","index_id":19557534,"msg_hashkey":"","sourcehost":"","time":1467617940,"type":0,"value":5}]}