获取 Spring Data 上按日期排序的最后记录

2022-01-18 00:00:00 spring java spring-mvc spring-data

我正在尝试在 Spring Data 存储库中定义一个方法，以获取按日期排序的表中的最后一条记录.这是我的实体:

I'm trying to define a method in a Spring Data repository to fetch the last records on a table ordered by date. This is my entity:

@Entity
public class News {

    @Id
    @GeneratedValue
    private Long id;

    @Column(nullable = false)
    private String title;

    @Column(nullable = false)
    private String text;

    private Date publicationDate;

    /* Getters and Setters */
}

这是我的存储库:

public interface NewsRepository extends JpaRepository<News, Long> {
    List<News> findFirst5OrderByPublicationDateDesc();
}

如果我尝试使用启动项目，我会收到下一个错误:

If I try to use launch the project I get the next error:

原因:org.springframework.data.mapping.PropertyReferenceException:否找到类型日期的属性描述！遍历路径:News.publicationDate.

Caused by: org.springframework.data.mapping.PropertyReferenceException: No property desc found for type Date! Traversed path: News.publicationDate.

如果我删除 Desc，我会得到:

And if I remove the Desc I get this:

原因:java.util.NoSuchElementException

Caused by: java.util.NoSuchElementException

我做错了什么?

推荐答案

原来方法的签名不正确.正确的是:

Turns out that the signature of the method was incorrect. The right one is:

findFirst5ByOrderByPublicationDateDesc()

有点令人困惑，因为在官方示例中他们有这个:

Is a little confusing because in the official samples they have this:

List<User> findTop10ByLastname(String lastname, Pageable pageable);

如您所见，那里只有一个，通常的那个.

As you can see there is only one By there, the usual one.

相关文章