首先是pom.xml,都是通用的,这里就不贴出来了。
其次就是application.properties配置,笔者因为不同的环境,所以新建了两个application-dev.properties和application-pro.properties配置文件。
application.properties:指定当前使用那个环境的配置.
spring.profiles.active=dev
application-dev.properties的配置(application-pro.properties类似dev的配置)
#datasource1 spring.datasource.username=** spring.datasource.password=***** spring.datasource.jdbc-url=jdbc:mysql://*************** useUnicode=true&characterEncoding=utf-8&useSSL=false spring.datasource.driver-class-name=com.mysql.jdbc.Driver #datasource2 spring.datasource.ds1.username=*** spring.datasource.ds1.password=****** spring.datasource.ds1.jdbc-url=jdbc:mysql://*************** useUnicode=true&characterEncoding=utf-8&useSSL=false spring.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().build(); }
以上就是JAVA开发之springBoot2.0搭建双数据源的详细内容,更多请关注php中文网其它相关文章!