Java方向（SSM+SpringBoot）项目实训Day9-SpringBoot（新闻管理系统）新闻管理条件查询分页展示+新增＋编辑

Java方向（SSM+SpringBoot）项目实训
Day9（2020.7.29）

新闻管理条件查询分页展示

1.修改News实体类；
News中添加：

    @ManyToMany(cascade = CascadeType.PERSIST) //级联
    private List<Tag> tags = new ArrayList<>();

    @Transient
    private String tagIds;

    private String description;

    public List<Tag> getTags() {
        return tags;
    }

    public void setTags(List<Tag> tags) {
        this.tags = tags;
    }

    public String getTagIds() {
        return tagIds;
    }

    public void setTagIds(String tagIds) {
        this.tagIds = tagIds;
    }

    public String getDescription() {
        return description;
    }

    public void setDescription(String description) {
        this.description = description;
    }

2.news下创建新的vo包并创建NewQuery类；

NewQuery添加：

package com.roger0123.news.vo;

public class NewQuery {

    private String title;

    private Long typeId;

    private boolean recommend;

    public String getTitle() {
        return title;
    }

    public void setTitle(String title) {
        this.title = title;
    }

    public Long getTypeId() {
        return typeId;
    }

    public void setTypeId(Long typeId) {
        this.typeId = typeId;
    }

    public boolean isRecommend() {
        return recommend;
    }

    public void setRecommend(boolean recommend) {
        this.recommend = recommend;
    }

    @Override
    public String toString() {
        return "NewQuery{" +
                "title='" + title + '\'' +
                ", typeId=" + typeId +
                ", recommend=" + recommend +
                '}';
    }
}

3.dao下创建NewRepository接口；

NewRepository中添加：

package com.roger0123.news.dao;

import com.roger0123.news.po.News;
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;

public interface NewRepository extends JpaRepository<News,Long>, JpaSpecificationExecutor<News> {

//    @Query("select n from News n where n.title like ?1 or n.content like ?1")
//    Page<News> findByQuery(String query, Pageable pageable);

}

4.service下创建NewService接口；

NewServicer中添加：

package com.roger0123.news.service;

import com.roger0123.news.po.News;
import com.roger0123.news.vo.NewQuery;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;

public interface NewService {

    Page<News> listNew(Pageable pageable, NewQuery newQuery);

}

5.service.impl下创建NewServiceImpl类；

NewServiceImpl中添加：

@Service
public class NewServiceImpl implements NewService {

    @Autowired
    private NewRepository newRepository;

    //新闻管理中的列表（包含了查询）
    @Override //查询构造器，多条件组合
    public Page<News> listNew(Pageable pageable, NewQuery newQuery) {
        return newRepository.findAll(new Specification<News>() {
            @Override
            public Predicate toPredicate(Root<News> 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.get("type").get("id"),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);
    }
}

6.controller下创建NewControllerr类；
NewController中添加：

@Controller
@RequestMapping("/admin")
public class NewController {

    private static final String INPUT = "admin/news-input";

    private 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.listNew(pageable,newQuery));
        System.out.println(model);
        return List;
    }

    @PostMapping("/news/search")
    public String search(@PageableDefault(size = 3,sort = {"updateTime"},direction = Sort.Direction.DESC)
                         Pageable pageable,NewQuery newQuery,Model model) {

        model.addAttribute("page",newService.listNew(pageable,newQuery));
        System.out.println(newService.listNew(pageable,newQuery));
        return "admin/news :: newsList";
    }
}

新增

1.修改Tag实体类；
Tag中添加：

    @ManyToMany(mappedBy = "tags")
    private List<News> newsList = new ArrayList<>();

2.修改TagService接口；
TagService中添加：

    List<Tag> listTag();

    List<Tag> listTag(String ids);

3.修改TagServiceImpl实体类；
TagServiceImpl中添加：

 @Override
    public List<Tag> listTag() {
        return tagRepository.findAll();
    }

    @Override
    public List<Tag> listTag(String ids) {
        return tagRepository.findAllById(convertToList(ids));
    }

    private List<Long> convertToList(String ids){
        System.out.println("service接收ids为:"+ids);
        List<Long> list = new ArrayList<>();
        if(!"".equals(ids) && ids!=null){
            String[] idArray = ids.split(",");
            for (int i=0;i<idArray.length;i++){
                list.add(new Long(idArray[i]));
            }
        }
        System.out.println("service中处理完成的id list"+list);
        return list;
    }

4.修改TypeService接口；
TypeService中添加：

    List<Type> listType();

5.修改TypeServiceImpl实体类；
TypeServiceImpl中添加：

    @Override
    public List<Type> listType() {
        return typeRepository.findAll();
    }

6.修改NewService接口；
NewServicer中添加：

    News saveNew(News news);

7.修改NewServiceImpl类；
NewServiceImpl中添加：

  @Override
    public News saveNew(News news) {

        if (news.getId()==null){
            news.setCreateTime(new Date());
            news.setUpdateTime(new Date());
        }
        return newRepository.save(news);
    }

8.修改NewControllerr类；
NewController中添加：

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

    @GetMapping("/news/input")
    public String input(Model model){
        setTypeAndTag(model);
        model.addAttribute("news",new News());
        return INPUT;
    }
    
    @PostMapping("/news/add")
    public String post(News news, RedirectAttributes attributes, HttpSession session){
        System.out.println("controller接收的news为:"+news);
        news.setUser((User) session.getAttribute("user"));
        news.setType(typeService.getType(news.getType().getId()));
        news.setTags(tagService.listTag(news.getTagIds()));
        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;
    }

编辑

1.修改NewService接口；
NewServicer中添加：

    News getNew(Long id);

    News updateNew(Long id,News news);

2.修改NewServiceImpl类；
NewServiceImpl中添加：

    @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);
    }

3.修改NewControllerr类；
NewController中添加：

    @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;
    }

Test
1.登陆成功后进入新闻管理界面；

2.点击新增，进入新闻添加界面，编辑好后点击保存；

保存为草稿，为未发布状态；

点击编辑，进入新闻编辑界面；

作出部分修改后，点击发布进行新闻更新操作；

重新编辑几条新闻，验证查询以及分页展示；
1.标题名称模糊搜索；

2.分类搜索；

3.是否推荐搜索；

4.多条件排列组合搜索；