Oracle实现批量增删改

新增：

    <insert id="actionRecordImport" parameterType="java.util.List">
        INSERT INTO test_data(idname,idcard,dyzt,dyztyy)
        <foreach collection="list" item="item" separator="UNION ALL">
            select
            #{item.idname},#{item.idcard},#{item.dyzt},#{item.dyztyy}
            from dual
        </foreach>
    </insert>

删除

    <delete id="delete" parameterType="java.util.List">
        DELETE FROM test_data WHERE idcard IN
        <foreach collection="list" item="item" index="no"
                 open="(" separator="," close=")">
            #{item.idcard}
        </foreach>
    </delete>

修改：

    <update id="updateStatus" parameterType="java.util.List">
        <foreach collection="list" item="item" separator=";" open="begin" close=";end;">
            update AU_HISTORY_SUSPEND
            <set>
                <if test="item.recoveryStatus != null">
                    RECOVERY_STATUS = #{item.recoveryStatus}
                </if>
            </set>
            where idcard = #{item.idcard}
        </foreach>
    </update>

笔记纯自用记录，如有错误欢迎指点，勿喷！我玻璃心！