可以在动态sql中拼接如下代码
<foreach item='item' index='index' collection='infos' open='(' separator=',' close=')'> #{item} </foreach>
@Insert({"<script>",
"insert into model(id, seq, header_id, column_name, extent, special_code, data_type, create_time, update_time)",
"values " +
"<foreach collection='list' item='item' index='index' separator=','>" +
"(#{item.id}, #{item.seq}, #{item.header_id}, #{item.column_name}, #{item.extent}, #{item.special_code}, #{item.data_type}, #{item.create_time}, #{item.update_time})" +
"</foreach>" +
"</script>"})
Long insertExcelModels(@Param("list") List<ExcelModel> list);