begin transaction；
    //1.本地数据库操作：张三减少金额
    //2.本地数据库操作：李四增加金额
commit transation;

begin transaction；
    //1.本地数据库操作：张三减少金额
    //2.远程调用：让李四增加金额
commit transation;

CREATE DATABASE `bank1` CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

DROP TABLE IF EXISTS `account_info`; CREATE TABLE `account_info` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`account_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '户主姓名',
`account_no` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '银行卡号',
`account_password` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '帐户密码',
`account_balance` double NULL DEFAULT NULL COMMENT '帐户余额',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT =
Dynamic;
INSERT INTO `account_info` VALUES (2, '张三的账户', '1', '', 10000);

CREATE DATABASE `bank2` CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

CREATE TABLE `account_info` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`account_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '户主姓名',
`account_no` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '银行卡号',
`account_password` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '帐户密码',
`account_balance` double NULL DEFAULT NULL COMMENT '帐户余额',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT =
Dynamic;
INSERT INTO `account_info` VALUES (3, '李四的账户', '2', NULL, 0);

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;

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring‐boot‐dependencies</artifactId>
    <version>2.1.3.RELEASE</version>
    <type>pom</type>
    <scope>import</scope>
</dependency>

<dependency>
    <groupId>org.springframework.cloud</groupId>
    <artifactId>spring‐cloud‐dependencies</artifactId>
    <version>Greenwich.RELEASE</version>
    <type>pom</type>
    <scope>import</scope>
</dependency>

<dependency>
    <groupId>com.alibaba.cloud</groupId>
    <artifactId>spring‐cloud‐alibaba‐dependencies</artifactId>
    <version>2.1.0.RELEASE</version>
    <type>pom</type>
    <scope>import</scope>
</dependency>

@Configuration
public class DatabaseConfiguration { @Bean
    @ConfigurationProperties(prefix = "spring.datasource.ds0") public DruidDataSource ds0() {
        DruidDataSource druidDataSource = new DruidDataSource();

        return druidDataSource;
    }

@Primary @Bean
    public DataSource dataSource(DruidDataSource ds0) { 
    	DataSourceProxy pds0 = new DataSourceProxy(ds0); return pds0;
    }
}

@Mapper @Component
public interface AccountInfoDao {

    //更新账户金额
    @Update("update account_info set account_balance = account_balance + #{amount} where account_no = #{accountNo}")
    int updateAccountBalance(@Param("accountNo") String accountNo, @Param("amount") Double amount);

}

@FeignClient(value = "seata‐demo‐bank2",fallback = Bank2ClientFallback.class) public interface Bank2Client {

    @GetMapping("/bank2/transfer")
    String transfer(@RequestParam("amount") Double amount);
}

@Component
public class Bank2ClientFallback implements Bank2Client{ 
    @Override
    public String transfer(Double amount) {
        return "fallback";
    }
}

@Service
public class AccountInfoServiceImpl implements AccountInfoService {
    private Logger logger = LoggerFactory.getLogger(AccountInfoServiceImpl.class); @Autowired
    AccountInfoDao accountInfoDao;

    @Autowired
    Bank2Client bank2Client;

    //张三转账@Override
    @GlobalTransactional @Transactional
        public void updateAccountBalance(String accountNo, Double amount) { 					logger.info("******** Bank1 Service Begin ... xid: {}" , RootContext.getXID());
        //张三扣减金额
        accountInfoDao.updateAccountBalance(accountNo,amount*‐1);
        //向李四转账
        String remoteRst = bank2Client.transfer(amount);
        //远程调用失败if(remoteRst.equals("fallback")){
        throw new RuntimeException("bank1 下游服务异常");
        }
        //人为制造错误if(amount==3){
        throw new RuntimeException("bank1 make exception 3");
        }
    }
}

@RestController
public class Bank1Controller {

    @Autowired
    AccountInfoService accountInfoService;

    //转账@GetMapping("/transfer")
    public String transfer(Double amount){ 				  						accountInfoService.updateAccountBalance("1",amount); return "bank1"+amount;
    }
}

@Mapper @Component
public interface AccountInfoDao {
    //向李四转账
    @Update("UPDATE account_info SET account_balance = account_balance + #{amount} WHERE account_no = #{accountNo}")
    int updateAccountBalance(@Param("accountNo") String accountNo, @Param("amount") Double amount);

}

@Service
public class AccountInfoServiceImpl implements AccountInfoService {
    private Logger logger = LoggerFactory.getLogger(AccountInfoServiceImpl.class); @Autowired
    AccountInfoDao accountInfoDao;
    @Override @Transactional
    public void updateAccountBalance(String accountNo, Double amount) {
        logger.info("******** Bank2 Service Begin ... xid: {}" , RootContext.getXID());
        //李四增加金额accountInfoDao.updateAccountBalance(accountNo,amount);
        //制造异常
        if(amount==2){
            throw new RuntimeException("bank1 make exception 2");
        }
    }
}

@RestController
public class Bank2Controller {

    @Autowired
    AccountInfoService accountInfoService;

    @GetMapping("/transfer")
    public String transfer(Double amount){ 	accountInfoService.updateAccountBalance("2",amount); return "bank2"+amount;
    }
}

try：
    检查余额是否够30元
    扣减30元
confirm：
	空
cancel：
	增加30元

try：
    增加30元
confirm： 
	空
cancel：
	减少30元

try：
    try幂等校验
    try悬挂处理
    检查余额是否够30元
    扣减30元
confirm： 
	空
cancel：
	cancel幂等校验
	cancel空回滚处理
	增加可用余额30元

try：
	空
confirm：
    confirm幂等校验
    正式增加30元
cancel：
	空

CREATE DATABASE `hmily` CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

CREATE DATABASE `bank1` CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

DROP TABLE IF EXISTS `account_info`; CREATE TABLE `account_info` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`account_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '户主姓名',
`account_no` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '银行卡号',
`account_password` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '帐户密码',
`account_balance` double NULL DEFAULT NULL COMMENT '帐户余额',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT =
Dynamic;
INSERT INTO `account_info` VALUES (2, '张三的账户', '1', '', 10000);

CREATE DATABASE `bank2` CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

CREATE TABLE `account_info` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`account_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '户主姓名',
`account_no` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '银行卡号',
`account_password` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '帐户密码',
`account_balance` double NULL DEFAULT NULL COMMENT '帐户余额',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT =
Dynamic;
INSERT INTO `account_info` VALUES (3, '李四的账户', '2', NULL, 0);

CREATE TABLE `local_try_log` (
`tx_no` varchar(64) NOT NULL COMMENT '事务id',
`create_time` datetime DEFAULT NULL, PRIMARY KEY (`tx_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
CREATE TABLE `local_confirm_log` (
`tx_no` varchar(64) NOT NULL COMMENT '事务id',
`create_time` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8
CREATE TABLE `local_cancel_log` (
`tx_no` varchar(64) NOT NULL COMMENT '事务id',
`create_time` datetime DEFAULT NULL, PRIMARY KEY (`tx_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

<dependency>
    <groupId>org.dromara</groupId>
    <artifactId>hmily‐springcloud</artifactId>
    <version>2.0.4‐RELEASE</version>
</dependency>

org:
    dromara:
        hmily :
        serializer : kryo recoverDelayTime : 128
        retryMax : 30
        scheduledDelay : 128
        scheduledThreadMax : 10 
        repositorySupport : db 
        started: true 
        hmilyDbConfig :
            driverClassName : com.mysql.jdbc.Driver
            url : jdbc:mysql://localhost:3306/bank?useUnicode=true username : root
            password : root

@Bean
public HmilyTransactionBootstrap hmilyTransactionBootstrap(HmilyInitService hmilyInitService){ 
    HmilyTransactionBootstrap hmilyTransactionBootstrap = new
    HmilyTransactionBootstrap(hmilyInitService); hmilyTransactionBootstrap.setSerializer(env.getProperty("org.dromara.hmily.serializer"));

    hmilyTransactionBootstrap.setRecoverDelayTime(Integer.parseInt(env.getProperty("org.dromara.hmi ly.recoverDelayTime")));

    hmilyTransactionBootstrap.setRetryMax(Integer.parseInt(env.getProperty("org.dromara.hmily.retry Max")));

    hmilyTransactionBootstrap.setScheduledDelay(Integer.parseInt(env.getProperty("org.dromara.hmily
    .scheduledDelay")));

    hmilyTransactionBootstrap.setScheduledThreadMax(Integer.parseInt(env.getProperty("org.dromara.h mily.scheduledThreadMax")));

    hmilyTransactionBootstrap.setRepositorySupport(env.getProperty("org.dromara.hmily.repositorySup port"));
    hmilyTransactionBootstrap.setStarted(Boolean.parseBoolean(env.getProperty("org.dromara.hmily.st arted")));
    HmilyDbConfig hmilyDbConfig = new HmilyDbConfig();

    hmilyDbConfig.setDriverClassName(env.getProperty("org.dromara.hmily.hmilyDbConfig.driverClassNa me"));
    hmilyDbConfig.setUrl(env.getProperty("org.dromara.hmily.hmilyDbConfig.url")); hmilyDbConfig.setUsername(env.getProperty("org.dromara.hmily.hmilyDbConfig.username")); hmilyDbConfig.setPassword(env.getProperty("org.dromara.hmily.hmilyDbConfig.password")); hmilyTransactionBootstrap.setHmilyDbConfig(hmilyDbConfig);
    return hmilyTransactionBootstrap;
}

@SpringBootApplication @EnableDiscoveryClient @EnableHystrix
@EnableFeignClients(basePackages = {"cn.itcast.dtx.tccdemo.bank1.spring"}) @ComponentScan({"cn.itcast.dtx.tccdemo.bank1","org.dromara.hmily"}) public class Bank1HmilyServer {
    public static void main(String[] args) { SpringApplication.run(Bank1HmilyServer.class, args);

    }
}

try：
    try幂等校验
    try悬挂处理
    检查余额是够扣减金额
    扣减金额
confirm：
	空
cancel：
    cancel幂等校验
    cancel空回滚处理
    增加可用余额

@Mapper @Component
public interface AccountInfoDao {
@Update("update account_info set account_balance=account_balance ‐ #{amount} where account_balance>#{amount} and account_no=#{accountNo} ")
int subtractAccountBalance(@Param("accountNo") String accountNo, @Param("amount") Double amount);
@Update("update account_info set account_balance=account_balance + #{amount} where account_no=#{accountNo} ")
int addAccountBalance(@Param("accountNo") String accountNo, @Param("amount") Double amount);

/**
*增加某分支事务try执行记录
*@param localTradeNo 本地事务编号
*@return
*/
@Insert("insert into local_try_log values(#{txNo},now());") int addTry(String localTradeNo);

@Insert("insert into local_confirm_log values(#{txNo},now());") int addConfirm(String localTradeNo);

@Insert("insert into local_cancel_log values(#{txNo},now());") int addCancel(String localTradeNo);

/**
*查询分支事务try是否已执行
*@param localTradeNo 本地事务编号
*@return
*/
@Select("select count(1) from local_try_log where tx_no = #{txNo} ") int isExistTry(String localTradeNo);
/**
*查询分支事务confirm是否已执行
*@param localTradeNo 本地事务编号
*@return
*/
@Select("select count(1) from local_confirm_log where tx_no = #{txNo} ") int isExistConfirm(String localTradeNo);

/**
*查询分支事务cancel是否已执行
*@param localTradeNo 本地事务编号
*@return
*/
@Select("select count(1) from local_cancel_log where tx_no = #{txNo} ") int isExistCancel(String localTradeNo);

}

@Service @Slf4j
public class AccountInfoServiceImpl implements AccountInfoService {
    private Logger logger = LoggerFactory.getLogger(AccountInfoServiceImpl.class);



    @Autowired
    private AccountInfoDao accountInfoDao;

    @Autowired
    private Bank2Client bank2Client;

    @Override @Transactional
    @Hmily(confirmMethod = "commit", cancelMethod = "rollback")
    public void updateAccountBalance(String accountNo, Double amount) {
    //事务id
    String transId = HmilyTransactionContextLocal.getInstance().get().getTransId(); log.info("******** Bank1 Service begin try... "+transId );
    int existTry = accountInfoDao.isExistTry(transId);
    //try幂等校验if(existTry>0){
    log.info("******** Bank1 Service 已经执行try，无需重复执行，事务id:{} "+transId );
    return ;
    }
    //try悬挂处理
    if(accountInfoDao.isExistCancel(transId)>0 || accountInfoDao.isExistConfirm(transId)>0){ log.info("******** Bank1 Service 已经执行confirm或cancel，悬挂处理，事务id:{} "+transId
    );
    return ;
    }
    //从账户扣减
    if(accountInfoDao.subtractAccountBalance(accountNo ,amount )<=0){
    //扣减失败
    throw new HmilyRuntimeException("bank1 exception，扣减失败，事务id:{}"+transId);
    }
    //增加本地事务try成功记录，用于幂等性控制标识accountInfoDao.addTry(transId);

    // 远 程 调 用 bank2 if(!bank2Client.test2(amount,transId)){
    throw new HmilyRuntimeException("bank2Client exception，事务id:{}"+transId);
    }
    if(amount==10){//异常一定要抛在Hmily里面
    throw new RuntimeException("bank1 make exception 10");
    }
    log.info("******** Bank1 Service end try... "+transId  );
    }


    @Transactional
    public void commit( String accountNo, double amount) {
    String localTradeNo = HmilyTransactionContextLocal.getInstance().get().getTransId();

    logger.info("******** Bank1 Service begin commit..."+localTradeNo );
    }
    @Transactional
    public void rollback( String accountNo, double amount) {
    String localTradeNo = HmilyTransactionContextLocal.getInstance().get().getTransId(); log.info("******** Bank1 Service begin rollback... " +localTradeNo); if(accountInfoDao.isExistTry(localTradeNo) == 0){ //空回滚处理，try阶段没有执行什么也不用做
    log.info("******** Bank1 try阶段失败... 无需rollback "+localTradeNo ); return;
    }
    if(accountInfoDao.isExistCancel(localTradeNo) > 0){ //幂等性校验，已经执行过了，什么也不用做log.info("******** Bank1 已经执行过rollback... 无需再次rollback " +localTradeNo); return;
    }
    //再将金额加回账户accountInfoDao.addAccountBalance(accountNo,amount);
    //添加cancel日志，用于幂等性控制标识
    accountInfoDao.addCancel(localTradeNo);
    log.info("******** Bank1 Service end rollback... " +localTradeNo);
    }

}

@FeignClient(value = "seata‐demo‐bank2", fallback = Bank2Fallback.class) public interface Bank2Client {

    @GetMapping("/bank2/transfer") @Hmily
    	Boolean transfer(@RequestParam("amount") Double amount);
}

@RestController
public class Bank1Controller { 
    @Autowired
    AccountInfoService accountInfoService;

    @RequestMapping("/transfer")
    public String test(@RequestParam("amount") Double amount) { this.accountInfoService.updateAccountBalance("1", amount); return "cn/itcast/dtx/tccdemo/bank1" + amount;
    }

}

try：
	空
confirm：
	confirm幂等校验
	正式增加金额
cancel：
	空

@Component @Mapper
public interface AccountInfoDao {

    @Update("update account_info set account_balance=account_balance + #{amount} where account_no=#{accountNo} ")
    int addAccountBalance(@Param("accountNo") String accountNo, @Param("amount") Double amount);



    /**
    *增加某分支事务try执行记录
    *@param localTradeNo 本地事务编号
    *@return
    */
    @Insert("insert into local_try_log values(#{txNo},now());") int addTry(String localTradeNo);

    @Insert("insert into local_confirm_log values(#{txNo},now());") int addConfirm(String localTradeNo);

    @Insert("insert into local_cancel_log values(#{txNo},now());") int addCancel(String localTradeNo);

    /**
    *查询分支事务try是否已执行
    *@param localTradeNo 本地事务编号
    *@return
    */
    @Select("select count(1) from local_try_log where tx_no = #{txNo} ") int isExistTry(String localTradeNo);
    /**
    *查询分支事务confirm是否已执行
    *@param localTradeNo 本地事务编号
    *@return
    */
    @Select("select count(1) from local_confirm_log where tx_no = #{txNo} ") int isExistConfirm(String localTradeNo);
    /**
    *查询分支事务cancel是否已执行
    *@param localTradeNo 本地事务编号
    *@return
    */
    @Select("select count(1) from local_cancel_log where tx_no = #{txNo} ") int isExistCancel(String localTradeNo);
}

@Service @Slf4j
public class AccountInfoServiceImpl implements AccountInfoService {

    @Autowired
    private AccountInfoDao accountInfoDao;

    @Override @Transactional
    @Hmily(confirmMethod = "confirmMethod", cancelMethod = "cancelMethod") public void updateAccountBalance(String accountNo, Double amount) {
    String localTradeNo = HmilyTransactionContextLocal.getInstance().get().getTransId(); log.info("******** Bank2 Service Begin try ..."+localTradeNo);

    }

    @Transactional
    public void confirmMethod(String accountNo, Double amount) {
    String localTradeNo = HmilyTransactionContextLocal.getInstance().get().getTransId(); log.info("******** Bank2 Service commit... " +localTradeNo); if(accountInfoDao.isExistConfirm(localTradeNo) > 0){ //幂等性校验，已经执行过了，什么也不用做
    log.info("******** Bank2 已经执行过confirm... 无需再次confirm "+localTradeNo ); return ;
    }
    //正式增加金额accountInfoDao.addAccountBalance(accountNo,amount);
    //添加confirm日志
    accountInfoDao.addConfirm(localTradeNo);
    }

    @Transactional
    public void cancelMethod(String accountNo, Double amount) {
    String localTradeNo = HmilyTransactionContextLocal.getInstance().get().getTransId(); log.info("******** Bank2 Service begin cancel... "+localTradeNo );

    }
}

@RestController
public class Bank2Controller { 
    @Autowired
    AccountInfoService accountInfoService;

    @RequestMapping("/transfer")
    public Boolean test2(@RequestParam("amount") Double amount) { this.accountInfoService.updateAccountBalance("2", amount); return true;
    }

}