<dependencies>
        <!-- lombok插件依賴 -->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <!-- mysql -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.30</version>
            <scope>runtime</scope>
        </dependency>
        <!-- jpa -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
    </dependencies>

import lombok.Data;
import org.hibernate.annotations.Comment;
//import org.hibernate.annotations.Table;
import javax.persistence.*;
/**
 * 人員
 */
@Data
@Entity
//@Table(appliesTo = "person",comment = "人員表")//appliesTo指表的名稱（必填），MySQL表名小寫，用Person會(huì)拋異常。
public class Person {
    @Id//主鍵標(biāo)識(shí)
    @GeneratedValue(strategy = GenerationType.IDENTITY)//數(shù)據(jù)庫主鍵策略，默認(rèn)是AUTO。IDENTITY自增有符號(hào)主鍵
    @Comment("主鍵ID")//字段備注
    private Long id;
    @Column(name = "name",length = 20,unique = true,nullable = false)//字段屬性設(shè)置
    @Comment("名稱")
    private String name;
    @Comment("性別")
    private Integer sex;
    @Transient//此注解表示數(shù)據(jù)庫不創(chuàng)建該字段
    private String ignore;//忽略字段
}

import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageRequest;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;
import java.util.List;
/**
 * 寫法參考<a  rel="external nofollow" />
 */
@Repository //不加也可以，只要你使用的時(shí)候注入即可。JpaRepository里面有很多簡單的CRUD接口，可以少寫很多代碼。
public interface PersonRepository extends JpaRepository<Person, Long> {
	//根據(jù)名稱精確查詢
    List<Person> findByName(String name);//自定義方法
	//模糊查詢
    List<Person> findByNameLike(String name);
	//分頁模糊查詢
    Page<Person> findAllByNameLike(String name, PageRequest pageRequest);
}

import lombok.extern.slf4j.Slf4j;
import org.junit.jupiter.api.Test;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageRequest;
import org.springframework.data.domain.Sort;
import javax.annotation.Resource;
@Slf4j
@SpringBootTest
public class PersonRepositoryTests {
    @Resource
    private PersonRepository personRepository;
    /**
     * 新增/修改。一般情況下新增是不傳ID的，只有修改才傳ID。
     */
    @Test
    public void save(){
        Person person = new Person();
        person.setName("Meta39");
        person.setSex(0);
        this.personRepository.save(person);
        log.info("{}",this.personRepository.save(person));
    }
    /**
     * 查詢
     */
    @Test
    public void search(){
//        log.info("{}",this.personRepository.findById(1L));//使用框架自帶的方法
//        log.info("{}",this.personRepository.findByName("Meta"));//使用自定義根據(jù)名稱查詢方法
//        log.info("{}",this.personRepository.findByNameLike("%t%"));//使用自定義模糊查詢方法
//        Page<Person> personPage = this.personRepository.findAll(PageRequest.of(0, 10, Sort.by(Sort.Direction.DESC, "id")));//分頁查詢
//        log.info("{}", personPage);//自帶無參分頁查詢
        Page<Person> personPageByNameLike = this.personRepository.findAllByNameLike("%e%", PageRequest.of(0, 10, Sort.by(Sort.Direction.DESC, "id")));
        personPageByNameLike.forEach(System.out::println);//自定義模糊分頁查詢（%M%這種寫法是不會(huì)有SQL注入的，不信自己可以試試%M% and id = 1）
    }
    /**
     * 刪除
     */
    @Test
    public void delete(){
        this.personRepository.deleteById(1L);//根據(jù)ID刪除一條記錄
        this.personRepository.deleteAllById(Arrays.asList(1L,2L,3L));//根據(jù)ID集合批量刪除記錄
    }
}