查询数据库有如下的查询结果
name id remark time data type contain
张三 1 测试 2016 数据1 test1 1
张三 1 测试 2016 数据2 test2 1
张三 1 测试 2016 数据3 test3 1
张三 1 测试 2016 数据4 test4 1
李四 2 测试2 2016 数据99 test66 0
李四 2 测试2 2016 数据98 test66 0
......
现在我想处理数据,形成如下格式
[{name:张三,remark:测试,time:2016,display:[{data:数据1,type:test1},{data:数据2,type:test2},{data:数据3,type:test3},{data:数据4,type:test4}]},{name:李四,remark:测试2,time:2016,display:[{data:数据99,type:test66},[{data:数据98,type:test66}]}]
需要一个比较方便的方法,手动拼接就算了,感谢。
[
{
name: 张三,remark:测试,time:2016,display: [
{
data: 数据1,type: test1
},
{
data: 数据2,type: test2
},
{
data: 数据3,type: test3
},
{
data: 数据4,type: test4
}
]
},
{
name: 李四,remark:测试2,time:2016,display: [
{
data: 数据99,type: test66
},
[
{
data: 数据98,type: test66
}
]
}
]
想到用hashmap,不过没实现,请教各位指点下
怪我咯2017-04-18 10:06:22
The questioner raised this question because there is no concept of serialization and deserialization yet.
Serialization is the process of converting an object into data in a specific format, such as converting a java instance into an xml or json (or other specification) string. The deserialization process is the opposite, converting an xml, json (or other specification) into a java object.
Specifically for the serialization and deserialization of json, I personally think there are two ways
1. Implement it yourself, such as using reflection and other methods to complete this method. In the end, you still need to splice strings, which is your own wheel.
2. Use Existing json libraries, such as gson, jackson, fastjson, etc., provide relatively simple serialization and deserialization interfaces.
For example, using fastjson, serialization can be implemented in this style (pseudocode)
List<User> list = new List<User>();
list.add(new User());
list.add....
String jsonStr = Json.toJsonString(list);
Deserialization is similar
迷茫2017-04-18 10:06:22
There are many Java libraries that generate JSON, such as fastjson (oschina introduction page)
Gson
Jackson
Fastjson
迷茫2017-04-18 10:06:22
First assemble it into a Java Bean, and then use some JSON serialization tools, commonly used ones include Jackson,fastjson,Gson
etc.
阿神2017-04-18 10:06:22
You can use hashmap, put it in the list, then put it in the map, and convert it through Gson.
For example
Map<String,Stirng> nameMap = new HashMap<String,String>();
nameMap .put(name,"Zhang San");
nameMap .put(remark,"Salesperson");
Map<String ,Stirng> dataMap= new HashMap<String,String>();
List dataList =new ArrayList();
for(int i=0;i<=4;i++){
dataMap.put("data"," data1");
dataMap.put("type","666");
}
dataList.add(dataMap);
nameMap.put(display,dataList);
String s = new Gson().toJson( nameMap);
The code should work with a slight adjustment.
巴扎黑2017-04-18 10:06:22
Java has so many ways to serialize objects into json strings, why not use them
黄舟2017-04-18 10:06:22
public class JsonUtils{
private static final ObjectMapper mapper = new ObjectMapper();
public static String Object2Json(Object o)throws BusinessException{
StringWriter writer = new StringWriter();
try {
mapper.writeValue(writer, o);
} catch (IOException e) {
e.printStackTrace();
throw new BusinessException(0, "Entity转换成Json时出现异常。", e);
}
return writer.toString();
}