动态批量插入有几个问题
1表名动态自定义
2列动态自定义
3批量
<insert id="insertTableListDynamic" parameterType="java.util.HashMap"> insert into ${map.tableName} ( <foreach collection="map.mapHead" index="key" item="value" separator=","> `${key}` </foreach> ) values <foreach collection="map.list" item="line" separator=","> ( <foreach collection="line" index="key" item="value" separator=","> #{value} </foreach> ) </foreach> </insert>
java代码:
private void insertBatchList(String tableName,Map<String, Object> mapHead,List<Map<String, Object>> list){ Map<String, Object> batchList = new HashMap<>(); batchList.put("tableName", tableName); batchList.put("mapHead",mapHead); batchList.put("list",list); insertTableListDynamic(batchList); }