MybatisConfiguration (mybatis配置)导入驱动包和druid,略....
定义多个数据源,本项目只有一读一写(可以根据需要配置一写多读)
DruidDataBaseConfiguration.java
public class DruidDataBaseConfiguration {
/**
* 主库, 一般只用于写数据。 通过配置自动注入
* @return DataSource
*/
@Bean(name = "writeDataSource")
@ConfigurationProperties("spring.datasource.druid.master")
public DataSource masterDataSource() {
return DruidDataSourceBuilder.create().build();
}
/**
* 读库。通过配置自动注入
* @return
*/
@Bean(name = "readDataSource")
@ConfigurationProperties("spring.datasource.druid.slave")
public DataSource slaveDataSource() {
return DruidDataSourceBuilder.create().build();
}
/**
* 读库列表(目前本项目只有一个读库)
* @return
*/
@Bean(name = "readDataSources")
public List<DataSource> readDataSources() {
List<DataSource> dataSources = new ArrayList<>();
dataSources.add(slaveDataSource());
return dataSources;
}
}
application.properties
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
datasource.readSize=1
#主库配置
spring.datasource.druid.master.username=root
spring.datasource.druid.master.password=123456
spring.datasource.druid.master.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.druid.master.url=jdbc:mysql:///master...
spring.datasource.druid.master.initialSize=5
spring.datasource.druid.master.minIdle=5
spring.datasource.druid.master.maxActive=20
#读库配置
spring.datasource.druid.slave.username=root
spring.datasource.druid.slave.password=123456
spring.datasource.druid.slave.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.druid.slave.url=jdbc:mysql:///slave...
spring.datasource.druid.slave.initialSize=5
spring.datasource.druid.slave.minIdle=5
spring.datasource.druid.slave.maxActive=20
DataSourceType.java(枚举)
DataSourceContextHolder.java&#x