oracle使用mybatis批量新增数据，批量更新数据

批量新增数据：

<insert id="batchPutInfo" parameterType="com.cdtye.kmims.computer.model.entity.ComputerGoodsPutInfo">
        insert into COMPUTER_GOODS_PUT_INFO(ID,PUT_IN_ID,PURCHASE_NUM,SELF_NO,GOODS_NAME,MODEL_SPEC,
        COMMODITY_CATEGORY,THIRD_CATEGORY,COMMODITY_NAME,PUT_IN_NUM,REMARK)
        <foreach collection="list" item="item" separator="UNION ALL">
            SELECT #{item.id},#{item.putInId},#{item.purchaseNum},#{item.selfNo},#{item.goodsName},#{item.modelSpec},
            #{item.commodityCategory},#{item.thirdCategory},#{item.commodityName},#{item.putInNum},#{item.remark}
            FROM dual
        </foreach>
    </insert>

批量更新数据：

<update id="batchUpdateRepairInfo">
        <foreach collection="list" item="item" index="index" separator=";" open="begin" close=";end;">
            UPDATE COMPUTER_GOODS_REPAIR_INFO SET REPAIR_METHOD = #{item.repairMethod},
            REPAIR_RESULT = #{item.repairResult},RETURN_REMARK = #{item.returnRemark}
            WHERE ID = #{item.id}
        </foreach>
    </update>