1.配置文件:
spring.datasource.test.jdbc-url=jdbc:mysql://localhost:3306/test1?serverTimezon
e=UTC&useUnicode=true&characterEncoding=utf-8&useSSL=true
spring.datasource.test.username=root
spring.datasource.test.password=root
spring.datasource.test.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.test1.jdbc-url=jdbc:mysql://localhost:3306/test2?serverTimez
one=UTC&useUnicode=true&characterEncoding=utf-8&useSSL=true
spring.datasource.test1.username=root
spring.datasource.test1.password=root
spring.datasource.test1.driver-class-name=com.mysql.cj.jdbc.Driver
2.配置DataSource:
@Configuration // 注册到springboot容器中
@MapperScan(basePackages = "com.example.springboot.dao", sqlSessionFactoryRef = "testSqlSessionFactory")
public class DataSourceConfig {
@Bean(name = "testDataSource")
@Primary
@ConfigurationProperties(prefix = "spring.datasource.test")
public DataSource testDataSource() {
return DataSourceBuilder.create().build();
}
@Bean(name = "testSqlSessionFactory")
@Primary
public SqlSessionFactory testSqlSessionFactory(@Qualifier("testDataSource") DataSource dataSource)
throws Exception {
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.setDataSource(dataSource);
//扫描mapper文件
bean.setMapperLocations(
new PathMatchingResourcePatternResolver().getResources("classpath:mapper/test/*.xml"));
return bean.getObject();
}
@Bean(name = "testTransactionManager")
@Primary
public DataSourceTransactionManager testTransactionManager(@Qualifier("testDataSource") DataSource dataSource) {
return new DataSourceTransactionManager(dataSource);
}
@Bean(name = "testSqlSessionTemplate")
@Primary
public SqlSessionTemplate testSqlSessionTemplate(
@Qualifier("testSqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
return new SqlSessionTemplate(sqlSessionFactory);
}
}
@Configuration // 注册到springboot容器中
@MapperScan(basePackages = "com.example.springboot.dao1", sqlSessionFactoryRef = "testSqlSessionFactory1")
public class DataSourceConfig1 {
@Bean(name = "testDataSource1")
@ConfigurationProperties(prefix = "spring.datasource.test1")
public DataSource testDataSource() {
return DataSourceBuilder.create().build();
}
@Bean(name = "testSqlSessionFactory1")
public SqlSessionFactory testSqlSessionFactory(@Qualifier("testDataSource1") DataSource dataSource)
throws Exception {
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.setDataSource(dataSource);
//扫描mapper文件
bean.setMapperLocations(
new PathMatchingResourcePatternResolver().getResources("classpath:mapper/test1/*.xml"));
return bean.getObject();
}
@Bean(name = "testTransactionManager1")
public DataSourceTransactionManager testTransactionManager(@Qualifier("testDataSource1") DataSource dataSource) {
return new DataSourceTransactionManager(dataSource);
}
@Bean(name = "testSqlSessionTemplate1")
public SqlSessionTemplate testSqlSessionTemplate(
@Qualifier("testSqlSessionFactory1") SqlSessionFactory sqlSessionFactory) throws Exception {
return new SqlSessionTemplate(sqlSessionFactory);
}
}
注意:可能遇到的问题:
在配置数据源的时候spring.datasource.test1.url可能汇报找不到jdbc-url
这里要使用spring.datasource.jdbc-url,还有代码配置:
@Bean(name = "testDataSource")
@Primary
@ConfigurationProperties(prefix = "spring.datasource.test")
public DataSource testDataSource() {
return dataSourceProperties().initializeDataSourceBuilder().build();
}
@Bean(name = "dataSourceProperties")
@Primary
@ConfigurationProperties(prefix = "spring.datasource.test")
public DataSourceProperties dataSourceProperties(){
return new DataSourceProperties();
}