springcloud3 Seata客户端的编写测试事务的性能2

本文链接：https://blog.youkuaiyun.com/u011066470/article/details/129309853

本文介绍了在一个软件项目中使用的各种技术版本，包括SpringBoot、SpringCloudHoxton.SR9、SpringCloudAlibaba、Nacos、Seata等。详细展示了Seata的依赖配置、工程结构、配置文件以及关键代码，如数据源配置、Mapper接口和全局事务注解。文章还提到了启动服务的步骤以及在遇到问题时的测试情况，揭示了在没有事务管理注解时数据会直接入库，而启用事务管理后可以进行回滚。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

一软件版本的介绍

1.1 软件版本介绍

1.springboot 2.3.2.

2.springcloud Hoxton.SR9

3.springcloud-alibaba 2.2.6.RELEASE

4.nacos 1.4.4

5.seata 1.4.2

6.seata pom文件的配置

    <!-- seata的依赖-->
    <dependency>
      <groupId>com.alibaba.cloud</groupId>
      <artifactId>spring-cloud-starter-alibaba-seata</artifactId>
      <exclusions>
        <exclusion>
          <groupId>io.seata</groupId>
          <artifactId>seata-spring-boot-starter</artifactId>
        </exclusion>
      </exclusions>
    </dependency>
    <dependency>
      <groupId>io.seata</groupId>
      <artifactId>seata-spring-boot-starter</artifactId>
      <version>1.4.2</version>
    </dependency>

1.2 说明

本案例的操作是在： https://mp.youkuaiyun.com/mp_blog/creation/editor/129052158 seata搭建服务之后的进行操作。

二操作

2.1 工程结构

2.2 工程搭建

2.2.1 pom文件


    <dependency>
      <groupId>org.mybatis.spring.boot</groupId>
      <artifactId>mybatis-spring-boot-starter</artifactId>
      <version>1.3.2</version>
    </dependency>
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
    </dependency>
    <!-- seata的依赖-->
    <dependency>
      <groupId>com.alibaba.cloud</groupId>
      <artifactId>spring-cloud-starter-alibaba-seata</artifactId>
      <exclusions>
        <exclusion>
          <groupId>io.seata</groupId>
          <artifactId>seata-spring-boot-starter</artifactId>
        </exclusion>
      </exclusions>
    </dependency>
    <dependency>
      <groupId>io.seata</groupId>
      <artifactId>seata-spring-boot-starter</artifactId>
      <version>1.4.2</version>
    </dependency>
    <!--SpringCloud ailibaba nacos -->
    <dependency>
      <groupId>com.alibaba.cloud</groupId>
      <artifactId>spring-cloud-starter-alibaba-nacos-discovery</artifactId>
    </dependency>
    <!-- SpringBoot整合Web组件 -->
    <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.apache.commons</groupId>
      <artifactId>commons-lang3</artifactId>
      <version>3.4</version>
    </dependency>
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-core</artifactId>
    </dependency>
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-databind</artifactId>
    </dependency>
    <dependency>
      <groupId>com.fasterxml.jackson.datatype</groupId>
      <artifactId>jackson-datatype-joda</artifactId>
      <version>2.9.6</version>
    </dependency>
    <dependency>
      <groupId>com.fasterxml.jackson.module</groupId>
      <artifactId>jackson-module-parameter-names</artifactId>
    </dependency>
    <!-- 分页插件 -->
    <dependency>
      <groupId>com.github.pagehelper</groupId>
      <artifactId>pagehelper-spring-boot-starter</artifactId>
      <version>1.2.5</version>
    </dependency>
    <!-- alibaba的druid数据库连接池 -->
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid-spring-boot-starter</artifactId>
      <version>1.1.9</version>
    </dependency>

2.2.2 配置文件

1.application配置文件

2.application-dev配置文件

关键信息配置

2.详情代码

# nacos配置
server:
  port: 7004

spring:
  datasource:
    name: mysql_test
    type: com.alibaba.druid.pool.DruidDataSource
    #druid相关配置
    druid:
      #监控统计拦截的filters
      filters: stat
      driver-class-name: com.mysql.jdbc.Driver
      #基本属性
      url: jdbc:mysql://127.0.0.1:3306/seata?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true
      username: root
      password: cloudiip
      #配置初始化大小/最小/最大
      initial-size: 1
      min-idle: 1
      max-active: 20
      #获取连接等待超时时间
      max-wait: 60000
      #间隔多久进行一次检测，检测需要关闭的空闲连接
      time-between-eviction-runs-millis: 60000
      #一个连接在池中最小生存的时间
      min-evictable-idle-time-millis: 300000
      validation-query: SELECT 'x'
      test-while-idle: true
      test-on-borrow: false
      test-on-return: false
      #打开PSCache，并指定每个连接上PSCache的大小。oracle设为true，mysql设为false。分库分表较多推荐设置为false
      pool-prepared-statements: false
      max-pool-prepared-statement-per-connection-size: 20
  application:
    name: mb-111
  cloud:
    nacos:
      discovery:
        server-addr: localhost:8848 #Nacos服务注册中心地址
      #config:
       # server-addr: localhost:8848 #Nacos作为配置中心地址
        #file-extension: yaml #指定yaml格式的配置
        #group: DEV_GROUP_ljf
        #namespace: 05573840-fcf3-472d-a64a-c66b4fe878f4
    alibaba:
      seata: #设置事务分支 默认就是 my_test_tx_group
        tx-service-group: default_tx_group
mybatis:
  mapper-locations: classpath:mapper/*.xml
  type-aliases-package: com.ljf.mscloud.model
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
#pagehelper
pagehelper:
  helperDialect: mysql
  reasonable: true
  supportMethodsArguments: true
  params: count=countSql
  returnPageInfo: check
seata:
  enabled: true
  enable-auto-data-source-proxy: true
  tx-service-group: default_tx_group #此处与上面config.txt中的vgroupMapping一致
  registry:
    type: nacos
    nacos:
      application: seata-server    #服务name要和nacos中保持一致 默认就是seata-server
      server-addr: 127.0.0.1:8848  #根据自己情况调整
      username: nacos              #根据自己情况调整
      password: nacos          #根据自己情况调整
      cluster: default
      group: DEV_GROUP_ljf
      namespace: 05573840-fcf3-472d-a64a-c66b4fe878f4  #根据自己情况调整
  config:
    type: nacos
    nacos:
      server-addr: 127.0.0.1:8848 #根据自己情况调整
      group: DEV_GROUP_ljf
      username: nacos       #根据自己情况调整
      password: nacos         #根据自己情况调整
      dataId: seata-server.properties
      namespace: 05573840-fcf3-472d-a64a-c66b4fe878f4    #根据自己情况调整
  service:
    vgroup-mapping:
      default_tx_group: default

2.2.3 其他业务层

1.controller

@RestController
//@RefreshScope //支持Nacos的动态刷新功能。
public class OrderController {
    @Autowired
    private OrderService orderService;
    @RequestMapping("/stationInfo")
    public Object queryWsBasicInfo(){
        Map<String,Object> resultMap=new TreeMap<String,Object>();
        resultMap.put("list",orderService.queryOrderList());
        resultMap.put("time:",new Date());
        return resultMap;
    }

    @RequestMapping("/addInfo")
    //@GlobalTransactional
    //seata事务控制注解,name自定义保证唯一性
    @GlobalTransactional(name = "save-funds", rollbackFor = Exception.class)
    public Object addInfo(String orderName,String orderNo){
        System.out.println("==================================================name:"+orderName+" no:"+orderNo);
        Order order=new Order();
        order.setOrderName(orderName);
        order.setOrderNo(orderNo);
        int m=orderService.addInfo(order);
        int k=5/0;
        return m;
    }
}

2.service

public interface OrderService {
    public List<Order> queryOrderList();
    public int  addInfo(Order order);
}

@Service
public class OrderServiceImpl  implements OrderService {
    @Autowired
    private OrderDao orderDao;
    @Override
    public List<Order> queryOrderList() {
        return orderDao.queryOrderList();
    }

    @Override
    public int addInfo(Order order) {
        return orderDao.addInfo(order);
    }
}

3.dao

@Mapper
public interface OrderDao {
    public List<Order> queryOrderList();
     public int  addInfo(Order order);
}

4.mapper

<?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.ljf.mscloud.dao.OrderDao" >

	<select id="queryOrderList" resultType="com.ljf.mscloud.model.Order">
	     select   * from tb_order
	</select>
   <insert id="addInfo" parameterType="com.ljf.mscloud.model.Order">
	   insert into tb_order values(null,#{orderName},#{orderNo})
   </insert>
</mapper>

5.启动类

@EnableDiscoveryClient
@SpringBootApplication
@EnableAutoDataSourceProxy
public class App 
{
    public static void main( String[] args )
    {
        SpringApplication.run(App.class, args);
        System.out.println("服务启动成功！！！！！！！");
    }
}

2.3 附加undo.log表

CREATE TABLE `undo_log` (
  `branch_id` bigint(20) NOT NULL COMMENT 'branch transaction id',
  `xid` varchar(128) NOT NULL COMMENT 'global transaction id',
  `context` varchar(128) NOT NULL COMMENT 'undo_log context,such as serialization',
  `rollback_info` longblob NOT NULL COMMENT 'rollback info',
  `log_status` int(11) NOT NULL COMMENT '0:normal status,1:defense status',
  `log_created` datetime(6) NOT NULL COMMENT 'create datetime',
  `log_modified` datetime(6) NOT NULL COMMENT 'modify datetime',
  UNIQUE KEY `ux_undo_log` (`xid`,`branch_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='AT transaction mode undo table';

2.4 启动服务

1.启动nacos，再启动seata

2.最后启动工程

2.5 测试

1.请求地址： http://localhost:7004/addInfo?orderName=juzi&orderNo=240

页面不停的刷新，查看数据库，也没有入到库中

后台日志:

2.将

@GlobalTransactional(name = "save-funds", rollbackFor = Exception.class)  注解注释掉，再次访问

刷新地址，多次访问：

可以看到后台报错，没有事务回滚，报错数据也入到库中了