shardingsphere 4.1新版 如何配置mybatis多数据源
pom文件引入
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>sharding-jdbc-spring-boot-starter</artifactId>
<version>4.1.1</version>
</dependency>
<!-- tk mybatis -->
<dependency>
<groupId>tk.mybatis</groupId>
<artifactId>mapper</artifactId>
<version>4.1.5</version>
</dependency>
<!-- pagehelper 分页 -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.10</version>
</dependency>
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.1.8</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.3</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
Yml配
置为
server:
port: 8080
spring:
application:
name: demo2021
datasource:
ds1:
driver-class-name: com.mysql.cj.jdbc.Driver
name: defaultDataSource
password:
url:
username:
shardingsphere:
dataSource:
names: ds0,ds1
ds0:
jdbc-url:
driver-class-name: com.mysql.cj.jdbc.Driver
password:
type: com.zaxxer.hikari.HikariDataSource
username:
ds1:
jdbc-url:
driver-class-name: com.mysql.cj.jdbc.Driver
password:
type: com.zaxxer.hikari.HikariDataSource
username:
如代码中所见, 配置了一个普通不分库的数据源, 和shardingsphere分库的数据源, 分了2个库ds0和ds1
配置不分库的数据源
import javax.sql.DataSource;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.autoconfigure.jdbc.DataSourceProperties;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
/**
* 普通数据库数据源
*
* @author zhaolei
* @date 2020年12月3日
*
*/
@Configuration
public class DataSourceConfig {
// 主数据源配置 ds1数据源
@Primary
@Bean(name = "ds1DataSourceProperties")
@ConfigurationProperties(prefix = "spring.datasource.ds1")
public DataSourceProperties ds1DataSourceProperties() {
return new DataSourceProperties();
}
// 主数据源 ds1数据源
@Primary
@Bean(name = "ds1DataSource")
public DataSource ds1DataSource(@Qualifier("ds1DataSourceProperties") DataSourceProperties dataSourceProperties) {
return dataSourceProperties.initializeDataSourceBuilder().build();
}
}
对应的mybatisconfig如下:
import javax.sql.DataSource;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import tk.mybatis.spring.annotation.MapperScan;
/**
* mybatis 非分库分表配置
*
* @author zhaolei
* @date 2020年12月3日
*
*/
@Configuration
@MapperScan(basePackages = "com.normal.demo2021.mapper", properties = "style=normal", sqlSessionTemplateRef