我正在尝试按日期倒序排序数据,但总是按升序排列,我尝试了两种方法,但没有好的结果:
我有这个存储库:
@Repository
public interface CollectRepository extends JpaRepository<Collect, Long>
第一种方法,我在@query中使用了排序:
@Query("SELECT c FROM Collect c LEFT JOIN c.payee p WHERE p.userId=:userId AND c.date BETWEEN :startDate AND :endDate ORDER BY c.date DESC")
List<Collect> getCollectionHistory(@Param("userId") String userId,
@Param("startDate") Date startDate,
@Param("endDate") Date endDate);
第二种方式,我使用了排序。
@Query("SELECT c FROM Collect c LEFT JOIN c.payee p WHERE p.userId=:userId AND c.date BETWEEN :startDate AND :endDate")
List<Collect> getCollectionHistory(@Param("userId") String userId,
@Param("startDate") Date startDate,
@Param("endDate") Date endDate, Sort sort);
然后使用以下方式调用该函数:
collectionList = collectRepository.getCollectionHistoryByCollector(userId, startDate, endDate, new Sort(Direction.DESC, "date"));
收集实体
@Entity
@Table(name = "collect")
@SequenceGenerator(name = "SEQ", sequenceName = "collect_id_seq", allocationSize = 1)
@AttributeOverride(name = "id", column = @Column(name = "collect_id", nullable = false))
public class Collect extends GenericEntity {
@Column(name = "collector_user_id")
private String collectorUserId;
@ManyToOne(fetch = FetchType.EAGER)
@JoinColumn(name = "payer")
private Payer payer;
@ManyToOne(fetch = FetchType.EAGER)
@JoinColumn(name = "payee")
private Payee payee;
@Column(name = "amount", precision = 5)
private BigDecimal amount;
@Column(name = "date", columnDefinition = "TIMESTAMP DEFAULT CURRENT_TIMESTAMP")
@JsonSerialize(using = IsoDateSerializer.class)
private Date date;
@Column(name = "reason")
private String reason;
@Column(name = "reference")
private String reference;
// getters and setters
收款方实体:
@Entity
@Table(name = "payee")
@SequenceGenerator(name = "SEQ", sequenceName = "payee_id_seq", allocationSize = 1)
@AttributeOverride(name = "id", column = @Column(name = "payee_id", nullable = false))
public class Payee extends GenericEntity {
private String userId;
@OneToMany(mappedBy = "payee", cascade = CascadeType.ALL)
private List<Collect> collects;
@OneToMany(mappedBy = "payee", cascade = CascadeType.ALL, fetch = FetchType.EAGER)
private List<PayeePayer> payeePayers;
我正在使用Spring Data JPA版本:1.10.5.RELEASE
这是一个错误还是我在代码中有些问题? 我该如何解决这个问题?