最近项目遇到一个需求:
从JSON里解析数据后,批量插入到数据库(重点在于不是只针对一个表操作,而是根据json里的表名和字段来动态插入),数据库用的Oracle;
下面贴代码
java代码
//dataStr为
{
"tbl_pe_enterprise_record":[{"RECORD_ID":"1","AP_CHN_ADDRESS":"shachong","APPLY_DATE":"2019/12/31"},{"RECORD_ID":"2","AP_CHN_ADDRESS":"shachong2","APPLY_DATE":"2019/12/31"}],
"tbl_pe_imex_pestcert_r_rs":
[{"PDRGID":"1","PDRGNO":"shachong","PDBEGINDAY":"2019/12/31"},{"PDRGID":"2","PDRGNO":"shachong2","PDBEGINDAY":"2019/12/31"}]
}
Map<String, List<Map<String, String>>> dataListMap =
JSON.parseObject(dataStr, new TypeReference<Map<String, List<Map<String, String>>>&g