<insert id="addPcPointexchgGoods" parameterType="com.goldsign.project.zhy.integral.integralExchange.domain.PcPointexchgGoods" useGeneratedKeys="false">
insert into PC_POINTEXCHG_GOODS (PERIOD_GOODS_ID,EXCHG_RULE_ID,PRODUCT_CODE,PC_AMOUNT,GOOD_TYPE)
<foreach collection="list" item="bill" index="index" separator="UNION ALL">
select #{bill.periodGoodsId},#{bill.exchgRuleId},#{bill.productCode},#{bill.pcAmount},#{bill.goodType}
from dual
</foreach>
</insert>
【oracle】Mybatis批量添加数据(传入List集合)
最新推荐文章于 2024-03-29 14:24:22 发布