批量新增
int batchInsertEntity(List<CardProductOrderRelation> list);
<insert id="batchInsertEntity" useGeneratedKeys="true" keyProperty="id">
insert into card_product_order_relation(order_id,order_code,
card_number,card_password,amount,discount,status,create_time,create_by) values
<foreach item="item" index="index" collection="list" separator=",">
(
</foreach>
</insert>
批量更新
<update id="batchUpdateEntity">
update card_product_order u
<trim prefix="set" suffixOverrides=",">
<trim prefix="success_amount =case" suffix="end,">
<foreach collection="list" item="i" index="index">
<if test="i.successAmount!=null">
when id=#{i.id} then #{i.successAmount}
</if>
</foreach>
</trim>
<trim prefix=" actual_amount =case" suffix="end,">
<foreach collection="list" item="i" index="index">
<if test="i.actualAmount!=null">
when id=#{i.id} then #{i.actualAmount}
</if>
</foreach>
</trim>
<trim prefix=" actual_balance =case" suffix="end,">
<foreach collection="list" item="i" index="index">
<if test="i.actualBalance!=null">
when id=#{i.id} then #{i.actualBalance}
</if>
</foreach>
</trim>
<trim prefix=" success_count =case" suffix="end,">
<foreach collection="list" item="i" index="index">
<if test="i.successCount!=null">
when id=#{i.id} then #{i.successCount}
</if>
</foreach>
</trim>
<trim prefix=" fail_count =case" suffix="end,">
<foreach collection="list" item="i" index="index">
<if test="i.failCount!=null">
when id=#{i.id} then #{i.failCount}
</if>
</foreach>
</trim>
</trim>
where id in
<foreach collection="list" index="index" item="i" separator="," open="(" close=")">
#{i.id}
</foreach>
</update>