spring data jpa 原生态sql语句多表不添加外键，实现分页

实现jpa的接口

@Query(nativeQuery = true, value = "SELECT lost.id,lost.student_no,lost.lost_time,lost.lost_place,lost.lost_people,lost.lost_content,lost.lost_img_name,lost.lost_img,lost.lost_title,lost.phone,lost.updated,sort.sort_name,user.username FROM lost LEFT JOIN user ON lost.student_no = user.id LEFT JOIN sort ON lost.sort_id = sort.id ORDER BY lost.updated DESC ", countQuery = "select count(*) from lost ")
Page<JSONObject> getLostList(Pageable pageable);

在ServiceImpl层

public Page<JSONObject> getLostPageList(Integer page, Integer size) {
   PageRequest pageable = PageRequest.of(page, size);
    return lostRepository.getLostList(pageable);
}

这样的话就可以做到原生态sql语句加分页