更新null

没事搞点事做serendipity

已于 2022-03-09 14:01:55 修改

阅读量392

点赞数 1

文章标签： MyBatis-Plus 全量更新自定义Sql注入器 Mapper接口 null字段

于 2022-02-25 13:52:57 首次发布

本文链接：https://blog.csdn.net/weixin_40118044/article/details/123131435

版权

watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rKh5LqL5pCe54K55LqL5YGac2VyZW5kaXBpdHk=,size_12,color_FFFFFF,t_70,g_se,x_16

watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rKh5LqL5pCe54K55LqL5YGac2VyZW5kaXBpdHk=,size_13,color_FFFFFF,t_70,g_se,x_16

watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rKh5LqL5pCe54K55LqL5YGac2VyZW5kaXBpdHk=,size_19,color_FFFFFF,t_70,g_se,x_16

public interface CommonMapper<T> extends BaseMapper<T> {

/**

* 全量更新，不忽略null字段，等价于update

* 解决mybatis-plus会自动忽略null字段不更新

* {@link com.baomidou.mybatisplus.extension.injector.methods.AlwaysUpdateSomeColumnById}

* @param entity

* @return

int alwaysUpdateSomeColumnById(@Param(Constants.ENTITY) T entity);

}

@Bean
public CustomSqlInjector customSqlInjector() {
return new CustomSqlInjector();
}

/**
* 自定义Sql注入器
*/
static class CustomSqlInjector extends MppSqlInjector {
@Override
public List<AbstractMethod> getMethodList(Class<?> mapperClass) {
List<AbstractMethod> methodList = super.getMethodList(mapperClass);
//增加全量更新
methodList.add(new AlwaysUpdateSomeColumnById());
return methodList;
}
}