mybatis批量更新根据多个条件

<update id="updateListEntity">

        <foreach collection="list" item="item" index="index" open="" close="" separator=";">
            update ${tableName}
            <set>
                <if test="item.isValid != null">
                    IS_VALID = #{item.isValid},
                </if>
                <if test="item.dataTypeId != null">
                    DATA_TYPE_ID = #{item.dataTypeId},
                </if>
                <if test="item.siteCheck != null">
                    SITE_CHECK = #{item.siteCheck},
                </if>
                <if test="item.fileNameO != null">
                    FILE_NAME_O = #{item.fileNameO},
                </if>
                <if test="item.fileNameN != null">
                    FILE_NAME_N = #{item.fileNameN},
                </if>
                <if test="item.orgId != null">
                    ORG_ID = #{item.orgId},
                </if>
                <if test="item.cityOrgId != null">
                    CITY_ORG_ID = #{item.cityOrgId},
                </if>
                <if test="item.siteStatus != null">
                    SITE_STATUS = #{item.siteStatus},
                </if>
                <if test="item.endTime != null">
                    END_TIME = #{item.endTime},
                </if>
            </set>
            where SITE_CODE = #{item.siteCode} AND TIMES=#{item.times}
        </foreach>
    </update>