<!--添加Jpa依賴-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <!--數(shù)據(jù)庫鏈接驅動-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

# 應用服務 WEB 訪問端口
server:
  port: 8080
# 應用名稱
spring:
  application:
    name: HelloSpringBoot
  #數(shù)據(jù)庫配置連接
  datasource:
    url: jdbc:mysql://127.0.0.1:3306/hello_jpa?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai
    username: root
    password: "123456"
    driver-class-name: com.mysql.cj.jdbc.Driver
  jpa:
    show-sql: true

CREATE TABLE `jpa_user`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主鍵',
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用戶名稱',
  `age` tinyint(4) NULL DEFAULT NULL COMMENT '年齡',
  `gender` tinyint(4) NULL DEFAULT NULL COMMENT '性別0女 1男',
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手機號',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

//引入lombok的getset注解，也可以不引入，自己寫下面字段的對應getset方法
@Getter
@Setter
//注解此類為實體類
@Entity
//關聯(lián)數(shù)據(jù)庫表的名稱
@Table(name = "jpa_user")
public class User {
 
    //聲明屬性為主鍵
    @Id
    //指定主鍵生成策略
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    // @Column注解，設置屬性關聯(lián)的數(shù)據(jù)庫表字段
    // 注意：如果屬性名和表字段名相同，可以不設置，比如這個實體類對應的所有字段就都是與數(shù)據(jù)庫表字段相同的，都可以不設置Column注解
    @Column(name = "id")
    private Long id;
 
    @Column(name = "username")
    private String username;
 
    @Column(name = "age")
    private Integer age;
 
    @Column(name = "gender")
    private Integer gender;
 
    @Column(name = "phone")
    private String phone;
 
    //駝峰命名法和數(shù)據(jù)庫中的下劃線字段是對應的
    @Column(name = "access_card_number")
    private String accessCardNumber;
 
}

public interface UserRepository extends JpaRepository<User, Long> {
}

        //insert into jpa_user (access_card_number, age, gender, phone, username) values (?, ?, ?, ?, ?)
        User user = new User();
        user.setUsername("test");
        user.setPhone("13112345678");
        user.setAge(18);
        user.setGender(0);
        user.setAccessCardNumber("ic_001");
        userRepository.save(user);

//select * from jpa_user user where user.id=?
        User user = userRepository.findById(id).orElse(null);

//update jpa_user set access_card_number=?, age=?, gender=?, phone=?, username=? where id=?
        User user = userRepository.findById(1L).orElse(null);
        user.setPhone("13212345678");
        userRepository.save(user);

//update jpa_user set access_card_number=?, age=?, gender=?, phone=?, username=? where id=?
        User user = userRepository.findById(1L).orElse(null);
        user.setPhone("13212345678");
        userRepository.save(user);

//select * from jpa_user user where (user.age between ? and ?) and user.gender=?
 
List<User> findByAgeBetweenAndGender(int minAge, int maxAge, int gender);