Spring boot博客项目实战3（新闻管理）

接上：
https://blog.csdn.net/qq_43923042/article/details/107681238

博客中新闻管理也是分为增删査改操作，按结构来分也是先dao层，service层再cotroller层
1、新建实体类：

@Entity
@Table(name="t_news")
public class News {
    @Id
    @GeneratedValue(strategy= GenerationType.IDENTITY)
    Long id;
    String Title;
    @Basic(fetch= FetchType.LAZY)
    @Lob                     //有时内容较长，使用懒加载模式
    private String content;
    private String firstPicture;
    private String flag;
    private String views;
    private boolean appreciation;
    private boolean shareStatement;
    private boolean commentabled;
    private boolean published=false;
    private boolean recommend;

    @Temporal(TemporalType.TIMESTAMP)
    private Date createTime;
    @Temporal(TemporalType.TIMESTAMP)
    private Date updateTime;
    @ManyToOne
    private  Type type;
    @ManyToOne
    private User user;
    public News(){
    }
    @ManyToMany(cascade = CascadeType.PERSIST) //级联，生成中间表
    private List<Tag> tags=new ArrayList<>();
    @Transient  //该注解表示不不会被映射到数据库中
    private String tagIds;//接收前端⻚页⾯面传过来的标签Id
    private String description;

2、DAO层：

package com.daqi.daqi.dao;

import com.daqi.daqi.po.News;
import com.daqi.daqi.po.Tag;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import java.util.List;

public interface NewRepository extends JpaRepository<News,Long>, JpaSpecificationExecutor<News> {
    @Query("select m from News m where m.Title like ?1 or m.content like  ?1")
    Page<News> findByQuery(String query,Pageable pageable);
    @Query("select n from News n where n.recommend=true")
    List<News> findTop(Pageable pageable);
}

3、Service层：

@Service
public class NewServiceImpl implements NewService {
    @Autowired
    private NewRepository newRepository;
//新闻管理中的新闻列表：模糊查询
    @Override
    public Page<News> listNews(Pageable pageable, NewQuery newQuery){
        return newRepository.findAll(new Specification() {
            @Override
            public Predicate toPredicate(Root root, CriteriaQuery cq, CriteriaBuilder cb) {
                List<Predicate> predicates=new ArrayList<>();
                if (!"".equals(newQuery.getTitle())&&newQuery.getTitle()!=null){
                    predicates.add(cb.like(root.<String>get("title"),"%"+newQuery.getTitle()+"%"));
                }
                if (newQuery.getTypeId()!=null){
                    predicates.add(cb.equal(root.<String>get("type"),newQuery.getTypeId()));
                }
                if (newQuery.isRecommend()){
                    predicates.add(cb.equal(root.get("recommend"),newQuery.isRecommend()));
                }
                cq.where(predicates.toArray(new Predicate[predicates.size()]));
                return null;
            }
        },pageable);
    }

    @Override
    public News saveNew(News news) {
        if (news.getId()==null){
            news.setCreateTime(new Date());
            news.setUpdateTime(new Date());
        }
        return newRepository.save(news);
    }

    @Override
    public News getNew(Long id) {
        return newRepository.findById(id).orElse(null);
    }

    @Override
    public News updateNew(Long id, News news) {
        News news1=newRepository.findById(id).orElse(null);
        if (news1==null){
            System.out.println("未获得更新对象");
        }
        BeanUtils.copyProperties(news,news1);
        news1.setUpdateTime(new Date());
        return newRepository.save(news1);
    }

    @Override
    public List<Tag> listTag() {
        return null;
    }

    @Override
    public void deleteNew(Long id) {
        newRepository.deleteById(id);
    }

    public Page<News> listNews(Pageable pageable){
        return newRepository.findAll(pageable);
    }

    //主页推荐
    @Override
    public List<News> listRecommentNewTop(Integer size) {
        Sort sort=Sort.by(Sort.Direction.DESC,"updateTime");
        Pageable pageable= PageRequest.of(0,size,sort);
        return newRepository.findTop(pageable);
    }
    //全局搜索
    @Override
    public Page<News> listNews(String query, Pageable pageable) {
        return newRepository.findByQuery(query,pageable);
    }

    @Override
    public News getAndConvert(Long id) {
        News news=newRepository.findById(id).orElse(null);
        if (news==null){
            System.out.println("该新闻不存在");
        }
        News news1=new News();
        BeanUtils.copyProperties(news,news1);
        String contents=news1.getContent();
        news1.setContent(MarkdownUtils.markdownToHtmlExtensions(contents));
        return news1;
    }

    @Override
    public Page<News> listNew(Long tagId, Pageable pageable) {
        return newRepository.findAll(new Specification<News>() {
            @Override
            public Predicate toPredicate(Root<News> root, CriteriaQuery<?> criteriaQuery, CriteriaBuilder criteriaBuilder) {
                Join join=root.join("tags");
                return criteriaBuilder.equal(join.get("id"),tagId);
            }
        },pageable);
    }
}

4、DAO层：

@Controller
@RequestMapping("/admin")
public class NewController {
    private static final String INPUT="admin/news-input";
    public static  final String LIST="admin/news";
    private static final String REDIRECT_LIST="redirect:/admin/news";
    @Autowired
    private NewService newService;

    @Autowired
    private TypeService typeService;

    @Autowired
    private TagService tagService;

    @GetMapping("/news")
    public String news(@PageableDefault(size=3,sort={"updateTime"},direction = Sort.Direction.DESC)
                                   Pageable pageable, NewQuery newQuery, Model model){
        model.addAttribute("types",typeService.listType());
        model.addAttribute("page",newService.listNews(pageable,newQuery));
        return LIST;
    }
    @GetMapping("/news/search")
    public String search(@PageableDefault(size=3,sort={"updateTime"},direction = Sort.Direction.DESC)
                               Pageable pageable, NewQuery newQuery, Model model){
        System.out.println("Sysds");
        model.addAttribute("page",newService.listNews(pageable,newQuery));
        return "admin/news :: newsList";
    }

    public void setTypeAndTag(Model model){
        model.addAttribute("types",typeService.listType());
        model.addAttribute("tags",tagService.listTag());
    }

    @GetMapping("/news/input")
    public String input(Model model){
        model.addAttribute("news",new News());
        setTypeAndTag(model);
        return INPUT;
    }

    @GetMapping("/news/{id}/toUpdate")
    public String toUpdate(@PathVariable Long id,Model model){
        setTypeAndTag(model);
        News news=newService.getNew(id);
        news.init();
        model.addAttribute("news",news);
        return INPUT;
    }
    @PostMapping("/news/add")
    public String post(News news, RedirectAttributes attributes, HttpSession session){
        news.setUser((User)session.getAttribute("user"));
        news.setType(typeService.getType(news.getType().getId()));
        System.out.println("Id:"+news.getId());
        news.setTags(tagService.listTag());
        News news1;
        if (news.getId()==null){
            news1=newService.saveNew(news);
        }else {
            news1=newService.updateNew(news.getId(),news);
        }
        if (news1!=null){
            attributes.addFlashAttribute("message","操作失败");
        }else {
            attributes.addFlashAttribute("message","操作失败");
        }
        return REDIRECT_LIST;
    }
    @GetMapping("/news/{id}/delete")
    public String delete(@PathVariable Long id,RedirectAttributes attributes){
        newService.deleteNew(id);
        attributes.addFlashAttribute("message","删除成功");
        return REDIRECT_LIST;
    }
}