Mybatis批量插入数据
<insert id="createBatch" parameterType="PointSummary" useGeneratedKeys="true">
INSERT INTO
<include refid="table"/>
(<include refid="columns"/>)
VALUES
<foreach collection="list" item="PointSummary" index="index" separator=",">
(#{PointSummary.channelId}, #{PointSummary.channelCode},
#{PointSummary.channelName}, #{PointSummary.pointKey},
#{PointSummary.pointBrand}, #{PointSummary.cumulativeScore},
#{PointSummary.freezeScore}, #{PointSummary.thawScore},
#{PointSummary.consumeScore}, #{PointSummary.consumedScore},
#{PointSummary.returnScore}, #{PointSummary.expiredScore},
#{PointSummary.today}, now(), now())
</foreach>
</insert>
注意点：批量插入时，collection项必须写list，item 项与下面展示的对应。
页:
[1]