devbox
繁依Fanyi0
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

springboot实战项目——个人博客系统_spring boot 实践之十三 10 spring boot综合项目实战——个人博客系统源码+文

作者：繁依Fanyi0 | 2024-02-15 13:12:31

赞

踩

spring boot 实践之十三 10 spring boot综合项目实战——个人博客系统源码+文件

1.项目介绍

1.1项目效果

博客首页

登录功能 

 

注册功能

文章分类 

 

文章归档 

文章页面 

  

发布文章 （集成富文本编译器）

 

 1.2项目使用技术

前端：

  • vue
  • element-ui

 后端：

  • Springboot
  • mybatis-plus
  • redis
  • mysql
  • jwt

2.工程搭建

2.1新建springboot项目

2.2在maven中导入相关依赖

  1. <dependencies>
  2.  
  3.         <dependency>
  4.             <groupId>org.springframework.boot</groupId>
  5.             <artifactId>spring-boot-starter</artifactId>
  6.             <!-- 排除 默认使用的logback  -->
  7.             <exclusions>
  8.                 <exclusion>
  9.                     <groupId>org.springframework.boot</groupId>
  10.                     <artifactId>spring-boot-starter-logging</artifactId>
  11.                 </exclusion>
  12.             </exclusions>
  13.         </dependency>
  14.  
  15.         <dependency>
  16.             <groupId>org.springframework.boot</groupId>
  17.             <artifactId>spring-boot-starter-web</artifactId>
  18.         </dependency>
  19.  
  20.         <dependency>
  21.             <groupId>mysql</groupId>
  22.             <artifactId>mysql-connector-java</artifactId>
  23.             <scope>runtime</scope>
  24.         </dependency>
  25.         <dependency>
  26.             <groupId>org.springframework.boot</groupId>
  27.             <artifactId>spring-boot-starter-test</artifactId>
  28.             <scope>test</scope>
  29.         </dependency>
  30.  
  31.         <dependency>
  32.             <groupId>org.projectlombok</groupId>
  33.             <artifactId>lombok</artifactId>
  34.         </dependency>
  35.  
  36.         <dependency>
  37.             <groupId>com.qiniu</groupId>
  38.             <artifactId>qiniu-java-sdk</artifactId>
  39.             <version>[7.7.0, 7.7.99]</version>
  40.         </dependency>
  41.  
  42.         <dependency>
  43.             <groupId>org.springframework.boot</groupId>
  44.             <artifactId>spring-boot-starter-data-redis</artifactId>
  45.         </dependency>
  46.  
  47.         <dependency>
  48.             <groupId>org.springframework.boot</groupId>
  49.             <artifactId>spring-boot-starter-aop</artifactId>
  50.         </dependency>
  51.  
  52.         <dependency>
  53.             <groupId>org.springframework.boot</groupId>
  54.             <artifactId>spring-boot-starter-mail</artifactId>
  55.         </dependency>
  56.  
  57.         <!-- https://mvnrepository.com/artifact/com.alibaba/fastjson -->
  58.         <dependency>
  59.             <groupId>com.alibaba</groupId>
  60.             <artifactId>fastjson</artifactId>
  61.             <version>1.2.76</version>
  62.         </dependency>
  63.  
  64.         <dependency>
  65.             <groupId>org.springframework.boot</groupId>
  66.             <artifactId>spring-boot-configuration-processor</artifactId>
  67.             <optional>true</optional>
  68.         </dependency>
  69.  
  70.         <dependency>
  71.             <groupId>org.springframework.boot</groupId>
  72.             <artifactId>spring-boot-starter-log4j2</artifactId>
  73.         </dependency>
  74.  
  75.         <dependency>
  76.             <groupId>org.springframework.boot</groupId>
  77.             <artifactId>spring-boot-starter-aop</artifactId>
  78.         </dependency>
  79.  
  80.         <dependency>
  81.             <groupId>org.springframework.boot</groupId>
  82.             <artifactId>spring-boot-starter-mail</artifactId>
  83.         </dependency>
  84.  
  85.  
  86.         <dependency>
  87.             <groupId>com.baomidou</groupId>
  88.             <artifactId>mybatis-plus-boot-starter</artifactId>
  89.             <version>3.4.3</version>
  90.         </dependency>
  91.  
  92.         <dependency>
  93.             <groupId>joda-time</groupId>
  94.             <artifactId>joda-time</artifactId>
  95.             <version>2.10.10</version>
  96.         </dependency>
  97.  
  98.         <dependency>
  99.             <groupId>org.apache.commons</groupId>
  100.             <artifactId>commons-lang3</artifactId>
  101.         </dependency>
  102.  
  103.         <dependency>
  104.             <groupId>commons-codec</groupId>
  105.             <artifactId>commons-codec</artifactId>
  106.             <version>1.15</version>
  107.         </dependency>
  108.         <dependency>
  109.             <groupId>commons-collections</groupId>
  110.             <artifactId>commons-collections</artifactId>
  111.             <version>3.2.2</version>
  112.         </dependency>
  113.  
  114.         <dependency>
  115.             <groupId>org.springframework.boot</groupId>
  116.             <artifactId>spring-boot-starter-data-redis</artifactId>
  117.         </dependency>
  118.  
  119.         <!-- https://mvnrepository.com/artifact/io.jsonwebtoken/jjwt -->
  120.         <dependency>
  121.             <groupId>io.jsonwebtoken</groupId>
  122.             <artifactId>jjwt</artifactId>
  123.             <version>0.9.1</version>
  124.         </dependency>
  125.  
  126.     </dependencies>

 2.3配置文件

mybatis-plus分页插件

  1. import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
  2. import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
  3. import org.mybatis.spring.annotation.MapperScan;
  4. import org.springframework.context.annotation.Bean;
  5. import org.springframework.context.annotation.Configuration;
  6.  
  7. @Configuration
  8. @MapperScan("com.leggasai.dao.mapper")
  9. public class MybatisPlusConfig {
  10.     //分页插件
  11.     @Bean
  12.     public MybatisPlusInterceptor mybatisPlusInterceptor() {
  13.         MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
  14.         interceptor.addInnerInterceptor(new PaginationInnerInterceptor());
  15.         return interceptor;
  16.     }
  17. }

跨域配置文件

  1. import com.leggasai.handler.LoginInterceptor;
  2. import org.springframework.beans.factory.annotation.Autowired;
  3. import org.springframework.context.annotation.Configuration;
  4. import org.springframework.web.servlet.config.annotation.CorsRegistry;
  5. import org.springframework.web.servlet.config.annotation.WebMvcConfigurer;
  6.  
  7. @Configuration
  8. public class WebMvcConfig implements WebMvcConfigurer {
  9.  
  10.     @Override
  11.     public void addCorsMappings(CorsRegistry registry) {
  12.         //跨域配置
  13.         registry.addMapping("/**")
  14.                 .allowedOrigins("http://localhost:8080")
  15.                 .allowedMethods("GET","POST","PUT","OPTIONS","DELETE")
  16.                 .allowCredentials(true)
  17.                 .maxAge(3600);
  18.     }
  19. }

springboot配置文件 application.yml

  1. server:
  2.   port: 8888
  3.  
  4.  
  5. spring:
  6.   datasource:
  7.     username: "mysql用户名"
  8.     password: "mysql密码"
  9.     url: jdbc:mysql://localhost:3306/blog?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
  10.     driver-class-name: com.mysql.cj.jdbc.Driver
  11.   redis:
  12.     host: localhost
  13.     port: 6379
  14.   servlet:
  15.     multipart:
  16.       max-file-size: 2MB
  17.       max-request-size: 20MB
  18.  
  19. mybatis-plus:
  20.   configuration:
  21.     log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
  22. #mysql中表前缀为ms_
  23.   global-config:
  24.     db-config:
  25.       table-prefix: ms_
  26.   type-aliases-package: com.leggasai.dao.pojo
  27.   mapper-locations: classpath*:mapper/*.xml

2.4特殊类

异常类：用于统一处理异常

  1. package com.leggasai.handler;
  2.  
  3.  
  4. import com.leggasai.vo.Result;
  5. import org.springframework.web.bind.annotation.ControllerAdvice;
  6. import org.springframework.web.bind.annotation.ExceptionHandler;
  7. import org.springframework.web.bind.annotation.ResponseBody;
  8.  
  9. //对加了@controller注解的方法进行拦截处理 Aop的实现
  10. @ControllerAdvice
  11. public class AllExceptionHandler {
  12.     @ExceptionHandler(Exception.class)
  13.     @ResponseBody//返回json数据
  14.     public Result doException(Exception ex){
  15.         ex.printStackTrace();
  16.         return Result.fail(-999, "系统异常");
  17.     }
  18. }

返回结果类：用于给前端返回数据 

  1. import lombok.AllArgsConstructor;
  2. import lombok.Data;
  3. import lombok.NoArgsConstructor;
  4.  
  5. @Data
  6. @AllArgsConstructor
  7. @NoArgsConstructor
  8. //返回结果类
  9. public class Result {
  10.     private boolean success;
  11.     private int code;
  12.     private String msg;
  13.     private Object data;
  14.     //链式
  15.     public static Result success(Object data){
  16.         return new Result(true, 200, "success",data);
  17.     }
  18.     //链式
  19.     public static Result fail(int code,String msg){
  20.         return new Result(false,code,msg,null);
  21.     }
  22. }

异常码类：枚举类，用于显示不同的出错提示 

  1. package com.leggasai.vo;
  2.  
  3. public enum  ErrorCode {
  4.  
  5.     PARAMS_ERROR(10001,"参数有误"),
  6.     ACCOUNT_PWD_NOT_EXIST(10002,"用户名或密码不存在"),
  7.     TOKEN_ERROR(10003,"token不合法"),
  8.     ACCOUNT_EXISTED(10004,"账号已存在"),
  9.  
  10.     NO_PERMISSION(70001,"无访问权限"),
  11.     SESSION_TIME_OUT(90001,"会话超时"),
  12.     NO_LOGIN(90002,"未登录"),
  13.     UPLOAD_ERROR(20001,"上传失败"),;
  14.     private int code;
  15.     private String msg;
  16.  
  17.     ErrorCode(int code, String msg){
  18.         this.code = code;
  19.         this.msg = msg;
  20.     }
  21.  
  22.     public int getCode() {
  23.         return code;
  24.     }
  25.  
  26.     public void setCode(int code) {
  27.         this.code = code;
  28.     }
  29.  
  30.     public String getMsg() {
  31.         return msg;
  32.     }
  33.  
  34.     public void setMsg(String msg) {
  35.         this.msg = msg;
  36.     }
  37. }

3.数据库搭建 

在sqlyog（或navicat）中新建名为blog的数据库

3.1表一：ms_article文章表

  1. CREATE TABLE `blog`.`ms_article`  (
  2.   `id` bigint(0) NOT NULL AUTO_INCREMENT,
  3.   `comment_counts` int(0) NULL DEFAULT NULL COMMENT '评论数量',
  4.   `create_date` bigint(0) NULL DEFAULT NULL COMMENT '创建时间',
  5.   `summary` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '简介',
  6.   `title` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',
  7.   `view_counts` int(0) NULL DEFAULT NULL COMMENT '浏览数量',
  8.   `weight` int(0) NOT NULL COMMENT '是否置顶',
  9.   `author_id` bigint(0) NULL DEFAULT NULL COMMENT '作者id',
  10.   `body_id` bigint(0) NULL DEFAULT NULL COMMENT '内容id',
  11.   `category_id` int(0) NULL DEFAULT NULL COMMENT '类别id',
  12.   PRIMARY KEY (`id`) USING BTREE
  13. ) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

 3.2表二：ms_article_body文章内容表

  1. drop table if exists `ms_article_body`;
  2. create table `ms_article_body`  (
  3.   `id` bigint(0) not null auto_increment,
  4.   `content` longtext character set utf8 collate utf8_general_ci null,
  5.   `content_html` longtext character set utf8 collate utf8_general_ci null,
  6.   `article_id` bigint(0) not null,
  7.   primary key (`id`) using btree,
  8.   index `article_id`(`article_id`) using btree
  9. ) engine = innodb auto_increment = 1405916999854342147 character set = utf8 collate = utf8_general_ci row_format = dynamic;

 3.3表三：ms_article_tag关联表

 这个表是用于关联article表和tag表（文章标签表）

  1. drop table if exists `ms_article_tag`;
  2. create table `ms_article_tag`  (
  3.   `id` bigint(0) not null auto_increment,
  4.   `article_id` bigint(0) not null,
  5.   `tag_id` bigint(0) not null,
  6.   primary key (`id`) using btree,
  7.   index `article_id`(`article_id`) using btree,
  8.   index `tag_id`(`tag_id`) using btree
  9. ) engine = innodb auto_increment = 1405916999787233282 character set = utf8 collate = utf8_general_ci row_format = dynamic;

3.4表四：ms_sys_user用户表

  1. drop table if exists `ms_sys_user`;
  2. create table `ms_sys_user`  (
  3.   `id` bigint(0) not null auto_increment,
  4.   `account` varchar(64) character set utf8 collate utf8_general_ci null default null comment '账号',
  5.   `admin` bit(1) null default null comment '是否管理员',
  6.   `avatar` varchar(255) character set utf8 collate utf8_general_ci null default null comment '头像',
  7.   `create_date` bigint(0) null default null comment '注册时间',
  8.   `deleted` bit(1) null default null comment '是否删除',
  9.   `email` varchar(128) character set utf8 collate utf8_general_ci null default null comment '邮箱',
  10.   `last_login` bigint(0) null default null comment '最后登录时间',
  11.   `mobile_phone_number` varchar(20) character set utf8 collate utf8_general_ci null default null comment '手机号',
  12.   `nickname` varchar(255) character set utf8 collate utf8_general_ci null default null comment '昵称',
  13.   `password` varchar(64) character set utf8 collate utf8_general_ci null default null comment '密码',
  14.   `salt` varchar(255) character set utf8 collate utf8_general_ci null default null comment '加密盐',
  15.   `status` varchar(255) character set utf8 collate utf8_general_ci null default null comment '状态',
  16.   primary key (`id`) using btree
  17. ) engine = innodb auto_increment = 1404448588146192387 character set = utf8 collate = utf8_general_ci row_format = dynamic;

3.5表五： ms_tag文章标签表

  1. drop table if exists `ms_tag`;
  2. create table `ms_tag`  (
  3.   `id` bigint(0) not null auto_increment,
  4.   `avatar` varchar(255) character set utf8mb4 collate utf8mb4_unicode_ci null default null,
  5.   `tag_name` varchar(255) character set utf8mb4 collate utf8mb4_unicode_ci null default null,
  6.   primary key (`id`) using btree
  7. ) engine = innodb auto_increment = 11 character set = utf8 collate = utf8_general_ci row_format = dynamic;

3.6表六：ms_comment评论表 

  1. drop table if exists `ms_comment`;
  2. create table `ms_comment`  (
  3.   `id` bigint(0) not null auto_increment,
  4.   `content` varchar(255) character set utf8mb4 collate utf8mb4_unicode_ci not null,
  5.   `create_date` bigint(0) not null,
  6.   `article_id` int(0) not null,
  7.   `author_id` bigint(0) not null,
  8.   `parent_id` bigint(0) not null,
  9.   `to_uid` bigint(0) not null,
  10.   `level` varchar(1) character set utf8 collate utf8_general_ci not null,
  11.   primary key (`id`) using btree,
  12.   index `article_id`(`article_id`) using btree
  13. ) engine = innodb auto_increment = 1405209691876790275 character set = utf8 collate = utf8_general_ci row_format = dynamic;

3.7表七： ms_category类别表

  1. drop table if exists `ms_category`;
  2. create table `ms_category`  (
  3.   `id` bigint(0) not null auto_increment,
  4.   `avatar` varchar(255) character set utf8mb4 collate utf8mb4_unicode_ci null default null,
  5.   `category_name` varchar(255) character set utf8mb4 collate utf8mb4_unicode_ci null default null,
  6.   `description` varchar(255) character set utf8mb4 collate utf8mb4_unicode_ci null default null,
  7.   primary key (`id`) using btree
  8. ) engine = innodb auto_increment = 6 character set = utf8 collate = utf8_general_ci row_format = dynamic;

4.首页功能

4.1文章列表实现

效果图

 

4.1.1pojo类 

 1.建立pojo类——article

  1. package com.leggasai.dao.pojo;
  2.  
  3.  
  4. import lombok.Data;
  5.  
  6. @Data
  7. public class Article {
  8.     public static final int Article_TOP=1;//是否指定，默认是
  9.     public static final int Article_Common=0;//默认评论数0
  10.     private Long id;//文章id
  11.     private String title;//文章标题
  12.     private String summary;//文章简介
  13.     private Integer commentCounts;//文章评论数
  14.     private Integer viewCounts;//文章阅读数
  15.     private Long authorId;//作者id
  16.     private Long bodyId;//文章内容id
  17.     private Long categoryId;//文章类别id
  18.     private Integer weight=Article_Common;//文章权重
  19.     private Long createDate;//文章创建时间
  20. }

 2.建立pojo类——sysUser用户类

  1. package com.leggasai.dao.pojo;
  2.  
  3.  
  4. import lombok.Data;
  5.  
  6. @Data
  7. public class SysUser {
  8.     private Long id;//用户id
  9.     private String account;//用户账号
  10.     private String password;//用户密码
  11.     private Integer admin;//是否管理员
  12.     private String avatar;//用户头像地址
  13.     private Long createDate;//用户创建时间
  14.     private Integer deleted;//是否被删除
  15.     private String email;//用户邮箱
  16.     private Long lastLogin;//用户最后一次登录时间
  17.     private String nickname;//用户昵称
  18.     private String mobilePhoneNumber;//用户手机号
  19.     private String salt;//加密盐
  20.     private String status;//用户状态
  21.  
  22. }

3.建立pojo类——tag标签类 

  1. package com.leggasai.dao.pojo;
  2. import lombok.Data;
  3. @Data
  4. public class Tag {
  5.     private Long id;//标签id
  6.     private String avatar;//标签图片地址
  7.     private String tagName;//标签名
  8. }

4.建立vo类——articleVo:前端显示类往往和数据库中的类有差别 

  1.  
  2. import java.util.List;
  3.  
  4. @Data
  5. public class ArticleVo {
  6.  
  7.     private Long id;
  8.  
  9.     private String title;
  10.  
  11.     private String summary;
  12.  
  13.     private int commentCounts;
  14.  
  15.     private int viewCounts;
  16.  
  17.     private int weight;
  18.     /**
  19.      * 创建时间
  20.      */
  21.     private String createDate;
  22.  
  23.     private String author;
  24.  
  25.     private ArticleBodyVo body;
  26.  
  27.     private List<TagVo> tags;
  28.  
  29.     private List<CategoryVo> categorys;
  30.  
  31. }

4.1.2controller类

ArticleController类：用于处理和article相关业务

  1. import java.util.List;
  2.  
  3. @RestController
  4. @RequestMapping("articles")
  5. public class ArticleController {
  6.  
  7.     @Autowired
  8.     private ArticleService articleService;
  9. 	//Result是统一结果返回
  10.     @PostMapping
  11.     public Result articles(@RequestBody PageParams pageParams) {
  12.         //ArticleVo 页面接收的数据
  13.         List<ArticleVo> articles = articleService.listArticlesPage(pageParams);
  14.  
  15.         return Result.success(articles);
  16.     }
  17.  
  18.  
  19. }

 4.1.3service类

ArticleService接口与ArticleServiceImpl实现类

  1. import java.util.List;
  2.  
  3. public interface ArticleService {
  4.  
  5.     List<ArticleVo> listArticlesPage(PageParams pageParams);
  6.  
  7. }
  1. package com.leggasai.service.impl;
  2.  
  3. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
  4. import com.baomidou.mybatisplus.core.metadata.IPage;
  5. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  6. import com.leggasai.common.aop.LogAnnotation;
  7. import com.leggasai.dao.dos.Archives;
  8. import com.leggasai.dao.mapper.ArticleBodyMapper;
  9. import com.leggasai.dao.mapper.ArticleMapper;
  10. import com.leggasai.dao.mapper.ArticleTagMapper;
  11. import com.leggasai.dao.pojo.Article;
  12. import com.leggasai.dao.pojo.ArticleBody;
  13. import com.leggasai.dao.pojo.ArticleTag;
  14. import com.leggasai.dao.pojo.SysUser;
  15. import com.leggasai.service.*;
  16. import com.leggasai.utils.UserThreadLocal;
  17. import com.leggasai.vo.ArticleBodyVo;
  18. import com.leggasai.vo.ArticleVo;
  19. import com.leggasai.vo.Result;
  20. import com.leggasai.vo.TagVo;
  21. import com.leggasai.vo.params.ArticleParam;
  22. import com.leggasai.vo.params.PageParams;
  23. import net.sf.jsqlparser.expression.DateTimeLiteralExpression;
  24. import org.joda.time.DateTime;
  25. import org.springframework.beans.BeanUtils;
  26. import org.springframework.beans.factory.annotation.Autowired;
  27.  
  28. import org.springframework.stereotype.Service;
  29.  
  30. import java.util.ArrayList;
  31. import java.util.HashMap;
  32. import java.util.List;
  33. import java.util.Map;
  34.  
  35. @Service
  36. public class ArticleServiceImpl implements ArticleService {
  37.     @Autowired
  38.     private ArticleMapper articleMapper;
  39.    @Autowired
  40.    private SysUserService sysUserService;
  41.     @Autowired
  42.     private TagsService tagsService;
  43.  
  44.     public ArticleVo copy(Article article,boolean isAuthor,boolean isBody,boolean isTags){
  45.         ArticleVo articleVo = new ArticleVo();
  46.         BeanUtils.copyProperties(article, articleVo);
  47.         if (isAuthor) {
  48.             SysUser sysUser = sysUserService.findSysUserById(article.getAuthorId());
  49.             articleVo.setAuthor(sysUser.getNickname());
  50.         }
  51.         articleVo.setCreateDate(new DateTime(article.getCreateDate()).toString("yyyy-MM-dd HH:mm"));
  52.         if (isTags){
  53.            List<TagVo> tags = tagsService.findTagsByArticleId(article.getId());
  54.            articleVo.setTags(tags);
  55.         }
  56.         return articleVo;
  57.     }
  58.  
  59.     private List<ArticleVo> copyList(List<Article> records,boolean isAuthor,boolean isBody,boolean isTags) {
  60.         List<ArticleVo> articleVoList = new ArrayList<>();
  61.         for (Article article : records) {
  62.             ArticleVo articleVo = copy(article,isAuthor,isBody,isTags);
  63.             articleVoList.add(articleVo);
  64.         }
  65.         return articleVoList;
  66.     }
  67.  
  68.  
  69.     @Override
  70.     public List<ArticleVo> listArticlesPage(PageParams pageParams) {
  71.         QueryWrapper<Article> queryWrapper = new QueryWrapper<>();
  72.         Page<Article> page = new Page<>(pageParams.getPage(),pageParams.getPageSize());
  73.         Page<Article> articlePage = articleMapper.selectPage(page, queryWrapper);
  74.         List<ArticleVo> articleVoList = copyList(articlePage.getRecords(),true,false,true);
  75.         return articleVoList;
  76.     }
  77.  
  78.  
  79. }

sysUserService和sysUserServiceImpl 

  1. public interface UserService {
  2.  
  3.     SysUser findUserById(Long userId);
  4. }
  1. package com.leggasai.service.impl;
  2.  
  3. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
  4. import com.leggasai.dao.mapper.SysUserMapper;
  5. import com.leggasai.dao.pojo.SysUser;
  6. import com.leggasai.service.LoginService;
  7. import com.leggasai.service.SysUserService;
  8. import com.leggasai.vo.ErrorCode;
  9. import com.leggasai.vo.LoginUserVo;
  10. import com.leggasai.vo.Result;
  11. import com.leggasai.vo.UserVo;
  12. import org.apache.commons.lang3.StringUtils;
  13. import org.springframework.beans.BeanUtils;
  14. import org.springframework.beans.factory.annotation.Autowired;
  15. import org.springframework.data.redis.core.RedisTemplate;
  16. import org.springframework.stereotype.Service;
  17.  
  18. @Service
  19. public class UserServiceImpl implements UserService {
  20.  
  21.     @Autowired
  22.     private SysUserMapper sysUserMapper;
  23.  
  24.     @Override
  25.     public SysUser findUserById(Long userId) {
  26.         SysUser sysUser = sysUserMapper.selectById(userId);
  27.         if (sysUser == null) {
  28.             sysUser = new SysUser();
  29.             sysUser.setNickname("码神之路");
  30.         }
  31.         return sysUser;
  32.     }
  33. }

tagService和tagServiceImpl 

  1. package com.leggasai.service;
  2.  
  3. import com.leggasai.vo.Result;
  4. import com.leggasai.vo.TagVo;
  5.  
  6. import java.util.List;
  7.  
  8. public interface TagService {
  9.     List<TagVo> findTagsByArticleId(Long articleId);
  10. }
  1. package com.leggasai.service.impl;
  2. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
  3. import com.leggasai.dao.mapper.TagMapper;
  4. import com.leggasai.dao.pojo.Tag;
  5. import com.leggasai.service.TagService;
  6. import com.leggasai.vo.Result;
  7. import com.leggasai.vo.TagVo;
  8. import org.springframework.beans.BeanUtils;
  9. import org.springframework.beans.factory.annotation.Autowired;
  10. import org.springframework.stereotype.Service;
  11. import org.springframework.util.CollectionUtils;
  12.  
  13. import java.lang.reflect.Array;
  14. import java.util.ArrayList;
  15. import java.util.Collections;
  16. import java.util.List;
  17.  
  18.  
  19. @Service
  20. public class TagServiceImpl implements TagService {
  21.     @Autowired
  22.     private TagMapper tagMapper;
  23.     @Override
  24.     public List<TagVo> findTagsByArticleId(Long articleId) {
  25.         //mybatis-plus无法进行多表查询
  26.         List<Tag> tags=tagMapper.findTagsByArticleId(articleId);
  27.         return copyList(tags);
  28.     }
  29.  
  30.  
  31.     public TagVo copy(Tag tag){
  32.         TagVo tagVo=new TagVo();
  33.         BeanUtils.copyProperties(tag,tagVo);
  34.         tagVo.setId(String.valueOf(tag.getId()));
  35.         return tagVo;
  36.     }
  37.     public List<TagVo> copyList(List<Tag> tagList){
  38.         List<TagVo> tagVoList = new ArrayList<>();
  39.         for (Tag tag : tagList) {
  40.             tagVoList.add(copy(tag));
  41.         }
  42.         return tagVoList;
  43.     }
  44.  
  45.  
  46.  
  47. }

4.1.4dao层

ArticleMapper接口

  1. package com.leggasai.dao.mapper;
  2.  
  3. import com.baomidou.mybatisplus.core.mapper.BaseMapper;
  4. import com.baomidou.mybatisplus.core.metadata.IPage;
  5. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  6. import com.leggasai.dao.dos.Archives;
  7. import com.leggasai.dao.pojo.Article;
  8. import org.apache.ibatis.annotations.Mapper;
  9. import org.springframework.stereotype.Repository;
  10.  
  11. import java.util.List;
  12. @Mapper
  13. public interface ArticleMapper extends BaseMapper<Article> {
  14.     List<Archives> listArchives();
  15.  
  16.     IPage<Article> listArticle(Page<Article> page,
  17.                                Long categoryId,
  18.                                Long tagId,
  19.                                String year,
  20.                                String month);
  21. }

SysUserMapper接口 

  1. package com.leggasai.dao.mapper;
  2.  
  3. import com.baomidou.mybatisplus.core.mapper.BaseMapper;
  4. import com.leggasai.dao.pojo.SysUser;
  5. import org.apache.ibatis.annotations.Mapper;
  6. import org.springframework.stereotype.Repository;
  7.  
  8. @Mapper
  9. public interface SysUserMapper extends BaseMapper<SysUser> {
  10. }

TagMapper接口 

  1. package com.leggasai.dao.mapper;
  2.  
  3. import com.baomidou.mybatisplus.core.mapper.BaseMapper;
  4. import com.leggasai.dao.pojo.Tag;
  5. import org.apache.ibatis.annotations.Mapper;
  6. import org.apache.ibatis.annotations.Param;
  7. import org.springframework.stereotype.Repository;
  8.  
  9.  
  10. import java.util.List;
  11. @Mapper
  12. public interface TagMapper extends BaseMapper<Tag> {
  13.     /*
  14.     根据文章id查询标签列表
  15.      */
  16.     List<Tag> findTagsByArticleId(Long articleId);
  17.  
  18.    
  19. }

 TagMapper.xml

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!--中文错误改成UTF8即可-->
  3. <!DOCTYPE mapper
  4.         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  5.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  6.  
  7. <mapper namespace="com.leggasai.dao.mapper.TagMapper">
  8. <!--    List<Tag> findTagsByArticleId(Long articleId);-->
  9.     <select id="findTagsByArticleId" parameterType="long" resultType="com.leggasai.dao.pojo.Tag">
  10.         select id,avatar,tag_name as tagName from ms_tag
  11.         where id in (select tag_id from ms_article_tag where article_id=#{articleId})
  12.     </select>
  13.  
  14. </mapper>

4.2首页最热标签功能

 4.2.1前端接口

接口url：/tags/hot

请求方式：GET

请求参数：无

返回数据：

  1. {
  2.     "success": true,
  3.     "code": 200,
  4.     "msg": "success",
  5.     "data": [
  6.         {
  7.             "id":1,
  8.             "tagName":"4444"
  9.         }
  10.     ]
  11. }

4.2.2controller类

  1.     @GetMapping("/hot")
  2.     public Result hot(){
  3.         int limit =6;
  4.         Result hots = tagService.hots(limit);
  5.         return hots;
  6.     }

4.2.3service层

    Result hots(int limit);
  1.     @Override
  2.     public Result hots(int limit) {
  3.         /*
  4.         标签所拥有的文章数量做多，就是最热标签
  5.          */
  6.         List<Long> tagIds=tagMapper.findHotsTagIds(limit);
  7.         if(CollectionUtils.isEmpty(tagIds)){
  8.             return Result.success(Collections.emptyList());
  9.         }
  10.         //需要的是tagId和tagName
  11.         List<Tag> tagList=tagMapper.findTagesByTagIds(tagIds);
  12.         //System.out.println("最热标签");
  13.         //System.out.println(tagList);
  14.         return Result.success(tagList);
  15.     }

4.2.4mapper层

  1.     <select id="findHotsTagIds" parameterType="int" resultType="java.lang.Long">
  2.         select tag_id from ms_article_tag group by tag_id order by COUNT(*) desc limit #{limit}
  3.     </select>
  4.  
  5.     <select id="findTagesByTagIds" parameterType="list" resultType="com.leggasai.dao.pojo.Tag">
  6.         select id,tag_name as tagName from ms_tag
  7.         where id in
  8.         <foreach collection="tagIds" item="tagId" separator="," open="(" close=")">
  9.             #{tagId}
  10.         </foreach>
  11.     </select>

4.3首页最热文章功能

 

后续可以用cache优化

4.3.1前端接口

接口url：/articles/hot

请求方式：POST

请求参数：

返回数据：

{
    "success": true,
    "code": 200,
    "msg": "success",
    "data": [
        {
            "id": 1,
            "title": "springboot介绍以及入门案例",
        },
        {
            "id": 9,
            "title": "Vue.js 是什么",
        },
        {
            "id": 10,
            "title": "Element相关",
            
        }
    ]
}

4.3.2controller层

  1.     @PostMapping("/hot")
  2.     public Result hotArticle(){
  3.         int limit =5;
  4.         return articleService.hotArticle(limit);
  5.     }

4.3.3service层

  1.     @Override
  2.     public Result hotArticle(int limit) {
  3.         LambdaQueryWrapper<Article> queryWrapper = new LambdaQueryWrapper<>();
  4.         queryWrapper.orderByDesc(Article::getViewCounts);
  5.         queryWrapper.select(Article::getId,Article::getTitle);
  6.         queryWrapper.last("limit "+limit);
  7.         //select id,title from article order by view_counts desc limit 5
  8.         List<Article> articles = articleMapper.selectList(queryWrapper);
  9.         return Result.success(copyList(articles,false,false));
  10.     }

4.4首页最新文章功能

 

后续可以用cache优化 

4.4.1前端接口

接口url：/articles/new

请求方式：POST

请求参数：

返回数据：

{
    "success": true,
    "code": 200,
    "msg": "success",
    "data": [
        {
            "id": 1,
            "title": "springboot介绍以及入门案例",
        },
        {
            "id": 9,
            "title": "Vue.js 是什么",
        },
        {
            "id": 10,
            "title": "Element相关",
            
        }
    ]
}

4.4.2controller层

  1.     @PostMapping("/new")
  2.     public Result newArticles(){
  3.         int limit =5;
  4.         return articleService.newArticles(limit);
  5.     }

4.4.3service层

  1.     @Override
  2.     public Result newArticles(int limit) {
  3.         LambdaQueryWrapper<Article> queryWrapper = new LambdaQueryWrapper<>();
  4.         queryWrapper.orderByDesc(Article::getCreateDate);
  5.         queryWrapper.select(Article::getId,Article::getTitle);
  6.         queryWrapper.last("limit "+limit);
  7.         //select id,title from article order by create_date desc limit 5
  8.         List<Article> articles = articleMapper.selectList(queryWrapper);
  9.         return Result.success(copyList(articles,false,false));
  10.     }

4.5首页文章归档功能

 

4.5.1前端接口

接口url：/articles/listArchives

请求方式：POST

请求参数：

返回数据：

{
    "success": true,
    "code": 200,
    "msg": "success",
    "data": [
        {
            "year": "2021",
            "month": "6",
            "count": 2
        }
            
    ]

}

4.5.2controller层

  1.     @PostMapping("listArchives")
  2.     public Result listArchives(){
  3.         return articleService.listArchives();
  4.     }

4.5.3service层

  1.     @Override
  2.     public Result listArchives() {
  3.         List<Archives> archivesList=articleMapper.listArchives();
  4.         return Result.success(archivesList);
  5.     }

4.5.4mapper层 

    List<Archives> listArchives();

注意数据库中create_date是时间戳，需要使用FROM_UNIXTIME转化为xxxx年xx月的格式！

  1.     <select id="listArchives" resultType="com.leggasai.dao.dos.Archives">
  2.         select FROM_UNIXTIME(create_date/1000,'%Y') as year,FROM_UNIXTIME(create_date/1000,'%m') as month,COUNT(*) as COUNT
  3.         from ms_article group by year,month
  4.     </select>

 Archives类

  1. package com.leggasai.dao.dos;
  2.  
  3. import lombok.AllArgsConstructor;
  4. import lombok.Data;
  5. import lombok.NoArgsConstructor;
  6. @Data
  7. @AllArgsConstructor
  8. @NoArgsConstructor
  9. public class Archives {
  10.  
  11.     private Integer year;
  12.     private Integer month;
  13.     private Long count;
  14.  
  15. }

5.登录功能

5.1jwt技术

5.2退出功能

5.3注册功能

5.4登录拦截器

5.5ThreadLocal使用

未完待续~

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/繁依Fanyi0/article/detail/84761
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号