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>

转载于:https://my.oschina.net/u/3823956/blog/1790914