mysql jsonArray怎么查询排序

Question

jsonArray如下：
{"recodeInfo":
[
{"orderId": "1", "userName": "张三1", "insertDate": "2018-01-27", "recordText": "测试1"},
{"orderId": "1", "userName": "李四2", "insertDate": "2018-04-02", "recordText": "测试2"}
]
}

我需要根据InsertDate获取最后一条数据

Answer 1

//转成list
List list = new ArrayList ();
JSONObject jsonObj = null;
for (int i = 0; i < jsonArr.size(); i++) {
jsonObj = (JSONObject)jsonArr.get(i);
list.add(jsonObj);
}
Collections.sort(list,new MyComparator());
jsonArr.clear();
for (int i = 0; i < list.size(); i++) {
jsonObj = list.get(i);
jsonArr.add(jsonObj);
}
//jsonArr排序