使用过fastjson的同胞我们都知道fastjson内部的方法只支持解析单层json,比如这些数据:
jsonObject类型的:{"generalWorker":2,"skillWorker":3}
jsonarray类型的:
[{"id":"zjqf001","projectId":"1","workType":"3"},{"id":"zjqf002","projectId":"1","workType":"3"},{"id":"zjqf003","projectId":"1","workType":"3"}]
但如果遇到这种类型的呢:
{
"generalWorker ":[{ "id ": "zjqf001 ", "projectId ": "1 ", "workType ": "3 "},{ "id ": "zjqf002 ", "projectId ": "1 ", "workType ": "3 "}],
"projectMember ":[{ "displayOrdinal ":0, "gender ":0, "idCardNumber ": "123 ", "idCardType ": "身份证 "},{ "displayOrdinal ":0, "gender ":1, "idCardNumber ": "456 ", "idCardType ": "居住证 "}],
"skilledWorker ":[{ "cardNumber ": "WL ", "cardStatus ": "9 ", "empno ": "003 "},{ "cardNumber ": "ER ", "cardStatus ": "7 ", "empno ": "004 "}]
}
可能有些小伙伴会想到fastjson的这种用法:
List<Map<String, Object>> mapList = JSON.parseObject(str, new TypeReference<List<Map<String, Object>>>() {});
抛出异常:
Exception in thread "main" com.alibaba.fastjson.JSONException: exepct '[', but {, pos 1, json : {"generalWorker":[{"id":"zjqf001"...略
又或者这种方法:
new ObjectMapper().readValue()
抛出异常:JSON deserialization throwing exception - Can not deserialize instance of java.util.ArrayList out of START_OBJECT token
原因是需要一个包装器去包装,可以用pojo封装,但是自己的需求是不知道传过来的是什么,所以不适合自己
划重点
解析json 动态遍历未知key与value,最终返回形式为List<List<Map<String,Object>>>类型(当然,根据业务需求,你也可以得到Map<String,List<Map<String,Object>>>类型,需自己修改代码)
重点方法:
JSONArray jsonArray = (JSONArray)jsonObject.getJSONArray("xxx");
思路就是动态将json里面的根节点全部取出来,然后在一个一个转成jsonarray
代码如下:(仔细看注释)
public static void main(String[] args) {
//模拟数据
String str = "{
\"generalWorker\":[{\"id\":\"zjqf001\",\"projectId\":\"1\",\"workType\":\"3\"},{\"id\":\"zjqf002\",\"projectId\":\"1\",\"workType\":\"3\"},{\"id\":\"zjqf003\",\"projectId\":\"1\",\"workType\":\"3\"},{\"id\":\"zjqf004\",\"projectId\":\"1\",\"workType\":\"3\"}],
\"projectMember\":[{\"displayOrdinal\":0,\"gender\":0,\"idCardNumber\":\"123\",\"idCardType\":\"身份证\"},{\"displayOrdinal\":0,\"gender\":1,\"idCardNumber\":\"456\",\"idCardType\":\"居住证\"},{\"displayOrdinal\":0,\"gender\":0,\"idCardNumber\":\"789\",\"idCardType\":\"健康证\"}],
\"skilledWorker\":[{\"cardNumber\":\"WL\",\"cardStatus\":\"9\",\"empno\":\"003\"},{\"cardNumber\":\"ER\",\"cardStatus\":\"7\",\"empno\":\"004\"},{\"cardNumber\":\"FG\",\"cardStatus\":\"8\",\"empno\":\"005\"}]}";
//String str = "{\"generalWorker\":2,\"skillWorker\":3}";
List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
JSONObject jsonObject = JSON.parseObject(str);
//判读是否符合数据格式
if(str.indexOf("[") == -1){
Map<String,Object> newMap = jsonObject;
list.add(newMap);
}else{
//将[]内容替换成A,模拟成数据格式为:{"generalWorker":"A","projectMember":"A","skilledWorker":"A"}
int count = 0;
int num = 0;
while(count != -1 && num!=-1){
count = str.indexOf("[",count+1);
num = str.indexOf("]",count+1);
if(count !=-1 && num!=-1){
str = str.replace(str.substring(count,num+1),"\"A\"");
}
}
HashMap<String, Object> map = new HashMap<>();
HashMap dataMap = JSON.parseObject(str, HashMap.class);
//dataMap={"generalWorker":"A","projectMember":"A","skilledWorker":"A"}
for (Object obj : dataMap.keySet()){//遍历json的根节点
//转成jsonArray
JSONArray jsonArray = (JSONArray)jsonObject.getJSONArray(obj.toString());
map.put(obj.toString(),jsonArray);
}
list.add(map);
}
System.out.println(list);
}
输出结果:
[{
generalWorker=[{"workType":"3","id":"zjqf001","projectId":"1"},{"workType":"3","id":"zjqf002","projectId":"1"},{"workType":"3","id":"zjqf003","projectId":"1"},{"workType":"3","id":"zjqf004","projectId":"1"}],
projectMember=[{"idCardType":"身份证","displayOrdinal":0,"gender":0,"idCardNumber":"123"},{"idCardType":"居住证","displayOrdinal":0,"gender":1,"idCardNumber":"456"},{"idCardType":"健康证","displayOrdinal":0,"gender":0,"idCardNumber":"789"}],
skilledWorker=[{"empno":"003","cardNumber":"WL","cardStatus":"9"},{"empno":"004","cardNumber":"ER","cardStatus":"7"},{"empno":"005","cardNumber":"FG","cardStatus":"8"}]
}]
主要就是动态获取其根节点,然后一个一个转