MybatisPlus updateById踩坑
提示:这里简述项目相关背景:
mybatisPlus,执行updateById,或者updateBatchById,报空指针异常
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error updating database. Cause: java.lang.NullPointerException
### The error may exist in club/caihappy/mapper/ArticleMapper.java (best guess)
### The error may involve club.caihappy.mapper.ArticleMapper.updateById
### The error occurred while executing an update
### Cause: java.lang.NullPointerException
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96) ~[mybatis-spring-2.0.7.jar:2.0.7]
at com.baomidou.mybatisplus.extension.toolkit.SqlHelper.executeBatch(SqlHelper.java:192) ~[mybatis-plus-extension-3.5.2.jar:3.5.2]
at com.baomidou.mybatisplus.extension.toolkit.SqlHelper.executeBatch(SqlHelper.java:217) ~[mybatis-plus-extension-3.5.2.jar:3.5.2]
at com.baomidou.mybatisplus.extension.service.impl.ServiceImpl.executeBatch(ServiceImpl.java:240) ~[mybatis-plus-extension-3.5.2.jar:3.5.2]
at com.baomidou.mybatisplus.extension.service.impl.ServiceImpl.updateBatchById(ServiceImpl.java:192) ~[mybatis-plus-extension-3.5.2.jar:3.5.2]
at com.baomidou.mybatisplus.extension.service.IService.updateBatchById(IService.java:268) ~[mybatis-plus-extension-3.5.2.jar:3.5.2]
at com.baomidou.mybatisplus.extension.service.IService$$FastClassBySpringCGLIB$$f8525d18.invoke(<generated>) ~[mybatis-plus-extension-3.5.2.jar:3.5.2]
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.7.jar:5.3.7]
解决方案:
这是做mybatisPlus自动填充配置的时候没有判断tokenid是否为空,因为这个接口是不需要前端携带token的,所有会报错
原代码: @Override
public void updateFill(MetaObject metaObject) {
this.setFieldValByName("updateTime", new Date(), metaObject);
this.setFieldValByName("updateBy", SecurityUtils.getUserId(), metaObject);
}
改后:
@Override
public void updateFill(MetaObject metaObject) {
this.setFieldValByName("updateTime", new Date(), metaObject);
if (Objects.nonNull(SecurityUtils.getUserId())) {
this.setFieldValByName("updateBy", SecurityUtils.getUserId(), metaObject);
}
}