Spring Data JPA 无法为方法创建查询

Question

我想列出这样的订单

select * from post
Order by created_date desc

这是

//Mapper
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;
    @Column(name="created_date")
    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;
    }
    

}

//Repository
public interface PostRepository extends JpaRepository<Post, Long> {
    List<Post> findByOrderBycreateDateDesc();
    List<Post> findAllByDescriptionContaining(String description);
    List<Post> findAllByPostNameContaining(String postName);
    List<Post> findAllBySub(Sub sub);
    List<Post> findByUser(User user);
    
}

//Service

    @Transactional(readOnly = true)
    public List<PostResponse> getAllPosts() {
        return postRepository.findByOrderBycreateDateDesc()
                .stream()
                .map(postMapper::mapToDto)
                .collect(toList());
    }

我正在使用 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!

你们可以帮助我吗！我认为我在“findByOrderBycreateDateDesc”中错了。谢谢！ 对不起我的英语。这是我第一次发表我的问题。xD

Answer 1

尝试像这样编辑方法：

List<Post> findAllByOrderByCreatedDateDesc();

因为它看起来表列名称和实例名称不同，因此您必须注释实例变量，如下所示：

@Column(name="created_date")

Answer 2

您的方法名称似乎已关闭。
findByOrderBycreateDateDesc() 应为 findByOrderByCreatedDateDesc()，且属性名称以大写字母开头。