Mybatis中使用case when 批量更新数据

最新推荐文章于 2024-09-29 22:38:03 发布

若疆赤云online

最新推荐文章于 2024-09-29 22:38:03 发布

阅读量273

点赞数 2

文章标签： mybatis java windows

本文链接：https://blog.csdn.net/now19930616/article/details/141635310

版权

替换 {} 括住的信息

update {table_name}
	<trim prefix="set" suffixOverrides=",">

		<trim prefix="{column_name1} =case" suffix="end,">
			<foreach collection="list" item="s">
				when id = #{s.id}
				then {val1}
			</foreach>
		</trim>

		<trim prefix="{column_name2} =case" suffix="end,">
			<foreach collection="list" item="s">
				when id = #{s.id}
				then {val2}
			</foreach>
		</trim>

		<trim prefix="update_time =case" suffix="end,">
			<foreach collection="list" item="s">
				when id = #{s.id}
				then now()
			</foreach>
		</trim>

	</trim>
<where>
	id in
	<foreach collection="list" separator="," item="s" open="(" close=")">
		#{s.id}
	</foreach>
</where>