페이징

1. 예제

---

• offset : 몇 개 건너뒴?
• limit : 몇 개 씩?

 @Test
    public void paging1(){
        List<Member> result = queryFactory
                .selectFrom(member)
                .orderBy(member.username.desc())
                .offset(1)
                .limit(2) //2개씩
                .fetch();

        assertThat(result.size()).isEqualTo(2);
    }

• fetchResults()를 통해 페이징 정보 포함.

  @Test
    public void paging2(){
        QueryResults<Member> queryResults = queryFactory
                .selectFrom(member)
                .orderBy(member.username.desc())
                .offset(1)
                .limit(2) //2개씩
                .fetchResults();

       assertThat(queryResults.getTotal()).isEqualTo(4);
       assertThat(queryResults.getLimit()).isEqualTo(2);
       assertThat(queryResults.getOffset()).isEqualTo(1);
       assertThat(queryResults.getResults().size()).isEqualTo(2);

    }

 

2. GitHub : 210901 Paging

---

GitHub - bsh6463/Querydsl