java 增量插入

<insert id="ValuecardExtractCashDetailDomain_insertbatch" parameterType="com.hzhy.mylm.opm.sale.card.record.domain.ValuecardExtractCashDomain">
<foreach collection="detailDomains" item="item" separator=";">
insert into opm_crm_member_valuecard_extract_cash_detail
<trim prefix="(" suffix=")" suffixOverrides=",">
org_code,
org_name,
company_org_code,
company_org_name,
main_id,
<if test="item.source_id != null ">source_id,</if>
<if test="item.balance_cash != null ">balance_cash,</if>
<if test="item.cash != null ">cash,</if>
<if test="item.surplus_cash != null ">surplus_cash,</if>
<if test="item.consume_cash != null ">consume_cash,</if>
create_user_id,
create_time,
<if test="item.modify_user_id != null ">modify_user_id,</if>
modify_time,
<if test="item.source_type != null and item.source_type !='' ">source_type,</if>
<if test="item.is_present != null and item.is_present !='' ">is_present,</if>
sts
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
#{org_code},
#{org_name},
#{company_org_code},
#{company_org_name},
#{id},
<if test="item.source_id != null "> #{item.source_id},</if>
<if test="item.balance_cash != null "> #{item.balance_cash},</if>
<if test="item.cash != null "> #{item.cash},</if>
<if test="item.surplus_cash != null "> #{item.surplus_cash},</if>
<if test="item.consume_cash != null "> #{item.consume_cash},</if>
#{create_user_id},
now(),
<if test="item.modify_user_id != null "> #{item.modify_user_id},</if>
now(),
<if test="item.source_type != null and item.source_type !='' "> #{item.source_type},</if>
<if test="item.is_present != null and item.is_present !='' "> #{item.is_present},</if>
'Y'
</trim>
</foreach>
  • 1
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值