-- mybatise xml可以循环list/map等
<update id="saveSort" parameterType="java.util.Map">
<foreach collection="sortMap.keys" open="" close="" separator="; " item="key">
UPDATE `standard_switchover` set sort=
<if test='sortMap[key] == null and sortMap[key] == ""'>
NULL
</if>
<if test="sortMap[key] != ''">
#{sortMap[${key}]}
</if>
WHERE id=#{key}
</foreach>
</update>
<update id="saveSort" parameterType="java.util.Map">
<foreach collection="sortMap.keys" open="" close="" separator="; " item="key">
UPDATE `standard_switchover` set sort=
<if test='sortMap[key] == null and sortMap[key] == ""'>
NULL
</if>
<if test="sortMap[key] != ''">
#{sortMap[${key}]}
</if>
WHERE id=#{key}
</foreach>
</update>