\uac80\uc0c9\uc870\uac74\uc774 \ud558\ub098 \ub610\ub294 \ub450\uac1c\ub85c \uace0\uc815\uc77c \uacbd\uc6b0, JPA \uc758 \ucffc\ub9ac\uc790\ub3d9\uc0dd\uc131 \uae30\ub2a5\uc73c\ub85c \ucc98\ub9ac\uac00 \uac00\ub2a5\ud569\ub2c8\ub2e4.<\/p>\n
\ud558\uc9c0\ub9cc, \uc2e4\ubb34\uc5d0\uc11c\ub294 1 ~ N \uac1c\uc758 \ubcf5\ud569 \uac80\uc0c9\uc870\uac74\uc744 \uc694\uad6c\ud558\ub294 \uacbd\uc6b0\uac00 \ub9e4\uc6b0 \ub9ce\uc544 JPA \ub9cc\uc73c\ub85c \uac10\ub2f9\uc774 \uc548\ub429\ub2c8\ub2e4. \uadf8\ub798\uc11c \uc4f0\uc774\ub294 \ub77c\uc774\ube0c\ub7ec\ub9ac \uc911\uc5d0 \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 querydsl \uc758 \uc815\uc0c1\uc801\uc778 \ucef4\ud30c\uc77c\uc744 \uc704\ud574 build.gradle<\/p>\n \ub450\uac1c\uc758 \uac80\uc0c9\uc870\uac74\uacfc \ud55c\uac1c\uc758 \uc815\ub82c\uc21c\uc11c\ub97c \uc804\ub2ec\ud560 \ud074\ub798\uc2a4\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/p>\n src\/main\/java\/kr\/co\/episode\/example\/domain\/posts\/PostsSearch.java<\/p>\n \uc6b0\uc120 \ucee4\uc2a4\ud140 \uc778\ud130\ud398\uc774\uc2a4\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/p>\n src\/main\/java\/kr\/co\/episode\/example\/domain\/posts\/PostsPagingRepositoryCustom.java<\/p>\n src\/main\/java\/kr\/co\/episode\/example\/domain\/posts\/PostsPagingRepositoryImpl.java<\/p>\n src\/main\/java\/kr\/co\/episode\/example\/domain\/posts\/PostsPagingRepository.java<\/p>\n src\/main\/java\/kr\/co\/episode\/example\/web\/dto\/PostsSearchDto.java<\/p>\n src\/main\/java\/kr\/co\/episode\/example\/service\/posts\/PostsPagingService.java<\/p>\n src\/main\/resources\/templates\/index.html<\/p>\n src\/main\/java\/kr\/co\/episode\/example\/web\/IndexController.java<\/p>\n querydsl \uc744 \uc774\uc6a9\ud55c \ub2e4\uc774\ub098\ubbf9 \ucffc\ub9ac \uc0dd\uc131\uc744 \ud574\ubd05\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-121","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\/121","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=121"}],"version-history":[{"count":16,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/121\/revisions"}],"predecessor-version":[{"id":341,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/121\/revisions\/341"}],"wp:attachment":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=121"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=121"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}querydsl<\/code> \uc744 \uc774\uc6a9\ud55c \ub2e4\uc774\ub098\ubbf9 \ucffc\ub9ac \uc0dd\uc131\uc744 \ud574\ubd05\ub2c8\ub2e4.<\/p>\n\uac1c\ubc1c\ud658\uacbd<\/h2>\n
\n
\ud30c\uc77c\ucd94\uac00 \ubc0f \uc218\uc815<\/h2>\n
build.gradle<\/code> \uc744 \uc544\ub798\uc640 \uac19\uc774 \uc218\uc815\ud569\ub2c8\ub2e4.<\/p>\nbuildscript {\n ext {\n springBootVersion = '2.1.13.RELEASE'\n }\n repositories {\n mavenCentral()\n jcenter()\n }\n dependencies {\n classpath("org.springframework.boot:spring-boot-gradle-plugin:${springBootVersion}")\n }\n}\n\napply plugin: 'java'\napply plugin: 'war'\napply plugin: 'org.springframework.boot'\napply plugin: 'io.spring.dependency-management'\n\ngroup 'kr.co.episode.example'\nversion '0.0.1-SNAPSHOT'\nsourceCompatibility = 11\n\nrepositories {\n mavenCentral()\n jcenter()\n}\n\ndependencies {\n compile('org.springframework.boot:spring-boot-starter-web')\n compile('org.projectlombok:lombok')\n compile('org.springframework.boot:spring-boot-starter-thymeleaf')\n compile('com.querydsl:querydsl-jpa')\n compile('com.querydsl:querydsl-apt')\n compile('org.springframework.boot:spring-boot-starter-data-jpa')\n compile('org.springframework.session:spring-session-jdbc')\n testCompile('org.springframework.boot:spring-boot-starter-test')\n testCompile("org.springframework.security:spring-security-test")\n}\n\n\/** QueryDSL Class Generate Script *\/\ndef generatedJavaSrcDir = 'src\/main\/generated'\ndef queryDslOutput = file(generatedJavaSrcDir)\n\nsourceSets {\n main {\n java {\n srcDirs = ['src\/main\/java', generatedJavaSrcDir]\n }\n }\n}\n\n\/** QClass \uc0dd\uc131 *\/\ntask generateQueryDSL(type: JavaCompile, group: 'build') {\n doFirst {\n delete queryDslOutput\n queryDslOutput.mkdirs()\n }\n source = sourceSets.main.java\n classpath = configurations.compile\n destinationDir = queryDslOutput\n options.compilerArgs = [\n '-proc:only',\n '-processor',\n 'com.querydsl.apt.jpa.JPAAnnotationProcessor'\n ]\n}\ncompileJava.dependsOn(generateQueryDSL)\n\n\/** clean \ud0dc\uc2a4\ud06c \uc2e4\ud589\uc2dc QClass \uc0ad\uc81c *\/\nclean {\n delete queryDslOutput\n}<\/code><\/pre>\n@Getter\npublic class PostsSearch {\n\n private String title;\n private String author;\n private boolean orderBy;\n\n public PostsSearch(String title, String author, boolean orderBy) {\n this.title = title;\n this.author = author;\n this.orderBy = orderBy;\n }\n}<\/code><\/pre>\npublic interface PostsPagingRepositoryCustom {\n\n Page<Posts> search(Pageable pageable, PostsSearch postsSearch);\n}<\/code><\/pre>\nQClass<\/code> \ub97c \ucc3e\uc9c0 \ubabb\ud558\uc9c0\ub9cc \ud504\ub85c\uc81d\ud2b8\ub294 \uc815\uc0c1\uc801\uc73c\ub85c \uc2e4\ud589\ub429\ub2c8\ub2e4. \uadf8\ub798\ub3c4 \uc624\ub958\ub97c \uc218\uc815\ud558\uace0 \uc2f6\uc73c\uba74 \uba54\ub274\uc5d0\uc11c Build > Rebuild Project<\/code> \ud558\uba74 \uc624\ub958\uac00 \uc0ac\ub77c\uc9d1\ub2c8\ub2e4.<\/p>\npublic class PostsPagingRepositoryImpl extends QuerydslRepositorySupport implements PostsPagingRepositoryCustom {\n\n public PostsPagingRepositoryImpl() {\n super(Posts.class);\n }\n\n @Override\n public Page<Posts> search(Pageable pageable, PostsSearch postsSearch) {\n\n QPosts posts = QPosts.posts;\n\n JPQLQuery query = from(posts);\n\n if (!"".equals(postsSearch.getTitle())) {\n query.where(posts.title.contains(postsSearch.getTitle()));\n }\n\n if (!"".equals(postsSearch.getAuthor())) {\n query.where(posts.author.contains(postsSearch.getAuthor()));\n }\n\n if (postsSearch.isOrderBy()) {\n query.orderBy(posts.id.asc());\n } else {\n query.orderBy(posts.id.desc());\n }\n\n long totalCount = query.fetchCount();\n List<Posts> results = getQuerydsl().applyPagination(pageable, query).fetch();\n\n return new PageImpl<>(results, pageable, totalCount);\n }\n}<\/code><\/pre>\npublic interface PostsPagingRepository extends JpaRepository<Posts, Long>, PostsPagingRepositoryCustom {\n\n \/\/ ......\n\n Page<Posts> search(Pageable pageable, PostsSearch postsSearch);\n}<\/code><\/pre>\n@Getter\npublic class PostsSearchDto {\n\n private String title;\n private String author;\n private boolean orderBy;\n\n @Builder\n public PostsSearchDto(String title, String author, boolean orderBy) {\n this.title = title;\n this.author = author;\n this.orderBy = orderBy;\n }\n\n public PostsSearchDto(Map<String, String> params) {\n this.title = params.get("title") == null ? "" : params.get("title");\n this.author = params.get("author") == null ? "" : params.get("author");\n this.orderBy = params.get("orderBy") != null;\n }\n\n public PostsSearch toEntity() {\n return new PostsSearch(title, author, orderBy);\n }\n}<\/code><\/pre>\n@RequiredArgsConstructor\n@Service\npublic class PostsPagingService {\n\n private final PostsPagingRepository postsPagingRepository;\n\n \/\/ ......\n\n @Transactional(readOnly = true)\n public Page<PostsListResponseDto> search(Pageable pageable, PostsSearchDto postsSearchDto) {\n Page<Posts> posts = postsPagingRepository.search(pageable, postsSearchDto.toEntity());\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}<\/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="${search.title}" \/>\n <\/div>\n <div class="form-group">\n <label for="author">\uc791\uc131\uc790<\/label>\n <input type="text" class="form-control" id="author" name="author" placeholder="\uc791\uc131\uc790\ub97c \uc785\ub825\ud558\uc138\uc694." th:value="${search.author}" \/>\n <\/div>\n <div class="custom-control custom-checkbox">\n <input type="checkbox" class="custom-control-input" id="orderBy" name="orderBy" th:checked="${search.orderBy}" \/>\n <label class="custom-control-label" for="orderBy">\uae00\ubc88\ud638 \uc21c\uc73c\ub85c<\/label>\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 \/\/ ......\n @GetMapping("\/")\n public String index(Model model, @PageableDefault Pageable pageable, @RequestParam Map<String, String> params) {\n pageable = PageRequest.of(pageable.getPageNumber(), 3);\n PostsSearchDto postsSearchDto = new PostsSearchDto(params);\n\n model.addAttribute("posts", postsPagingService.search(pageable, postsSearchDto));\n model.addAttribute("search", postsSearchDto);\n\n return "index";\n }\n \/\/ ......<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"