博客标签功能管理以及首页展示
1、博客发布的管理,实现了博客的增删改查
同样每张页面上最多显示五条博客,在编辑、新增、删除中实现功能。
博客可以显示为草稿(保存)、发布两种状态,并且根据更新时间进行排序,显示标签信息。
2、首页展示,对博客进行展示,对标签、类型和推荐在右侧进行显示
博客页面
首页展示
新增test博客
删除test
查询Mysql相关博客
修改博客,从web修改成python
##核心代码
BlogController
@Controller
@RequestMapping("admin/blogs")
public class BlogController {
@Autowired
private IBlogService blogService;
@Autowired
private ITypeService typeService;
@Autowired
private ITagService tagService;
@RequestMapping
public String blogs(@PageableDefault(size = 5,sort = {"updateTime"},direction = Sort.Direction.DESC) Pageable pageable, Model model){
Page<Blog> page = blogService.listBlog(pageable);
model.addAttribute("types",typeService.listType());
model.addAttribute("page",page);
return "admin/blogs";
}
@GetMapping("{id}/delete")
public String delete(@PathVariable Long id){
blogService.deleteById(id);
return "redirect:/admin/blogs";
}
@GetMapping("input")
public String input(Model model){
model.addAttribute("blog",new Blog());
model.addAttribute("types",typeService.listType());
model.addAttribute("tags",tagService.listType());
return "admin/blogs-input";
}
@RequestMapping("add")
public String add(Blog blog, HttpSession session){
User user = (User) session.getAttribute("user");
blog.setUser(user);
String tagIds = blog.getTagIds();
List<Tag> tagList=tagService.getTagByIds(tagIds);
blog.setTags(tagList);
if(blog.getId()==null){
blogService.add(blog);
}else {
blogService.update(blog);
}
return "redirect:/admin/blogs";
}
@RequestMapping("{id}/toUpdate")
public String toUpdate(@PathVariable Long id,Model model){
Blog blog=blogService.getBlog(id);
blog.initTags(id);
model.addAttribute("blog",blog);
model.addAttribute("types",typeService.listType());
model.addAttribute("tags",tagService.listType());
return "admin/blogs-input";
}
@RequestMapping("search")
public String search(@PageableDefault(size = 5,sort = {"updateTime"},direction = Sort.Direction.DESC) Pageable pageable,
BlogQuery blogQuery,Model model){
Page<Blog> page=blogService.listBlog(pageable,blogQuery);
model.addAttribute("page",page);
model.addAttribute("types",typeService.listType());
return "admin/blogs :: blogList";
}
}
IBlogService接口
public interface IBlogService {
Page<Blog> listBlog(Pageable pageable);
void deleteById(Long id);
void add(Blog blog);
Blog getBlog(Long id);
void update(Blog blog);
Page<Blog> listBlog(Pageable pageable, BlogQuery blogQuery);
List<Blog> listRecommendBlogTop(int i);
Page<Blog> listBlog(String query, Pageable pageable);
}
BlogServiceImpl
@Service
public class BlogServiceImpl implements IBlogService {
@Autowired
private BlogDao blogDao;
@Override
public Page<Blog> listBlog(Pageable pageable) {
return blogDao.findAll(pageable);
}
@Override
public void deleteById(Long id) {
blogDao.deleteById(id);
}
@Override
public void add(Blog blog) {
blog.setCreateTime(new Date());
blog.setUpdateTime(new Date());
blogDao.save(blog);
}
@Override
public Blog getBlog(Long id) {
return blogDao.getOne(id);
}
@Override
public void update(Blog blog) {
Blog one = blogDao.getOne(blog.getId());
BeanUtils.copyProperties(blog,one);
one.setUpdateTime(new Date());
blogDao.save(one);
}
@Override// 使用Specification进行条件拼接、模糊查找
public Page<Blog> listBlog(Pageable pageable, BlogQuery blogQuery) {
Specification<Blog> specification=new Specification<Blog>() {
@Override
public Predicate toPredicate(Root<Blog> root, CriteriaQuery<?> criteriaQuery, CriteriaBuilder criteriaBuilder) {
List<Predicate> predicates=new ArrayList<>();
if(!StringUtils.isEmpty(blogQuery.getTitle())){
predicates.add(criteriaBuilder.like(root.<String>get("title"),"%"+blogQuery.getTitle()+"%"));
}
if(blogQuery.getTypeId()!=null){
predicates.add(criteriaBuilder.equal(root.<Type>get("type").get("id"),blogQuery.getTypeId()));
}
if(blogQuery.getRecommend()){
predicates.add(criteriaBuilder.equal(root.<Boolean>get("recommend"),blogQuery.getRecommend()));
}
criteriaQuery.where(predicates.toArray(new Predicate[predicates.size()]));
return null;
}
};
return blogDao.findAll(specification, pageable);
}
@Override//首页查询是否为推荐recommond文章
public List<Blog> listRecommendBlogTop(int i) {
Sort sort= Sort.by(Sort.Direction.DESC,"updateTime");
Pageable pageable= PageRequest.of(0,i,sort);
List<Blog> blogs=blogDao.findTop(pageable);
return blogs;
}
@Override//模糊查找
public Page<Blog> listBlog(String query, Pageable pageable) {
return blogDao.findByQuery("%"+query+"%",pageable);
}
}
BlogDao
继承JpaSpecificationExecutor类,用于实现拼接查询
public interface BlogDao extends JpaRepository<Blog,Long>, JpaSpecificationExecutor<Blog> {
@Query("select b from Blog b where b.recommend= true")
List<Blog> findTop(Pageable pageable);
@Query("select b from Blog b where b.title like ?1 or b.content like ?1")
Page<Blog> findByQuery(String s, Pageable pageable);
}