-- 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>