mybatis注解對象批量更改
一、介紹
當有多個對象需要進行更改時，批量修改對象集合List
二、代碼
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
@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); |
mybatis 注解批量更新、插入
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
//批量插入 @Insert({ "<script>", "insert into table(column1, column2) values ", "<foreach collection='userLists' item='item' index='index' separator=','>", "(#{item.column1}, #{item.column2} )", "</foreach>", "</script>" }) public int insertUsers(@Param(value="userLists") List<User> userLists);//批量更新@Update({ "<script>", "<foreach collection='userLists' item='item' index='index' separator=';'>", "update table b", "set b.column1= #{item.column1}，b.column2= #{item.column2} where b.column3= #{item.column3}", "</foreach>", "</script>" }) public int updateUser(@Param(value="userLists") List<User> userLists); |
collection：你傳來的集合
item：里面的類
index：就是for循環的i
separator：間隔符
以上為個人經驗，希望能給大家一個參考，也希望大家多多支持服務器之家。
原文鏈接：https://blog.csdn.net/CoderYin/article/details/93141862
