日韩欧美视频一区,在线观看国产wwwa级羞羞视频,亚洲男人第一天堂

中文

https://graphql.cn/

接下來將以一個(gè)完整的示例演示GraphQL的使用。

環(huán)境配置

引入依賴

<dependency>

  <groupId>org.springframework.boot</groupId>

  <artifactId>spring-boot-starter-data-jpa</artifactId>

</dependency>

<dependency>

  <groupId>org.springframework.boot</groupId>

  <artifactId>spring-boot-starter-graphql</artifactId>

</dependency>

<dependency>

  <groupId>org.springframework.boot</groupId>

  <artifactId>spring-boot-starter-web</artifactId>

</dependency>

<dependency>

  <groupId>com.mysql</groupId>

  <artifactId>mysql-connector-j</artifactId>

  <scope>runtime</scope>

</dependency>

配置文件

spring:

  datasource:

    driverClassName: com.mysql.cj.jdbc.Driver

    url: jdbc:mysql://localhost:3306/testjpa?serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&useSSL=false

    username: root

    password: xxxxxx

    type: com.zaxxer.hikari.HikariDataSource

    hikari:

      minimumIdle: 10

      maximumPoolSize: 200

      autoCommit: true

      idleTimeout: 30000

      poolName: MasterDatabookHikariCP

      maxLifetime: 1800000

      connectionTimeout: 30000

      connectionTestQuery: SELECT 1  

---

spring:

  jpa:

    generateDdl: false

    hibernate:

      ddlAuto: update

    openInView: true

    show-sql: true

---

spring:

  graphql:

    path: /graphql

    graphiql:

      enabled: true

      path: /graphiql

    cors:

      allow-credentials: true

      allowed-headers: '*'

      allowed-methods: '*'

    schema:

      locations:

      - classpath*:graphql/**/

      file-extensions:

      - .graphqls

      - .gqls

      printer:

        enabled: true

注意：這里的
spring.graphql.graphql.enabled=true開啟后，將會(huì)提供一個(gè)UI界面供我們快速查詢測試使用

做好以上配置后，接下來就是建立2張表t_book和t_author。

實(shí)體定義

Book

@Entity

@Table(name = "t_book")

public class Book {



  @Id

  @GeneratedValue(strategy = GenerationType.IDENTITY)

  private Long id ;

  private String name ;

  private Integer pageCount ;

  @Transient

  private List<Author> author = new ArrayList<>();

}

Author

@Entity

@Table(name = "t_author")

public class Author {



  @Id

  @GeneratedValue(strategy = GenerationType.IDENTITY)

  private Long id ;

  private String firstName ;

  private String lastName ;

  // Book表的主鍵

  private Long bid ;

}

Repository定義

BookRepository

public interface BookRepository extends JpaRepository<Book, Long>, JpaSpecificationExecutor<Book> {

}

AuthorRepository

public interface AuthorRepository extends JpaRepository<Author, Long>, JpaSpecificationExecutor<Author> {



  List<Author> findByBid(Long bid) ;



}

Service定義

@Service

public class BookService {



  @Resource

  private BookRepository bookRepository ;

  @Resource

  private AuthorRepository authorRepository ;



  public Book queryBook(Long id) {

    Book book = bookRepository.findById(id).orElse(null) ;

    List<Author> authors = authorRepository.findByBid(id) ;

    book.setAuthor(authors) ;

    return book ;

  }



}

以上是基本的數(shù)據(jù)庫操作，很容易理解。接下來就是定義GraphQL Schema

GraphQL Schema定義

schema {

  query: BookQuery

}



type BookQuery {

  bookById(id: ID): Book

}



type Book {

  id: ID

  name: String

  pageCount: Int

  author: [Author]

}



type Author {

  id: ID

  firstName: String

  lastName: String

}

有關(guān)graphql相關(guān)語法請參考上面提到的網(wǎng)址。接下來是定義訪問接口

Controller接口

@Controller

public class BookController {



  @Resource

  private BookService bookService;

  @Resource

  private AuthorRepository authorRepository;



  @SchemaMapping(typeName = "BookQuery", field = "bookById")

  public Book bookById(@Argument Long id) {

    return bookService.queryBook(id);

  }



}