java - FindByDate 并在 Spring Boot 中仅显示有效日期的列表
问题描述
我的数据库中有一个旅行清单。我只想在前端显示未过期的旅行。我试过 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);
}
解决方案
推荐阅读
- git - Gerrit Code Review 中是否可以更改 dev 分支?
- jenkins - 如何准确识别 Jenkins 管道中发生异常的位置?
- javascript - 排序Html表格列reactjs
- postgresql - Postgres 全文搜索 - 查找其他类似文档
- python - 如何解决这个致命错误:numpy/arrayobject.h:没有这样的文件或目录?
- sql - 为每一行添加额外的行,为特定列添加不同的值
- c# - Asp.Net Core 3.1 生成无法删除的 .exe 文件
- wordpress - .htaccess 重定向网址
- android - RecyclerView 为其项目设置错误的 MotionLayout 状态
- javascript - 如何在javascript中跟踪和保存虚拟滚动列表的最后滚动位置