[Java Spring MVC] Paging and sorting DTOs

Repo:

复制代码
package com.example.ec.repo;

import com.example.ec.domain.TourRating;
import com.example.ec.domain.TourRatingPk;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.repository.CrudRepository;
import org.springframework.data.rest.core.annotation.RepositoryRestResource;

import java.util.List;
import java.util.Optional;

@RepositoryRestResource(exported = false)
public interface TourRatingRepository extends CrudRepository<TourRating, TourRatingPk> {
    List<TourRating> findByPkTourId(Integer tourId);

    Optional<TourRating> findByPkTourIdAndPkCustomerId(Integer tourId, Integer customerId);

    Page<TourRating> findByPkTourId(Integer tourId, Pageable pageable);
}
复制代码

 

Controller:

复制代码
    @GetMapping
    public Page<RatingDto> getAllRatingsForTour(@PathVariable(value = "tourId") int tourId, Pageable pageable) {
        verifyTour(tourId);
        Page<TourRating> ratings = tourRatingRepository.findByPkTourId(tourId, pageable);
        return new PageImpl<>(
                ratings.get()
                    .map(RatingDto::new)
                    .collect(Collectors.toList()),
                pageable,
                ratings.getTotalElements()
        );
    }
复制代码

 

posted @   Zhentiw  阅读(94)  评论(0编辑  收藏  举报
编辑推荐:
· SQL Server 2025 AI相关能力初探
· Linux系列:如何用 C#调用 C方法造成内存泄露
· AI与.NET技术实操系列(二):开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
阅读排行:
· 阿里最新开源QwQ-32B,效果媲美deepseek-r1满血版,部署成本又又又降低了!
· Manus重磅发布:全球首款通用AI代理技术深度解析与实战指南
· 开源Multi-agent AI智能体框架aevatar.ai,欢迎大家贡献代码
· 被坑几百块钱后,我竟然真的恢复了删除的微信聊天记录!
· AI技术革命,工作效率10个最佳AI工具
历史上的今天:
2019-12-16 [Algorithm] 118. Pascal's Triangle
2019-12-16 [React] Create a Custom Suspending Image Component
2016-12-16 [RxJS] Flatten a higher order observable with concatAll in RxJS
2016-12-16 [RxJS] Flatten a higher order observable with mergeAll in RxJS
2016-12-16 [Compose] 8. A curated collection of Monoids and their uses
2016-12-16 [Javascript] Combine Objects with Object.assign and Lodash merge
2014-12-16 [AngularJS] Introduction to ui-router
点击右上角即可分享
微信分享提示