一、目录结构
二、实现
1、DataSourceApp.java
package com.aeolusway;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
public class DataSourceApp {
public static void main(String[] args) {
SpringApplication.run(DataSourceApp.class, args);
}
}
2、UserController.java
package com.aeolusway.controller;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.aeolusway.mapper1.UserMapper1;
import com.aeolusway.mapper2.UserMapper2;
@RestController
public class UserController {
@Autowired
private UserMapper1 userMapper1;
@Autowired
private UserMapper2 userMapper2;
/*
* @Transactional 标注开启事务。
*
*/
// @Transactional
@RequestMapping("/add")
public String add() {
userMapper1.addUser1("数据源1", 20);
// int i = 1 / 0;
userMapper2.addUser2("数据源2", 39);
return "success";
}
}
3、DatasourceConfig1.java
package com.aeolusway.datasource;
import javax.sql.DataSource;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
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.jdbc.datasource.DataSourceTransactionManager;
@Configuration
@MapperScan(basePackages="com.aeolusway.mapper1",sqlSessionFactoryRef="sqlSessionFactory1")
public class DatasourceConfig1 {
/*
* 配置数据库
*/
@Bean(name="dataSource1")
@Primary
@ConfigurationProperties(prefix="spring.datasource.user1") //以配置文件中属性名称的前缀区分不同的数据源
public DataSource getDataSource(){
return DataSourceBuilder.create().build();
}
/*
* session 会话工厂
*/
@Bean(name="sqlSessionFactory1")
@Primary
public SqlSessionFactory getSqlSessionFactory(@Qualifier("dataSource1")DataSource dataSource) throws Exception{
//配置数据库
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.setDataSource(dataSource);
//如果不配置*mapper.xml 文件则不需要set
// bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:mybatis/mapper/test1/*.xml"));
return bean.getObject();
}
/*
* 事务管理
*/
public DataSourceTransactionManager getTransactionManager(@Qualifier("dataSource1")DataSource dataSource){
return new DataSourceTransactionManager(dataSource);
}
}
4、DatasourceConfig2.java
package com.aeolusway.datasource;
import javax.sql.DataSource;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
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
@MapperScan(basePackages="com.aeolusway.mapper2",sqlSessionFactoryRef="sqlSessionFactory2")
public class DatasourceConfig2 {
/*
* 配置数据库
*/
@Bean(name="dataSource2")
@ConfigurationProperties(prefix="spring.datasource.user2") //以配置文件中属性名称的前缀区分不同的数据源
public DataSource getDataSource(){
return DataSourceBuilder.create().build();
}
/*
* session 会话工厂
*/
@Bean(name="sqlSessionFactory2")
public SqlSessionFactory getSqlSessionFactory(@Qualifier("dataSource2")DataSource dataSource) throws Exception{
//配置数据库
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.setDataSource(dataSource);
//如果不配置*mapper.xml 文件则不需要set
// bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:mybatis/mapper/test1/*.xml"));
return bean.getObject();
}
/*
* 事务管理
*/
public DataSourceTransactionManager getTransactionManager(@Qualifier("dataSource2")DataSource dataSource){
return new DataSourceTransactionManager(dataSource);
}
}
5、UserMapper1.java
package com.aeolusway.mapper1;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
public interface UserMapper1 {
@Insert("insert into newuser values(null,#{name},#{age})")
int addUser1(@Param("name")String name,@Param("age")int age);
}
6、UserMapper2.java
package com.aeolusway.mapper2;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
public interface UserMapper2 {
@Insert("insert into newuser values(null,#{name},#{age})")
int addUser2(@Param("name")String name,@Param("age")int age);
}
7、application.properties
spring.datasource.user1.driver-class-name= com.mysql.jdbc.Driver
spring.datasource.user1.username=root
spring.datasource.user1.password=root
spring.datasource.user1.url=jdbc:mysql://localhost:3306/hibernate
spring.datasource.user2.driver-class-name= com.mysql.jdbc.Driver
spring.datasource.user2.username=root
spring.datasource.user2.password=root
spring.datasource.user2.url=jdbc:mysql://localhost:3306/hibernate2
8、pom.xml
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.aeolus</groupId>
<artifactId>SpringBoot-DataSource</artifactId>
<version>0.0.1-SNAPSHOT</version>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>1.4.0.RELEASE</version>
</parent>
<dependencies>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.21</version>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.0</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
</dependencies>
</project>
三、代码解析
1、UserController.java中的add()方法的事务分析
第一种情况:
@Transactional
@RequestMapping("/add")
public String add() {
userMapper1.addUser1("数据源1", 20);
int i = 1 / 0;
userMapper2.addUser2("数据源2", 39);
return "success";
}
第二种情况:
@Transactional
@RequestMapping("/add")
public String add() {
userMapper2.addUser2("数据源2", 39);
int i = 1 / 0;
userMapper1.addUser1("数据源1", 20);
return "success";
}
两种情况:在开启事务之后,手动产生异常并且改变两个不同数据源操作的执行顺序。最后查询数据库表的结果将会不一样。
分析: @Transactional,开启的是默认数据源datasource1的事务管理,所以能够管理的也只是datasource1数据源的操作。
第一种情况:首先执行了数据源1 的操作,之后遇到异常,程序不再往下执行,因此事务回滚,数据源1事务被回滚,数据源2因异常未执行。——>两个表都没有数据
第二种情况:首先执行数据源2 的操作,之后碰见异常,程序不再往下执行。所以数据源2中的表格插入了数据,而数据源1 的操作未执行。——>2表中有数据,1表中没有数据
也就是说:@Transactional 只能回滚数据源1(在DatasourceConfig1中的@Primary注解,便是设置默认数据源1)的事务,无法回滚数据源2 的事务
2、数据源和属性文件
1、
spring.datasource.user1.url=jdbc:mysql://localhost:3306/hibernate
2、
spring.datasource.user2.url=jdbc:mysql://localhost:3306/hibernate2
不同的数据源配置,是根据属性文件中属性名的前缀进行区分的。在DatasourceConfig 中有如下的注解:
@ConfigurationProperties(prefix="spring.datasource.user1")
@ConfigurationProperties(prefix="spring.datasource.user2")
3、数据源和包名
在DatasourceConfig类上有如下的注解:
@MapperScan(basePackages="com.aeolusway.mapper1")
指定的便是:供包mapper1下所有的mapper使用,因此不同的数据源操作是以包名为单位划分的。
四、注意事项
异常:No qualifying bean of type [javax.sql.DataSource] is defined: expected single matching bean but found 2
表示未设置默认数据源,在配置数据源的方法上(一般有多个方法)加上注解@Primary即可。