{"id":7644,"date":"2023-11-28T19:49:56","date_gmt":"2023-11-28T11:49:56","guid":{"rendered":"https:\/\/wx.kaifamiao.info\/?p=7644"},"modified":"2023-12-05T15:43:43","modified_gmt":"2023-12-05T07:43:43","slug":"springboot-shi-xian-fen-ye-he-pai-xu","status":"publish","type":"post","link":"http:\/\/wx.kaifamiao.info\/index.php\/2023\/11\/28\/springboot-shi-xian-fen-ye-he-pai-xu\/","title":{"rendered":"SpringBoot\u5b9e\u73b0\u5206\u9875\u548c\u6392\u5e8f\uff1f"},"content":{"rendered":"

\u5728 Spring Boot \u4e2d\uff0c\u5b9e\u73b0\u5206\u9875\u548c\u6392\u5e8f\u901a\u5e38\u4f7f\u7528 Spring Data JPA \u63d0\u4f9b\u7684 Pageable<\/code> \u5bf9\u8c61\u3002Spring Data JPA \u662f Spring \u5bf9 JPA\uff08Java Persistence API\uff09\u7684\u7b80\u5316\u5c01\u88c5\uff0c\u63d0\u4f9b\u4e86\u4e00\u7ec4\u6613\u7528\u7684 API \u6765\u8fdb\u884c\u6570\u636e\u5e93\u64cd\u4f5c\uff0c\u5305\u62ec\u5206\u9875\u548c\u6392\u5e8f\u529f\u80fd\u3002<\/p>\n

\u4ee5\u4e0b\u662f\u5b9e\u73b0\u5206\u9875\u548c\u6392\u5e8f\u7684\u57fa\u672c\u6b65\u9aa4\uff1a<\/p>\n

    \n
  1. \n\u5b9a\u4e49\u6570\u636e\u5b9e\u4f53\uff1a<\/strong> \u521b\u5efa\u4e00\u4e2a JPA \u5b9e\u4f53\u7c7b\uff0c\u4f7f\u7528 @Entity<\/code> \u6ce8\u89e3\u6807\u6ce8\uff0c\u540c\u65f6\u5b9a\u4e49\u597d\u9700\u8981\u8fdb\u884c\u5206\u9875\u548c\u6392\u5e8f\u7684\u5b57\u6bb5\u3002<\/p>\n
    import javax.persistence.Entity;\nimport javax.persistence.GeneratedValue;\nimport javax.persistence.GenerationType;\nimport javax.persistence.Id;\n\n@Entity\npublic class MyEntity {\n    @Id\n    @GeneratedValue(strategy = GenerationType.IDENTITY)\n    private Long id;\n\n    private String name;\n    private int age;\n\n    \/\/ Getters and setters\n}\n<\/code><\/pre>\n<\/li>\n
  2. \n\u521b\u5efa JPA Repository \u63a5\u53e3\uff1a<\/strong> \u521b\u5efa\u4e00\u4e2a\u7ee7\u627f\u81ea JpaRepository<\/code> \u7684\u63a5\u53e3\uff0c\u8fd9\u4e2a\u63a5\u53e3\u63d0\u4f9b\u4e86\u4e00\u4e9b\u5185\u7f6e\u7684\u65b9\u6cd5\uff0c\u5305\u62ec\u5206\u9875\u548c\u6392\u5e8f\u3002<\/p>\n
    import org.springframework.data.jpa.repository.JpaRepository;\n\npublic interface MyEntityRepository extends JpaRepository<MyEntity, Long> {\n    \/\/ Custom query methods, if needed\n}\n<\/code><\/pre>\n<\/li>\n
  3. \n\u5728 Service \u5c42\u4f7f\u7528 Pageable<\/code> \u8fdb\u884c\u5206\u9875\u548c\u6392\u5e8f\uff1a<\/strong> \u5728 Service \u5c42\u7684\u65b9\u6cd5\u4e2d\u4f7f\u7528 Pageable<\/code> \u5bf9\u8c61\uff0c\u8be5\u5bf9\u8c61\u5305\u542b\u4e86\u5206\u9875\u548c\u6392\u5e8f\u7684\u4fe1\u606f\u3002<\/p>\n
    import org.springframework.data.domain.Page;\nimport org.springframework.data.domain.PageRequest;\nimport org.springframework.data.domain.Pageable;\nimport org.springframework.stereotype.Service;\n\n@Service\npublic class MyEntityService {\n    private final MyEntityRepository repository;\n\n    public MyEntityService(MyEntityRepository repository) {\n        this.repository = repository;\n    }\n\n    public Page<MyEntity> findAllPaginatedAndSorted(int page, int size, String sortBy) {\n        Pageable pageable = PageRequest.of(page, size, Sort.by(sortBy));\n        return repository.findAll(pageable);\n    }\n}\n<\/code><\/pre>\n
    \u5728\u4e0a\u8ff0\u4f8b\u5b50\u4e2d\uff0cPageRequest.of(page, size, Sort.by(sortBy))<\/code> \u521b\u5efa\u4e86\u4e00\u4e2a Pageable<\/code> \u5bf9\u8c61\uff0c\u5176\u4e2d\u5305\u542b\u4e86\u5206\u9875\u4fe1\u606f\uff08\u9875\u7801\u548c\u6bcf\u9875\u5927\u5c0f\uff09\u548c\u6392\u5e8f\u4fe1\u606f\u3002\n<\/li>\n
  4. \n\u5728 Controller \u5c42\u8c03\u7528 Service \u65b9\u6cd5\uff1a<\/strong> \u5728 Controller \u5c42\u8c03\u7528 Service \u5c42\u7684\u65b9\u6cd5\uff0c\u83b7\u53d6\u5206\u9875\u548c\u6392\u5e8f\u540e\u7684\u6570\u636e\u3002<\/p>\n
    import org.springframework.beans.factory.annotation.Autowired;\nimport org.springframework.data.domain.Page;\nimport org.springframework.web.bind.annotation.GetMapping;\nimport org.springframework.web.bind.annotation.RequestParam;\nimport org.springframework.web.bind.annotation.RestController;\n\n@RestController\npublic class MyEntityController {\n    private final MyEntityService service;\n\n    @Autowired\n    public MyEntityController(MyEntityService service) {\n        this.service = service;\n    }\n\n    @GetMapping("\/entities")\n    public Page<MyEntity> getAllEntities(\n            @RequestParam(defaultValue = "0") int page,\n            @RequestParam(defaultValue = "10") int size,\n            @RequestParam(defaultValue = "id") String sortBy) {\n        return service.findAllPaginatedAndSorted(page, size, sortBy);\n    }\n}\n<\/code><\/pre>\n
    \u5728\u4e0a\u8ff0\u4f8b\u5b50\u4e2d\uff0cgetAllEntities<\/code> \u65b9\u6cd5\u63a5\u6536\u9875\u7801\u3001\u6bcf\u9875\u5927\u5c0f\u548c\u6392\u5e8f\u5b57\u6bb5\u4f5c\u4e3a\u8bf7\u6c42\u53c2\u6570\uff0c\u5e76\u8c03\u7528 Service \u5c42\u7684\u65b9\u6cd5\u6765\u83b7\u53d6\u5206\u9875\u548c\u6392\u5e8f\u540e\u7684\u6570\u636e\u3002\n<\/li>\n<\/ol>\n
    \u901a\u8fc7\u4e0a\u8ff0\u6b65\u9aa4\uff0c\u4f60\u5c31\u53ef\u4ee5\u5728 Spring Boot \u4e2d\u5b9e\u73b0\u57fa\u672c\u7684\u5206\u9875\u548c\u6392\u5e8f\u529f\u80fd\u3002\u6839\u636e\u5b9e\u9645\u9700\u6c42\uff0c\u8fd8\u53ef\u4ee5\u5728 Repository \u63a5\u53e3\u4e2d\u5b9a\u4e49\u66f4\u591a\u7684\u67e5\u8be2\u65b9\u6cd5\uff0c\u4ee5\u652f\u6301\u66f4\u590d\u6742\u7684\u67e5\u8be2\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
    \u5728 Spring Boot \u4e2d\uff0c\u5b9e\u73b0\u5206\u9875\u548c\u6392\u5e8f\u901a\u5e38\u4f7f\u7528 Spring Data JPA \u63d0\u4f9b\u7684 Pageabl […]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[100],"tags":[],"class_list":["post-7644","post","type-post","status-publish","format-standard","hentry","category-springboot"],"_links":{"self":[{"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts\/7644","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/comments?post=7644"}],"version-history":[{"count":2,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts\/7644\/revisions"}],"predecessor-version":[{"id":16533,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts\/7644\/revisions\/16533"}],"wp:attachment":[{"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/media?parent=7644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/categories?post=7644"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/tags?post=7644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}