|Spring BootとAWSによって個別に実施されたWebサービス-4.4完全なクエリー

リストから降順にすべての投稿番号を表示

PostsRepositoryへのクエリーの追加

public interface PostsRepository extends JpaRepository<Posts, Long> {

    @Query("SELECT p FROM Posts p ORDER BY p.id DESC")
    List<Posts> findAllDesc();
}

PostsService

    @Transactional(readOnly = true)
    public List<PostsListResponseDto> findByDesc() {
        return postsRepository.findAllDesc().stream()
                .map(PostsListResponseDto::new)
                .collect(Collectors.toList());
    }

PostsListResponseDto

@Getter
public class PostsListResponseDto {
    private Long id;
    private String title;
    private String author;
    private LocalDateTime modifiedDate;

    public PostsListResponseDto(Posts entity) {
        this.id = entity.getId();
        this.title = entity.getTitle();
        this.author = entity.getAuthor();
        this.modifiedDate = entity.getModifiedDate();
    }
}

IndexController

    @GetMapping("/")
    public String index(Model model) {
        model.addAttribute("posts", postsService.findByDesc());
        return "index";
    }