mybatis升级为mybatis-plus实现方案

1.背景

老项目是mybatis的,但是新项目想使用mybatis-plus,

故需要升级

2.实现步骤

步骤一:删除mybatis相关的依赖包

步骤二:导入mybatis-plus相关的包

com.baomidou mybatis-plus-boot-starter 3.0-RELEASE

步骤三:修改application.properties文件

其他配置不变

# mybatis配置
#mybatis.mapperLocations=classpath:mapper/*.xml
#mybatis.configuration.map-underscore-to-camel-case=true
#mybatis.configuration.call-setters-on-nulls=true
#pagehelper.helperDialect=oracle

mybatis-plus配置

mybatis-plus.mapper-locations=classpath:mapper/*.xml
mybatis-plus.global-config.db-config.db-type=oracle
mybatis-plus.global-config.db-config.field-strategy=not_empty
mybatis-plus.configuration.map-underscore-to-camel-case=true

步骤四:手动配置数据库对象(非充重要)

@Configuration
@MapperScan(basePackages = {"com.XXX.mapper"})
@EnableTransactionManagement
public class MybatisPlusConfig {
    /**
     * 性能分析拦截器，不建议生产使用
     */
//    @Bean
//    public PerformanceInterceptor performanceInterceptor(){
//        return new PerformanceInterceptor();
//    }

    /**
     * 分页插件
     */
    @Bean
    public PaginationInterceptor paginationInterceptor() {
        return new PaginationInterceptor();
    }

    /**
     * pagehelper的分页插件
     */
    @Bean
    public PageInterceptor pageInterceptor() {
        return new PageInterceptor();
    }

    @Bean
    public SqlSessionFactory sqlSessionFactory(DataSource dataSource) throws Exception {
        String mapperLocations = "classpath:mapper/*.xml";
        VFS.addImplClass(SpringBootVFS.class);
        final MybatisSqlSessionFactoryBean sessionFactory = new MybatisSqlSessionFactoryBean();
        sessionFactory.setDataSource(dataSource);
        sessionFactory.setMapperLocations(new PathMatchingResourcePatternResolver().getResources(mapperLocations));
        return sessionFactory.getObject();
    }
}

3.系统化学系mybatis-plus

mybatis-plus详细的图文教程 - 博客园

4.完美!