mybatis注解实现对象批量更改

最新推荐文章于 2022-03-24 21:14:33 发布

CoderYin

最新推荐文章于 2022-03-24 21:14:33 发布

阅读量2.1k

点赞数

分类专栏： java 文章标签： mybatis批量修改

本文链接：https://blog.csdn.net/CoderYin/article/details/93141862

版权

java 专栏收录该内容

29 篇文章 1 订阅

订阅专栏

mybatis注解实现对象批量更改

一、介绍

当有多个对象需要进行更改时，批量修改对象集合List

二、代码

@Update("<script>"
			+ "<foreach collection='listUserAnswerRecord' item='item' open='' close=''  separator=';'> "
			+ " update t_qb_record_201910"
			+ " set answered = 0, progress = 1, answer_sheet = null, gmt_update = #{item.gmtUpdate}"
			+ " <where>"
			+ "<choose>"
			+ "<when test='item.unionid !=null'> unionid=#{item.unionid}</when>"
			+ "<otherwise> openid= #{item.openid} </otherwise>"
			+ "</choose>"
			+ " and goods_id = #{item.goodsId} and charpter_id = #{item.charpterId} and type = #{item.type}"
			+ "</where>"
			+ "</foreach>"
			+ "</script>")
	Integer deleteUserAnswerSheet(@Param("listUserAnswerRecord") List<UserAnswerRecordNew> listUserAnswerRecord);