Mybatis 批量更新

update <include refid="main_table"/>
        <trim prefix="set" suffixOverrides=",">
            <trim prefix="mark_name = case" suffix="end ,">
                <foreach collection="businessMarkBeanList" item="item" index="index">
                    <if test="item.markName != null and '' != item.markName">
                        when id = #{item.id}
                        then #{item.markName}
                    </if>
                </foreach>
            </trim>
            <trim prefix="name_path = case" suffix="end ,">
                <foreach collection="businessMarkBeanList" item="item" index="index">
                    <if test="item.namePath != null and '' != item.namePath">
                        when id = #{item.id}
                        then #{item.namePath}
                    </if>
                </foreach>
            </trim>
        </trim>
        where id in
        <foreach collection="businessMarkBeanList" item="item" index="index" separator="," open="(" close=")">
            #{item.id}
        </foreach>