.net list 转json字符串 list转jsonobject

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