\uac80\uc0c9\uc870\uac74\uc744 \ucd94\uac00\ud569\ub2c8\ub2e4. \uc77c\ub2e8, \uac80\uc0c9\uc870\uac74\uc774 \ud558\ub098\uc77c\ub54c \uc5bc\ub9c8\ub098 \uc27d\uac8c \uac80\uc0c9\uc870\uac74\uc744 \ucd94\uac00\ud560 \uc218 \uc788\ub294\uc9c0 \uc54c\ub824\ub4dc\ub9bd\ub2c8\ub2e4.<\/p>\n
\ud504\ub85c\uc81d\ud2b8\ub294 \uc774\uc804 \uae00\uc5d0\uc11c \uc791\uc131\ub41c \ud504\ub85c\uc81d\ud2b8\uc5d0 \ud30c\uc77c\uc744 \ucd94\uac00 \ub610\ub294 \uc218\uc815\ud558\ub294 \ubc29\uc2dd\uc73c\ub85c \uc9c4\ud589\ub429\ub2c8\ub2e4. \uc774\uc804 \uae00\uc744 \ub530\ub77c \ud558\uc9c0 \uc54a\uc740 \uacbd\uc6b0, \uba3c\uc800 \uc774\uc804 \uae00\ub300\ub85c \ud504\ub85c\uc81d\ud2b8\ub97c \uad6c\uc131\ud558\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n
\uc5c6\uc74c<\/p>\n
\uc544\ub798 findByTitle \uc774\ub77c\ub294 \uba54\uc18c\ub4dc\uba85\uc73c\ub85c \ubcc0\uc218\uba85\uc774 title \uc778 \ubcc0\uc218\ub97c \ucc3e\uc544 where \uc808\uc5d0 \ucd94\uac00\ud558\ub294 \ubc29\uc2dd\uc785\ub2c8\ub2e4.<\/p>\n src\/main\/java\/kr\/co\/episode\/example\/domain\/posts\/PostsPagingRepository.java<\/p>\n src\/main\/java\/kr\/co\/episode\/example\/service\/posts\/PostsPagingService.java<\/p>\n src\/main\/java\/kr\/co\/episode\/example\/web\/IndexController.java<\/p>\n src\/main\/resources\/templates\/index.html<\/p>\n \uac80\uc0c9\uc870\uac74\uc744 \ucd94\uac00\ud569\ub2c8\ub2e4. \uc77c\ub2e8, \uac80\uc0c9\uc870\uac74\uc774 \ud558\ub098\uc77c\ub54c \uc5bc\ub9c8\ub098 \uc27d\uac8c \uac80\uc0c9\uc870\uac74\uc744 \ucd94\uac00\ud560 \uc218 \uc788\ub294\uc9c0 \uc54c\ub824\ub4dc\ub9bd\ub2c8\ub2e4.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-116","post","type-post","status-publish","format-standard","hentry","category-spring-boot-2-1"],"_links":{"self":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/116","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=116"}],"version-history":[{"count":6,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/116\/revisions"}],"predecessor-version":[{"id":222,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/116\/revisions\/222"}],"wp:attachment":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=116"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}findByTitle()<\/code> \uba54\uc18c\ub4dc \ud558\ub098 \ucd94\uac00\ud558\ub294 \uac83\uc73c\ub85c \ucffc\ub9ac \uc0dd\uc131\uc774 \ub05d\ub0a9\ub2c8\ub2e4.<\/p>\n\/\/ ......\npublic interface PostsPagingRepository extends JpaRepository<Posts, Long> {\n\n @Query(value = "SELECT p FROM Posts p ORDER BY p.id DESC")\n Page<Posts> findAllDesc(Pageable pageable);\n\n Page<Posts> findByTitle(Pageable pageable, String title);\n}\n\/\/ ......<\/code><\/pre>\nPageable<\/code> \uc758 \uae30\ubcf8\uc801\uc778 \uc815\ub82c\uc21c\uc11c\ub294 id<\/code> \uc21c\ucc28\uc815\ub82c\uc774\ub77c, \uc815\ub82c\uc21c\uc11c\ub97c \ubcc0\uacbd\ud558\ub294 \ucf54\ub4dc\ub97c \ucd94\uac00\ud569\ub2c8\ub2e4.<\/p>\n\/\/ ......\n@RequiredArgsConstructor\n@Service\npublic class PostsPagingService {\n\n private final PostsPagingRepository postsPagingRepository;\n\n \/\/ ......\n\n @Transactional(readOnly = true)\n public Page<PostsListResponseDto> findAllDesc(Pageable pageable, String title) {\n Page<Posts> posts;\n if ("".equals(title)) {\n posts = postsPagingRepository.findAllDesc(pageable);\n } else {\n \/\/ \uc815\ub82c\uc21c\uc11c \ubcc0\uacbd\n Pageable p = PageRequest.of(pageable.getPageNumber(), pageable.getPageSize(), Sort.by("id").descending());\n posts = postsPagingRepository.findByTitle(p, title);\n }\n List<PostsListResponseDto> results = posts.getContent().stream()\n .map(PostsListResponseDto::new)\n .collect(Collectors.toList());\n long totalCount = posts.getTotalElements();\n\n return new PageImpl<>(results, pageable, totalCount);\n }\n}\n\/\/ ......<\/code><\/pre>\n@RequiredArgsConstructor\n@Controller\npublic class IndexController {\n\n private final PostsService postsService;\n private final PostsPagingService postsPagingService;\n\n @GetMapping("\/")\n public String index(Model model, @PageableDefault Pageable pageable,\n @RequestParam(value = "title", required = false, defaultValue = "") String title) {\n \/\/model.addAttribute("posts", postsService.findAllDesc());\n\n pageable = PageRequest.of(pageable.getPageNumber(), 3);\n \/\/model.addAttribute("posts", postsPagingService.findAllDesc(pageable));\n model.addAttribute("posts", postsPagingService.findAllDesc(pageable, title));\n model.addAttribute("title", title);\n\n return "index";\n }\n\n \/\/ ......\n}<\/code><\/pre>\n<!DOCTYPE html>\n<html xmlns:th="http:\/\/www.thymeleaf.org">\n<head>\n <meta charset="UTF-8">\n <title>\uac8c\uc2dc\ud310<\/title>\n <link rel="stylesheet" href="https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.2\/css\/bootstrap.min.css">\n <style>\n .container p { display: inline }\n <\/style>\n<\/head>\n<body class="container">\n\n<h1>\uc2a4\ud504\ub9c1 \ubd80\ud2b8 \uac8c\uc2dc\ud310<\/h1>\n\n<div class="col-md-12">\n <div class="row">\n <div class="col-md-6">\n <a href="\/posts\/save" role="button" class="btn" btn-primary>\uae00 \ub4f1\ub85d<\/a>\n <\/div>\n <\/div>\n<\/div>\n\n<div style="height: 80px;">\n\n<\/div>\n\n<table class="table">\n <tr>\n <th>\uae00 \ubc88\ud638<\/th>\n <th>\uae00\uc4f4\uc774<\/th>\n <th>\uae00 \uc81c\ubaa9<\/th>\n <th>\ucd5c\uc885\uc218\uc815<\/th>\n <\/tr>\n <tr th:each="posts: ${posts}">\n <td th:text="${posts.id}"><\/td>\n <td>\n <a th:href="${posts.link}" th:text="${posts.author}" \/>\n <\/td>\n <td>\n <a th:href="${posts.link}" th:text="${posts.title}" \/>\n <\/td>\n <td th:text="${posts.modifiedDate}"><\/td>\n <\/tr>\n<\/table>\n\n<div class="col-md-12">\n <div class="col-md-4">\n <form name="frm">\n <input type="hidden" name="page" value="0">\n <div class="form-group">\n <label for="title">\uc81c\ubaa9<\/label>\n <input type="text" class="form-control" id="title" placeholder="\uc81c\ubaa9\uc744 \uc785\ub825\ud558\uc138\uc694." name="title" th:value="${title}" \/>\n <\/div>\n <\/form>\n\n <button type="button" class="btn btn-primary" id="btn-search">\uac80\uc0c9<\/button>\n <\/div>\n<\/div>\n\n<nav style="text-align: center;">\n <ul class="pagination"\n th:with="start=${T(Math).floor(posts.number\/10)*10},\n last=(${start + 9 < posts.totalPages-1 ? start + 9 : posts.totalPages-1})">\n <li>\n <a th:onclick="|javascript:gotoPage(0)|" aria-label="First">\n <span aria-hidden="true">First<\/span>\n <\/a>\n <\/li>\n\n <li th:class="${posts.first} ? 'disabled'">\n <a th:onclick="|javascript:gotoPage(${posts.number-1})|" aria-label="Previous">\n <span aria-hidden="true"><<\/span>\n <\/a>\n <\/li>\n\n <li th:each="page: ${#numbers.sequence(start, last)}" th:class="${page == posts.number} ? 'active'">\n <a th:text="${page+1}" th:onclick="|javascript:gotoPage(${page})|" ><\/a>\n <\/li>\n\n <li th:class="${posts.last} ? 'disabled'">\n <a th:onclick="|javascript:gotoPage(${posts.number+1})|" aria-label="Next">\n <span aria-hidden="true">><\/span>\n <\/a>\n <\/li>\n\n <li>\n <a th:onclick="|javascript:gotoPage(${posts.totalPages-1})|" aria-label="Last">\n <span aria-hidden="true">Last<\/span>\n <\/a>\n <\/li>\n <\/ul>\n<\/nav>\n\n<script src="https:\/\/code.jquery.com\/jquery-3.3.1.min.js"><\/script>\n<script src="https:\/\/stackpath.bootstrapcdn.com\/bootstrap\/4.3.1\/js\/bootstrap.min.js"><\/script>\n\n<script src="\/js\/app\/index.js"><\/script>\n<script>\n function gotoPage(pg) {\n document.frm.page.value = pg;\n document.frm.submit();\n }\n<\/script>\n<\/body>\n<\/html><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"