JAVA开发之springBoot2.0搭建双数据源

最近因为项目需要，需要在程序中同时访问不同的数据库。之前使用springboot注解写代码确实方便快捷，但是如果需要自己需改其中的一些东西来方便自己使用，改起来有点烦，不知道从哪里入手。写个这个记录下。

首先是pom.xml，都是通用的，这里就不贴出来了。

其次就是application.properties配置，笔者因为不同的环境，所以新建了两个application-dev.properties和application-pro.properties配置文件。

application.properties：指定当前使用那个环境的配置.

spring.profiles.active=dev

application-dev.properties的配置(application-pro.properties类似dev的配置)

#datasource1spring.datasource.username=**spring.datasource.password=*****spring.datasource.jdbc-url=jdbc:mysql://***************useUnicode=true&characterEncoding=utf-8&useSSL=falsespring.datasource.driver-class-name=com.mysql.jdbc.Driver#datasource2spring.datasource.ds1.username=***spring.datasource.ds1.password=******spring.datasource.ds1.jdbc-url=jdbc:mysql://***************useUnicode=true&characterEncoding=utf-8&useSSL=falsespring.datasource.ds1.driver-class-name=com.mysql.jdbc.Drive

不同数据源的MyBatis (Config1)

@Configuration@MapperScan(basePackages = "com.pet.petgame2.mapper.dao", sqlSessionFactoryRef = "petgame2SessionFactory")public class Config1 {    @Bean(name = "petgame2")    @ConfigurationProperties(prefix = "spring.datasource")    @Primary    public DataSource dataSource(){        return DataSourceBuilder.create().build();    }    @Bean(name = "petgame2SessionFactory")    @Primary    public SqlSessionFactory sessionFactory(@Qualifier("petgame2") DataSource dataSource) throws Exception{        SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();        factoryBean.setDataSource(dataSource);        factoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:Mapper/pet2Mapper/*.xml"));        return factoryBean.getObject();    }    @Bean(name = "petgame2TransactionManager")    @Primary    public DataSourceTransactionManager transactionManager(@Qualifier("petgame2") DataSource dataSource){        return new DataSourceTransactionManager(dataSource);    }}

不同数据源的MyBatis (Config2)

@Configuration@MapperScan(basePackages = "com.pet.petgame2.mapper.dao2", sqlSessionFactoryRef = "petgamesqlSessionFactory")public class Config2 {    @Bean(name = "petgame")    @ConfigurationProperties(prefix = "spring.datasource.ds1")    public DataSource dataSource(){        return DataSourceBuilder.create().build();    }    @Bean(name = "petgamesqlSessionFactory")    public SqlSessionFactory sessionFactory(@Qualifier("petgame") DataSource dataSource) throws Exception{        SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();        factoryBean.setDataSource(dataSource);        factoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:Mapper/petMapper/*.xml"));        return factoryBean.getObject();    }    @Bean(name = "petgameTransactionManager")    public DataSourceTransactionManager transactionManager(@Qualifier("petgame") DataSource dataSource){        return new DataSourceTransactionManager(dataSource);    }}

@MapperScan注解会自动扫描mapper的接口文件， factoryBean.setMapperLocations会扫描mapper接口文件对应的Mapper.XML文件，注意这两个的路径不要写错。@Primary设定默认的一个数据库链接配置，必须指定其中一个数据源为默认。

*注意：如果使用了springboot2.0自带的Hikari作为连接池,需要注意properties中的

spring.datasource.url改为spring.datasource.jdbc-url

或者修改config中DataSource为DataSourceProperties，如下

@Bean(name = "petgame2DataSourceProperties")    @Qualifier("petgame2DataSourceProperties")    @ConfigurationProperties(prefix = "spring.datasource")    @Primary    public DataSourceProperties properties(){        return new DataSourceProperties();    }    @Bean(name = "petgame2")    @ConfigurationProperties(prefix = "spring.datasource")    @Primary    public DataSource dataSource(){//        return DataSourceBuilder.create().build();        return properties().initializeDataSourceBuilder<p style="color:transparent">本文来源gao!%daima.com搞$代*!码网1</p>().build();    }

以上就是JAVA开发之springBoot2.0搭建双数据源的详细内容，更多请关注搞代码gaodaima其它相关文章！

喜欢 (0)赏

[搞代码]

分享 (0)