|
| <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 项与下面展示的对应。
|
|
|