【SQL】批量操作：批量插入、删除

1、批量删除
    <delete id="deleteLanguageBatch">
        delete from user where
        <foreach collection="list" item="item" separator="or">
            id = #{item.id}
            name = #{item.name}
        </foreach>
    </delete>

2、批量插入
<!--  批量插入  -->
    <insert id="batchInsert" parameterType="java.util.List">
        INSERT INTO
        ORDER_GOODS
　　　　　(
　　　　　OG_ID,
        ORDER_ID,
        GOODS_DBID
　　　　　）VALUE
　　　　　<foreach collection="orderGoodsList" item="item" separator=",">

   （
    #{item.ogId},
    #{item.orderId},
    #{item.goodsDbid}
    )

    </foreach>
</insert>

 3、批量插入：如果这条记录已存在，则执行更新操作，否则执行插入

    <!--更新商品库存和销量-->
    <insert id="batchUpdateGoodsNum" parameterType="list">
        INSERT INTO GOODS_INFO(
        GOODS_DBID,
        GOODS_CAN_BUY,
        GOODS_STOCK,
        GOODS_SOLD
        )
        VALUE
        <foreach collection="goodsInfoList" item="item" separator=",">
            (
            #{item.goodsDbid},
            #{item.goodsCanBuy},
            #{item.goodsStock},
            #{item.goodsSold}
            )
        </foreach>
        ON DUPLICATE KEY UPDATE
        GOODS_DBID = VALUES (GOODS_DBID),
        GOODS_CAN_BUY = VALUES (GOODS_CAN_BUY),
        GOODS_STOCK = VALUES (GOODS_STOCK),
        GOODS_SOLD = VALUES (GOODS_SOLD)
    </insert>