java FindByDate并在Spring Boot中仅显示具有有效日期的列表

Question

我的数据库中有一个旅行列表。我只想在前端显示未过期的旅行。我尝试过findByTravelDateAfter，但它只显示我作为输入提供的日期之后的日期。例如，如果我们是2021-10-12，我给出输入2021-10-22，并且我想显示2021-10-22之前和之后但仅在2021-10-12之后的所有行程，我该怎么办

有人能告诉我怎么做吗

这是我的实体：

import lombok.Getter;
import lombok.Setter;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.validation.constraints.NotBlank;
import javax.validation.constraints.NotNull;
import java.sql.Date;
@Getter
@Setter
@Entity
public class ProposeTravel {
    @Id
    @GeneratedValue
    public Long travelId;
    public String startCity;
    public String endCity;
    public Date travelDate;
    public String travelTime;
    public Long numberOfPlace;
    public double travelPrice;
    public String startPoint;
    public String carDetails;
    public String baggageDetails;
    @Column(nullable = false)
    public String emailDriver;
    @NotBlank
    @NotNull
    public String drivingLicenceNr;
    public Long userId;
    public ProposeTravel() {
        super();
        // TODO Auto-generated constructor stub
    }
    public ProposeTravel(Long travelId, String startCity, String endCity, Date travelDate, String travelTime,
            Long numberOfPlace, double travelPrice, String startPoint, String carDetails, String baggageDetails,
            String emailDriver, Long userId) {
        super();
        this.travelId = travelId;
        this.startCity = startCity;
        this.endCity = endCity;
        this.travelDate = travelDate;
        this.travelTime = travelTime;
        this.numberOfPlace = numberOfPlace;
        this.travelPrice = travelPrice;
        this.startPoint = startPoint;
        this.carDetails = carDetails;
        this.baggageDetails = baggageDetails;
        this.emailDriver = emailDriver;
        this.userId = userId;
    }
}

我的存储库：

import cm.camtougo.apicamtougo.TravelModule.entities.ProposeTravel;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;

import java.sql.Date;
import java.util.List;


@Repository
public interface ProposeTravelRepository extends JpaRepository<ProposeTravel, Long> {

    ProposeTravel findByTravelId(Long travelId);
    public List<ProposeTravel> findByUserId(Long userId);
    List<ProposeTravel> findByStartCityAndTravelDateAfterAndEndCity(String startCity, Date travelDate, String endCity);
    List<ProposeTravel> findByStartCityAndTravelDateAndEndCity(String startCity, Date travelDate, String endCity);
    List<ProposeTravel> findByStartCityAndTravelDateAfter(String startCity, Date travelDate);
    List<ProposeTravel> findByEndCityAndTravelDateAfter(String endCity, Date travelDate);
    List<ProposeTravel> findByStartCityAndEndCityAndTravelDateAfter(String startCity, String endCity, Date travelDate);
}