[스프링] page

(data.sql)
insert into member(`id`, `name`, `email`, `create_at`, `update_at`) values (1, '홍길동', 'mars@thejoeun.com', now(), now());
insert into member(`id`, `name`, `email`, `create_at`, `update_at`) values (2, '홍길동', 'namsun@thejoeun.com', now(), now());
insert into member(`id`, `name`, `email`, `create_at`, `update_at`) values (3, '이순신', 'leesunsin@gmail.com', now(), now());
insert into member(`id`, `name`, `email`, `create_at`, `update_at`) values (4, '강감찬', 'namsun@thejoeun.com', now(), now());
insert into member(`id`, `name`, `email`, `create_at`, `update_at`) values (5, '홍길동', 'ryukwansun@thejoeun.com', now(), now());
insert into member(`id`, `name`, `email`, `create_at`, `update_at`) values (6, '이홍렬', 'hong@thejoeun.com', now(), now());

package com.example.practice5.jpa.repository;

import com.example.practice5.jpa.model.Member;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;

public interface MemberRepository extends JpaRepository<Member, Long> {
      Page<Member> findByName(String name, Pageable pageable);
}

   @Test
    void jpaQueryMethodTest6() {
        System.out.println("page-----------------");
        Page<Member> pageMember = memberRepository.findByName("홍길동", PageRequest.of(0, 3, Sort.by(Sort.Order.desc("id"), Sort.Order.asc("name"))));
        List<Member> memberList = pageMember.getContent();
        memberList.forEach(System.out::println);
    }

select m1_0.id,m1_0.create_at,m1_0.email,m1_0.name,m1_0.update_at 
from member m1_0 
where m1_0.name='홍길동' order by m1_0.id desc,m1_0.name limit 0,3;


select a1_0.member_id,a1_1.id,a1_1.zipcode from member_address a1_0 join address a1_1 on a1_1.id=a1_0.address_id where a1_0.member_id=1;
select a1_0.member_id,a1_1.id,a1_1.zipcode from member_address a1_0 join address a1_1 on a1_1.id=a1_0.address_id where a1_0.member_id=2;
select a1_0.member_id,a1_1.id,a1_1.zipcode from member_address a1_0 join address a1_1 on a1_1.id=a1_0.address_id where a1_0.member_id=5;

select count(m1_0.id) from member m1_0 where m1_0.name='홍길동';
Member(id=5, name=홍길동, email=ryukwansun@thejoeun.com, createAt=2023-07-11T16:55:22, updateAt=2023-07-11T16:55:22, address=[])
Member(id=2, name=홍길동, email=namsun@thejoeun.com, createAt=2023-07-11T16:55:22, updateAt=2023-07-11T16:55:22, address=[])
Member(id=1, name=홍길동, email=mars@thejoeun.com, createAt=2023-07-11T16:55:22, updateAt=2023-07-11T16:55:22, address=[])