springboot整合多数据源(分布式、微服务)在一个项目中有多个jdbc连接
1>多数据源产生的问题:事务管理
2>在项目中如何搭建多数据源
两个数据源:test001 test002
1.分包结构
com.maker.test001---访问数据库testoo1
dao
service
controller
com.maker.test002---访问数据库testoo2
dao
service
controller
分布式事务解决方案 jta_automatic 传统项目
2.使用注解方式
com.maker
dao
service
class userService{
@Datasource001(自定义注解)
public void test001(){
}
@Datasource002(自定义注解)
public void test002(){
}
}
配置文件application.properties
1>配置多个数据源
###test001 datasource
spring.datasource.test001.driverClassName=com.mysql.jdbc.Driver
spring.datasource.test001.url=jdbc:mysql://localhost:3306/test001?useUnicode=true&characterEncoding=utf-8
spring.datasource.test001.username=root
spring.datasource.test001.password=root
###test002 datasource
spring.datasource.test002.driverClassName=com.mysql.jdbc.Driver
spring.datasource.test002.url=jdbc:mysql://localhost:3306/test002?useUnicode=true&characterEncoding=utf-8
spring.datasource.test002.username=root
spring.datasource.test002.password=root
2>配置并连接两个数据源
package com.maker.datasource;
import javax.sql.DataSource;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.autoconfigure.jdbc.DataSourceBuilder;
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 org.springframework.jdbc.datasource.DataSourceTransactionManager;
@Configuration//注册到springboot容器中
@MapperScan(basePackages="com.maker.test001",sqlSessionFactoryRef = "test001SessionFactory" )
public class DataSource001Config {
/**
* 配置test001数据库
* @return
*/
@Bean(name = "test001DataSource")
@Primary
@ConfigurationProperties(prefix="spring.datasource.test001")
public DataSource testDatasource() {
return DataSourceBuilder.create().build();
}
/**
* sql会话工厂
* @param dataSource
* @return
* @throws Exception
*/
@Primary
@Bean(name="test001SessionFactory")
public SqlSessionFactory testSqlSessionFactory(@Qualifier("test001DataSource") DataSource dataSource) throws Exception {
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.setDataSource(dataSource);
bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("mapper/*.xml"));
return bean.getObject();
}
/**
* 事务管理
* @param dataSource
* @return
*/
@Primary
@Bean(name="test001TransactionManager")
public DataSourceTransactionManager testTransactionManager(@Qualifier("test001DataSource") DataSource dataSource) {
return new DataSourceTransactionManager(dataSource);
}
@Bean(name="test001SessionTemplate")
@Primary
public SqlSessionTemplate test001SessionTemplate(@Qualifier("test001SessionFactory") SqlSessionFactory sqlSessionFactory) {
return new SqlSessionTemplate(sqlSessionFactory);
}
}
package com.maker.datasource;
import javax.sql.DataSource;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.autoconfigure.jdbc.DataSourceBuilder;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
@Configuration//注册到springboot容器中
@MapperScan(basePackages="com.maker.test002",sqlSessionFactoryRef = "test002SessionFactory" )
public class DataSource002Config {
/**
* 配置test002数据库
* @return
*/
@Bean(name = "test002DataSource")
@ConfigurationProperties(prefix="spring.datasource.test002")
public DataSource testDatasource() {
return DataSourceBuilder.create().build();
}
/**
* sql会话工厂
* @param dataSource
* @return
* @throws Exception
*/
@Bean(name="test002SessionFactory")
public SqlSessionFactory testSqlSessionFactory(@Qualifier("test002DataSource") DataSource dataSource) throws Exception {
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.setDataSource(dataSource);
bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("mapper/*.xml"));
return bean.getObject();
}
/**
* 事务管理
* @param dataSource
* @return
*/
@Bean(name="test002TransactionManager")
public DataSourceTransactionManager testTransactionManager(@Qualifier("test002DataSource") DataSource dataSource) {
return new DataSourceTransactionManager(dataSource);
}
@Bean(name="test002SessionTemplate")
public SqlSessionTemplate test002SessionTemplate(@Qualifier("test002SessionFactory") SqlSessionFactory sqlSessionFactory) {
return new SqlSessionTemplate(sqlSessionFactory);
}
}
1>多数据源产生的问题:事务管理
2>在项目中如何搭建多数据源
两个数据源:test001 test002
1.分包结构
com.maker.test001---访问数据库testoo1
dao
service
controller
com.maker.test002---访问数据库testoo2
dao
service
controller
分布式事务解决方案 jta_automatic 传统项目
2.使用注解方式
com.maker
dao
service
class userService{
@Datasource001(自定义注解)
public void test001(){
}
@Datasource002(自定义注解)
public void test002(){
}
}
配置文件application.properties
1>配置多个数据源
###test001 datasource
spring.datasource.test001.driverClassName=com.mysql.jdbc.Driver
spring.datasource.test001.url=jdbc:mysql://localhost:3306/test001?useUnicode=true&characterEncoding=utf-8
spring.datasource.test001.username=root
spring.datasource.test001.password=root
###test002 datasource
spring.datasource.test002.driverClassName=com.mysql.jdbc.Driver
spring.datasource.test002.url=jdbc:mysql://localhost:3306/test002?useUnicode=true&characterEncoding=utf-8
spring.datasource.test002.username=root
spring.datasource.test002.password=root
2>配置并连接两个数据源
package com.maker.datasource;
import javax.sql.DataSource;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.autoconfigure.jdbc.DataSourceBuilder;
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 org.springframework.jdbc.datasource.DataSourceTransactionManager;
@Configuration//注册到springboot容器中
@MapperScan(basePackages="com.maker.test001",sqlSessionFactoryRef = "test001SessionFactory" )
public class DataSource001Config {
/**
* 配置test001数据库
* @return
*/
@Bean(name = "test001DataSource")
@Primary
@ConfigurationProperties(prefix="spring.datasource.test001")
public DataSource testDatasource() {
return DataSourceBuilder.create().build();
}
/**
* sql会话工厂
* @param dataSource
* @return
* @throws Exception
*/
@Primary
@Bean(name="test001SessionFactory")
public SqlSessionFactory testSqlSessionFactory(@Qualifier("test001DataSource") DataSource dataSource) throws Exception {
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.setDataSource(dataSource);
bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("mapper/*.xml"));
return bean.getObject();
}
/**
* 事务管理
* @param dataSource
* @return
*/
@Primary
@Bean(name="test001TransactionManager")
public DataSourceTransactionManager testTransactionManager(@Qualifier("test001DataSource") DataSource dataSource) {
return new DataSourceTransactionManager(dataSource);
}
@Bean(name="test001SessionTemplate")
@Primary
public SqlSessionTemplate test001SessionTemplate(@Qualifier("test001SessionFactory") SqlSessionFactory sqlSessionFactory) {
return new SqlSessionTemplate(sqlSessionFactory);
}
}
package com.maker.datasource;
import javax.sql.DataSource;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.autoconfigure.jdbc.DataSourceBuilder;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
@Configuration//注册到springboot容器中
@MapperScan(basePackages="com.maker.test002",sqlSessionFactoryRef = "test002SessionFactory" )
public class DataSource002Config {
/**
* 配置test002数据库
* @return
*/
@Bean(name = "test002DataSource")
@ConfigurationProperties(prefix="spring.datasource.test002")
public DataSource testDatasource() {
return DataSourceBuilder.create().build();
}
/**
* sql会话工厂
* @param dataSource
* @return
* @throws Exception
*/
@Bean(name="test002SessionFactory")
public SqlSessionFactory testSqlSessionFactory(@Qualifier("test002DataSource") DataSource dataSource) throws Exception {
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.setDataSource(dataSource);
bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("mapper/*.xml"));
return bean.getObject();
}
/**
* 事务管理
* @param dataSource
* @return
*/
@Bean(name="test002TransactionManager")
public DataSourceTransactionManager testTransactionManager(@Qualifier("test002DataSource") DataSource dataSource) {
return new DataSourceTransactionManager(dataSource);
}
@Bean(name="test002SessionTemplate")
public SqlSessionTemplate test002SessionTemplate(@Qualifier("test002SessionFactory") SqlSessionFactory sqlSessionFactory) {
return new SqlSessionTemplate(sqlSessionFactory);
}
}