<insert id="insertByCsPlanDBatch" parameterType="java.util.List">
insert into cs_plan_d
(
<trim suffix="" suffixOverrides=",">
plan_no,
sku_no,
product_level,
lot_attribute,
remark,
tenant_id,
warehouse_no,
org_no,
distribute_no,
version,
create_time,
update_time,
create_user,
update_user,
is_delete,
</trim>
)
values
<foreach collection="list" item="item" open="" separator="," close="">
(
<trim suffix="" suffixOverrides=",">
#{item.planNo},
#{item.skuNo},
#{item.productLevel},
#{item.lotAttribute},
#{item.remark},
#{item.tenantId},
#{item.warehouseNo},
#{item.orgNo},
#{item.distributeNo},
#{item.version},
now(),
now(),
#{item.createUser},
#{item.updateUser},
0
</trim>
)
</foreach>
<!--若主键存在,重复,则执行更新-->
ON DUPLICATE KEY UPDATE
<trim suffix="" suffixOverrides=",">
plan_no= values(plan_no),
sku_no= values(sku_no),
product_level= values(product_level),
lot_attribute= values(lot_attribute),
remark= values(remark),
tenant_id= values(tenant_id),
warehouse_no= values(warehouse_no),
org_no= values(org_no),
distribute_no= values(distribute_no),
version= values(version),
create_time= values(create_time),
update_time= values(update_time),
create_user= values(create_user),
update_user= values(update_user),
is_delete= values(is_delete),
</trim>
</insert>
xml中批量插入语句(若主键存在则执行更新)
最新推荐文章于 2023-11-01 14:45:12 发布