mybatis批量修改

    <update id="updatePlayListSortByMap" parameterType="map">
        UPDATE library_play_list SET
            sort = CASE `play_list_id`
                <foreach collection="newPlayListSort" item="value"  index="key">
                    WHEN #{key} THEN #{value}
                </foreach>
            END
        WHERE play_list_id IN
            <foreach collection="newPlayListSort" item="value"  index="key" open="(" separator="," close=")">
                #{key}
            </foreach>
    </update>