SpringCloudAlibaba--分布式事务--Seata配置搭建

1. Seata搭建分布式事务之数据库准备：
   1. 

       

   2. 

       

       

   3. 

       

       

   4. 

       

       

   5. 

       

       

       

   6. 

       

       

   7. 

       

       

   8. CREATE DATABASE seata_order;
      
      CREATE DATABASE seata_storage;
      
      CREATE DATABASE seata_account;
      
      
      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;
      
      
      
      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');
      
      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);

       

   9.  

      

       

   10. 

   11. 

        

   12. <?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>SpringCloud</artifactId>
               <groupId>com.model</groupId>
               <version>1.0-SNAPSHOT</version>
           </parent>
           <modelVersion>4.0.0</modelVersion>
       
           <artifactId>springcloudalibaba006-seata-order-service2001</artifactId>
       
           <properties>
               <maven.compiler.source>8</maven.compiler.source>
               <maven.compiler.target>8</maven.compiler.target>
           </properties>
           <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>
                           <groupId>seata-all</groupId>
                           <artifactId>io.seata</artifactId>
                       </exclusion>
                   </exclusions>
               </dependency>
               <dependency>
                   <groupId>io.seata</groupId>
                   <artifactId>seata-all</artifactId>
                   <version>1.0.0</version>
               </dependency>
       
               <dependency>
                   <groupId>mysql</groupId>
                   <artifactId>mysql-connector-java</artifactId>
               </dependency>
               <dependency>
                   <groupId>org.springframework.cloud</groupId>
                   <artifactId>spring-cloud-starter-openfeign</artifactId>
               </dependency>
       
               <dependency>
                   <groupId>com.ruijc</groupId>
                   <artifactId>spring-boot-starter-mybatis</artifactId>
                   <version>3.2.2</version>
               </dependency>
       
               <dependency>
                   <groupId>com.alibaba.cloud</groupId>
                   <artifactId>spring-cloud-alibaba-sentinel</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>org.projectlombok</groupId>
                   <artifactId>lombok</artifactId>
               </dependency>
               <dependency>
                   <groupId>org.springframework.boot</groupId>
                   <artifactId>spring-boot-starter-test</artifactId>
               </dependency>
               <dependency>
                   <groupId>org.springframework.boot</groupId>
                   <artifactId>spring-boot-devtools</artifactId>
               </dependency>
               <dependency>
                   <groupId>log4j</groupId>
                   <artifactId>log4j</artifactId>
               </dependency>
           </dependencies>
       
       </project>

        

   13.  

       server:
         port: 2001
       spring:
         application:
           name: seata-order-service
         cloud:
           alibaba:
       #        自定义事务组名称
               seata:
                 tx-service-group: fsp_tx_group
       
           nacos:
             discovery:
               server-addr: localhost:8848
         datasource:
           username: root
           password: 123456
           driver-class-name: com.mysql.jdbc.Driver
           url: jdbc:mysql://localhost:3306/seata_order?characterEncoding=utf8&serverTimezone=Asia/Shanghai&useSSL=false
       
       
       feign:
         hystrix:
           enabled: false
       #logging:
       #  level: info
       mybatis:
         mapper-locations: classpath:mapper/*.xml
         configuration:
           map-underscore-to-camel-case: true

        

   14.  

       

        

        

   15. 

        

        

   16. 

        

        

   17. 

        

        

   18. 

        

        

   19. 

        

        

   20. 

        

        

   21. 

        

        

   22. 

        

        

   23.