JPQL - 페이징 API

페이징 API

• JPA는 페이징을 다음 두 API로 추상화한다.
• setFirstResult(int startPosition)
  • 조회 시작 위치
• setMaxResult(int maxResult)
  • 조회할 데이터 수

 

-- 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 ?, ?
    

-- 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_
    WHERER ROW <= ?
    )
WHERE ROWNUM_ > ?