1:先将Application(启动类)的自动扫描给注掉,不然自己配置的多数据源不起作用
//@MapperScan({"**.demo.system.**"})
2:再配置文件里面 spring.datasource.* 系列, 根据数据库的数据量, 改成 spring.datasource.data1.* spring.datasource.data2* 系列(data1,data2之类为自己给数据库起的名字)
3 创建 将原先数据库的 mapper,service,impl等 改成 data1.mapper,data1.service,data1.impl 和 data2.mapper,data2.service,data2.impl
4创建配置 ,DataSource1,DataSource2 分别代表两个服务器
DataSource1里面代码内容:
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.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import tk.mybatis.spring.annotation.MapperScan;
import javax.sql.DataSource;
@Configuration
@MapperScan(basePackages = "这个指向你刚刚创建的data1路径如//com.demo.system.data1", sqlSessionFactoryRef = "data1SqlSessionFactory")
public class DataSource1 {
/**
* 返回data1数据库的数据源
*
* @return
*/
@Bean(name = "data1Source")
@Primary//主数据源
@ConfigurationProperties(prefix = "spring.datasource.data1")
public DataSource dataSource() {
return DataSourceBuilder.create().build();
}
/**
* 返回data1数据库的会话工厂
*
* @param ds
* @return
* @throws Exception
*/
@Bean(name = "data1SqlSessionFactory")
@Primary
public SqlSessionFactory sqlSessionFactory(@Qualifier("data1Source") DataSource ds) throws Exception {
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.setDataSource(ds);
return bean.getObject();
}
/**
* 返回data1数据库的会话模板
*
* @param sessionFactory
* @return
* @throws Exception
*/
@Bean(name = "data1SqlSessionTemplate")
@Primary
public SqlSessionTemplate sqlSessionTemplate(@Qualifier("data1SqlSessionFactory") SqlSessionFactory sessionFactory) throws Exception {
return new SqlSessionTemplate(sessionFactory);
}
/**
* 返回data1数据库的事务
*
* @param ds
* @return
*/
@Bean(name = "data1TransactionManager")
@Primary
public DataSourceTransactionManager transactionManager(@Qualifier("data1Source") DataSource ds) {
return new DataSourceTransactionManager(ds);
}
}
DataSource2里面代码内容:
| ||
|
1:先将Application(启动类)的自动扫描给注掉,不然自己配置的多数据源不起作用
//@MapperScan({"**.demo.system.**"})
2:再配置文件里面 spring.datasource.* 系列, 根据数据库的数据量, 改成 spring.datasource.data1.* spring.datasource.data2* 系列(data1,data2之类为自己给数据库起的名字)
3 创建 将原先数据库的 mapper,service,impl等 改成 data1.mapper,data1.service,data1.impl 和 data2.mapper,data2.service,data2.impl
4创建配置 ,DataSource1,DataSource2 分别代表两个服务器
DataSource1里面代码内容:
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.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import tk.mybatis.spring.annotation.MapperScan;
import javax.sql.DataSource;
@Configuration
@MapperScan(basePackages = "这个指向你刚刚创建的data1路径如//com.demo.system.data1", sqlSessionFactoryRef = "data1SqlSessionFactory")
public class DataSource1 {
/**
* 返回data1数据库的数据源
*
* @return
*/
@Bean(name = "data1Source")
@Primary//主数据源
@ConfigurationProperties(prefix = "spring.datasource.data1")
public DataSource dataSource() {
return DataSourceBuilder.create().build();
}
/**
* 返回data1数据库的会话工厂
*
* @param ds
* @return
* @throws Exception
*/
@Bean(name = "data1SqlSessionFactory")
@Primary
public SqlSessionFactory sqlSessionFactory(@Qualifier("data1Source") DataSource ds) throws Exception {
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.setDataSource(ds);
return bean.getObject();
}
/**
* 返回data1数据库的会话模板
*
* @param sessionFactory
* @return
* @throws Exception
*/
@Bean(name = "data1SqlSessionTemplate")
@Primary
public SqlSessionTemplate sqlSessionTemplate(@Qualifier("data1SqlSessionFactory") SqlSessionFactory sessionFactory) throws Exception {
return new SqlSessionTemplate(sessionFactory);
}
/**
* 返回data1数据库的事务
*
* @param ds
* @return
*/
@Bean(name = "data1TransactionManager")
@Primary
public DataSourceTransactionManager transactionManager(@Qualifier("data1Source") DataSource ds) {
return new DataSourceTransactionManager(ds);
}
}
DataSource2里面代码内容:
| ||
|
1:先将Application(启动类)的自动扫描给注掉,不然自己配置的多数据源不起作用
//@MapperScan({"**.demo.system.**"})
2:再配置文件里面 spring.datasource.* 系列, 根据数据库的数据量, 改成 spring.datasource.data1.* spring.datasource.data2* 系列(data1,data2之类为自己给数据库起的名字)
3 创建 将原先数据库的 mapper,service,impl等 改成 data1.mapper,data1.service,data1.impl 和 data2.mapper,data2.service,data2.impl
4创建配置 ,DataSource1,DataSource2 分别代表两个服务器
DataSource1里面代码内容:
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.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import tk.mybatis.spring.annotation.MapperScan;
import javax.sql.DataSource;
@Configuration
@MapperScan(basePackages = "这个指向你刚刚创建的data1路径如//com.demo.system.data1", sqlSessionFactoryRef = "data1SqlSessionFactory")
public class DataSource1 {
/**
* 返回data1数据库的数据源
*
* @return
*/
@Bean(name = "data1Source")
@Primary//主数据源
@ConfigurationProperties(prefix = "spring.datasource.data1")
public DataSource dataSource() {
return DataSourceBuilder.create().build();
}
/**
* 返回data1数据库的会话工厂
*
* @param ds
* @return
* @throws Exception
*/
@Bean(name = "data1SqlSessionFactory")
@Primary
public SqlSessionFactory sqlSessionFactory(@Qualifier("data1Source") DataSource ds) throws Exception {
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.setDataSource(ds);
return bean.getObject();
}
/**
* 返回data1数据库的会话模板
*
* @param sessionFactory
* @return
* @throws Exception
*/
@Bean(name = "data1SqlSessionTemplate")
@Primary
public SqlSessionTemplate sqlSessionTemplate(@Qualifier("data1SqlSessionFactory") SqlSessionFactory sessionFactory) throws Exception {
return new SqlSessionTemplate(sessionFactory);
}
/**
* 返回data1数据库的事务
*
* @param ds
* @return
*/
@Bean(name = "data1TransactionManager")
@Primary
public DataSourceTransactionManager transactionManager(@Qualifier("data1Source") DataSource ds) {
return new DataSourceTransactionManager(ds);
}
}
DataSource2里面代码内容:
package com.example.demo.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.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import tk.mybatis.spring.annotation.MapperScan;
import javax.sql.DataSource;
@Configuration//注解到spring容器中
@MapperScan(basePackages = "com.example.demo.system.data2", sqlSessionFactoryRef = "data2SqlSessionFactory")
public class DataSource2 {
/**
* 返回data2数据库的数据源
*
* @return
*/
@Bean(name = "data2Source")
@ConfigurationProperties(prefix = "spring.datasource.data2")
public DataSource dataSource() {
return DataSourceBuilder.create().build();
}
/**
* 返回data2数据库的会话工厂
*
* @param ds
* @return
* @throws Exception
*/
@Bean(name = "data2SqlSessionFactory")
public SqlSessionFactory sqlSessionFactory(@Qualifier("data2Source") DataSource ds) throws Exception {
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.setDataSource(ds);
return bean.getObject();
}
/**
* 返回data2数据库的会话模板
*
* @param sessionFactory
* @return
* @throws Exception
*/
@Bean(name = "data2SqlSessionTemplate")
public SqlSessionTemplate sqlSessionTemplate(@Qualifier("data2SqlSessionFactory") SqlSessionFactory sessionFactory) throws Exception {
return new SqlSessionTemplate(sessionFactory);
}
/**
* 返回data2数据库的事务
*
* @param ds
* @return
*/
@Bean(name = "data2TransactionManager")
public DataSourceTransactionManager transactionManager(@Qualifier("data2Source") DataSource ds) {
return new DataSourceTransactionManager(ds);
}
}
最后直接调用指定路径的 方法,就能完成相应的数据库匹配