重點重點重點，不然會報錯
連接數據庫url后面加個參數
allowMultiQueries=true
用習慣了 insertList 怎么能沒有 updateList呢
就兩個類 直接上代碼
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
|
package com.lancabbage.gorgeous.utils.mybatis;import org.apache.ibatis.mapping.MappedStatement;import tk.mybatis.mapper.entity.EntityColumn;import tk.mybatis.mapper.mapperhelper.EntityHelper;import tk.mybatis.mapper.mapperhelper.MapperHelper;import tk.mybatis.mapper.mapperhelper.MapperTemplate;import tk.mybatis.mapper.mapperhelper.SqlHelper;import java.util.Set;import static tk.mybatis.mapper.mapperhelper.SqlHelper.whereVersion;/** * ListUpdateProvider實現類，批量修改方法實現類 * * @author lanyanhua */public class ListUpdateProvider extends MapperTemplate { public ListUpdateProvider(Class<?> mapperClass, MapperHelper mapperHelper) { super(mapperClass, mapperHelper); }// /**// * 通過主鍵更新全部字段// *// * @param ms// */// public String updateByPrimaryKey(MappedStatement ms) {// Class<?> entityClass = getEntityClass(ms);// StringBuilder sql = new StringBuilder();// sql.append(SqlHelper.updateTable(entityClass, tableName(entityClass)));// sql.append(SqlHelper.updateSetColumns(entityClass, null, false, false));// sql.append(SqlHelper.wherePKColumns(entityClass, true));// return sql.toString();// } /** * 通過主鍵更新不為null的字段 * * @param ms * @return */ public String updateByPrimaryKeySelectiveList(MappedStatement ms) { Class<?> entityClass = getEntityClass(ms); StringBuilder sql = new StringBuilder(); sql.append("<foreach collection=\"list\" item=\"record\" >"); //set sql.append(SqlHelper.updateTable(entityClass, tableName(entityClass))); sql.append(SqlHelper.updateSetColumns(entityClass, "record", true, isNotEmpty())); //where sql.append("<where>"); Set<EntityColumn> columnSet = EntityHelper.getPKColumns(entityClass); //當某個列有主鍵策略時，不需要考慮他的屬性是否為空，因為如果為空，一定會根據主鍵策略給他生成一個值 for (EntityColumn column : columnSet) { sql.append(" AND ").append(column.getColumnEqualsHolder("record")); } sql.append(whereVersion(entityClass)); sql.append("</where>"); sql.append(" ;\n"); sql.append("</foreach>"); return sql.toString(); }} |
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
package com.lancabbage.gorgeous.utils.mybatis;import org.apache.ibatis.annotations.UpdateProvider;import tk.mybatis.mapper.annotation.RegisterMapper;import java.util.List;/** * 通用Mapper接口,更新 * * @param <T> 不能為空 * @author lanyanhua */@RegisterMapperpublic interface ListUpdateByPrimaryKeySelectiveMapper<T> { /** * 根據主鍵更新屬性不為null的值 * * @param record * @return */ @UpdateProvider(type = ListUpdateProvider.class, method = "dynamicSQL") int updateByPrimaryKeySelectiveList(List<T> record);} |
我是使用的是Tk.mybatis。代碼是復制的原來的updateByPrimaryKeySelective的代碼進行的微調
保證最終的結構類似這種就ok
|
1
2
3
4
5
6
7
8
9
10
11
|
<foreach collection="list" item="record" separator=";"> UPDATE project <set>id = id, <if test="record.name != null">name = #{record.name},</if> <if test="record.remotePath != null">remote_path = #{record.remotePath},</if> <if test="record.createTime != null">create_time = #{record.createTime},</if> <if test="record.isShow != null">is_show = #{record.isShow},</if> <if test="record.displayOrder != null">display_order = #{record.displayOrder},</if> </set> <where>AND id = #{record.id}</where></foreach> |
使用 就和其他的一樣 在你的Mapper類上繼承這個類ListUpdateByPrimaryKeySelectiveMapper就好了
|
1
2
|
public interface BaseMapper<T> extends Mapper<T>, MySqlMapper<T>, ListUpdateByPrimaryKeySelectiveMapper<T> {} |
總結
本篇文章就到這里了，希望能夠給你帶來幫助，也希望您能夠多多關注服務器之家的更多內容！
原文鏈接：https://blog.csdn.net/lanyanhua/article/details/121034603
