- 创建一个springboot项目
- 引入pom依赖
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.21</version>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.2</version>
</dependency>
- yml文件配置两个数据源
spring:
datasource:
primary:
jdbc-url: jdbc:mysql://localhost:3306/boot-shiro?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC&useSSL=false
username: root
password: 123456
driver-class-name: com.mysql.jdbc.Driver
secondary:
jdbc-url: jdbc:mysql://localhost:3306/how2java?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC&useSSL=false
username: root
password: 123456
driver-class-name: com.mysql.jdbc.Driver
- 创建主数据源配置类
@Configuration
@MapperScan(basePackages = "com.xlj.datasource.dao.one", sqlSessionFactoryRef = "PrimarySqlSessionFactory")
public class PrimaryDataSourceConfig {
@Primary
@Bean(name = "PrimaryDataSource")
@ConfigurationProperties(prefix = "spring.datasource.primary")
public DataSource getPrimaryDateSource() {
return DataSourceBuilder.create().build();
}
@Primary
@Bean(name = "PrimarySqlSessionFactory")
public SqlSessionFactory primarySqlSessionFactory(@Qualifier("PrimaryDataSource") DataSource datasource) throws Exception {
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.setDataSource(datasource);
return bean.getObject();
}
@Primary
@Bean(name = "PrimarySqlSessionTemplate")
public SqlSessionTemplate primarySqlSessionTemplate(@Qualifier("PrimarySqlSessionFactory") SqlSessionFactory sessionfactory) {
return new SqlSessionTemplate(sessionfactory);
}
}
- 创建次数据源配置类
@Configuration
@MapperScan(basePackages = "com.xlj.datasource.dao.two", sqlSessionFactoryRef = "SecondarySqlSessionFactory")
public class SecondaryDataSourceConfig {
@Bean(name = "SecondaryDataSource")
@ConfigurationProperties(prefix = "spring.datasource.secondary")
public DataSource getSecondaryDataSource() {
return DataSourceBuilder.create().build();
}
@Bean(name = "SecondarySqlSessionFactory")
public SqlSessionFactory secondarySqlSessionFactory(@Qualifier("SecondaryDataSource") DataSource datasource) throws Exception {
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.setDataSource(datasource);
return bean.getObject();
}
@Bean(name = "SecondarySqlSessionTemplate")
public SqlSessionTemplate secondarySqlSessionTemplate(@Qualifier("SecondarySqlSessionFactory") SqlSessionFactory sessionfactory) {
return new SqlSessionTemplate(sessionfactory);
}
}
- 编写主配置类对应的接口(此处使用注解方式编写sql,注意与主配置的
basePackages
对应)
@Mapper
public interface DatasourceOne {
@Insert("insert into data_test (name) values (\"test\")")
void insert();
}
- 编写次配置类对应的接口(此处使用注解方式编写sql,注意与主配置的
basePackages
对应)
@Mapper
public interface DatasourceTwo {
@Insert(" insert into data_test (name) values (\"test\")")
void insert();
}
- controller调用接口
@RestController
public class DataSourceController {
@Resource
private DatasourceOne datasourceOne;
@Resource
private DatasourceTwo datasourceTwo;
@GetMapping(value = "/insertOne")
public void insertOne(){
datasourceOne.insert();
}
@GetMapping(value = "/insertTwo")
public void insertTwo(){
datasourceTwo.insert();
}
}
- 启动springboot主main方法,进行接口测试