动态批量插入有几个问题
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);
}