报错如下
type 数据库结构
DAO代码
public interface TypeRepository extends JpaRepository<Type, Long> {
Type findByName(String name);
@Query("select t from Type t")
List<Type> findTop(Pageable pageable);
}
接口实现类实现对获取Type排序
@Override
public List<Type> listTypeTop(Integer size) {
Pageable pageable = PageRequest.of(0, size, Sort.by(Sort.Direction.DESC, "blogs.size"));
return typeRepository.findTop(pageable);
}
web层实现
@GetMapping("/")
public String index(@PageableDefault(size=4, sort={"updateTime"}, direction = Sort.Direction.DESC) Pageable pageable,
BlogQuery blog, Model model){
model.addAttribute("page", blogService.listBlog(pageable));
model.addAttribute("types", typeService.listTypeTop(6));
model.addAttribute("tags", tagService.listTagTop(10));
model.addAttribute("recommendBlogs", blogService.listRecommendBlogTop(8));
return "index";
}
JPA用的不熟,不知道数据库语句为啥异常了
你查询的字段用具体的字段名,不要用t
t替换为具体的字段
@Query("select t from Type t")