json格式如下:
json整体目录结构
1:获取result内的数据
String jsonStr = "";
ObjectMapper mapper = new ObjectMapper();
JsonNode node = mapper.readTree(jsonStr );
String resultJson = node.get("result").toString();
JsonNode resultNode = mapper.readTree(resultJson);
System.out.println(resultNode.get("updatetime"));
输出“2016-09-20”
2:获取data内的数据
resultNode.get("data").get(0).get("province");
resultNode.get("data").get(0).get("lsprefix");
resultNode.get("data").get(0).get("carorg");
resultNode.get("data").get(0).get("frameno");
resultNode.get("data").get(0).get("engineno");
输出:
"北京"
"京"
"beijing"
"0"
"100"
3:for循环获取list内的数据
ObjectMapper mapper = new ObjectMapper();
JsonNode node = mapper.readTree(jsonStr);
String resultJson = node.get("result").toString();
JsonNode resultNode = mapper.readTree(resultJson);
String dataJson = resultNode.get("data").toString();
JsonNode dataNode = mapper.readTree(dataJson);
for (int i = 0; i <= 30; i++) {
JsonNode list = dataNode.get(i).get("list");
if (list != null) {
for (int j = 0; j < list.size(); j++) {
Citys c = new Citys();
c.setName(list.get(j).get("city").toString().replaceAll("\"", ""));
c.setCityNum(list.get(j).get("lsnum").toString().replaceAll("\"", ""));
//简称
c.setAbbr(list.get(j).get("lsprefix").toString().replaceAll("\"", ""));
c.setCarorg(list.get(j).get("carorg").toString().replaceAll("\"", ""));
c.setFrameno(list.get(j).get("frameno").toString().replaceAll("\"", ""));
c.setEngineno(list.get(j).get("engineno").toString().replaceAll("\"", ""));
carMapper.insertInfo(c);
}
} else {
System.out.println("应该是直辖市,没有list" + dataNode.get(i).get("province"));
}
}