mybatis-plus多数据源(官方框架目前已经支持,使用更简单,推荐)
1.项目结构
项目结构说明如下
config包中放置数据源配置类
mapper包中放置dao层接口
resources/main包中放置主数据库dao层xml文件
resources/second包中放置主数据库dao层xml文件
2.搭建环境
开发工具:idea
数据库:mysql5.6
Maven:maven3
3.正文
3.1 pom.xml依赖
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.1.6.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<properties>
<java.version>1.8</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<!-- mybatis-plus-->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.0.5</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<!-- alibaba的druid数据库连接池 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.14</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!-- mybatis-plus自动化工具需要的依赖 模板-->
<dependency>
<groupId>org.apache.velocity</groupId>
<artifactId>velocity-engine-core</artifactId>
<version>2.0</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-configuration-processor</artifactId>
<optional>true</optional>
</dependency>
</dependencies>
3.2 配置文件的编写
application.properties配置文件内容
spring.application.name=datasource-double
server.port=8885
spring.profiles.active=dev
application-dev.properties配置文件内容
#main
spring.datasource.main.name=main
spring.datasource.main.url=jdbc:mysql://localhost:3306/main?useSSL=true&&characterEncoding=UTF-8&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai
spring.datasource.main.username=root
spring.datasource.main.password=root
spring.datasource.main.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.main.driver-class-name=com.mysql.cj.jdbc.Driver
#second
spring.datasource.second.name=second
spring.datasource.second.url=jdbc:mysql://localhost:3306/second?useSSL=true&&characterEncoding=UTF-8&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai
spring.datasource.second.username=root
spring.datasource.second.password=root
spring.datasource.second.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.second.driver-class-name=com.mysql.cj.jdbc.Driver
3.3数据源配置类的编写
主数据源
import com.alibaba.druid.pool.DruidDataSource;
import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean;
import maven.template.spring.boot.datasource.utils.DataSourceProperties;
import org.apache.ibatis.plugin.Interceptor;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Qualifier;
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;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import javax.sql.DataSource;
/**
* @author dxw
* @ClassName MainDataSourceConfig.java
* @Description
* @createTime 2019-07-02 10:09
*/
@Configuration
@MapperScan(basePackages = "maven.template.spring.boot.datasource.mapper.main", sqlSessionFactoryRef = "mainSqlSessionFactory")
public class MainDataSourceConfig {
@Bean("mainSqlSessionTemplate")
public SqlSessionTemplate mainSqlSessionTemplate(
@Qualifier("mainSqlSessionFactory") SqlSessionFactory sqlSessionFactory) {
return new SqlSessionTemplate(sqlSessionFactory);
}
@Bean("mainSqlSessionFactory")
@Primary
public SqlSessionFactory sqlSessionFactory(@Qualifier("mainDataSource") DataSource dataSource,@Qualifier("mainPaginationInterceptor") PaginationInterceptor paginationInterceptor) throws Exception {
MybatisSqlSessionFactoryBean sqlSessionFactoryBean = new MybatisSqlSessionFactoryBean();
sqlSessionFactoryBean.setDataSource(dataSource);
sqlSessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:main/*.xml"));
Interceptor[] plugins = new Interceptor[]{paginationInterceptor};
sqlSessionFactoryBean.setPlugins(plugins);
return sqlSessionFactoryBean.getObject();
}
@Bean("mainPaginationInterceptor")
public PaginationInterceptor paginationInterceptor() {
return new PaginationInterceptor();
}
@Bean("mainDataSource")
public DataSource mainDataSource(@Qualifier("mainDataSourceProperties") DataSourceProperties dataSourceProperties) {
DruidDataSource druidDataSource = new DruidDataSource();
druidDataSource.setDriverClassName(dataSourceProperties.getDriverClassName());
druidDataSource.setUrl(dataSourceProperties.getUrl());
druidDataSource.setName(dataSourceProperties.getName());
druidDataSource.setUsername(dataSourceProperties.getUsername());
druidDataSource.setPassword(dataSourceProperties.getPassword());
return druidDataSource;
}
@Bean("mainDataSourceProperties")
@ConfigurationProperties(prefix = "spring.datasource.main")
public DataSourceProperties mainDataSourceProperties() {
return new DataSourceProperties();
}
}
次数据源
import com.alibaba.druid.pool.DruidDataSource;
import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean;
import maven.template.spring.boot.datasource.utils.DataSourceProperties;
import org.apache.ibatis.mapping.Environment;
import org.apache.ibatis.plugin.Interceptor;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.apache.ibatis.transaction.TransactionFactory;
import org.apache.ibatis.transaction.jdbc.JdbcTransactionFactory;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.PropertySource;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import javax.sql.DataSource;
import java.io.IOException;
/**
* @author dxw
* @ClassName AppConfig.java
* @Description 应用配置类
* @createTime 2019-07-01 16:49
*/
@Configuration
@MapperScan(basePackages = "maven.template.spring.boot.datasource.mapper.second", sqlSessionFactoryRef = "secondSqlSessionFactory")
public class SecondDataSourceConfig {
@Bean("secondSqlSessionTemplate")
public SqlSessionTemplate test2sqlsessiontemplate(
@Qualifier("secondSqlSessionFactory") SqlSessionFactory sessionfactory) {
return new SqlSessionTemplate(sessionfactory);
}
@Bean("secondSqlSessionFactory")
public SqlSessionFactory sqlSessionFactory(@Qualifier("secondDataSource") DataSource dataSource, @Qualifier("secondPaginationInterceptor")PaginationInterceptor paginationInterceptor) throws Exception {
MybatisSqlSessionFactoryBean sqlSessionFactoryBean = new MybatisSqlSessionFactoryBean();
sqlSessionFactoryBean.setDataSource(dataSource);
sqlSessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:second/*.xml"));
Interceptor[] plugins = new Interceptor[]{paginationInterceptor};
sqlSessionFactoryBean.setPlugins(plugins);
return sqlSessionFactoryBean.getObject();
}
@Bean("secondPaginationInterceptor")
public PaginationInterceptor paginationInterceptor() {
return new PaginationInterceptor();
}
@Bean("secondDataSource")
public DataSource getSecondDataSource(@Qualifier("secondDataSourceProperties") DataSourceProperties dataSourceProperties) {
DruidDataSource druidDataSource = new DruidDataSource();
druidDataSource.setDriverClassName(dataSourceProperties.getDriverClassName());
druidDataSource.setUrl(dataSourceProperties.getUrl());
druidDataSource.setName(dataSourceProperties.getName());
druidDataSource.setUsername(dataSourceProperties.getUsername());
druidDataSource.setPassword(dataSourceProperties.getPassword());
return druidDataSource;
}
@Bean("secondDataSourceProperties")
@ConfigurationProperties(prefix = "spring.datasource.second")
public DataSourceProperties secondDataSourceProperties() {
return new DataSourceProperties();
}
}
数据源配置类中用到自定义类DataSourceProperties
import org.springframework.beans.factory.annotation.Value;
/**
* @author dxw
* @ClassName DataSourceProperties.java
* @Description 数据源配置项工具
* @createTime 2019-07-01 17:02
*/
public class DataSourceProperties {
String name;
String url;
String username;
String password;
String driverClassName;
public String getName() {
return name;
}
@Value("name")
public void setName(String name) {
this.name = name;
}
public String getUrl() {
return url;
}
@Value("url")
public void setUrl(String url) {
this.url = url;
}
public String getUsername() {
return username;
}
@Value("username")
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
@Value("password")
public void setPassword(String password) {
this.password = password;
}
public String getDriverClassName() {
return driverClassName;
}
@Value("driver-class-name")
public void setDriverClassName(String driverClassName) {
this.driverClassName = driverClassName;
}
@Override
public String toString() {
return "DataSourceProperties{" +
"name='" + name + '\'' +
", url='" + url + '\'' +
", username='" + username + '\'' +
", password='" + password + '\'' +
", driverClassName='" + driverClassName + '\'' +
'}';
}
}
3.4启动类
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration;
import org.springframework.boot.autoconfigure.jdbc.DataSourceTransactionManagerAutoConfiguration;
import org.springframework.boot.context.properties.EnableConfigurationProperties;
@SpringBootApplication
@EnableConfigurationProperties
@EnableAutoConfiguration(exclude = {DataSourceAutoConfiguration.class,DataSourceTransactionManagerAutoConfiguration.class})
//, MybatisAutoConfiguration.class
public class SpringBootDatasourceDoubleApplication {
public static void main(String[] args) {
SpringApplication.run(SpringBootDatasourceDoubleApplication.class, args);
}
}
启动类中需要将spring的默认数据源bean排除在外
3.5其他类的编写
略 可以使用mybatis-plus的自动化生成工具
3.6测试
测试类编写
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import maven.template.spring.boot.datasource.mapper.main.MainMapper;
import maven.template.spring.boot.datasource.mapper.second.SecondMapper;
import maven.template.spring.boot.datasource.utils.DataSourceProperties;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;
@RunWith(SpringRunner.class)
@SpringBootTest
public class SpringBootDatasourceDoubleApplicationTests {
@Autowired
MainMapper mainMapper;
@Autowired
SecondMapper secondMapper;
@Test
public void testDoubleDataSource() {
//测试多数据源
System.out.println(mainMapper.selectCount(new QueryWrapper<>()));
System.out.println(secondMapper.selectCount(new QueryWrapper<>()));
}
@Test
public void testPagePlugin(){
//测试分页插件
System.out.println(mainMapper.selectPage(new Page<>(1, 1), new QueryWrapper<>()));
System.out.println(secondMapper.selectPage(new Page<>(1, 1), new QueryWrapper<>()));
}
@Test
public void testStatement(){
//测试自定义语句
System.out.println(mainMapper.selectByMain(1));
System.out.println(secondMapper.selectBySecond(2));
}
}
数据库数据second的second表
数据库数据main的main表
测试多数据源结果
测试分页插件结果
测试自定义语句