【SpringCloud AlibabaSeata处理分布式事务】

红太狼 2023-09-25 19:07 18阅读 0赞

本笔记内容为[尚硅谷SpringCloud][SpringCloud] AlibabaSeata处理分布式事务部分

**目录**

一、分布式事务问题

二、Seata简介

1、Seata是什么

2、作用

3、下载

三、Seata-Server安装

1. 官网地址

2. 下载版本

3. 解压并修改file.conf配置文件

4. mysql5.7数据库新建库seata和建表

5.修改registry.conf配置文件

7.先启动Nacos再启动seata-server

四、订单/库存/账户业务数据库准备

1、分布式事务业务说明

2、创建业务数据库

3、按照上述3库分别建对应业务表

4、按照上述3库分别建对应的回滚日志表

五、订单/库存/账户业务微服务准备

1、新建订单Order-Module

2、新建库存Storage-Module

3、新建账户Account-Module

六、Test

七、一部分补充

1、Seata

2、TC/TM/RM三大组件

3、AT模式如何做到对业务的无侵入

一阶段加载

二阶段提交

二阶段回滚

--------------------

# 一、分布式事务问题 #

--------------------

> 单体应用被拆分成微服务应用，原来的三个模块被拆分成三个独立的应用，分别使用三个独立的数据源，业务操作需要调用三个服务来完成。此时每个服务内部的数据一致性由本地事务来保证，但是全局的数据一致性问题没法保证。

一次业务操作需要跨多个数据源或需要跨多个系统进行远程调用，就会产生分布式事务问题

![c585cd1af50c4526b53a676cc1789c9c.png][]

# 二、Seata简介 #

--------------------

## 1、Seata是什么 ##

Seata是一款开源的分布式事务解决方案，致力于在微服务架构下提供高性能和简单易用的分布式事务服务。

官网地址：[Seata][]

## 2、作用 ##

一个典型的分布式事务过程

分布式事务处理过程的**一ID+三组件模型**

![4f6271941fb849c890b4c0bc1dd59bee.png][]

**处理过程**

> 1.  TM 向 TC 申请开启一个全局事务，全局事务创建成功并生成一个全局唯一的 XID；
> 2.  XID 在微服务调用链路的上下文中传播；
> 3.  RM 向 TC 注册分支事务，将其纳入 XID 对应全局事务的管辖；
> 4.  TM 向 TC 发起针对 XID 的全局提交或回滚决议；
> 5.  TC 调度 XID 下管辖的全部分支事务完成提交或回滚请求。

![8d62f7797c01422ea0a4e731aab57585.png][]

## 3、下载 ##

发布说明: https://github.com/seata/seata/releases

![b7ce6a5b03ac424bb7ac5c86270cba2e.png][]

![f002c952b6974aa2adcf79dfe0052cc7.png][]

# 三、Seata-Server安装 #

--------------------

## 1. 官网地址 ##

[Seata][]

# 2. 下载版本 #

[https://github.com/seata/seata/releases][https_github.com_seata_seata_releases]

下载的是seata-server-0.9.0.zip（下载哪个版本自己决定）

## 3. 解压并修改file.conf配置文件 ##

seata-server-0.9.0.zip解压到指定目录并修改conf目录下的file.conf配置文件

先备份原始file.conf文件

主要修改：自定义事务组名称+事务日志存储模式为db+数据库连接信息

**file.conf**

service模块

![8d873ff074b742a29cf43d0ba9f9b243.png][]

store模块

![598f18cdb84648bb9079e11d2597365e.png][]![9287072d2da344af8b45a15815cd59e0.png][]

## 4. mysql5.7数据库新建库seata和建表 ##

建表db\_store.sql在\\seata-server-0.9.0\\seata\\conf目录里面的db\_store.sql文件

把sql文件里的内容复制执行创建表

![22debdac952a49b38081f25b680bff73.png][]

## 5.修改registry.conf配置文件 ##

修改seata-server-0.9.0\\seata\\conf目录下的registry.conf配置文件

![b6619b14300a4aaa93c9605cfab28f9a.png][]

## 7.先启动Nacos再启动seata-server ##

![366bad799a244838a0a8be8707bdfd95.png][]

# 四、订单/库存/账户业务数据库准备 #

--------------------

先启动Nacos后启动Seata

Seata没启动报错no available server to connect

## 1、分布式事务业务说明 ##

下订单--->扣库存--->减账户(余额)

![0f4976f1ac0e46738545238360aec6fe.png][]

## 2、创建业务数据库 ##

![1136818e38234a7ab7c7b85b2b21dac6.png][]

CREATE DATABASE seata_order;
    
    CREATE DATABASE seata_storage;
    
    CREATE DATABASE seata_account;

## 3、按照上述3库分别建对应业务表 ##

![98fb592a226f4305ae045fae23893130.png][]

CREATE TABLE t_order (
    
      `id` BIGINT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    
      `user_id` BIGINT(11) DEFAULT NULL COMMENT '用户id',
    
      `product_id` BIGINT(11) DEFAULT NULL COMMENT '产品id',
    
      `count` INT(11) DEFAULT NULL COMMENT '数量',
    
      `money` DECIMAL(11,0) DEFAULT NULL COMMENT '金额',
    
      `status` INT(1) DEFAULT NULL COMMENT '订单状态：0：创建中；1：已完结' 
    
    ) ENGINE=INNODB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
    
    
    SELECT * FROM t_order;
    
    
    
    CREATE TABLE t_storage (
    
     `id` BIGINT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    
     `product_id` BIGINT(11) DEFAULT NULL COMMENT '产品id',
    
     `total` INT(11) DEFAULT NULL COMMENT '总库存',
    
     `used` INT(11) DEFAULT NULL COMMENT '已用库存',
    
     `residue` INT(11) DEFAULT NULL COMMENT '剩余库存'
    
    ) ENGINE=INNODB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
    
     
    
    INSERT INTO seata_storage.t_storage(`id`, `product_id`, `total`, `used`, `residue`)
    
    VALUES ('1', '1', '100', '0', '100');
    
    SELECT * FROM t_storage;
    
    
    
    CREATE TABLE t_account (
    
      `id` BIGINT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT 'id',
    
      `user_id` BIGINT(11) DEFAULT NULL COMMENT '用户id',
    
      `total` DECIMAL(10,0) DEFAULT NULL COMMENT '总额度',
    
      `used` DECIMAL(10,0) DEFAULT NULL COMMENT '已用余额',
    
      `residue` DECIMAL(10,0) DEFAULT '0' COMMENT '剩余可用额度'
    
    ) ENGINE=INNODB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
    
     
    INSERT INTO seata_account.t_account(`id`, `user_id`, `total`, `used`, `residue`)  VALUES ('1', '1', '1000', '0', '1000');
    
     
    SELECT * FROM t_account;

## 4、按照上述3库分别建对应的回滚日志表 ##

![adc2c72dc68b44b6a2b7ddd33dc741ed.png][]

-- the table to store seata xid data
    
    -- 0.7.0+ add context
    
    -- you must to init this sql for you business databese. the seata server not need it.
    
    -- 此脚本必须初始化在你当前的业务数据库中，用于AT 模式XID记录。与server端无关（注：业务数据库）
    
    -- 注意此处0.3.0+ 增加唯一索引 ux_undo_log
    
    DROP TABLE `undo_log`;
    
    CREATE TABLE `undo_log` (
    
      `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
    
      `branch_id` BIGINT(20) NOT NULL,
    
      `xid` VARCHAR(100) NOT NULL,
    
      `context` VARCHAR(128) NOT NULL,
    
      `rollback_info` LONGBLOB NOT NULL,
    
      `log_status` INT(11) NOT NULL,
    
      `log_created` DATETIME NOT NULL,
    
      `log_modified` DATETIME NOT NULL,
    
      `ext` VARCHAR(100) DEFAULT NULL,
    
      PRIMARY KEY (`id`),
    
      UNIQUE KEY `ux_undo_log` (`xid`,`branch_id`)
    
    ) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

**最终效果**

![ad8b1e1a9e9f42808dc480bb8efca1f5.png][]

# 五、订单/库存/账户业务微服务准备 #

--------------------

## 1、新建订单Order-Module ##

**1. seata-order-service2001**

**2. POM**

![8652daf482a6455b98f5cb7bf0efc268.png][]

<?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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
        <parent>
            <artifactId>mscloud03</artifactId>
            <groupId>com.atguigu.springcloud</groupId>
            <version>1.0-SNAPSHOT</version>
        </parent>
        <modelVersion>4.0.0</modelVersion>
    
        <artifactId>seata-order-service2001</artifactId>
    
    
    
        <dependencies>
            
            <dependency>
                <groupId>com.alibaba.cloud</groupId>
                <artifactId>spring-cloud-starter-alibaba-nacos-discovery</artifactId>
            </dependency>
            
            <dependency>
                <groupId>com.alibaba.cloud</groupId>
                <artifactId>spring-cloud-starter-alibaba-seata</artifactId>
                <exclusions>
                    <exclusion>
                        <artifactId>seata-all</artifactId>
                        <groupId>io.seata</groupId>
                    </exclusion>
                </exclusions>
            </dependency>
            <dependency>
                <groupId>io.seata</groupId>
                <artifactId>seata-all</artifactId>
                <version>0.9.0</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework.cloud</groupId>
                <artifactId>spring-cloud-starter-openfeign</artifactId>
            </dependency>
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-actuator</artifactId>
            </dependency>
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.37</version>
            </dependency>
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid-spring-boot-starter</artifactId>
                <version>1.1.10</version>
            </dependency>
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>2.0.0</version>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <optional>true</optional>
            </dependency>
        </dependencies>
    
    </project>

**3. YML**

![d2e6225d28494fc5a03e7ef3d6e3a74f.png][]

server:
      port: 2001
    
    spring:
      application:
        name: seata-order-service
      cloud:
        alibaba:
          seata:
            #自定义事务组名称需要与seata-server中的对应
            tx-service-group: fsp_tx_group
        nacos:
          discovery:
            server-addr: localhost:8848
      datasource:
        driver-class-name: com.mysql.jdbc.Driver
        url: jdbc:mysql://localhost:3306/seata_order
        username: root
        password: 123456
    
    feign:
      hystrix:
        enabled: false
    
    logging:
      level:
        io:
          seata: info
    
    mybatis:
      mapperLocations: classpath:mapper/*.xml

> 注意：
> 
> 如果是Steata0.9.0配合MySQL8.0以上版本，须更改driver-class-name = "com.mysql.cj.jdbc.Driver"
> 
> url的seata后面增加?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&useSSL=false
> 
> 删除seata的lib下的MySQL驱动，增加自己MySQL相应版本的驱动

**4. file.conf**

![49367d0dd03248b18d2ca808274d9c7b.png][]

![1d6a00f0028a4c31a331ecf7b86d72ab.png][]

transport {
    
      # tcp udt unix-domain-socket
    
      type = "TCP"
    
      #NIO NATIVE
    
      server = "NIO"
    
      #enable heartbeat
    
      heartbeat = true
    
      #thread factory for netty
    
      thread-factory {
    
        boss-thread-prefix = "NettyBoss"
    
        worker-thread-prefix = "NettyServerNIOWorker"
    
        server-executor-thread-prefix = "NettyServerBizHandler"
    
        share-boss-worker = false
    
        client-selector-thread-prefix = "NettyClientSelector"
    
        client-selector-thread-size = 1
    
        client-worker-thread-prefix = "NettyClientWorkerThread"
    
        # netty boss thread size,will not be used for UDT
    
        boss-thread-size = 1
    
        #auto default pin or 8
    
        worker-thread-size = 8
    
      }
    
      shutdown {
    
        # when destroy server, wait seconds
    
        wait = 3
    
      }
    
      serialization = "seata"
    
      compressor = "none"
    
    }
    
    
    
    service {
    
    
    
      vgroup_mapping.fsp_tx_group = "default" #修改自定义事务组名称
    
    
    
      default.grouplist = "127.0.0.1:8091"
    
      enableDegrade = false
    
      disable = false
    
      max.commit.retry.timeout = "-1"
    
      max.rollback.retry.timeout = "-1"
    
      disableGlobalTransaction = false
    
    }
    
    
    
    
    
    client {
    
      async.commit.buffer.limit = 10000
    
      lock {
    
        retry.internal = 10
    
        retry.times = 30
    
      }
    
      report.retry.count = 5
    
      tm.commit.retry.count = 1
    
      tm.rollback.retry.count = 1
    
    }
    
    
    
    ## transaction log store
    
    store {
    
      ## store mode: file、db
    
      mode = "db"
    
    
    
      ## file store
    
      file {
    
        dir = "sessionStore"
    
    
    
        # branch session size , if exceeded first try compress lockkey, still exceeded throws exceptions
    
        max-branch-session-size = 16384
    
        # globe session size , if exceeded throws exceptions
    
        max-global-session-size = 512
    
        # file buffer size , if exceeded allocate new buffer
    
        file-write-buffer-cache-size = 16384
    
        # when recover batch read size
    
        session.reload.read_size = 100
    
        # async, sync
    
        flush-disk-mode = async
    
      }
    
    
    
      ## database store
    
      db {
    
        ## the implement of javax.sql.DataSource, such as DruidDataSource(druid)/BasicDataSource(dbcp) etc.
    
        datasource = "dbcp"
    
        ## mysql/oracle/h2/oceanbase etc.
    
        db-type = "mysql"
    
        driver-class-name = "com.mysql.jdbc.Driver"
    
        url = "jdbc:mysql://127.0.0.1:3306/seata"
    
        user = "root"
    
        password = "123456"
    
        min-conn = 1
    
        max-conn = 3
    
        global.table = "global_table"
    
        branch.table = "branch_table"
    
        lock-table = "lock_table"
    
        query-limit = 100
    
      }
    
    }
    
    lock {
    
      ## the lock store mode: local、remote
    
      mode = "remote"
    
    
    
      local {
    
        ## store locks in user's database
    
      }
    
    
    
      remote {
    
        ## store locks in the seata's server
    
      }
    
    }
    
    recovery {
    
      #schedule committing retry period in milliseconds
    
      committing-retry-period = 1000
    
      #schedule asyn committing retry period in milliseconds
    
      asyn-committing-retry-period = 1000
    
      #schedule rollbacking retry period in milliseconds
    
      rollbacking-retry-period = 1000
    
      #schedule timeout retry period in milliseconds
    
      timeout-retry-period = 1000
    
    }
    
    
    
    transaction {
    
      undo.data.validation = true
    
      undo.log.serialization = "jackson"
    
      undo.log.save.days = 7
    
      #schedule delete expired undo_log in milliseconds
    
      undo.log.delete.period = 86400000
    
      undo.log.table = "undo_log"
    
    }
    
    
    
    ## metrics settings
    
    metrics {
    
      enabled = false
    
      registry-type = "compact"
    
      # multi exporters use comma divided
    
      exporter-list = "prometheus"
    
      exporter-prometheus-port = 9898
    
    }
    
    
    
    support {
    
      ## spring
    
      spring {
    
        # auto proxy the DataSource bean
    
        datasource.autoproxy = false
    
      }
    
    }

**5. registry.conf**

![e60089fe02cd49009f5c25c2b9266fd1.png][]

registry {
    
      # file 、nacos 、eureka、redis、zk、consul、etcd3、sofa
    
      type = "nacos"
    
    
    
      nacos {
    
        serverAddr = "localhost:8848"
    
        namespace = ""
    
        cluster = "default"
    
      }
    
      eureka {
    
        serviceUrl = "http://localhost:8761/eureka"
    
        application = "default"
    
        weight = "1"
    
      }
    
      redis {
    
        serverAddr = "localhost:6379"
    
        db = "0"
    
      }
    
      zk {
    
        cluster = "default"
    
        serverAddr = "127.0.0.1:2181"
    
        session.timeout = 6000
    
        connect.timeout = 2000
    
      }
    
      consul {
    
        cluster = "default"
    
        serverAddr = "127.0.0.1:8500"
    
      }
    
      etcd3 {
    
        cluster = "default"
    
        serverAddr = "http://localhost:2379"
    
      }
    
      sofa {
    
        serverAddr = "127.0.0.1:9603"
    
        application = "default"
    
        region = "DEFAULT_ZONE"
    
        datacenter = "DefaultDataCenter"
    
        cluster = "default"
    
        group = "SEATA_GROUP"
    
        addressWaitTime = "3000"
    
      }
    
      file {
    
        name = "file.conf"
    
      }
    
    }
    
    
    
    config {
    
      # file、nacos 、apollo、zk、consul、etcd3
    
      type = "file"
    
    
    
      nacos {
    
        serverAddr = "localhost"
    
        namespace = ""
    
      }
    
      consul {
    
        serverAddr = "127.0.0.1:8500"
    
      }
    
      apollo {
    
        app.id = "seata-server"
    
        apollo.meta = "http://192.168.1.204:8801"
    
      }
    
      zk {
    
        serverAddr = "127.0.0.1:2181"
    
        session.timeout = 6000
    
        connect.timeout = 2000
    
      }
    
      etcd3 {
    
        serverAddr = "http://localhost:2379"
    
      }
    
      file {
    
        name = "file.conf"
    
      }
    
    }

**6. domain**

domain类似pojo\\entities

CommonResult

package com.atguigu.springcloud.alibaba.domain;
    
    import lombok.AllArgsConstructor;
    import lombok.Data;
    import lombok.NoArgsConstructor;
    
    @Data
    @AllArgsConstructor
    @NoArgsConstructor
    public class CommonResult<T>
    {
        private Integer code;
        private String  message;
        private T       data;
    
        public CommonResult(Integer code, String message)
        {
            this(code,message,null);
        }
    }

Order

package com.atguigu.springcloud.alibaba.domain;
    
    import lombok.AllArgsConstructor;
    import lombok.Data;
    import lombok.NoArgsConstructor;
    
    import java.math.BigDecimal;
    
    @Data
    @AllArgsConstructor
    @NoArgsConstructor
    public class Order
    {
        private Long id;
    
        private Long userId;
    
        private Long productId;
    
        private Integer count;
    
        private BigDecimal money;
    
        /**
         * 订单状态：0：创建中；1：已完结
         */
        private Integer status;
    }

**7. Dao接口及实现**

OrderDao

package com.atguigu.springcloud.alibaba.dao;
    
    import com.atguigu.springcloud.alibaba.domain.Order;
    import org.apache.ibatis.annotations.Mapper;
    import org.apache.ibatis.annotations.Param;
    
    import javax.naming.Name;
    
    @Mapper
    public interface OrderDao {
    
        /**
         * 创建订单
         */
        void create(Order order);
    
        /**
         * 修改订单金额
         */
        void update(@Param("userId") Long userId, @Param("status") Integer status);
    }

resources文件夹下新建mapper文件夹后添加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.atguigu.springcloud.alibaba.dao.OrderDao">
    
        <resultMap id="BaseResultMap" type="com.atguigu.springcloud.alibaba.domain.Order">
            <id column="id" property="id" jdbcType="BIGINT"/>
            <result column="user_id" property="userId" jdbcType="BIGINT"/>
            <result column="product_id" property="productId" jdbcType="BIGINT"/>
            <result column="count" property="count" jdbcType="INTEGER"/>
            <result column="money" property="money" jdbcType="DECIMAL"/>
            <result column="status" property="status" jdbcType="INTEGER"/>
        </resultMap>
    
        <insert id="create">
            INSERT INTO `t_order` (`id`, `user_id`, `product_id`, `count`, `money`, `status`)
            VALUES (NULL, #{userId}, #{productId}, #{count}, #{money}, 0);
        </insert>
    
        <update id="update">
            UPDATE `t_order`
            SET status = 1
            WHERE user_id = #{userId} AND status = #{status};
        </update>
    </mapper>

**8. Service接口及实现**

OrderService

package com.atguigu.springcloud.alibaba.service;
    
    import com.atguigu.springcloud.alibaba.domain.Order;
    import org.springframework.cloud.openfeign.FeignClient;
    
    public interface OrderService {
    
        /**
         * 创建订单
         */
        void create(Order order);
    }

OrderServiceImpl

package com.atguigu.springcloud.alibaba.service.impl;
    
    import com.atguigu.springcloud.alibaba.dao.OrderDao;
    import com.atguigu.springcloud.alibaba.domain.Order;
    import com.atguigu.springcloud.alibaba.service.AccountService;
    import com.atguigu.springcloud.alibaba.service.OrderService;
    import com.atguigu.springcloud.alibaba.service.StorageService;
    import io.seata.spring.annotation.GlobalTransactional;
    import lombok.extern.slf4j.Slf4j;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    import org.slf4j.Logger;
    import org.slf4j.LoggerFactory;
    
    import javax.annotation.Resource;
    
    @Service
    @Slf4j
    public class OrderServiceImpl implements OrderService
    {
        @Resource
        private OrderDao orderDao;
    
        @Resource
        private StorageService storageService;
    
        @Resource
        private AccountService accountService;
    
        /**
         * 创建订单->调用库存服务扣减库存->调用账户服务扣减账户余额->修改订单状态
         * 简单说：
         * 下订单->减库存->减余额->改状态
         */
        @Override
        @GlobalTransactional(name = "fsp-create-order",rollbackFor = Exception.class)
        public void create(Order order) {
            log.info("------->下单开始");
            //本应用创建订单
            orderDao.create(order);
    
            //远程调用库存服务扣减库存
            log.info("------->order-service中扣减库存开始");
            storageService.decrease(order.getProductId(),order.getCount());
            log.info("------->order-service中扣减库存结束");
    
            //远程调用账户服务扣减余额
            log.info("------->order-service中扣减余额开始");
            accountService.decrease(order.getUserId(),order.getMoney());
            log.info("------->order-service中扣减余额结束");
    
            //修改订单状态为已完成
            log.info("------->order-service中修改订单状态开始");
            orderDao.update(order.getUserId(),0);
            log.info("------->order-service中修改订单状态结束");
    
            log.info("------->下单结束");
        }
    }

StorageService

package com.atguigu.springcloud.alibaba.service;
    
    import com.atguigu.springcloud.alibaba.domain.CommonResult;
    import org.springframework.cloud.openfeign.FeignClient;
    import org.springframework.web.bind.annotation.GetMapping;
    import org.springframework.web.bind.annotation.PostMapping;
    import org.springframework.web.bind.annotation.RequestParam;
    
    @FeignClient(value = "seata-storage-service")
    public interface StorageService {
    
        /**
         * 扣减库存
         */
        @PostMapping(value = "/storage/decrease")
        CommonResult decrease(@RequestParam("productId") Long productId, @RequestParam("count") Integer count);
    }

AccountService

package com.atguigu.springcloud.alibaba.service;
    
    import com.atguigu.springcloud.alibaba.domain.CommonResult;
    import org.springframework.cloud.openfeign.FeignClient;
    import org.springframework.web.bind.annotation.PostMapping;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RequestMethod;
    import org.springframework.web.bind.annotation.RequestParam;
    
    import java.math.BigDecimal;
    
    @FeignClient(value = "seata-account-service")
    public interface AccountService {
    
        /**
         * 扣减账户余额
         */
        //@RequestMapping(value = "/account/decrease", method = RequestMethod.POST, produces = "application/json; charset=UTF-8")
        @PostMapping("/account/decrease")
        CommonResult decrease(@RequestParam("userId") Long userId, @RequestParam("money") BigDecimal money);
    }

**9. Controller**

package com.atguigu.springcloud.alibaba.controller;
    
    import com.atguigu.springcloud.alibaba.domain.CommonResult;
    import com.atguigu.springcloud.alibaba.domain.Order;
    import com.atguigu.springcloud.alibaba.service.OrderService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.*;
    
    @RestController
    public class OrderController {
    
        @Autowired
        private OrderService orderService;
    
        /**
         * 创建订单
         */
        @GetMapping("/order/create")
        public CommonResult create( Order order) {
            orderService.create(order);
            return new CommonResult(200, "订单创建成功!");
        }
    }

**10. Config配置**

MyBatisConfig

package com.atguigu.springcloud.alibaba.config;
    
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.context.annotation.Configuration;
    
    @Configuration
    @MapperScan({"com.atguigu.springcloud.alibaba.dao"})
    public class MyBatisConfig {
    }

DataSourceProxyConfig

package com.atguigu.springcloud.alibaba.config;
    
    import com.alibaba.druid.pool.DruidDataSource;
    import io.seata.rm.datasource.DataSourceProxy;
    import org.apache.ibatis.session.SqlSessionFactory;
    import org.mybatis.spring.SqlSessionFactoryBean;
    import org.mybatis.spring.transaction.SpringManagedTransactionFactory;
    import org.springframework.beans.factory.annotation.Value;
    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 javax.sql.DataSource;
    
    @Configuration
    public class DataSourceProxyConfig {
    
        @Value("${mybatis.mapperLocations}")
        private String mapperLocations;
    
        @Bean
        @ConfigurationProperties(prefix = "spring.datasource")
        public DataSource druidDataSource(){
            return new DruidDataSource();
        }
    
        @Bean
        public DataSourceProxy dataSourceProxy(DataSource dataSource) {
            return new DataSourceProxy(dataSource);
        }
    
        @Bean
        public SqlSessionFactory sqlSessionFactoryBean(DataSourceProxy dataSourceProxy) throws Exception {
            SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
            sqlSessionFactoryBean.setDataSource(dataSourceProxy);
            sqlSessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources(mapperLocations));
            sqlSessionFactoryBean.setTransactionFactory(new SpringManagedTransactionFactory());
            return sqlSessionFactoryBean.getObject();
        }
    
    }

**11. 主启动**

package com.atguigu.springcloud.alibaba;
    
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    import org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration;
    import org.springframework.cloud.client.discovery.EnableDiscoveryClient;
    import org.springframework.cloud.openfeign.EnableFeignClients;
    import org.springframework.context.annotation.ComponentScan;
    
    @EnableDiscoveryClient
    @EnableFeignClients
    @SpringBootApplication(exclude = DataSourceAutoConfiguration.class)//取消数据源的自动创建
    public class SeataOrderMainApp2001
    {
    
        public static void main(String[] args)
        {
            SpringApplication.run(SeataOrderMainApp2001.class, args);
        }
    }

## 2、新建库存Storage-Module ##

**1. seata-storage-service2002**

**2. POM**

<?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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
        <parent>
            <artifactId>mscloud03</artifactId>
            <groupId>com.atguigu.springcloud</groupId>
            <version>1.0-SNAPSHOT</version>
        </parent>
        <modelVersion>4.0.0</modelVersion>
    
        <artifactId>seata-storage-service2002</artifactId>
    
    
    
        <dependencies>
            
            <dependency>
                <groupId>com.alibaba.cloud</groupId>
                <artifactId>spring-cloud-starter-alibaba-nacos-discovery</artifactId>
            </dependency>
            
            <dependency>
                <groupId>com.alibaba.cloud</groupId>
                <artifactId>spring-cloud-starter-alibaba-seata</artifactId>
                <exclusions>
                    <exclusion>
                        <artifactId>seata-all</artifactId>
                        <groupId>io.seata</groupId>
                    </exclusion>
                </exclusions>
            </dependency>
            <dependency>
                <groupId>io.seata</groupId>
                <artifactId>seata-all</artifactId>
                <version>0.9.0</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework.cloud</groupId>
                <artifactId>spring-cloud-starter-openfeign</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>2.0.0</version>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.37</version>
            </dependency>
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid-spring-boot-starter</artifactId>
                <version>1.1.10</version>
            </dependency>
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <optional>true</optional>
            </dependency>
        </dependencies>
    
    </project>

**3. YML**

server:
      port: 2002
    
    spring:
      application:
        name: seata-storage-service
      cloud:
        alibaba:
          seata:
            tx-service-group: fsp_tx_group
        nacos:
          discovery:
            server-addr: localhost:8848
      datasource:
        driver-class-name: com.mysql.jdbc.Driver
        url: jdbc:mysql://localhost:3306/seata_storage
        username: root
        password: 123456
    
    logging:
      level:
        io:
          seata: info
    
    mybatis:
      mapperLocations: classpath:mapper/*.xml

**4. file.conf**

**5. registry.conf**

registry {
      # file 、nacos 、eureka、redis、zk
      type = "nacos"
    
      nacos {
        serverAddr = "localhost:8848"
        namespace = ""
        cluster = "default"
      }
      eureka {
        serviceUrl = "http://localhost:8761/eureka"
        application = "default"
        weight = "1"
      }
      redis {
        serverAddr = "localhost:6381"
        db = "0"
      }
      zk {
        cluster = "default"
        serverAddr = "127.0.0.1:2181"
        session.timeout = 6000
        connect.timeout = 2000
      }
      file {
        name = "file.conf"
      }
    }
    
    config {
      # file、nacos 、apollo、zk
      type = "file"
    
      nacos {
        serverAddr = "localhost"
        namespace = ""
        cluster = "default"
      }
      apollo {
        app.id = "fescar-server"
        apollo.meta = "http://192.168.1.204:8801"
      }
      zk {
        serverAddr = "127.0.0.1:2181"
        session.timeout = 6000
        connect.timeout = 2000
      }
      file {
        name = "file.conf"
      }
    }

**6. domain**

CommonResult

Storage

package com.atguigu.springcloud.alibaba.domain;
    
    import lombok.Data;
    
    @Data
    public class Storage {
    
        private Long id;
    
        /**
         * 产品id
         */
        private Long productId;
    
        /**
         * 总库存
         */
        private Integer total;
    
        /**
         * 已用库存
         */
        private Integer used;
    
        /**
         * 剩余库存
         */
        private Integer residue;
    }

**7. Dao接口及实现**

StorageDao

package com.atguigu.springcloud.alibaba.dao;
    
    import org.apache.ibatis.annotations.Mapper;
    import org.apache.ibatis.annotations.Param;
    
    @Mapper
    public interface StorageDao {
    
        /**
         * 扣减库存
         */
        void decrease(@Param("productId") Long productId, @Param("count") Integer count);
    }

resources文件夹下新建mapper文件夹后添加StorageMapper.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.atguigu.springcloud.alibaba.dao.StorageDao">
    
        <resultMap id="BaseResultMap" type="com.atguigu.springcloud.alibaba.domain.Storage">
            <id column="id" property="id" jdbcType="BIGINT"/>
            <result column="product_id" property="productId" jdbcType="BIGINT"/>
            <result column="total" property="total" jdbcType="INTEGER"/>
            <result column="used" property="used" jdbcType="INTEGER"/>
            <result column="residue" property="residue" jdbcType="INTEGER"/>
        </resultMap>
    
        <update id="decrease">
            UPDATE t_storage
            SET used    = used + #{count},
                residue = residue - #{count}
            WHERE product_id = #{productId}
        </update>
    
    </mapper>

**8. Service接口及实现**

StorageService

package com.atguigu.springcloud.alibaba.service;
    
    
    public interface StorageService {
        /**
         * 扣减库存
         */
        void decrease(Long productId, Integer count);
    }

StorageServiceImpl

package com.atguigu.springcloud.alibaba.service.impl;
    
    import com.atguigu.springcloud.alibaba.dao.StorageDao;
    import com.atguigu.springcloud.alibaba.service.StorageService ;
    import org.slf4j.Logger;
    import org.slf4j.LoggerFactory;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import javax.annotation.Resource;
    
    
    @Service
    public class StorageServiceImpl implements StorageService {
    
        private static final Logger LOGGER = LoggerFactory.getLogger(StorageServiceImpl.class);
    
        @Resource
        private StorageDao storageDao;
    
        /**
         * 扣减库存
         */
        @Override
        public void decrease(Long productId, Integer count) {
            LOGGER.info("------->storage-service中扣减库存开始");
            storageDao.decrease(productId,count);
            LOGGER.info("------->storage-service中扣减库存结束");
        }
    }

**9. Controller**

package com.atguigu.springcloud.alibaba.controller;
    
    
    import com.atguigu.springcloud.alibaba.domain.CommonResult ;
    import com.atguigu.springcloud.alibaba.service.StorageService ;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RestController;
    
    @RestController
    public class StorageController {
    
        @Autowired
        private StorageService storageService;
    
        /**
         * 扣减库存
         */
        @RequestMapping("/storage/decrease")
        public CommonResult decrease(Long productId, Integer count) {
            storageService.decrease(productId, count);
            return new CommonResult(200,"扣减库存成功！");
        }
    }

**10. Config配置**

MyBatisConfig

DataSourceProxyConfig

package com.atguigu.springcloud.alibaba.config;
    
    import com.alibaba.druid.pool.DruidDataSource;
    import io.seata.rm.datasource.DataSourceProxy;
    import org.apache.ibatis.session.SqlSessionFactory;
    import org.mybatis.spring.SqlSessionFactoryBean;
    import org.mybatis.spring.transaction.SpringManagedTransactionFactory;
    import org.springframework.beans.factory.annotation.Value;
    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 javax.sql.DataSource;
    
    /**
     * 使用Seata对数据源进行代理
     */
    @Configuration
    public class DataSourceProxyConfig {
    
        @Value("${mybatis.mapperLocations}")
        private String mapperLocations;
    
        @Bean
        @ConfigurationProperties(prefix = "spring.datasource")
        public DataSource druidDataSource(){
            return new DruidDataSource();
        }
    
        @Bean
        public DataSourceProxy dataSourceProxy(DataSource dataSource) {
            return new DataSourceProxy(dataSource);
        }
    
        @Bean
        public SqlSessionFactory sqlSessionFactoryBean(DataSourceProxy dataSourceProxy) throws Exception {
            SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
            sqlSessionFactoryBean.setDataSource(dataSourceProxy);
            sqlSessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources(mapperLocations));
            sqlSessionFactoryBean.setTransactionFactory(new SpringManagedTransactionFactory());
            return sqlSessionFactoryBean.getObject();
        }
    
    }

**11. 主启动**

package com.atguigu.springcloud.alibaba;
    
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    import org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration;
    import org.springframework.cloud.client.discovery.EnableDiscoveryClient;
    import org.springframework.cloud.openfeign.EnableFeignClients;
    
    @SpringBootApplication(exclude = DataSourceAutoConfiguration.class)
    @EnableDiscoveryClient
    @EnableFeignClients
    public class SeataStorageServiceApplication2002 {
    
        public static void main(String[] args) {
            SpringApplication.run(SeataStorageServiceApplication2002.class, args);
        }
    
    }

## 3、新建账户Account-Module ##

**1. seata-account-service2003**

**2. POM**

<?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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
        <parent>
            <artifactId>mscloud03</artifactId>
            <groupId>com.atguigu.springcloud</groupId>
            <version>1.0-SNAPSHOT</version>
        </parent>
        <modelVersion>4.0.0</modelVersion>
    
        <artifactId>seata-account-service2003</artifactId>
    
    
        <dependencies>
            
            <dependency>
                <groupId>com.alibaba.cloud</groupId>
                <artifactId>spring-cloud-starter-alibaba-nacos-discovery</artifactId>
            </dependency>
            
            <dependency>
                <groupId>com.alibaba.cloud</groupId>
                <artifactId>spring-cloud-starter-alibaba-seata</artifactId>
                <exclusions>
                    <exclusion>
                        <artifactId>seata-all</artifactId>
                        <groupId>io.seata</groupId>
                    </exclusion>
                </exclusions>
            </dependency>
            <dependency>
                <groupId>io.seata</groupId>
                <artifactId>seata-all</artifactId>
                <version>0.9.0</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework.cloud</groupId>
                <artifactId>spring-cloud-starter-openfeign</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>2.0.0</version>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.37</version>
            </dependency>
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid-spring-boot-starter</artifactId>
                <version>1.1.10</version>
            </dependency>
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <optional>true</optional>
            </dependency>
        </dependencies>
    
    </project>

**3. YML**

![f99c38989e3d4f65b50e0caab82b257e.png][]

server:
      port: 2003
    
    spring:
      application:
        name: seata-account-service
      cloud:
        alibaba:
          seata:
            tx-service-group: fsp_tx_group
        nacos:
          discovery:
            server-addr: localhost:8848
      datasource:
        driver-class-name: com.mysql.jdbc.Driver
        url: jdbc:mysql://localhost:3306/seata_account
        username: root
        password: 123456
    
    feign:
      hystrix:
        enabled: false
    
    logging:
      level:
        io:
          seata: info
    
    mybatis:
      mapperLocations: classpath:mapper/*.xml

**4. file.conf**

transport {
      # tcp udt unix-domain-socket
      type = "TCP"
      #NIO NATIVE
      server = "NIO"
      #enable heartbeat
      heartbeat = true
      #thread factory for netty
      thread-factory {
        boss-thread-prefix = "NettyBoss"
        worker-thread-prefix = "NettyServerNIOWorker"
        server-executor-thread-prefix = "NettyServerBizHandler"
        share-boss-worker = false
        client-selector-thread-prefix = "NettyClientSelector"
        client-selector-thread-size = 1
        client-worker-thread-prefix = "NettyClientWorkerThread"
        # netty boss thread size,will not be used for UDT
        boss-thread-size = 1
        #auto default pin or 8
        worker-thread-size = 8
      }
      shutdown {
        # when destroy server, wait seconds
        wait = 3
      }
      serialization = "seata"
      compressor = "none"
    }
    
    service {
    
      vgroup_mapping.fsp_tx_group = "default" #修改自定义事务组名称
    
      default.grouplist = "127.0.0.1:8091"
      enableDegrade = false
      disable = false
      max.commit.retry.timeout = "-1"
      max.rollback.retry.timeout = "-1"
      disableGlobalTransaction = false
    }
    
    
    client {
      async.commit.buffer.limit = 10000
      lock {
        retry.internal = 10
        retry.times = 30
      }
      report.retry.count = 5
      tm.commit.retry.count = 1
      tm.rollback.retry.count = 1
    }
    
    ## transaction log store
    store {
      ## store mode: file、db
      mode = "db"
    
      ## file store
      file {
        dir = "sessionStore"
    
        # branch session size , if exceeded first try compress lockkey, still exceeded throws exceptions
        max-branch-session-size = 16384
        # globe session size , if exceeded throws exceptions
        max-global-session-size = 512
        # file buffer size , if exceeded allocate new buffer
        file-write-buffer-cache-size = 16384
        # when recover batch read size
        session.reload.read_size = 100
        # async, sync
        flush-disk-mode = async
      }
    
      ## database store
      db {
        ## the implement of javax.sql.DataSource, such as DruidDataSource(druid)/BasicDataSource(dbcp) etc.
        datasource = "dbcp"
        ## mysql/oracle/h2/oceanbase etc.
        db-type = "mysql"
        driver-class-name = "com.mysql.jdbc.Driver"
        url = "jdbc:mysql://127.0.0.1:3306/seata"
        user = "root"
        password = "123456"
        min-conn = 1
        max-conn = 3
        global.table = "global_table"
        branch.table = "branch_table"
        lock-table = "lock_table"
        query-limit = 100
      }
    }
    lock {
      ## the lock store mode: local、remote
      mode = "remote"
    
      local {
        ## store locks in user's database
      }
    
      remote {
        ## store locks in the seata's server
      }
    }
    recovery {
      #schedule committing retry period in milliseconds
      committing-retry-period = 1000
      #schedule asyn committing retry period in milliseconds
      asyn-committing-retry-period = 1000
      #schedule rollbacking retry period in milliseconds
      rollbacking-retry-period = 1000
      #schedule timeout retry period in milliseconds
      timeout-retry-period = 1000
    }
    
    transaction {
      undo.data.validation = true
      undo.log.serialization = "jackson"
      undo.log.save.days = 7
      #schedule delete expired undo_log in milliseconds
      undo.log.delete.period = 86400000
      undo.log.table = "undo_log"
    }
    
    ## metrics settings
    metrics {
      enabled = false
      registry-type = "compact"
      # multi exporters use comma divided
      exporter-list = "prometheus"
      exporter-prometheus-port = 9898
    }
    
    support {
      ## spring
      spring {
        # auto proxy the DataSource bean
        datasource.autoproxy = false
      }
    }

**5. registry.conf**

registry {
      # file 、nacos 、eureka、redis、zk、consul、etcd3、sofa
      type = "nacos"
    
      nacos {
        serverAddr = "localhost:8848"
        namespace = ""
        cluster = "default"
      }
      eureka {
        serviceUrl = "http://localhost:8761/eureka"
        application = "default"
        weight = "1"
      }
      redis {
        serverAddr = "localhost:6379"
        db = "0"
      }
      zk {
        cluster = "default"
        serverAddr = "127.0.0.1:2181"
        session.timeout = 6000
        connect.timeout = 2000
      }
      consul {
        cluster = "default"
        serverAddr = "127.0.0.1:8500"
      }
      etcd3 {
        cluster = "default"
        serverAddr = "http://localhost:2379"
      }
      sofa {
        serverAddr = "127.0.0.1:9603"
        application = "default"
        region = "DEFAULT_ZONE"
        datacenter = "DefaultDataCenter"
        cluster = "default"
        group = "SEATA_GROUP"
        addressWaitTime = "3000"
      }
      file {
        name = "file.conf"
      }
    }
    
    config {
      # file、nacos 、apollo、zk、consul、etcd3
      type = "file"
    
      nacos {
        serverAddr = "localhost"
        namespace = ""
      }
      consul {
        serverAddr = "127.0.0.1:8500"
      }
      apollo {
        app.id = "seata-server"
        apollo.meta = "http://192.168.1.204:8801"
      }
      zk {
        serverAddr = "127.0.0.1:2181"
        session.timeout = 6000
        connect.timeout = 2000
      }
      etcd3 {
        serverAddr = "http://localhost:2379"
      }
      file {
        name = "file.conf"
      }
    }

**6. domain**

CommonResult

Account

package com.atguigu.springcloud.alibaba.domain;
    
    import lombok.AllArgsConstructor;
    import lombok.Data;
    import lombok.NoArgsConstructor;
    
    import java.math.BigDecimal;
    
    @Data
    @AllArgsConstructor
    @NoArgsConstructor
    public class Account {
    
        private Long id;
    
        /**
         * 用户id
         */
        private Long userId;
    
        /**
         * 总额度
         */
        private BigDecimal total;
    
        /**
         * 已用额度
         */
        private BigDecimal used;
    
        /**
         * 剩余额度
         */
        private BigDecimal residue;
    }

**7. Dao接口及实现**

AccountDao

package com.atguigu.springcloud.alibaba.dao;
    
    import org.apache.ibatis.annotations.Mapper;
    import org.apache.ibatis.annotations.Param;
    import org.springframework.stereotype.Component;
    import org.springframework.stereotype.Repository;
    
    import java.math.BigDecimal;
    
    @Mapper
    public interface AccountDao {
    
        /**
         * 扣减账户余额
         */
        void decrease(@Param("userId") Long userId, @Param("money") BigDecimal money);
    }

resources文件夹下新建mapper文件夹后添加AccountMapper.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.atguigu.springcloud.alibaba.dao.AccountDao">
    
        <resultMap id="BaseResultMap" type="com.atguigu.springcloud.alibaba.domain.Account">
            <id column="id" property="id" jdbcType="BIGINT"/>
            <result column="user_id" property="userId" jdbcType="BIGINT"/>
            <result column="total" property="total" jdbcType="DECIMAL"/>
            <result column="used" property="used" jdbcType="DECIMAL"/>
            <result column="residue" property="residue" jdbcType="DECIMAL"/>
        </resultMap>
    
        <update id="decrease">
            UPDATE t_account
            SET
              residue = residue - #{money},used = used + #{money}
            WHERE
              user_id = #{userId};
        </update>
    
    </mapper>

**8. Service接口及实现**

AccountService

package com.atguigu.springcloud.alibaba.service;
    
    import org.springframework.web.bind.annotation.RequestParam;
    import org.springframework.web.bind.annotation.ResponseBody;
    
    import java.math.BigDecimal;
    
    
    public interface AccountService {
    
        /**
         * 扣减账户余额
         * @param userId 用户id
         * @param money 金额
         */
        void decrease(@RequestParam("userId") Long userId, @RequestParam("money") BigDecimal money);
    }

AccountServiceImpl

![051644fd90754e08bb385613fd96875f.png][]

package com.atguigu.springcloud.alibaba.service.impl;
    
    
    import com.atguigu.springcloud.alibaba.dao.AccountDao;
    import com.atguigu.springcloud.alibaba.service.AccountService ;
    import org.slf4j.Logger;
    import org.slf4j.LoggerFactory;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import javax.annotation.Resource;
    import java.math.BigDecimal;
    import java.util.concurrent.TimeUnit;
    
    /**
     * 账户业务实现类
     */
    @Service
    public class AccountServiceImpl implements AccountService {
    
        private static final Logger LOGGER = LoggerFactory.getLogger(AccountServiceImpl.class);
    
    
        @Resource
        AccountDao accountDao;
    
        /**
         * 扣减账户余额
         */
        @Override
        public void decrease(Long userId, BigDecimal money) {
            LOGGER.info("------->account-service中扣减账户余额开始");
            //模拟超时异常，全局事务回滚
            //暂停几秒钟线程
            //try { TimeUnit.SECONDS.sleep(30); } catch (InterruptedException e) { e.printStackTrace(); }
            accountDao.decrease(userId,money);
            LOGGER.info("------->account-service中扣减账户余额结束");
        }
    }

**9. Controller**

package com.atguigu.springcloud.alibaba.controller;
    
    import com.atguigu.springcloud.alibaba.domain.CommonResult ;
    import com.atguigu.springcloud.alibaba.service.AccountService ;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.PostMapping;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RequestParam;
    import org.springframework.web.bind.annotation.RestController;
    
    import javax.annotation.Resource;
    import java.math.BigDecimal;
    
    @RestController
    public class AccountController {
    
        @Resource
        AccountService accountService;
    
        /**
         * 扣减账户余额
         */
        @RequestMapping("/account/decrease")
        public CommonResult decrease(@RequestParam("userId") Long userId, @RequestParam("money") BigDecimal money){
            accountService.decrease(userId,money);
            return new CommonResult(200,"扣减账户余额成功！");
        }
    }

**10. Config配置**

MyBatisConfig

DataSourceProxyConfig

package com.atguigu.springcloud.alibaba.config;
    
    import com.alibaba.druid.pool.DruidDataSource;
    import io.seata.rm.datasource.DataSourceProxy;
    import org.apache.ibatis.session.SqlSessionFactory;
    import org.mybatis.spring.SqlSessionFactoryBean;
    import org.mybatis.spring.transaction.SpringManagedTransactionFactory;
    import org.springframework.beans.factory.annotation.Value;
    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 javax.sql.DataSource;
    
    /**
     * 使用Seata对数据源进行代理
     */
    @Configuration
    public class DataSourceProxyConfig {
    
        @Value("${mybatis.mapperLocations}")
        private String mapperLocations;
    
        @Bean
        @ConfigurationProperties(prefix = "spring.datasource")
        public DataSource druidDataSource(){
            return new DruidDataSource();
        }
    
        @Bean
        public DataSourceProxy dataSourceProxy(DataSource dataSource) {
            return new DataSourceProxy(dataSource);
        }
    
        @Bean
        public SqlSessionFactory sqlSessionFactoryBean(DataSourceProxy dataSourceProxy) throws Exception {
            SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
            sqlSessionFactoryBean.setDataSource(dataSourceProxy);
            sqlSessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources(mapperLocations));
            sqlSessionFactoryBean.setTransactionFactory(new SpringManagedTransactionFactory());
            return sqlSessionFactoryBean.getObject();
        }
    
    }

**11. 主启动**

package com.atguigu.springcloud.alibaba;
    
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    import org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration;
    import org.springframework.cloud.client.discovery.EnableDiscoveryClient;
    import org.springframework.cloud.openfeign.EnableFeignClients;
    
    @SpringBootApplication(exclude = DataSourceAutoConfiguration.class)
    @EnableDiscoveryClient
    @EnableFeignClients
    public class SeataAccountMainApp2003
    {
        public static void main(String[] args)
        {
            SpringApplication.run(SeataAccountMainApp2003.class, args);
        }
    }

# 六、Test #

--------------------

下订单->减库存->扣余额->改(订单)状态

![f180a6e2ffad4ed4a314cc5fc525310e.png][]

数据库初始情况

![cc70a85d01bc4a25a180f6bff772fb25.png][]

正常下单

[http://localhost:2001/order/create?userId=1&productId=1&count=10&money=100][http_localhost_2001_order_create_userId_1_productId_1_count_10_money_100]

数据库情况

![e6f5bc9539414d3e9ee5782f6bb78cf4.png][]

超时异常，没加@GlobalTransactional

![a7faa51048394f409948f3660c744cf4.png][]

![b00bfb248e7640c1aa19e022b8d9657a.png][]

![4e140b433e97447e94ac256bae6674a5.png][]

![b0d97b4a867845f587ea611b26c5a6c1.png][]

# 七、一部分补充 #

--------------------

## 1、Seata ##

![5970ffa2ec444e70954ee33557a00d4c.png][]

## 2、TC/TM/RM三大组件 ##

![2f2bb845f5954c96890d5ce994183f01.png][]

## 3、AT模式如何做到对业务的无侵入 ##

![c045f77511e7494c879ccfc1e73bf824.png][]

### 一阶段加载 ###

![135bb5afa68849e79774a7e27e16ba1f.png][]

### 二阶段提交 ###

![099d4acf0bca47c788f5375314cebf17.png][]

### 二阶段回滚 ###

![50a292eab93b49d7a011314ba2471624.png][]

补充

![7eb1f3e61213429199deeb2aeee08090.png][]

结束！

[SpringCloud]: https://so.csdn.net/so/search?q=%E5%B0%9A%E7%A1%85%E8%B0%B7SpringCloud&spm=1001.2101.3001.7020
[c585cd1af50c4526b53a676cc1789c9c.png]: https://img-blog.csdnimg.cn/c585cd1af50c4526b53a676cc1789c9c.png
[Seata]: http://seata.io/zh-cn/
[4f6271941fb849c890b4c0bc1dd59bee.png]: https://img-blog.csdnimg.cn/4f6271941fb849c890b4c0bc1dd59bee.png
[8d62f7797c01422ea0a4e731aab57585.png]: https://img-blog.csdnimg.cn/8d62f7797c01422ea0a4e731aab57585.png
[b7ce6a5b03ac424bb7ac5c86270cba2e.png]: https://img-blog.csdnimg.cn/b7ce6a5b03ac424bb7ac5c86270cba2e.png
[f002c952b6974aa2adcf79dfe0052cc7.png]: https://img-blog.csdnimg.cn/f002c952b6974aa2adcf79dfe0052cc7.png
[https_github.com_seata_seata_releases]: https://github.com/seata/seata/releases%E4%B8%8B%E8%BD%BD%E7%9A%84%E6%98%AFseata-server-0.9.0.zip
[8d873ff074b742a29cf43d0ba9f9b243.png]: https://img-blog.csdnimg.cn/8d873ff074b742a29cf43d0ba9f9b243.png
[598f18cdb84648bb9079e11d2597365e.png]: https://img-blog.csdnimg.cn/598f18cdb84648bb9079e11d2597365e.png
[9287072d2da344af8b45a15815cd59e0.png]: https://img-blog.csdnimg.cn/9287072d2da344af8b45a15815cd59e0.png
[22debdac952a49b38081f25b680bff73.png]: https://img-blog.csdnimg.cn/22debdac952a49b38081f25b680bff73.png
[b6619b14300a4aaa93c9605cfab28f9a.png]: https://img-blog.csdnimg.cn/b6619b14300a4aaa93c9605cfab28f9a.png
[366bad799a244838a0a8be8707bdfd95.png]: https://img-blog.csdnimg.cn/366bad799a244838a0a8be8707bdfd95.png
[0f4976f1ac0e46738545238360aec6fe.png]: https://img-blog.csdnimg.cn/0f4976f1ac0e46738545238360aec6fe.png
[1136818e38234a7ab7c7b85b2b21dac6.png]: https://img-blog.csdnimg.cn/1136818e38234a7ab7c7b85b2b21dac6.png
[98fb592a226f4305ae045fae23893130.png]: https://img-blog.csdnimg.cn/98fb592a226f4305ae045fae23893130.png
[adc2c72dc68b44b6a2b7ddd33dc741ed.png]: https://img-blog.csdnimg.cn/adc2c72dc68b44b6a2b7ddd33dc741ed.png
[ad8b1e1a9e9f42808dc480bb8efca1f5.png]: https://img-blog.csdnimg.cn/ad8b1e1a9e9f42808dc480bb8efca1f5.png
[8652daf482a6455b98f5cb7bf0efc268.png]: https://img-blog.csdnimg.cn/8652daf482a6455b98f5cb7bf0efc268.png
[d2e6225d28494fc5a03e7ef3d6e3a74f.png]: https://img-blog.csdnimg.cn/d2e6225d28494fc5a03e7ef3d6e3a74f.png
[49367d0dd03248b18d2ca808274d9c7b.png]: https://img-blog.csdnimg.cn/49367d0dd03248b18d2ca808274d9c7b.png
[1d6a00f0028a4c31a331ecf7b86d72ab.png]: https://img-blog.csdnimg.cn/1d6a00f0028a4c31a331ecf7b86d72ab.png
[e60089fe02cd49009f5c25c2b9266fd1.png]: https://img-blog.csdnimg.cn/e60089fe02cd49009f5c25c2b9266fd1.png
[f99c38989e3d4f65b50e0caab82b257e.png]: https://img-blog.csdnimg.cn/f99c38989e3d4f65b50e0caab82b257e.png
[051644fd90754e08bb385613fd96875f.png]: https://img-blog.csdnimg.cn/051644fd90754e08bb385613fd96875f.png
[f180a6e2ffad4ed4a314cc5fc525310e.png]: https://img-blog.csdnimg.cn/f180a6e2ffad4ed4a314cc5fc525310e.png
[cc70a85d01bc4a25a180f6bff772fb25.png]: https://img-blog.csdnimg.cn/cc70a85d01bc4a25a180f6bff772fb25.png
[http_localhost_2001_order_create_userId_1_productId_1_count_10_money_100]: http://localhost:2001/order/create?userId=1&productId=1&count=10&money=100
[e6f5bc9539414d3e9ee5782f6bb78cf4.png]: https://img-blog.csdnimg.cn/e6f5bc9539414d3e9ee5782f6bb78cf4.png
[a7faa51048394f409948f3660c744cf4.png]: https://img-blog.csdnimg.cn/a7faa51048394f409948f3660c744cf4.png
[b00bfb248e7640c1aa19e022b8d9657a.png]: https://img-blog.csdnimg.cn/b00bfb248e7640c1aa19e022b8d9657a.png
[4e140b433e97447e94ac256bae6674a5.png]: https://img-blog.csdnimg.cn/4e140b433e97447e94ac256bae6674a5.png
[b0d97b4a867845f587ea611b26c5a6c1.png]: https://img-blog.csdnimg.cn/b0d97b4a867845f587ea611b26c5a6c1.png
[5970ffa2ec444e70954ee33557a00d4c.png]: https://img-blog.csdnimg.cn/5970ffa2ec444e70954ee33557a00d4c.png
[2f2bb845f5954c96890d5ce994183f01.png]: https://img-blog.csdnimg.cn/2f2bb845f5954c96890d5ce994183f01.png
[c045f77511e7494c879ccfc1e73bf824.png]: https://img-blog.csdnimg.cn/c045f77511e7494c879ccfc1e73bf824.png
[135bb5afa68849e79774a7e27e16ba1f.png]: https://img-blog.csdnimg.cn/135bb5afa68849e79774a7e27e16ba1f.png
[099d4acf0bca47c788f5375314cebf17.png]: https://img-blog.csdnimg.cn/099d4acf0bca47c788f5375314cebf17.png
[50a292eab93b49d7a011314ba2471624.png]: https://img-blog.csdnimg.cn/50a292eab93b49d7a011314ba2471624.png
[7eb1f3e61213429199deeb2aeee08090.png]: https://img-blog.csdnimg.cn/7eb1f3e61213429199deeb2aeee08090.png