list对象转json

时间:2024-03-11 21:48:45

for (LdInquiryPage ldInquiryPage : l) {
List<LdInquiryCostEntity> lson = jdbcTemplate.query(sqlson+ldInquiryPage.getId()+"\'", rowMapperson);
ldInquiryPage.setLdInquiryCostList(lson);
ldInquiryPage.setInContent(sdf.format(ldInquiryPage.getCreateDate()));
}

 

1、LIST对象转json字符串
net.sf.json.JSONArray jsonarray = net.sf.json.JSONArray.fromObject(l);
js.put("content", jsonarray.toString());

 

2、jsonArray取值

JSONArray json

for (int i = 0; i < json.size(); i++) {
JSONObject jsonObject=(JSONObject) json.get(i);

String sql = "UPDATE ld_inquiry SET updatestate=\'0\' WHERE id=\'"+jsonObject.get("id")+"\' AND updatestate=\'"+jsonObject.get("updatestate")+"\'";
// String sql="update ldc_handbook_order set hbo_upstate=\'0\' where hbo_orderno=\'"+jsonObject.get("ordercode")+"\' and hbo_upstate=\'"+jsonObject.get("updatestate")+"\'";
jdbcTemplate.update(sql);
}

 

3、json字符串转list对象

List<CommonContractEntity> contractList = (List<CommonContractEntity>)net.sf.json.JSONArray.toList(array, CommonContractEntity.class);