@Configuration//mapper的包路径@MapperScan("com.mocha.framework.**.mapper"})publicclassMybatisPlusConfig{/*序列生成器/
@Bean
public OracleKeyGenerator oracleKeyGenerator() {
return new OracleKeyGenerator();
}
/*分页插件/
@Bean
public MybatisPlusInterceptor mybatisPlusInterceptor({
final MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
final PaginationInnerInterceptor paginationInnerInterceptor= new PaginationInnerInterceptor();
paginationInnerInterceptor.setDbType(DbType.ORACLE);
paginationInnerInterceptor.set0verflow(true);
interceptor.addInnerInterceptor(paginationInnerInterceptor);
final OptimisticLockerInnerInterceptor optimisticLockerInnerIntercepto = new OptimisticLockerInnerIntenceptor();
interceptor.addInnerInterceptor(optimisticLockerInnerInterceptor);
return interceptor;
}
}
@DS("userInfo")//指定第二个数据库,若使用默认数据库时不需要用该注释@MapperpublicinterfaceUserMapperextendsBaseMapper<UserPo>{@Select("SELECT u.* FROM user_info u")List<UserPo>selectListUserInfo();}