mybatis 批量跟新

jdbc需配置
&allowMultiQueries=true

一、批量增

<insert id="batchInsertSites" parameterType="com.*.PartnerOrderPackageSiteRelatoin">
        REPLACE  INTO partner_order_package_site_relatoin
        (partner_order_id, package_id,partner_site_code,device_type,site_id,cart_id,address,site_name,tower_type,device_number)
        VALUES
        <foreach collection="list" item="item" separator=",">
            (
            #{item.partnerOrderId},#{item.packageId},#{item.partnerSiteCode},#{item.deviceType},#{item.siteId},#{item.cartId},#{item.address},#{item.siteName},#{item.towerType},#{item.deviceNumber}
            )
        </foreach>
    </insert>

二 批量改

<update id="updateBatch" parameterType="java.util.List" >
        <foreach collection="list" item="item" index="index" open="" close="" separator=";">
            update partner_cart_info
            <set>
                <if test="item.delFlag != null" >
                    del_flag = #{item.delFlag,jdbcType=VARCHAR},
                </if>
            </set>
            where partner_cart_id = #{item.partnerCartId,jdbcType=BIGINT}
        </foreach>
    </update>

三、批量删

<delete id="deleteByIds" parameterType="java.util.List">
        DELETE FROM partner_order_package_function_relation where
        <foreach collection="list" item="item" separator="or" index="index">
            (
                partner_order_id is null
                <if test="item.packageId != null">
                    and package_id = #{item.packageId, jdbcType=VARCHAR}
                </if>
                <if test="item.cartId != null">
                    and cart_id = #{item.cartId, jdbcType=VARCHAR}
                </if>
            )
        </foreach>
    </delete>

<delete id="deletePartnerCartInfoByIds" parameterType="String">
        delete from partner_cart_info where partner_cart_id in
        <foreach item="partnerCartId" collection="array" open="(" separator="," close=")">
            #{partnerCartId}
        </foreach>
    </delete>