查询时用
SELECT
array_to_json (
ARRAY_AGG (
row_to_json (xxx)
)
)
查出数据就是以xxx明明的json字符串,在后台用
DBQueryParam param = new DBQueryParam();
param.setSelectFields(Lists.newArrayList("xxx","xxx"));
datas = getDAO().queryBySql(sql, param).getDatas();
for (Map<String, Object> data : datas) {
String goods = (String) data.get("xxx");
data.put("xxx", JSONArray.parse(xxx));
}
接收,Lists.newArrayList中放到是需要查出来的列,循环中放的是需要查询出数组的列名