springboot2整合seata(AT模式)
1.启动seata服务
docker启动seata-server实例，使用1.3.0版本
docker pull seataio/seata-server:1.3.0
docker run --name seata-server -p 8091:8091 seataio/seata-server
2.创建三个项目实现下订单、库存减少分布式事物
dkn-provider-order 下订单服务
dkn-provider-store 库存服务
dkn-shop 模拟用户购买商品服务
1.dkn-provider-orde和dkn-provider-store的pom.xml
<dependencyManagement>
<dependencies>
<dependency>
<groupId>com.alibaba.cloud</groupId>
<artifactId>spring-cloud-alibaba-dependencies</artifactId>
<version>2.2.3.RELEASE</version>
<type>pom</type>
<scope>import</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-dependencies</artifactId>
<version>2.3.8.RELEASE</version>
<type>pom</type>
<scope>import</scope>
</dependency>
<dependency>
<groupId>org.springframework.cloud</groupId>
<artifactId>spring-cloud-dependencies</artifactId>
<version>Hoxton.SR8</version>
<type>pom</type>
<scope>import</scope>
</dependency>
</dependencies>
</dependencyManagement>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-actuator</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-configuration-processor</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-devtools</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.2.2</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.4.2</version>
</dependency>
<dependency>
<groupId>com.alibaba.cloud</groupId>
<artifactId>spring-cloud-alibaba-seata</artifactId>
<version>2.2.0.RELEASE</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</dependency>
2.yml配置文件 dkn-provider-orde和dkn-provider-store
端口，服务名称、数据库信息，application-id需要换下
server:
port: 9102
spring:
application:
name: dkn-provider-order
datasource:
druid:
url: jdbc:mysql://localhost:3306/dkn-provider-order?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
driverClassName: com.mysql.cj.jdbc.Driver
username: root
password: root
seata:
enabled: true
application-id: dkn-provider-order
tx-service-group: dkn_tx_group
enable-auto-data-source-proxy: false #一定要是false
service:
vgroup-mapping:
dkn_tx_group: default #key与上面的tx-service-group的值对应
grouplist:
default: 10.0.0.70:8091 #seata-server地址仅file注册中心需要
config:
type: file
registry:
type: file
logging:
level:
com.dkn: debug
3.SeataConfig配置，这个都一样，dkn-shop不需要添加
@Configuration
public class SeataConfig {
@Bean
@ConfigurationProperties(prefix = "spring.datasource.druid")
public DataSource druidDataSource(){
DruidDataSource druidDataSource = new DruidDataSource();
return druidDataSource;
}
@Primary
@Bean("dataSource")
public DataSourceProxy dataSource(DataSource druidDataSource){
return new DataSourceProxy(druidDataSource);
}
}
4.service和controller
@Service
public class DknOrderServiceImpl extends ServiceImpl<DknOrderMapper,DknOrder> implements DknOrderService {
@Override
public boolean add(Integer productid, Integer num) {
DknOrder dknOrder=new DknOrder();
dknOrder.setNum(num);
dknOrder.setProductid(productid);
return this.save(dknOrder);
}
}
@Service
public class StoreServiceImpl extends ServiceImpl<StoreMapper,Store> implements StoreService {
@Override
public boolean reduce(Integer productid,Integer n) {
UpdateWrapper<Store> updateWrapper=new UpdateWrapper<Store>();
updateWrapper.setSql("num = num - "+n);
updateWrapper.eq("productid", productid);
return this.update(updateWrapper);
}
}
@RestController
@RequestMapping("/Order")
public class DknOrderController {
@Autowired
private DknOrderService dknOrderService;
@GetMapping("add")
public AjaxResult add(Integer productid, Integer num){
boolean result=dknOrderService.add(productid,num);
if(result){
return AjaxResult.success();
}else{
return AjaxResult.error();
}
}
}
@RestController
@RequestMapping("/Store")
public class StoreController {
@Autowired
private StoreService storeService;
@GetMapping("reduce")
public AjaxResult reduce(Integer productid,Integer num){
boolean result=storeService.reduce(productid,num);
if(result){
return AjaxResult.success();
}else{
return AjaxResult.error();
}
}
}
@SpringBootApplication(exclude = DataSourceAutoConfiguration.class)
public class OrderApplication {
public static void main(String[] args) {
SpringApplication.run(OrderApplication.class, args);
}
}
@SpringBootApplication(exclude = DataSourceAutoConfiguration.class)
public class StoreApplication {
public static void main(String[] args) {
SpringApplication.run(StoreApplication.class, args);
}
}
5.dkn-shop配置
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-actuator</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-configuration-processor</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-devtools</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>com.alibaba.cloud</groupId>
<artifactId>spring-cloud-alibaba-seata</artifactId>
<version>2.2.0.RELEASE</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.cloud</groupId>
<artifactId>spring-cloud-starter-openfeign</artifactId>
</dependency>
<dependency>
<groupId>io.github.openfeign</groupId>
<artifactId>feign-httpclient</artifactId>
</dependency>
server:
port: 9100
spring:
application:
name: dkn-shop
seata:
enabled: true
application-id: dkn-shop
tx-service-group: dkn_tx_group
enable-auto-data-source-proxy: false #一定要是false
service:
vgroup-mapping:
dkn_tx_group: default #key与上面的tx-service-group的值对应
grouplist:
default: 10.0.0.70:8091 #seata-server地址仅file注册中心需要
config:
type: file
registry:
type: file
#开启使用 httpclient
feign:
httpclient:
enabled: true
logging:
level:
com.dkn: debug
org.apache.http: debug
@EnableFeignClients
@SpringBootApplication
public class ShopApplication {
public static void main(String[] args) {
SpringApplication.run(ShopApplication.class, args);
}
}
@FeignClient(name="dkn-provider-order", url = "http://localhost:9102")
@Service
public interface OrderService {
@GetMapping("/Order/add")
public AjaxResult add(@RequestParam(name = "productid") Integer productid, @RequestParam(name = "num") Integer num);
}
@FeignClient(name="dkn-provider-store", url = "http://localhost:9101")
@Service
public interface StoreService {
@GetMapping("/Store/reduce")
public AjaxResult reduce(@RequestParam(name = "productid") Integer productid, @RequestParam(name = "num") Integer num);
}
@Service
public class ShopService {
@Autowired
OrderService orderService;
@Autowired
StoreService storeService;
@GlobalTransactional
public void buy(Integer productid,Integer num){
orderService.add(productid,num);
storeService.reduce(productid,num);
}
@GlobalTransactional
public void buyError(Integer productid,Integer num){
orderService.add(productid,num);
int a=1/0;
storeService.reduce(productid,num);
}
}
@RestController
@RequestMapping("/Shop")
public class ShopController {
@Autowired
private ShopService shopService;
//测试正常 http://localhost:9100/Shop/buy?productid=101&num=2
@GetMapping("buy")
public AjaxResult buy(Integer productid, Integer num){
shopService.buy(productid,num);
return AjaxResult.success();
}
//测试错误 http://localhost:9100/Shop/buy?productid=101&num=2
@GetMapping("buyError")
public AjaxResult buyError(Integer productid, Integer num){
shopService.buyError(productid,num);
return AjaxResult.success();
}
}
6.数据库文件
-- ----------------------------
-- Table structure for store
-- ----------------------------
DROP TABLE IF EXISTS `store`;
CREATE TABLE `store` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
`productid` int(11) DEFAULT NULL COMMENT '商品id',
`productname` varchar(255) DEFAULT NULL COMMENT '商品名称',
`num` int(11) DEFAULT NULL COMMENT '库存数量',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of store
-- ----------------------------
INSERT INTO `store` VALUES ('1', '101', '笔记本', '100');
-- ----------------------------
-- Table structure for undo_log
-- ----------------------------
DROP TABLE IF EXISTS `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=4 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of undo_log
-- ----------------------------
-- ----------------------------
-- Table structure for dkn_order
-- ----------------------------
DROP TABLE IF EXISTS `dkn_order`;
CREATE TABLE `dkn_order` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
`productid` int(11) DEFAULT NULL COMMENT '商品id',
`num` int(11) DEFAULT NULL COMMENT '购买数量',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of dkn_order
-- ----------------------------
-- ----------------------------
-- Table structure for undo_log
-- ----------------------------
DROP TABLE IF EXISTS `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=14 DEFAULT CHARSET=utf8;
