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);