1.遇到的问题:
使用Mybatis-Plus自动填充时间属性的时候,自动填充的属性为null
2.代码
@Slf4j
@Component
public class MyMetaObjectHandler implements MetaObjectHandler {
@Override
public void insertFill(MetaObject metaObject) {
// log.info("start insert fill ....");
this.strictInsertFill(metaObject, "createTime", LocalDateTime.class, LocalDateTime.now()); // 起始版本 3.3.0(推荐使用)
this.strictInsertFill(metaObject, "operateTime", LocalDateTime.class, LocalDateTime.now()); // 起始版本 3.3.0(推荐使用)
}
@Override
public void updateFill(MetaObject metaObject) {
// log.info("start update fill ....");
this.strictUpdateFill(metaObject, "operateTime", LocalDateTime.class, LocalDateTime.now()); // 起始版本 3.3.0(推荐)
}
}
@TableField(value = "create_time",fill = FieldFill.INSERT)
private LocalDateTime createTime;
@TableField(value = "operate_time",fill = FieldFill.INSERT_UPDATE)
private LocalDateTime operateTime;
3.解决
按照正常情况来说此时已经可以正常生效了,我查询之后看网上说一般是数据类型的问题,但是我尝试之后都没有解决。
最终找到了下面的文章,发现多数据源配置的时候还需要多配置一步
https://blog.csdn.net/weixin_46040901/article/details/125305535?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522168376828316800188533117%2522%252C%2522scm%2522%253A%252220140713.130102334…%2522%257D&request_id=168376828316800188533117&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2allsobaiduend~default-2-125305535-null-null.142v86insert_down28v1,239v2insert_chatgpt&utm_term=Mybatis-Plus%E8%87%AA%E5%8A%A8%E5%A1%AB%E5%85%85%E5%A4%B1%E6%95%88&spm=1018.2226.3001.4187
我就把代码改成了下面样子
public SqlSessionFactory testSqlSessionFactory(@Qualifier("aiuiDataSource") DataSource dataSource) throws Exception {
MybatisSqlSessionFactoryBean bean = new MybatisSqlSessionFactoryBean();
bean.setDataSource(dataSource);
bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:mybatis/mapper/seai/*.xml"));
bean.getObject().getConfiguration().setMapUnderscoreToCamelCase(true);
bean.setGlobalConfig(new GlobalConfig().setBanner(false).setMetaObjectHandler(new MyMetaObjectHandler()));
return bean.getObject();
}
发现还是不行,最终我尝试性的把代码位置进行了调整:
public SqlSessionFactory testSqlSessionFactory(@Qualifier("aiuiDataSource") DataSource dataSource) throws Exception {
MybatisSqlSessionFactoryBean bean = new MybatisSqlSessionFactoryBean();
bean.setDataSource(dataSource);
bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:mybatis/mapper/seai/*.xml"));
bean.setGlobalConfig(new GlobalConfig().setBanner(false).setMetaObjectHandler(new MyMetaObjectHandler()));
bean.getObject().getConfiguration().setMapUnderscoreToCamelCase(true);
return bean.getObject();
}
最终生效了。
有大佬来讲一下为什么代码位置调整之后才可以生效吗?