1在数据库中建立两个数据库连接,一个叫做logs,一个叫做order
建表脚本如下:
#logs数据库中
CREATE TABLE `log_info` (
`id` int(11) NOT NULL,
`create_time` datetime DEFAULT NULL,
`content` longtext,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#order数据库中
CREATE TABLE `order_info` (
`id` int(11) NOT NULL,
`money` double NOT NULL,
`user_id` varchar(20) DEFAULT NULL,
`address` varchar(200) DEFAULT NULL,
`create_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
最终效果如下:
2.新建一个springboot项目,导入如下依赖
1.导入如下pom.xml
<?xml version="1.0" encoding="UTF-8"?>
<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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.2.1.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.cd</groupId>
<artifactId>jta</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>jta</name>
<description>Demo project for Spring Boot</description>
<properties>
<java.version>1.8</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<!--lombok -->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<!-- mysql -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.0</version>
</dependency>
<!-- 引入atomikos -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jta-atomikos</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
<exclusions>
<exclusion>
<groupId>org.junit.vintage</groupId>
<artifactId>junit-vintage-engine</artifactId>
</exclusion>
</exclusions>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-configuration-processor</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.20</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
<configuration>
<excludes>
<exclude>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</exclude>
</excludes>
</configuration>
</plugin>
</plugins>
</build>
</project>
2.编写实体类
LogInfo.java
package com.cd.pojo;
import lombok.Data;
import java.util.Date;
@Data
public class LogInfo {
private Integer id;
private Date createTime;
private String content;
}
OrderInfo
package com.cd.pojo;
import lombok.Data;
import java.util.Date;
@Data
public class OrderInfo {
private Integer id;
private Double money;
private String userId;
private String address;
private Date createTime;
}
3.编写mapper层接口
LogMapper
package com.cd.log.mapper;
import com.cd.pojo.LogInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Component;
import java.util.List;
@Mapper
@Component
public interface LogMapper {
/**
* 新增
* @param logInfo
* @return
*/
int insertLogInfo(LogInfo logInfo);
/**
* 批量新增
* @param logInfoList
* @return
*/
int insertBatchLogs(@Param("logInfoList") List<LogInfo> logInfoList);
}
对应LogMapper.如下
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.cd.log.mapper.LogMapper">
<insert id="insertLogInfo">
insert into log_info(id,create_time,content) values(#{id},#{createTime},#{content})
</insert>
<insert id="insertBatchLogs">
insert into log_info
(id,create_time,content)
values
<foreach collection="logInfoList" item="log" index="index" separator=",">
(#{log.id},#{log.createTime},#{log.content})
</foreach>
</insert>
</mapper>
OrderMapper.java
package com.cd.order.mapper;
import com.cd.pojo.OrderInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Component;
import java.util.List;
@Mapper
@Component
public interface OrderMapper {
/**
* 新增
*
* @param orderInfo
* @return
*/
int insertOrderInfo(OrderInfo orderInfo);
/**
* 批量新增
*
* @param orderInfos
* @return
*/
int insertBatchOrder(@Param("orderInfos") List<OrderInfo> orderInfos);
}
对应OrderMapper.xml如下
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.cd.order.mapper.OrderMapper">
<insert id="insertOrderInfo">
insert into order_info(id,money,user_id,address,create_time)
values(#{id},#{money},#{userId},#{address},#{createTime})
</insert>
<insert id="insertBatchOrder">
insert into order_info
(id,money,user_id,address,create_time)
values
<foreach collection="orderInfos" item="order" index="index" separator=",">
(#{order.id},#{order.money},#{order.userId},#{order.address},#{order.createTime})
</foreach>
</insert>
</mapper>
4.编写service层接口
OrderService.java
package com.cd.service;
import com.cd.pojo.OrderInfo;
public interface OrderService {
/**
* 新增
* @param orderInfo
*/
void addOrder(OrderInfo orderInfo);
}
对应实现类
package com.cd.service.impl;
import com.cd.log.mapper.LogMapper;
import com.cd.order.mapper.OrderMapper;
import com.cd.pojo.LogInfo;
import com.cd.pojo.OrderInfo;
import com.cd.service.OrderService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import javax.transaction.Transactional;
import java.util.Date;
import java.util.Random;
@Slf4j
@Service
@Transactional(rollbackOn = Exception.class)
public class OrderServiceImpl implements OrderService {
@Autowired
private OrderMapper orderMapper;
@Autowired
private LogMapper logMapper;
@Override
public void addOrder(OrderInfo orderInfo) {
int insert = orderMapper.insertOrderInfo(orderInfo);
log.info("order库新增sql执行条数:{}",insert);
//测试1 异常回滚
int i=1/0;
LogInfo logInfo=new LogInfo();
logInfo.setId((new Random().nextInt()));
logInfo.setCreateTime(new Date());
logInfo.setContent(orderInfo.toString());
int insert1 = logMapper.insertLogInfo(logInfo);
log.info("logs库新增sql执行条数:{}",insert1);
//测试2 异常回滚
// int i=1/0;
}
}
配置类(由于只用了两个数据源,这里就有两个读取springboot主配置类的两个类:)
package com.cd.config;
import lombok.Data;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.stereotype.Component;
/**
* 数据源1配置类
* 用于读取配置文件自定义配置
*
*
*/
@Component
@Data
@ConfigurationProperties(prefix = "spring.datasource.druid.master")
public class DBConfig {
private String url;
private String username;
private String password;
}
package com.cd.config;
import lombok.Data;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.stereotype.Component;
/**
* 数据源2配置类
* 用于读取配置文件自定义配置
*/
@Component
@Data
@ConfigurationProperties(prefix = "spring.datasource.druid.slave")
public class DBConfig2 {
private String url;
private String username;
private String password;
}
使用xa数据源统一管理配置信息,每一个数据源对应一个SqlSessionFactoryBean;并且管理各自的mapper,然后配置全局的事务管理器,并将事务管理器纳入到spring容器当中;
package com.cd.config;
import com.mysql.cj.jdbc.MysqlXADataSource;
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.context.properties.ConfigurationProperties;
import org.springframework.boot.jta.atomikos.AtomikosDataSourceBean;
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;
import java.sql.SQLException;
@Configuration
@MapperScan(basePackages = "com.cd.order.mapper",
sqlSessionFactoryRef = "firstSqlSessionFactory"
)
public class MybatisDatasourceConfig {
@Primary
@Bean(name = "firstDataSource")
public DataSource firstDataSource(DBConfig config) throws SQLException {
//获取mysqlXaDataSource
MysqlXADataSource mysqlXaDataSource = new MysqlXADataSource();
//数据源配置
mysqlXaDataSource.setUrl(config.getUrl());
mysqlXaDataSource.setPinGlobalTxToPhysicalConnection(true);
mysqlXaDataSource.setPassword(config.getPassword());
mysqlXaDataSource.setUser(config.getUsername());
mysqlXaDataSource.setPinGlobalTxToPhysicalConnection(true);
//将mysql数据源交由Atomikos统一管理
AtomikosDataSourceBean xaDataSource = new AtomikosDataSourceBean();
xaDataSource.setXaDataSource(mysqlXaDataSource);
xaDataSource.setUniqueResourceName("firstDataSource1");
return xaDataSource;
}
/**
* 设置SqlSessionFactory,每一个数据源一个SqlSessionFactoryBean
*
* @param dataSource
* @return
* @throws Exception
*/
@Bean(name = "firstSqlSessionFactory")
public SqlSessionFactory firstSqlSessionFactory(@Qualifier("firstDataSource") DataSource dataSource) throws Exception {
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.setDataSource(dataSource);
bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:/mapper/order/*.xml"));
return bean.getObject();
}
@Bean(name = "firstSqlSessionTemplate")
public SqlSessionTemplate testSqlSessionTemplate(
@Qualifier("firstSqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
return new SqlSessionTemplate(sqlSessionFactory);
}
}
package com.cd.config;
import com.mysql.cj.jdbc.MysqlXADataSource;
import lombok.Data;
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.context.properties.ConfigurationProperties;
import org.springframework.boot.jta.atomikos.AtomikosDataSourceBean;
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;
import java.sql.SQLException;
/**
* @author Lucifer
*/
@Configuration
@MapperScan(basePackages = "com.cd.log.mapper",
sqlSessionFactoryRef = "secondSqlSessionFactory"
)
public class MybatisDatasourceConfig2 {
@Bean(name = "secondDataSource")
public DataSource secondDataSource(DBConfig2 config2) throws SQLException {
//获取mysqlXaDataSource
MysqlXADataSource mysqlXaDataSource = new MysqlXADataSource();
//配置数据源
mysqlXaDataSource.setUrl(config2.getUrl());
mysqlXaDataSource.setPinGlobalTxToPhysicalConnection(true);
mysqlXaDataSource.setPassword(config2.getPassword());
mysqlXaDataSource.setUser(config2.getUsername());
mysqlXaDataSource.setPinGlobalTxToPhysicalConnection(true);
//将mysql数据源交由Atomikos统一管理
AtomikosDataSourceBean xaDataSource = new AtomikosDataSourceBean();
xaDataSource.setXaDataSource(mysqlXaDataSource);
xaDataSource.setUniqueResourceName("secondDataSource");
return xaDataSource;
}
/**
* 设置SqlSessionFactory,每一个数据源一个SqlSessionFactoryBean
*
* @param dataSource
* @return
* @throws Exception
*/
@Bean(name = "secondSqlSessionFactory")
public SqlSessionFactory secondSqlSessionFactory(@Qualifier("secondDataSource") DataSource dataSource) throws Exception {
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.setDataSource(dataSource);
bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:/mapper/log/*.xml"));
return bean.getObject();
}
@Bean(name = "secondSqlSessionTemplate")
public SqlSessionTemplate testSqlSessionTemplate(
@Qualifier("secondSqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
return new SqlSessionTemplate(sqlSessionFactory);
}
}
5.编写application.yaml配置文件如下
spring:
datasource:
type: com.alibaba.druid.pool.xa.DruidXADataSource
druid:
master:
driver-class-name: com.mysql.jdbc.Driver
url: jdbc:mysql://192.168.84.129:3306/order?autoReconnect=true&useSSL=false&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull
username: root
password: 123456
maxPoolSize: 5
slave:
driver-class-name: com.mysql.jdbc.Driver
url: jdbc:mysql://192.168.84.129:3306/logs?autoReconnect=true&useSSL=false&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull
username: root
password: 123456
maxPoolSize: 5
server:
port: 8080
#mybatis:
# mapper-locations: classpath:/mapper/*.xml
# type-aliases-package: com.cd.pojo
最后,编写controller层代码进行测试
package com.cd.controller;
import com.cd.pojo.OrderInfo;
import com.cd.service.OrderService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RestController;
import java.util.Date;
@RestController
public class BeController {
@Autowired
private OrderService orderService;
@PostMapping("/insert")
public void insert(){
OrderInfo orderInfo = new OrderInfo();
orderInfo.setAddress("456");
orderInfo.setCreateTime(new Date());
orderInfo.setMoney(1.00);
orderInfo.setId(3);
orderService.addOrder(orderInfo);
}
}
进入主启动类,启动代码
package com.cd;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
public class JtaApplication {
public static void main(String[] args) {
SpringApplication.run(JtaApplication.class, args);
}
}
至此,大功告成,效果如下:
当往库中插入一条数据的时候,另外一条库也成功,当出现异常时,事务进行回滚,实现了分布式事务管理。
最后,附上该案例的整体结构图,可根据图创建对应文件结构