mybaits中使用对象进行数据库批量更新的sql:
<update id="batchUpdate" parameterType="XXX.XXX.XXX.XXX.XXX.XXX.XXXVO">
update t_table
<trim prefix="set" suffixOverrides=",">
<trim prefix="databaseFiled1= case" suffix="end,">
<foreach collection="updateList" item="item" index="index">
when keyFiled = #{item.keyFiled} then #{item.databaseFiled1}
</foreach>
</trim>
<trim prefix="databaseFiled2 = case" suffix="end,">
<foreach collection="updateList" item="item" index="index">
when keyFiled = #{item.keyFiled} then #{item.databaseFiled2}
</foreach>
</trim>
</trim>
WHERE
<foreach collection="updateList" separator="or" item="item" index="index" >
keyFiled = #{item.keyFiled}
</foreach>
</update>
其中prefix对应的是数据库的字段名。