问题背景

从零开始学springcloud微服务项目
注意事项：

约定 > 配置 > 编码
IDEA版本2021.1
这个项目，我分了很多篇章，每篇文章一个操作步骤，目的是显得更简单明了
controller调service，service调dao
默认安装nginx
项目源码以及sentinel安装包

Seata处理分布式事务

1 Seata中文文档：https://seata.io/zh-cn/docs/overview/what-is-seata.html

2 下载地址：https://github.com/seata/seata/releases/tag/v1.4.2

sql脚本下载地址：https://seata.io/zh-cn/blog/download.html

3 修改file.conf，更改存储模式和nacos的账号密码，mysql8以上驱动加cj

mode = "db"

  ## database store property
  db {
    ## the implement of javax.sql.DataSource, such as DruidDataSource(druid)/BasicDataSource(dbcp)/HikariDataSource(hikari) etc.
    datasource = "druid"
    ## mysql/oracle/postgresql/h2/oceanbase etc.
    dbType = "mysql"
    driverClassName = "com.mysql.cj.jdbc.Driver"
    ## if using mysql to store the data, recommend add rewriteBatchedStatements=true in jdbc connection param
    url = "jdbc:mysql://127.0.0.1:3306/seata?rewriteBatchedStatements=true"
    user = "root"
    password = "123456"
    minConn = 5
    maxConn = 100
    globalTable = "global_table"
    branchTable = "branch_table"
    lockTable = "lock_table"
    queryLimit = 100
    maxWait = 5000
  }

4 修改registry.conf，更改注册中心和配置中心类型

type = "nacos"

registry {
  # file 、nacos 、eureka、redis、zk、consul、etcd3、sofa
  type = "nacos"
  nacos {
    application = "seata-server"
    serverAddr = "127.0.0.1:8848"
    group = "SEATA_GROUP"
    namespace = "seata"
    cluster = "default"
    username = ""
    password = ""
  }
}
config {
  # file、nacos 、apollo、zk、consul、etcd3
  type = "nacos"
  nacos {
    serverAddr = "127.0.0.1:8848"
    namespace = "seata"
    group = "SEATA_GROUP"
    username = ""
    password = ""
    dataId = "seataServer.properties"
  }
}

5 Linux启动方式

sh ./bin/seata-server.sh

window启动方式

bin\seata-server.bat

6 创建seata数据库

create database seata;

7 导入sql脚本，将seata-1.4.2的script复制到seata-server-1.4.2

8 在数据库中执行sql文件：seata-server-1.4.2\script\server\db\mysql.sql

Seata配置文件放在Nacos

1 新建一个配置

2 填写信息seataServer.properties SEATA_GROUP

service.vgroupMapping.mygroup=default
store.mode=db
-----db-----
store.db.datasource=druid
store.db.dbType=mysql
store.db.driverClassName=com.mysql.cj.jdbc.Driver
store.db.url=jdbc:mysql://localhost:3306/mysqltest?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=Asia/Shanghai
store.db.user=root
store.db.password=123456
----client----
client.undo.logTable=undo_log