🔙뒤로가기

JPA는 페이징을 다음 두 API로 추상화

setFirstResult(int startPosition) : 조회 시작 위치(0부터 시작)

setMaxResults(int maxResult) : 조회할 데이터 수

페이징 API 예시

//페이징 쿼리
 String jpql = "select m from Member m order by m.name desc";
 List<Member> resultList = em.createQuery(jpql, Member.class)
 .setFirstResult(10)
 .setMaxResults(20)
 .getResultList();

페이징 API - MySQL 방언

SELECT
	M.ID AS ID,
	M.AGE AS AGE,
	M.TEAM_ID AS TEAM_ID,
	M.NAME AS NAME 
FROM
	MEMBER M 
ORDER BY
	M.NAME DESC LIMIT ?, ?

페이징 API - Oracle 방언

SELECT * FROM
	( SELECT ROW_.*, ROWNUM ROWNUM_ 
	FROM
		( SELECT
			M.ID AS ID,
			M.AGE AS AGE,
			M.TEAM_ID AS TEAM_ID,
			M.NAME AS NAME 
		FROM MEMBER M 
		ORDER BY M.NAME 
		) ROW_ 
	WHERE ROWNUM <= ?
	) 
WHERE ROWNUM_ > ?