myBatis批量增删改和批量增OR删

<!-- 批量修改 -->
<update id="batchEdit" parameterType="java.util.List">
    update  CUSTOMER
    <trim prefix="set" suffixOverrides=",">
          <trim prefix="USER_ID =case" suffix="end,">
              <foreach collection="list" item="item" index="index">
                  <if test="item.USER_ID != null">
                   when CUSTOMER_ID=#{item.CUSTOMER_ID} then #{item.USER_ID}
                  </if>
              </foreach>
           </trim>
          <trim prefix="NAME =case" suffix="end,">
              <foreach collection="list" item="item" index="index">
                  <if test="item.NAME != null">
                   when CUSTOMER_ID=#{item.CUSTOMER_ID} then #{item.NAME}
                  </if>
              </foreach>
          </trim>
      </trim>
      where
        <foreach collection="list" separator="or" item="item" index="index" >
            CUSTOMER_ID=#{item.CUSTOMER_ID}
        </foreach>
</update>
<!-- 批量增加 -->
  <insert id="saveByBatch" parameterType="java.util.List">
      insert into PRO_ORDER(
    ORDER_NO,   
    USER_ID,    
    APPUSER_ID, 
    CONSUME_TOTAL,  
    NUM,    
    CODE,   
    CONSIGNEE,  
    PHONE,  
    ADDRESS,    
    STATUS, 
    CREATE_DATE,    
    ALL_ORDER_ID,   
    PRO_ORDER_ID
) values
      <foreach collection="list" item="item" index="index" separator=",">
          (#{item.ORDER_NO},    
    #{item.USER_ID},    
    #{item.APPUSER_ID}, 
    #{item.CONSUME_TOTAL},  
    #{item.NUM},    
    #{item.CODE},   
    #{item.CONSIGNEE},  
    #{item.PHONE},  
    #{item.ADDRESS},    
    #{item.STATUS}, 
    #{item.CREATE_DATE},    
    #{item.ALL_ORDER_ID},   
    #{item.PRO_ORDER_ID}
    )
      </foreach>
  </insert>
<!-- 批量删除 -->
<delete id="deleteAll" parameterType="String">
    delete from PRO_ORDER
    where 
    PRO_ORDER_ID in
<foreach item="item" index="index" collection="array" open="(" separator="," close=")">
         #{item}
</foreach>
</delete>
    <!-- 批量增加和修改 -->
  <insert id="SaveOrUpdate" parameterType="java.util.List">
      insert into CART_PRO_SPEC(
    CART_PRO_ID,    
    PRO_SPEC2_ID,   
    NUM,    
    CART_PRO_SPEC_ID
) values 
      <foreach collection="list" item="item" index="index" separator=",">
          (#{item.CART_PRO_ID},    
       #{item.PRO_SPEC2_ID},    
        #{item.NUM}, 
        #{item.CART_PRO_SPEC_ID}
       )
      </foreach>
      ON DUPLICATE KEY UPDATE
        CART_PRO_ID =CASE CART_PRO_SPEC_ID
        <foreach collection="list" item="item" index="index">
        WHEN #{item.CART_PRO_SPEC_ID} THEN #{item.CART_PRO_ID}
    </foreach>
    END,
        PRO_SPEC2_ID =CASE CART_PRO_SPEC_ID
        <foreach collection="list" item="item" index="index">
        WHEN #{item.CART_PRO_SPEC_ID} THEN #{item.PRO_SPEC2_ID}
    </foreach>
    END,
        NUM =CASE CART_PRO_SPEC_ID
        <foreach collection="list" item="item" index="index">
        WHEN #{item.CART_PRO_SPEC_ID} THEN #{item.NUM}
    </foreach>
    END
  </insert>