想要批量更新，不想用for循环了，
mapper:

int batchUpdateCustomer(List<BaseCustomerCarrierVO> baseCustomerCarrierVO);

xml：

<update id="batchUpdateCustomer" parameterType="java.util.List">
    update base_customer_carrier
    <trim prefix="set" suffixOverrides=",">
      <trim prefix="org_id =case" suffix="end,">
        <foreach collection="list" item="i" index="index">
          <if test="i.orgID!=null">
            when customer_id = #{i.customerID} then #{i.orgID}
          </if>
        </foreach>
      </trim>
    </trim>
    where
    <foreach collection="list" separator="or" item="i" index="index" >
      customer_id=#{i.customerID}
    </foreach>
  </update>

承接各类软件开发
微信：792977974
QQ：2973688860