<insert id="betchInsertMallTuanCode" parameterType="java.util.List">
<![CDATA[
insert into mall_tuan_code (mall_id, user_id,code,status,trade_id,out_trade_id,type,gmt_create,gmt_modify,attribute,copies) values
]]>
<foreach collection="list" item="mallTuanCode" index="index" separator=",">
<![CDATA[
(#{mallTuanCode.mallId}, #{mallTuanCode.userId}, #{mallTuanCode.code},
#{mallTuanCode.status}, #{mallTuanCode.tradeId}, #{mallTuanCode.outTradeId},
#{mallTuanCode.type}, #{mallTuanCode.gmtCreate}, #{mallTuanCode.gmtModify},
#{mallTuanCode.attribute}, #{mallTuanCode.copies})
]]>
</foreach>
<selectKey resultType="long" keyProperty="id">
SELECT @@IDENTITY AS id
</selectKey>
</insert>
mybatis 批量插入
最新推荐文章于 2024-07-24 14:08:06 发布