mybatis 进行批量更新操作

<update id="updateAgentOpt" parameterType="java.util.List">
          UPDATE gt_agent_day_corr_optstatus
    <trim prefix="set" suffixOverrides=",">
        <trim prefix="data_source_open =case" suffix="end,">
            <foreach collection="list" item="i" index="index">
                <if test="i.dataSourceOpen!=null">
                    when id=#{i.id} then #{i.dataSourceOpen}
                </if>
            </foreach>
        </trim>
        <trim prefix="data_source_agent =case" suffix="end,">
            <foreach collection="list" item="i" index="index">
                <if test="i.dataSourceAgent!=null">
                    when id=#{i.id} then #{i.dataSourceAgent}
                </if>
            </foreach>
        </trim>
        <trim prefix="remark =case" suffix="end,">
            <foreach collection="list" item="i" index="index">
                <if test="i.remark!=null">
                    when id=#{i.id} then #{i.remark}
                </if>
            </foreach>
        </trim>
            <trim prefix="update_user =case" suffix="end,">
                <foreach collection="list" item="i" index="index">
                    <if test="i.updateUser!=null">
                        when id=#{i.id} then #{i.updateUser}
                    </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>