Hibernate的List转换成json,大家的呢?

LoginOut LoginOut 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区

public void testQueryNoXml() {
Session session = HibernateSessionFactory.getSession();
JSONArray array = new JSONArray();
try {
List list = session
.createSQLQuery(
"select cardid,cardreaderid,mapid,stayinterval from v_locatedata")
.setFirstResult(0)
.setMaxResults(10)
.list();
for (int i = 0; i < list.size(); i++) {
Object[] obj = (Object[]) list.get(i);
JSONObject row = new JSONObject();
row.put("cid", obj[0]);
row.put("crid", obj[1]);
row.put("mid", obj[2]);
row.put("stl", obj[3]);
array.add(row);
}
JSONObject json = new JSONObject();
json.put("rowcount", list.size());
json.put("rows", array);
System.out.println("sb.tostring: " + json);
} catch (RuntimeException re) {
log.error("==converse json failed==", re);
} finally {
session.close();
}
}


输出:

sb.tostring: {"rowcount":10,"rows":[{"cid":10352,"crid":17,"mid":1,"stl":"0天00:00:17"},{"cid":10583,"crid":3,"mid":1,"stl":"0天00:00:17"},{"cid":10783,"crid":17,"mid":1,"stl":"0天00:00:51"},{"cid":10913,"crid":3,"mid":1,"stl":"0天00:00:17"},{"cid":10352,"crid":17,"mid":1,"stl":"0天00:00:34"},{"cid":10583,"crid":17,"mid":1,"stl":"0天00:00:34"},{"cid":10913,"crid":17,"mid":1,"stl":"0天00:00:34"},{"cid":10352,"crid":17,"mid":1,"stl":"0天00:02:50"},{"cid":10583,"crid":17,"mid":1,"stl":"0天00:02:50"},{"cid":10783,"crid":17,"mid":1,"stl":"0天00:03:07"}]}


请问大家是如何处理的呢?
...全文

相关推荐

评论 14
收藏 已收藏
分享
返回顶部
LoginOut
Java EE 67,535 成员 225,843 内容