【实训记录】中软国际实训记录(十一)

16 篇文章 2 订阅
14 篇文章 3 订阅

1.评论
1.1 添加评论
1.1.1 实体类

Comment

@Entity
@Table(name = "t_comment")
public class Comment {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private String nickname;
    private String email;
    private String content;
    private String avatar;
    @Temporal(TemporalType.TIMESTAMP)
    private Date createTime;

    @ManyToOne
    private News news;

    @OneToMany(mappedBy = "parentComment")
    private List<Comment> replyComments = new ArrayList<>();

    @ManyToOne
    private Comment parentComment;

    private boolean adminComment;

    public Comment() {
    }

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public String getNickname() {
        return nickname;
    }

    public void setNickname(String nickname) {
        this.nickname = nickname;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getContent() {
        return content;
    }

    public void setContent(String content) {
        this.content = content;
    }

    public String getAvatar() {
        return avatar;
    }

    public void setAvatar(String avatar) {
        this.avatar = avatar;
    }

    public Date getCreateTime() {
        return createTime;
    }

    public void setCreateTime(Date createTime) {
        this.createTime = createTime;
    }

    public News getNews() {
        return news;
    }

    public void setNews(News news) {
        this.news = news;
    }

    public List<Comment> getReplyComments() {
        return replyComments;
    }

    public void setReplyComments(List<Comment> replyComment) {
        this.replyComments = replyComment;
    }

    public Comment getParentComment() {
        return parentComment;
    }

    public void setParentComment(Comment parentComment) {
        this.parentComment = parentComment;
    }

    public boolean isAdminComment() {
        return adminComment;
    }

    public void setAdminComment(boolean adminComment) {
        this.adminComment = adminComment;
    }

    @Override
    public String toString() {
        return "Comment{" +
                "id=" + id +
                ", nickname='" + nickname + '\'' +
                ", email='" + email + '\'' +
                ", content='" + content + '\'' +
                ", avatar='" + avatar + '\'' +
                ", createTime=" + createTime +
                ", news=" + news +
                ", replyComment=" + replyComments +
                ", parentComment=" + parentComment +
                ", adminComment=" + adminComment +
                '}';
    }
}


News

       @OneToMany(mappedBy = "news")
    private List<Comment> comments = new ArrayList<>();
    //添加Getter and Setter方法
        public List<Comment> getComments() {
        return comments;
    }

    public void setComments(List<Comment> comments) {
        this.comments = comments;
    }
    //修改toString()方法,toString中添加
                    ", comments=" + comments +
    

1.1.2 接口

CommentRespository

public interface CommentRepository extends JpaRepository<Comment,Long> {

}

CommentService

public interface CommentService {

    Comment saveComment(Comment comment);
}


1.1.3 实现类

CommentServiceImpl

@Service
public class CommentServiceImpl implements CommentService {

    @Autowired
    private CommentRepository commentRepository;

    @Override
    public Comment saveComment(Comment comment) {
        Long parentCommentId = comment.getParentComment().getId();
        if (parentCommentId!=-1){
            comment.setParentComment(commentRepository.findById(parentCommentId).orElse(null));
        }else {
            comment.setParentComment(null);
        }
        comment.setCreateTime(new Date());
        return commentRepository.save(comment);
    }
}

CommentController

@Controller
public class CommentController {

    @Autowired
    private CommentService commentService;

    @Autowired
    private NewService newService;

    private String avatar = "http://static.jwcyber.com/wp-content/uploads/2017/10/1459086602935351.jpg";
    
    @PostMapping("/comments")
    public String post(Comment comment, HttpSession session){
        Long newId = comment.getNews().getId();
        comment.setNews(newService.getNew(newId));
        User user = (User) session.getAttribute("user");
        if (user!=null){
            comment.setAdminComment(true);
            comment.setAvatar(avatar);
        }else {
            comment.setAvatar(avatar);
        }
        commentService.saveComment(comment);
//        System.out.println(commentService.saveComment(comment));
        return "redirect:/comments/"+newId;
    }
}

1.2 回复评论
1.2.1 接口修改

CommentRepository

    List<Comment> findByNewsIdAndParentCommentNull(Long newId, Sort sort);

CommentService

    List<Comment> listCommentByNewId(Long newId);
1.2.2 类修改

CommentServiceImpl

    @Override
    public List<Comment> listCommentByNewId(Long newId) {
        Sort sort = Sort.by("createTime");
        List<Comment> comments = commentRepository.findByNewsIdAndParentCommentNull(newId,sort);
        return eachComment(comments);
    }

    private List<Comment> eachComment(List<Comment> comments){
        List<Comment> commentsView = new ArrayList<>();
        for (Comment comment:comments){
            Comment c = new Comment();
            BeanUtils.copyProperties(comment,c);
            commentsView.add(c);
        }
        //合并评论的各层子代到第一级子代集合中
        combineChildren(commentsView);
        return commentsView;
    }

    private void combineChildren(List<Comment> comments){
        for (Comment comment:comments){
            List<Comment> replys1 = comment.getReplyComments();
            for (Comment reply1:replys1){
                //循环迭代,找出子代
                recursively(reply1);
            }
            comment.setReplyComments(tempReplys);
            //清楚临时缓存区
            tempReplys = new ArrayList<>();
        }
    }

    private List<Comment> tempReplys = new ArrayList<>();

    private void recursively(Comment comment){
        tempReplys.add(comment);  //顶节点添加到临时存放区
        if (comment.getReplyComments().size()>0){
            List<Comment> replys = comment.getReplyComments();
            for (Comment reply:replys){
                tempReplys.add(reply);
                if(reply.getReplyComments().size()>0){
                    recursively(reply);
                }
            }
        }
    }

CommentController

@GetMapping("/comments/{newId}")
public String comments(@PathVariable Long newId, Model model){
    model.addAttribute("comments",commentService.listCommentByNewId(newId));
    return "new::commentList";
   }

2.分类页面

web层下新创建一个TypeController类

TypeController类

@Controller
public class TypeShowController {

    @Autowired
    private TypeService typeService;

    @Autowired
    private NewService newService;

    @GetMapping("/types/{id}")
    public String types(@PageableDefault(size = 8,sort = {"updateTime"},direction = Sort.Direction.DESC)
                        Pageable pageable, @PathVariable Long id, Model model){
        List<Type> types = typeService.listTypeTop(20);
        if (id==-1){
            id = types.get(0).getId();
        }
        NewQuery newQuery = new NewQuery();
        newQuery.setTypeId(id);
        model.addAttribute("types",types);
        model.addAttribute("page",newService.listNew(pageable,newQuery));
        model.addAttribute("activeTypeId",id);
        return "types";
    }
}

3.标签页面
3.1 接口修改

NewService

    //标签页面查看新闻
    Page<News> listNew(Long tagId,Pageable pageable);

NewServiceImpl

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

TagShowControlller

@Controller
public class TagShowController {

    @Autowired
    private NewService newService;

    @Autowired
    private TagService tagService;

    @GetMapping("/tags/{id}")
    public String types(@PageableDefault(size = 8,sort = {"updateTime"},direction = Sort.Direction.DESC)
                                Pageable pageable, @PathVariable Long id, Model model){
        List<Tag> tags = tagService.listTagTop(20);
        if (id==-1){
            id = tags.get(0).getId();
        }
        model.addAttribute("tags",tags);
        model.addAttribute("page",newService.listNew(id,pageable));
        model.addAttribute("activeTagId",id);
        return "tags";
    }
}

4.结果展示

在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
国际外包是一家专业提供件开发、外包和咨询服务的公司。华为ETL(Extract, Transform, Load)是华为公司用于数据仓库建设与管理的关键技术之一,用于将数据从不同的来源提取出来、进行转换和加载到目标数据仓库。 华为ETL面试通常会涉及以下几个方面的内容: 1. ETL的基本概念和原理:面试官可能会询问ETL的定义、核心工作流程和重要性等。应聘者需要清楚地解释ETL的概念和作用,并能够说明其在数据仓库建设和管理的重要性。 2. 数据提取(Extract):面试官可能会询问你对数据提取过程的理解和应用实践。你需要了解不同的数据来源和提取方法,例如从关系型数据库、文件或API提取数据,并且能够解释数据提取过程可能遇到的挑战和解决方案。 3. 数据转换(Transform):面试官可能会询问你在数据转换过程的经验和技能。你需要掌握数据清洗、转换和整合的方法和技术,例如数据规范化、格式转换、数据合并等,并能够描述数据转换过程的一些典型问题和解决方案。 4. 数据加载(Load):面试官可能会询问你对数据加载的理解和应用实践。你需要了解不同的数据加载方法和策略,例如全量加载、增量加载、并行加载等,并能够解释数据加载过程的一些常见问题和解决方案。 此外,面试还有可能出现一些与ETL相关的工具和技术的问题,例如数据抽取工具、数据转换语言、数据质量控制等。应聘者需要对这些工具和技术有一定的了解和应用经验。 最后,无论面试问到哪个方面的内容,应聘者需要准备足够的实际案例和解决方案,以便能够展示自己的实际经验和能力。只有通过具体的实践案例,才能更好地回答面试官的问题,展现自己的能力和价值。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值