Springboot中传入参数为List时对数据库数据进行查询和增加

可以在动态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);