批量更新 <update id="updateList"> update aaa_table t inner join <foreach collection="list" item="bean" separator="union all" open="(" close=") t1 on t.id = t1.id and t.version = t1.version"> select #{bean.id} as id, #{bean.version} as version, #{bean.updateTime} as update_time, #{bean.updateId} as update_id, #{bean.updateName} as update_name from dual </foreach> set t.version = t1.version + 1, t.update_time = t1.update_time, t.update_id = t1.update_id, t.update_name = t1.update_name </update>