Spring JPA方法，用于查找之前为a date和之后为a date的实体

Question

我有一个实体锦标赛如下：

class Tournament {
    //other attributes
    private LocalDate startDate;
    private LocalDate endDate;
}

这表示从startDate到EndDate持续几天/几个月的锦标赛。我需要使用Spring JPA和分页检索今天运行的所有比赛，此时此刻，比如startDate<=today&&endDate>=today。

@Repository
public interface TournamentRepository extends PagingAndSortingRepository<Tournament, Long> {

    Page<Tournament> findByStartBeforeAndEndAfter(LocalDate date, LocalDate dateCopy, Pageable page); //today's date is passed as date and dateCopy

}

tournamentRepository.findByStartBeforeAndEndAfter(LocalDate.now(), LocalDate.now(), page);

Answer 1

可以对日期使用lethan、GreaterThan、lethanequal、GreaterThanEqual。

@Repository
public interface TournamentRepository extends PagingAndSortingRepository<Tournament, Long> {

    Page<Tournament> findByGreaterThanEqualStartDateAndLessThanEqualEndDate(LocalDate date, LocalDate dateCopy, Pageable page); //today's date is passed as date and dateCopy

}