json如何解析混合數(shù)組對(duì)象到實(shí)體類的list集合里去
一、前言
這次項(xiàng)目中遇到了一個(gè)這樣的需求,把下面數(shù)據(jù)解析到我下面的對(duì)象里去。
json 文件
[
{
"categories": [
"美食,小吃快餐"
],
"coordinate": {
"address": "王府井大街138號(hào)新東安廣場(chǎng)3層328",
"area": "東安市場(chǎng)",
"area_id": "jk238eewf0k",
"city": "北京市",
"city_code": "110100",
"district": "東城區(qū)",
"district_code": "110101",
"floor": "3",
"latitude": "39.91456",
"longitude": "116.41155",
"province": "北京市",
"province_code": "110000"
},
"name": "探魚(yú)",
"phone": "010-65280328",
"poi_id": "d7s8f6s6212"
},
{
"categories": [
"美食,面包甜點(diǎn)"
],
"coordinate": {
"address": "豐臺(tái)北路18號(hào)院恒泰廣場(chǎng)F6樓",
"area": "恒泰廣場(chǎng)",
"area_id": "ji8sgg3b32o",
"city": "北京市",
"city_code": "110100",
"district": "豐臺(tái)區(qū)",
"district_code": "110106",
"floor": "6",
"latitude": "39.86608",
"longitude": "116.30516",
"province": "北京市",
"province_code": "110000"
},
"name": "好客來(lái)",
"phone": "010-65280221",
"poi_id": "3g97sg8sd67"
}
]
實(shí)體對(duì)象:
public class LocatorData {
// 分類
private String categories;
// 商圈
private String area;
// 商圈id
private String areaId;
// 省份
private String province;
// 省份code
private String provinceCode;
// 城市
private String city;
// 城市code
private String cityCode;
// 區(qū)縣
private String district;
// 區(qū)縣code
private String districtCode;
// 樓層
private String floor;
// 經(jīng)度
private Double latitude;
// 維度
private Double longitude;
// 店鋪名稱
private String name;
// 店鋪地址
private String address;
// 店鋪電話
private String phone;
// 店鋪id
private String poiId;
}
不知道小伙伴有沒(méi)有發(fā)現(xiàn),我這里只是一個(gè)對(duì)象,沒(méi)有一對(duì)多的關(guān)系哈,要的就是這樣的效果。
但 json 文件里有個(gè) coordinate 對(duì)象,而我實(shí)體對(duì)象不需要這個(gè)字段。那也沒(méi)關(guān)系,一步步解析就完事了。
@RestController
public class ParseController {
private static final Logger LOGGER = LoggerFactory.getLogger(EasyExcelController.class);
@PostMapping(value = "/arrayObjectNestingParse",produces = "application/json;charset=UTF-8")
public ReturnT<String> arrayObjectNestingParse(@RequestParam(value = "jsonFile") MultipartFile jsonFile) {
if (jsonFile == null) {
return new ReturnT<>(ReturnT.BAD_REQUEST, "Params can not be null");
}
InputStream is = null;
BufferedReader br = null;
StringBuffer sb = new StringBuffer();
String str = null;
try {
is = jsonFile.getInputStream();
br = new BufferedReader(new InputStreamReader(is));
while ((str = br.readLine()) != null) {
sb.append(str);
}
} catch (IOException e) {
e.printStackTrace();
} finally {
try {
br.close();
} catch (IOException e) {
e.printStackTrace();
}
}
List<LocatorData> locatorDataList = new ArrayList<>();
JSONArray jsonArray = JSONArray.parseArray(sb.toString());
for (int i = 0; i < jsonArray.size(); i++) {
LocatorData locatorData = new LocatorData();
JSONObject jsonObject = jsonArray.getJSONObject(i);
String categories = jsonObject.getString("categories");
String coordinate = jsonObject.getString("coordinate");
JSONObject coordinateObj = JSONObject.parseObject(coordinate);
String address = coordinateObj.getString("address");
String area = coordinateObj.getString("area");
String areaId = coordinateObj.getString("area_id");
String city = coordinateObj.getString("city");
String cityCode = coordinateObj.getString("city_code");
String district = coordinateObj.getString("district");
String districtCode = coordinateObj.getString("district_code");
String floor = coordinateObj.getString("floor");
String latitude = coordinateObj.getString("latitude");
String longitude = coordinateObj.getString("longitude");
String province = coordinateObj.getString("province");
String provinceCode = coordinateObj.getString("province_code");
String name = jsonObject.getString("name");
String phone = jsonObject.getString("phone");
String poiId = jsonObject.getString("poi_id");
locatorData.setCategories(categories);
locatorData.setAddress(address);
locatorData.setArea(area);
locatorData.setAreaId(areaId);
locatorData.setProvince(province);
locatorData.setProvinceCode(provinceCode);
locatorData.setCity(city);
locatorData.setCityCode(cityCode);
locatorData.setDistrict(district);
locatorData.setDistrictCode(districtCode);
locatorData.setFloor(floor);
locatorData.setLatitude(Double.parseDouble(latitude));
locatorData.setLongitude(Double.parseDouble(longitude));
locatorData.setName(name);
locatorData.setPhone(phone);
locatorData.setPoiId(poiId);
locatorDataList.add(locatorData);
}
LOGGER.info("locatorDataList: " + JSON.toJSONString(locatorDataList));
return new ReturnT<>(ReturnT.SUCCESS, JSON.toJSONString(locatorDataList));
}
}
日志打?。?/p>
2020-01-07 00:39:30.284 [http-nio-8080-exec-3] INFO c.r.springbootdemo.controller.EasyExcelController-locatorDataList: [{"address":"王府井大街138號(hào)新東安廣場(chǎng)3層328","area":"東安市場(chǎng)","areaId":"jk238eewf0k","categories":"[\"美食,小吃快餐\"]","city":"北京市","cityCode":"110100","district":"東城區(qū)","districtCode":"110101","floor":"3","latitude":39.91456,"longitude":116.41155,"name":"探魚(yú)","phone":"010-65280328","poiId":"d7s8f6s6212","province":"北京市","provinceCode":"110000"},{"address":"豐臺(tái)北路18號(hào)院恒泰廣場(chǎng)F6樓","area":"恒泰廣場(chǎng)","areaId":"ji8sgg3b32o","categories":"[\"美食,面包甜點(diǎn)\"]","city":"北京市","cityCode":"110100","district":"豐臺(tái)區(qū)","districtCode":"110106","floor":"6","latitude":39.86608,"longitude":116.30516,"name":"好客來(lái)","phone":"010-65280221","poiId":"3g97sg8sd67","province":"北京市","provinceCode":"110000"}]
我們用工具轉(zhuǎn)換一下看的更清晰一點(diǎn):
[
{
"address": "王府井大街138號(hào)新東安廣場(chǎng)3層328",
"area": "東安市場(chǎng)",
"areaId": "jk238eewf0k",
"categories": "["美食,小吃快餐"]",
"city": "北京市",
"cityCode": "110100",
"district": "東城區(qū)",
"districtCode": "110101",
"floor": "3",
"latitude": 39.91456,
"longitude": 116.41155,
"name": "探魚(yú)",
"phone": "010-65280328",
"poiId": "d7s8f6s6212",
"province": "北京市",
"provinceCode": "110000"
},
{
"address": "豐臺(tái)北路18號(hào)院恒泰廣場(chǎng)F6樓",
"area": "恒泰廣場(chǎng)",
"areaId": "ji8sgg3b32o",
"categories": "["美食,面包甜點(diǎn)"]",
"city": "北京市",
"cityCode": "110100",
"district": "豐臺(tái)區(qū)",
"districtCode": "110106",
"floor": "6",
"latitude": 39.86608,
"longitude": 116.30516,
"name": "好客來(lái)",
"phone": "010-65280221",
"poiId": "3g97sg8sd67",
"province": "北京市",
"provinceCode": "110000"
}
]
json數(shù)組和List集合轉(zhuǎn)換總結(jié)
//方法一,將json解析后賦給單獨(dú)的元素
String jstr="{'json':'jsonvalue','bool':true,'int':1,'double':'20.5'}";
JSONObject json=JSONObject.fromObject(jstr);
boolean bool=json.getBoolean("bool");
int i=json.getInt("int");
double d=json.getDouble("double");
String value=json.getString("json");
System.out.println("bool="+String.valueOf(bool)+"\tjson="+value+"\tint="+i+"\tdouble="+d);
//方法二,json對(duì)象和bean對(duì)象之間相互轉(zhuǎn)換
//假如你是有一個(gè)bean對(duì)象
class User{
private String name;
private String psw;
//封裝getter/setter省略
}
//把一個(gè)json對(duì)象變成user
String u="{'name':'sail331x','psw':'123456789'}";
//用user對(duì)象接收json中的元素
User user=(User)JSONObject.toBean(JSONObject.fromObject(u),User.class);
//把一個(gè)user變成json對(duì)象:
JSONObject juser=JSONObject.fromObject(user);
//json字符串jstr
String jstr=juser.toString();
//方法三,json對(duì)象直接轉(zhuǎn)list集合、list集合轉(zhuǎn)json對(duì)象
//聲明一個(gè)Person 實(shí)體類:
import java.util.Date;
public class Person {
String id;
int age;
String name;
Date birthday;
//get,set方法省略
}
//測(cè)試json數(shù)據(jù)轉(zhuǎn)換
import java.util.Iterator;
import java.util.List;
import org.junit.Test;
import net.sf.json.JSONArray;
import net.sf.json.JsonConfig;
public class JsonToList {
public static void main(String[] args) {
String json="[{'name':'zhuangsan','age':18},{'name':'lisi','age':20}]";
JSONArray jsonarray = JSONArray.fromObject(json);
System.out.println(jsonarray);
List list = (List)JSONArray.toCollection(jsonarray, Person.class);
Iterator it = list.iterator();
while(it.hasNext()){
Person p = (Person)it.next();
System.out.println(p.getAge());
}
}
@Test
public void jsonToList1(){
String json="[{'name':'zhuangsan','age':18},{'name':'lisi','age':20}]";
JSONArray jsonarray = JSONArray.fromObject(json);
System.out.println(jsonarray);
List list = (List)JSONArray.toList(jsonarray, Person.class);
Iterator it = list.iterator();
while(it.hasNext()){
Person p = (Person)it.next();
System.out.println(p.getAge());
}
}
@Test
public void jsonToList2(){
String json="[{'name':'zhuangsan','age':20},{'name':'lisi','age':18}]";
JSONArray jsonarray = JSONArray.fromObject(json);
System.out.println(jsonarray);
System.out.println("------------");
List list = (List)JSONArray.toList(jsonarray, new Person(), new JsonConfig());
Iterator it = list.iterator();
while(it.hasNext()){
Person p = (Person)it.next();
System.out.println(p.getAge());
}
}
}
//將list對(duì)象轉(zhuǎn)為JSON字符串?dāng)?shù)組:
import java.util.LinkedList;
import java.util.List;
import net.sf.json.JSONArray;
public class ListToJson {
public static void main(String[] args) {
List list = new LinkedList();
for(int i=0;i<3;i++){
Person p = new Person();
p.setAge(i);
p.setName("name"+i);
list.add(p);
}
JSONArray jsonarray = JSONArray.fromObject(list);
System.out.println(jsonarray);
}
}
以上為個(gè)人經(jīng)驗(yàn),希望能給大家一個(gè)參考,也希望大家多多支持腳本之家。
相關(guān)文章
volatile與happens-before的關(guān)系與內(nèi)存一致性錯(cuò)誤
本文講了Java并發(fā)編程中volatile變量、happens-before與內(nèi)存一致性錯(cuò)誤,下面來(lái)和小編一起學(xué)習(xí)下如何解決2019-05-05
一篇文章帶你學(xué)習(xí)JAVA MyBatis底層原理
近來(lái)想寫(xiě)一個(gè)mybatis的分頁(yè)插件,但是在寫(xiě)插件之前肯定要了解一下mybatis具體的工作原理吧,本文就詳細(xì)總結(jié)了MyBatis工作原理,,需要的朋友可以參考下2021-09-09
解決Spring國(guó)際化文案占位符失效問(wèn)題的方法
本篇文章主要介紹了解決Spring國(guó)際化文案占位符失效問(wèn)題的方法,小編覺(jué)得挺不錯(cuò)的,現(xiàn)在分享給大家,也給大家做個(gè)參考。一起跟隨小編過(guò)來(lái)看看吧2018-04-04
Mybatis RowBounds 限制查詢條數(shù)的實(shí)現(xiàn)代碼
Oracle 數(shù)據(jù)庫(kù)查詢?cè)黾覴owBounds限制查詢條數(shù),默認(rèn)是0到1000條。下面給大家分享Mybatis RowBounds 限制查詢條數(shù)的實(shí)現(xiàn)代碼,需要的朋友參考下吧2016-11-11
解決Maven的pom.xml中設(shè)置repository不起作用問(wèn)題
這篇文章主要介紹了解決Maven的pom.xml中設(shè)置repository不起作用問(wèn)題,具有很好的參考價(jià)值,希望對(duì)大家有所幫助,如有錯(cuò)誤或未考慮完全的地方,望不吝賜教2024-03-03

