xml中批量插入语句（若主键存在则执行更新）

<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>