SpringBoot+Vue博客前后端分离项目八文章详情-线程池（springboot + mybatisplus+redis+mysql+jwt+缓存）

PJP__00

已于 2023-10-04 23:05:10 修改

阅读量84

点赞数 1

文章标签：缓存 spring boot vue.js redis mysql java spring

于 2023-10-04 14:00:54 首次发布

本文链接：https://blog.csdn.net/m0_65819602/article/details/133551014

版权

2.1 为什么要使用线程池来更新阅读次数：

1. 文章详情

1.1 接口说明

接口url：/articles/view/{id}

请求方式：POST

请求参数：

参数名称	参数类型	说明
id	long	文章id（路径参数）

返回数据：

{
    "success": true,
    "code": 200,
    "msg": "success",
    "data": {
        "id": 1,
        "title": "springboot介绍以及入门案例",
        "summary": "通过Spring Boot实现的服务，只需要依靠一个Java类，把它打包成jar，
        并通过`java -jar`命令就可以运行起来。\r\n\r\n这一切相较于传统Spring应用来说，已经变得非常的轻便、简单。",
        "commentCounts": 1,
        "viewCounts": 125,
        "weight": 0,
        "createDate": "1970-01-20 21:28",
        "author": "pjp",
        "body": {
            "content": "# 1. Spring Boot\r\n\r\n........"
       },
        "tags": [
            {
                "id": 5,
                "tagName": "Mybatis-Plus",
                "avatar": null
            },
            {
                "id": 7,
                "tagName": "表达式",
                "avatar": null
            },
            {
                "id": 8,
                "tagName": "Java",
                "avatar": null
            }
        ],
        "category": {
            "id": 2,
            "avatar": "/static/category/back.png",
            "categoryName": "后端"
        }
    }
}

1.2 涉及到的表及pojo

CREATE TABLE `blog`.`ms_article_body`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT,
  `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `content_html` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `article_id` bigint(0) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `article_id`(`article_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 38 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

@Data
public class ArticleBody {

    private Long id;
    
    private String content;
    
    private String contentHtml;
    
    private Long articleId;
}

CREATE TABLE `blog`.`ms_category`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT,
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `category_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

@Data
public class Category {

    private Long id;

    private String avatar;

    private String categoryName;

    private String description;
}

1.3 Controller

package com.pjp.blog.controller;

import com.pjp.blog.service.ArticleService;
import com.pjp.blog.vo.ArticleVo;
import com.pjp.blog.vo.Result;
import com.pjp.blog.vo.params.PageParams;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.sql.PreparedStatement;

//json数据进行交互
@RestController
@RequestMapping("/articles")
public class ArticleController {
    @Autowired
    private ArticleService articleService;

    /**
     * 查询文章详情
     * @param articleId
     * @return
     */
    @PostMapping("view/{id}")
    public Result findArticleById(@PathVariable("id") Long articleId) {
        return articleService.findArticleById(articleId);
    }
}

1.4 Service

package com.pjp.blog.vo;

import lombok.Data;

import java.util.List;

/**
 * 和前端数据进行交互
 */
@Data
public class ArticleVo {
    private Long id;

    private String title;

    private String summary;

    private int commentCounts;

    private int viewCounts;

    private int weight;
    /**
     * 创建时间
     */
    private String createDate;

    private String author;

    private ArticleBodyVo body;

    private List<TagVo> tags;

    private CategoryVo category;
}

ArticleService

package com.pjp.blog.service;

import com.pjp.blog.vo.Result;
import com.pjp.blog.vo.params.PageParams;

public interface ArticleService {

    /**
     * 查询文章详情
     * @param articleId
     * @return
     */
    Result findArticleById(Long articleId);
}

ArticleServiceImpl

package com.pjp.blog.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.pjp.blog.dao.dos.Archives;
import com.pjp.blog.dao.mapper.ArticleBodyMapper;
import com.pjp.blog.dao.mapper.ArticleMapper;
import com.pjp.blog.dao.mapper.TagMapper;
import com.pjp.blog.dao.pojo.Article;
import com.pjp.blog.dao.pojo.ArticleBody;
import com.pjp.blog.service.ArticleService;
import com.pjp.blog.service.CategoryService;
import com.pjp.blog.service.SysUserService;
import com.pjp.blog.service.TagService;
import com.pjp.blog.vo.ArticleBodyVo;
import com.pjp.blog.vo.ArticleVo;
import com.pjp.blog.vo.Result;
import com.pjp.blog.vo.TagVo;
import com.pjp.blog.vo.params.PageParams;
import org.joda.time.DateTime;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.ArrayList;
import java.util.List;

@Service
public class ArticleServiceImpl implements ArticleService {
    @Autowired
    private ArticleMapper articleMapper;
    @Autowired
    private TagService tagService;

    @Autowired
    private SysUserService sysUserService;
    @Autowired
    private CategoryService categoryService;



    @Override
    public Result findArticleById(Long articleId) {
        /**
        * 1.根据id查询 文章信息
        * 2.根据bodyId和categoryId 去做关联查询
        */
        Article article = articleMapper.selectById(articleId);
        ArticleVo articleVo = cope(article, true, true, true, true);
        return Result.success(articleVo);
    }

    private List<ArticleVo> copyList(List<Article> records, boolean isTag, boolean isAuthor) {
        List<ArticleVo> articleVoList = new ArrayList<>();
        for (Article article : records) {
            articleVoList.add(cope(article, isTag, isAuthor, false, false));
        }
        return articleVoList;
    }

    //方法重载
    private List<ArticleVo> copyList(List<Article> records, boolean isTag, boolean isAuthor, boolean isBody, boolean isCategory) {
        List<ArticleVo> articleVoList = new ArrayList<>();
        for (Article article : records) {
            articleVoList.add(cope(article, isTag, isAuthor, isBody, isCategory));
        }
        return articleVoList;
    }

    private ArticleVo cope(Article article, boolean isTag, boolean isAuthor, boolean isBody, boolean isCategory) {
        ArticleVo articleVo = new ArticleVo();
        BeanUtils.copyProperties(article, articleVo);
        //      vo中createDate为String Article中为long copy不了
        articleVo.setCreateDate(new DateTime(article.getCreateDate()).toString("yyy-MM-dd HH:ss"));
        //        不是所有的接口 都需要标签 作者信息
        if (isTag) {
            //            根据ArticleId 查询 TagId
            Long articleId = article.getId();
            articleVo.setTags(tagService.findTagByArticleId(articleId));
        }
        if (isAuthor) {
            Long authorId = article.getAuthorId();
            articleVo.setAuthor(sysUserService.findUserById(authorId).getNickname());
        }
        if (isBody) {
            Long bodyId = article.getBodyId();
            articleVo.setBody(findArticleBodyById(bodyId));
        }
        if (isCategory) {
            Long categoryId = article.getCategoryId();
            articleVo.setCategory(categoryService.findCategoryById(categoryId));
        }
        return articleVo;
    }

    @Autowired
    private ArticleBodyMapper articleBodyMapper;

    private ArticleBodyVo findArticleBodyById(Long bodyId) {
        ArticleBody articleBody = articleBodyMapper.selectById(bodyId);
        ArticleBodyVo articleBodyVo = new ArticleBodyVo();
        articleBodyVo.setContent(articleBody.getContent());
        return articleBodyVo;
    }
}

CategoryService

package com.pjp.blog.service;

import com.pjp.blog.vo.CategoryVo;

public interface CategoryService {
    /**
     * 查询分类信息
     *
     * @return
     */
    CategoryVo findCategoryById(Long categoryId);

}

CategoryServiceImpl

package com.pjp.blog.service.impl;

import com.pjp.blog.dao.mapper.CategoryMapper;
import com.pjp.blog.dao.pojo.Category;
import com.pjp.blog.service.CategoryService;
import com.pjp.blog.vo.CategoryVo;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.ArrayList;
import java.util.List;

@Service
public class CategoryServiceImpl implements CategoryService {

    @Autowired
    private CategoryMapper categoryMapper;

    @Override
    public CategoryVo findCategoryById(Long categoryId) {
        Category category = categoryMapper.selectById(categoryId);
        CategoryVo categoryVo = new CategoryVo();
        BeanUtils.copyProperties(category, categoryVo);
        return categoryVo;
    }
}