批量更新:
<update id= "updateSubmitTimeByUids" parameterType= "map">
update 表名
set submit_time = #{submitTime,jdbcType=BIGINT} where uid in
<foreach collection="list" item= "uid" index ="index"
open= "(" close =")" separator=",">
#{ uid}
</foreach >
</update >
用法和之前的基本相同,但是需要注意传入的参数是map类型。
map的值:{submitTime:XXXXXX, list:XXXXXX}
注意:map中的list一定不能为null,否则会报Syntax错误
转:http://jingyan.baidu.com/article/11c17a2c7f376af446e39d21.html