Spring Data JPA创建方法查询失败

Question

我想列一份订单，比如

select * from post
Order by created_date desc

这是我的密码

public class Post {
    @Id
    @GeneratedValue(strategy = IDENTITY)
    private Long postId;
    @NotBlank
    private String postName;
    @Nullable
    private String url;
    @Nullable
    @Lob
    private String description;
    private Integer voteCount = 0;
    @ManyToOne(fetch = LAZY)
    @JoinColumn(name = "userId", referencedColumnName = "userId")
    private User user;
    private Instant createdDate;
    @ManyToOne(fetch = LAZY)
    @JoinColumn(name = "id", referencedColumnName = "id")
    private Sub sub;
    public Integer getVoteCount() {
        if (this.voteCount == null) {
            return 0;
        }
        return this.voteCount;
    }
    

}

public interface PostRepository extends JpaRepository<Post, Long> {
    List<Post> findAllOrderBycreateDateDesc();
}

我使用的是Java Spring Boot和Spring Data JPA，我遇到了如下错误

 Could not create query for public abstract java.util.List com.Website.Step2.repository.PostRepository.findAllOrderbycreateDateDesc()!
 Reason: Failed to create query for method public abstract java.util.List com.Website.Step2.repository.PostRepository.findAllOrderbycreateDateDesc()! 
 No property findAllOrderbycreateDateDesc found for type Post!

你们能帮帮我吗！我想我在《findAllOrderBycreateDateDesc》中错了。谢谢对不起我的英语。这是我第一次发布我的问题。除息的

Answer 1

尝试如下编辑方法：

List<Post> findByOrderBycreateDateDesc();

由于表列名和实例名看起来不同，因此必须按如下所示注释实例变量：

@Column(name="created_date")