compile('org.springframework.boot:spring-boot-starter-data-jpa')
runtime('mysql:mysql-connector-java')

spring:
  datasource:
    url: jdbc:mysql://127.0.0.1:3306/test?useSSL=false&createDatabaseIfNotExist=true
    username: root
    password: 123456
    driver-class-name: com.mysql.jdbc.Driver
  jpa:
      database: MYSQL
      show-sql: true #顯示后臺(tai)處(chu)理(li)的SQL語句(ju)
      hibernate:
        ddl-auto: update #自動檢查實體和數據庫表是否一致，如果不一致則會進行更新數據庫表

Hibernate: select next_val as id_val from hibernate_sequence for update
Hibernate: update hibernate_sequence set next_val= ? where next_val=?
Hibernate: insert into t_userinfo (password, user_name, id) values (?, ?, ?)
Hibernate: select next_val as id_val from hibernate_sequence for update
Hibernate: update hibernate_sequence set next_val= ? where next_val=?
Hibernate: insert into t_accountinfo (balance, user_info, account_id) values (?, ?, ?)

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import lombok.Data;

@Data
@Entity
@Table(name = "user")
public class User {
  @Id
  @GeneratedValue(strategy = GenerationType.AUTO)
  @Column(name = "Id")
  private int id;
  @Column(name = "Name")
  private String name;
}

import com.example.springdemo.model.User;
import org.springframework.data.jpa.repository.JpaRepository;

public interface SqlUserRepository extends JpaRepository<User, Integer> {

}

@RestController
@RequestMapping("/mysql")
public class MysqlController {

  @Autowired
  private SqlUserRepository repository;

  /**
   * return list.
   *
   * @return
   */
  @RequestMapping("/list")
  public List<User> dataList() {
    return repository.findAll();

  }
}