批量修改

使用一条sql语句更新

    <update id="batchUpdateStatus">
        UPDATE cust_vehicle
        <trim prefix="set" suffixOverrides=",">
            <trim prefix="update_status = case" suffix="end,">
                <foreach collection="list" item="i" index="index">
                    <if test="i.updateStatus != null">
                        when id=#{i.id} then #{i.updateStatus}
                    </if>
                </foreach>
            </trim>
            <trim prefix="update_time = case" suffix="end," >
                <foreach collection="list" item="i" index="index">
                    <if test="i.updateTime != null">
                        when id=#{i.id} then #{i.updateTime}
                    </if>
                </foreach>
            </trim>
        </trim>
        where
        <foreach collection="list" separator="or" item="i" index="index" >
            id=#{i.id}
        </foreach>
    </update>    <update id="batchUpdat