[JPA] Page, nativeQuery사용

Controller

    @GetMapping("/api/image")
    public ResponseEntity<?> imageStory(@AuthenticationPrincipal PrincipalDetails principalDetails,
                                        @PageableDefault(size = 3) Pageable pageable) {
        Page<Image> images = imageService.이미지스토리(principalDetails.getUser().getId(), pageable);
        return new ResponseEntity<>(new CMRespDto<>(1, "성공", images), HttpStatus.OK);
    }

@PageableDefault(size = 3) Pageable pageable 추가 후 

리턴받는 타입을 Page로 설정한다.

 

import는

import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;

 

Service

    @Transactional(readOnly = true) 
    public Page<Image> 이미지스토리(int principalId, Pageable pageable){
        Page<Image> images = imageRepository.mStory(principalId, pageable);
        return images;
    }

 

Repository

    @Query(value = "SELECT A.* FROM image A\n" +
            "INNER JOIN subscribe B\n" +
            "ON A.userId = B.toUserId\n" +
            "WHERE B.fromUserId = :principalId ORDER BY A.id DESC"
            , countQuery = "SELECT COUNT(*) FROM image A\n" +
            "INNER JOIN subscribe B\n" +
            "ON A.userId = B.toUserId\n" +
            "WHERE B.fromUserId = :principalId"
            , nativeQuery = true)
    Page<Image> mStory(int principalId, Pageable pageable);