• 月木学途开发 3.博客模块开发

    概述

    效果展示

     

     

     

    数据库设计

    专栏表

    1. DROP TABLE IF EXISTS `blog_column`;
    2. CREATE TABLE `blog_column` (
    3.   `blogColumnId` int(11) NOT NULL AUTO_INCREMENT,
    4.   `blogColumnName` varchar(255) DEFAULT NULL,
    5.   `blogColumnCoverImg` longtext,
    6.   `blogColumnIntroduction` longtext,
    7.   `userId` int(11) DEFAULT NULL,
    8.   PRIMARY KEY (`blogColumnId`)
    9. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

    标签表

    1. DROP TABLE IF EXISTS `blog_tag`;
    2. CREATE TABLE `blog_tag` (
    3.   `blogTagId` int(11) NOT NULL AUTO_INCREMENT,
    4.   `blogTagName` varchar(255) DEFAULT NULL,
    5.   PRIMARY KEY (`blogTagId`)
    6. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

    博客类型表

    1. DROP TABLE IF EXISTS `blog_type`;
    2. CREATE TABLE `blog_type` (
    3.   `blogTypeId` int(11) NOT NULL AUTO_INCREMENT,
    4.   `blogTypeName` varchar(255) DEFAULT NULL,
    5.   PRIMARY KEY (`blogTypeId`)
    6. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

    评论表

    1. DROP TABLE IF EXISTS `blog_comment`;
    2. CREATE TABLE `blog_comment` (
    3.   `blogCommentId` int(11) NOT NULL AUTO_INCREMENT,
    4.   `blogCommentContent` varchar(255) DEFAULT NULL,
    5.   `blogCommentTime` varchar(255) DEFAULT NULL,
    6.   `userId` int(11) DEFAULT NULL,
    7.   `blogId` int(11) DEFAULT NULL,
    8.   PRIMARY KEY (`blogCommentId`)
    9. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

    可见范围表

    1. DROP TABLE IF EXISTS `blog_visibility`;
    2. CREATE TABLE `blog_visibility` (
    3.   `blogVisibilityId` int(11) NOT NULL AUTO_INCREMENT,
    4.   `blogVisibilityName` varchar(255) DEFAULT NULL,
    5.   PRIMARY KEY (`blogVisibilityId`)
    6. ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4;

    博客表

    1. DROP TABLE IF EXISTS `blog`;
    2. CREATE TABLE `blog` (
    3.   `blogId` int(11) NOT NULL AUTO_INCREMENT,
    4.   `blogTitle` varchar(255) DEFAULT NULL,
    5.   `blogCoverImg` longtext,
    6.   `blogSummary` longtext,
    7.   `blogContent` longtext,
    8.   `blogCreateData` varchar(255) DEFAULT NULL,
    9.   `blogShow` int(11) DEFAULT NULL,
    10.   `blogRead` int(11) DEFAULT NULL,
    11.   `blogLike` int(11) DEFAULT NULL,
    12.   `blogFavorite` int(11) DEFAULT NULL,
    13.   `userId` int(11) DEFAULT NULL,
    14.   `blogTypeId` int(11) DEFAULT NULL,
    15.   `blogVisibilityId` int(11) DEFAULT NULL,
    16.   `blogStatus` varchar(255) DEFAULT NULL,
    17.   PRIMARY KEY (`blogId`)
    18. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

    博客专栏关联表

    1. DROP TABLE IF EXISTS `blog_blog_column`;
    2. CREATE TABLE `blog_blog_column` (
    3.   `blogId` int(11) DEFAULT NULL,
    4.   `blogColumnId` int(11) DEFAULT NULL
    5. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

    博客标签关联表

    1. DROP TABLE IF EXISTS `blog_blog_tag`;
    2. CREATE TABLE `blog_blog_tag` (
    3.   `blogId` int(11) DEFAULT NULL,
    4.   `blogTagId` int(11) DEFAULT NULL
    5. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

    实体类设计

    Blog

    1. /**
    2.  * 博客文章实体类
    3.  */
    4. @Data
    5. public class Blog implements Serializable {
    6.     @TableId
    7.     private Integer blogId;
    8.     private String blogCoverImg;//封面
    9.     private String blogTitle;//标题
    10.     private String blogSummary;//摘要
    11.     private String blogContent;//内容
    12.     private String blogCreateData;//创作时间
    13.  
    14.     private String blogStatus;//状态【0：审核/1：发布】
    15.  
    16.     private Integer blogShow;//展现量
    17.     private Integer blogRead;//阅读量
    18.     private Integer blogLike;//点赞量
    19.     private Integer blogFavorite;//收藏量
    20.  
    21.     private Integer userId;//作者
    22.     @TableField(exist = false)
    23.     private User user;
    24.  
    25.     private Integer blogTypeId;//类型
    26.     @TableField(exist = false)
    27.     private BlogType blogType;
    28.  
    29.     private Integer blogVisibilityId;//可见范围
    30.     @TableField(exist = false)
    31.     private BlogVisibility blogVisibility;
    32.  
    33.     @TableField(exist = false)
    34.     private List<BlogTag> tags;//标签
    35.     @TableField(exist = false)
    36.     private List<BlogColumn> columns;//专栏
    37.  
    38. }

    BlogColumn

    1. /**
    2.  * 专栏
    3.  * 博客和专栏是多对多的关系
    4.  * 用户和专栏是一对多的关系
    5.  */
    6. @Data
    7. public class BlogColumn implements Serializable {
    8.     @TableId
    9.     private Integer blogColumnId;
    10.     private String blogColumnName;//名称
    11.     private String blogColumnCoverImg;//封面
    12.     private String blogColumnIntroduction;//简介
    13.     private Integer userId;//用户
    14. }

    BlogComment

    1. /**
    2.  * 评论
    3.  */
    4. @Data
    5. public class BlogComment implements Serializable {
    6.     @TableId
    7.     private Integer blogCommentId;
    8.     private String blogCommentTime;//评论时间
    9.     private String blogCommentContent;//内容
    10.  
    11.     private Integer userId;//评论者
    12.     private Integer blogId;//博客
    13. }

    BlogTag

    1. /**
    2.  * 标签
    3.  * 博客和标签是多对多的关系
    4.  */
    5. @Data
    6. public class BlogTag implements Serializable {
    7.     @TableId
    8.     private Integer blogTagId;
    9.     private String blogTagName;//标签名
    10. }

    BlogType

    1. /**
    2.  * 类型
    3.  */
    4. @Data
    5. public class BlogType implements Serializable {
    6.     @TableId
    7.     private Integer blogTypeId;
    8.     private String blogTypeName;//类型名
    9. }

    BlogVisibility

    1. /**
    2.  * 可见范围
    3.  */
    4. @Data
    5. public class BlogVisibility implements Serializable {
    6.     @TableId
    7.     private Integer blogVisibilityId;
    8.     private String blogVisibilityName;//名称
    9. }

    Mapper层编写

    BlogColumnMapper

    1. public interface BlogColumnMapper extends BaseMapper<BlogColumn> {
    2.     //根据标签id删除博客_专栏关联表的数据
    3.     void deleteBlog_columnByBlogColumnId(Integer blogColumnId);
    4. }

    BlogColumnMapper.xml

    1. "1.0" encoding="UTF-8"?>
    2. mapper
    3.         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
    4.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    5. <mapper namespace="jkw.mapper.BlogColumnMapper">
    6.  
    7.     <delete id="deleteBlog_columnByBlogColumnId" parameterType="int">
    8.         DELETE
    9.         FROM blog_blog_column
    10.         WHERE blogColumnId = #{blogColumnId}
    11.     delete>
    12.  
    13.  
    14. mapper>

    BlogCommentMapper

    1. public interface BlogCommentMapper extends BaseMapper<BlogComment> {
    2. }

    BlogMapper

    1. public interface BlogMapper extends BaseMapper<Blog> {
    2.     //添加博客_专栏中间表的数据
    3.     void addBlog_column(@Param("blogId") Integer blogId, @Param("blogColumnId") Integer blogColumnId);
    4.  
    5.     //删除博客_专栏中间表的数据
    6.     void deleteBlog_column(@Param("blogId") Integer blogId, @Param("blogColumnId") Integer blogColumnId);
    7.  
    8.     //根据博客id删除博客_专栏中间表的数据
    9.     void deleteBlog_columnByBlogId(Integer blogId);
    10.  
    11.     //根据博客id查询博客_专栏中间表的专栏数据
    12.     List<BlogColumn> findColumnByBlogId(Integer blogId);
    13.  
    14.     //添加博客_标签中间表的数据
    15.     void addBlog_tag(@Param("blogId") Integer blogId, @Param("blogTagId") Integer blogTagId);
    16.  
    17.     //删除博客_标签中间表的数据
    18.     void deleteBlog_tag(@Param("blogId") Integer blogId, @Param("blogTagId") Integer blogTagId);
    19.  
    20.     //根据博客id删除博客_标签中间表的数据
    21.     void deleteBlog_tagByBlogId(Integer blogId);
    22.  
    23.     //根据博客id查询博客_标签中间表的标签数据
    24.     List<BlogTag> findTagByBlogId(Integer blogId);
    25.  
    26.     //删除博客对应的所有评论
    27.     void deleteAllComments(Integer blogId);
    28.  
    29.     //根据id查询博客内容【封装数据】
    30.     Blog findById(Integer blogId);
    31.  
    32.     //条件分页分页查询博客内容【封装数据】
    33.     Page<Blog> search(Page<Blog> page, @Param(Constants.WRAPPER) Wrapper<Blog> wrapper);
    34.  
    35.     //条件分页分页查询博客内容【封装数据并且为发布状态】
    36.     Page<Blog> searchWhenStatus(Page<Blog> page, @Param(Constants.WRAPPER) Wrapper<Blog> wrapper);
    37.  
    38. }

    BlogMapper.xml

    1. <?xml version="1.0" encoding="UTF-8"?>
    2. <!DOCTYPE mapper
    3.         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
    4.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    5. <mapper namespace="jkw.mapper.BlogMapper">
    6.     <resultMap id="blogMapper" type="jkw.pojo.Blog">
    7.         <id property="blogId" column="blogId"></id>
    8.         <result property="blogTitle" column="blogTitle"></result>
    9.         <result property="blogCoverImg" column="blogCoverImg"></result>
    10.         <result property="blogSummary" column="blogSummary"></result>
    11.         <result property="blogContent" column="blogContent"></result>
    12.         <result property="blogCreateData" column="blogCreateData"></result>
    13.         <result property="blogStatus" column="blogStatus"></result>
    14.         <result property="blogShow" column="blogShow"></result>
    15.         <result property="blogRead" column="blogRead"></result>
    16.         <result property="blogLike" column="blogLike"></result>
    17.         <result property="blogFavorite" column="blogFavorite"></result>
    18.         <result property="userId" column="userId"></result>
    19.         <result property="blogTypeId" column="blogTypeId"></result>
    20.         <result property="blogVisibilityId" column="blogVisibilityId"></result>
    21.         <result property="userId" column="userId"></result>
    22.         <collection property="user" column="userId" ofType="jkw.pojo.User">
    23.             <id property="userId" column="userId"></id>
    24.             <result property="userImg" column="userImg"></result>
    25.             <result property="nickname" column="nickname"></result>
    26.             <result property="email" column="email"></result>
    27.             <result property="username" column="username"></result>
    28.             <result property="signature" column="signature"></result>
    29.         </collection>
    30.         <collection property="blogType" column="blogTypeId" ofType="jkw.pojo.BlogType">
    31.             <id property="blogTypeId" column="blogTypeId"></id>
    32.             <result property="blogTypeName" column="blogTypeName"></result>
    33.         </collection>
    34.         <collection property="blogVisibility" column="blogVisibilityId" ofType="jkw.pojo.BlogVisibility">
    35.             <id property="blogVisibilityId" column="blogVisibilityId"></id>
    36.             <result property="blogVisibilityName" column="blogVisibilityName"></result>
    37.         </collection>
    38.         <collection property="tags" column="blogId" ofType="jkw.pojo.BlogTag">
    39.             <id property="blogTagId" column="blogTagId"></id>
    40.             <result property="blogTagName" column="blogTagName"></result>
    41.         </collection>
    42.         <collection property="columns" column="blogId" ofType="jkw.pojo.BlogColumn">
    43.             <id property="blogColumnId" column="blogColumnId"></id>
    44.             <result property="blogColumnName" column="blogColumnName"></result>
    45.             <result property="blogColumnCoverImg" column="blogColumnCoverImg"></result>
    46.             <result property="blogColumnIntroduction" column="blogColumnIntroduction"></result>
    47.             <result property="userId" column="userId"></result>
    48.         </collection>
    49.     </resultMap>
    50.     <insert id="addBlog_column">
    51.         INSERT INTO blog_blog_column
    52.         VALUES (#{blogId}, #{blogColumnId});
    53.     </insert>
    54.     <delete id="deleteBlog_column" parameterType="int">
    55.         DELETE
    56.         FROM blog_blog_column
    57.         WHERE blogId = #{blogId}
    58.           and blogColumnId = #{blogColumnId});
    59.     </delete>
    60.     <delete id="deleteBlog_columnByBlogId" parameterType="int">
    61.         DELETE
    62.         FROM blog_blog_column
    63.         WHERE blogId = #{blogId}
    64.     </delete>
    65.  
    66.     <select id="findColumnByBlogId" resultType="jkw.pojo.BlogColumn" parameterType="int">
    67.         select blog_column.*
    68.         from blog_column
    69.                  left join blog_blog_column
    70.                            on blog_blog_column.blogColumnId = blog_column.blogColumnId
    71.         where blog_blog_column.blogId = #{blogId}
    72.     </select>
    73.  
    74.     <insert id="addBlog_tag">
    75.         INSERT INTO blog_blog_tag
    76.         VALUES (#{blogId}, #{blogTagId});
    77.     </insert>
    78.     <delete id="deleteBlog_tag" parameterType="int">
    79.         DELETE
    80.         FROM blog_blog_tag
    81.         WHERE blogId = #{blogId}
    82.           and blogTagId = #{blogTagId})
    83.     </delete>
    84.     <delete id="deleteBlog_tagByBlogId" parameterType="int">
    85.         DELETE
    86.         FROM blog_blog_tag
    87.         WHERE blogId = #{blogId}
    88.     </delete>
    89.  
    90.     <select id="findTagByBlogId" resultType="jkw.pojo.BlogTag" parameterType="int">
    91.         select blog_tag.*
    92.         from blog_tag
    93.                  left join blog_blog_tag
    94.                            on blog_blog_tag.blogTagId = blog_tag.blogTagId
    95.         where blog_blog_tag.blogId = #{blogId}
    96.     </select>
    97.  
    98.     <delete id="deleteAllComments" parameterType="int">
    99.         DELETE
    100.         FROM blog_comment
    101.         WHERE blogId = #{blogId}
    102.     </delete>
    103.  
    104.     <select id="findById" parameterType="int" resultMap="blogMapper">
    105.         SELECT *
    106.         FROM blog
    107.                  LEFT JOIN user
    108.                            ON blog.userId = user.userId
    109.                  LEFT JOIN blog_type
    110.                            ON blog.blogTypeId = blog_type.blogTypeId
    111.                  LEFT JOIN blog_visibility
    112.                            ON blog.blogVisibilityId = blog_visibility.blogVisibilityId
    113.                  LEFT JOIN blog_blog_tag
    114.                            ON blog.blogId = blog_blog_tag.blogId
    115.                  LEFT JOIN blog_tag
    116.                            ON blog_blog_tag.blogTagId = blog_tag.blogTagId
    117.                  LEFT JOIN blog_blog_column
    118.                            ON blog.blogId = blog_blog_column.blogId
    119.                  LEFT JOIN blog_column
    120.                            ON blog_column.blogColumnId = blog_blog_column.blogColumnId
    121.         WHERE blog.blogId = #{blogId}
    122.     </select>
    123.  
    124.     <select id="search" resultMap="blogMapper">
    125.         SELECT *
    126.         FROM blog
    127.                  LEFT JOIN user
    128.                            ON blog.userId = user.userId
    129.                  LEFT JOIN blog_type
    130.                            ON blog.blogTypeId = blog_type.blogTypeId
    131.                  LEFT JOIN blog_visibility
    132.                            ON blog.blogVisibilityId = blog_visibility.blogVisibilityId
    133.                  LEFT JOIN blog_blog_tag
    134.                            ON blog.blogId = blog_blog_tag.blogId
    135.                  LEFT JOIN blog_tag
    136.                            ON blog_blog_tag.blogTagId = blog_tag.blogTagId
    137.                  LEFT JOIN blog_blog_column
    138.                            ON blog.blogId = blog_blog_column.blogId
    139.                  LEFT JOIN blog_column
    140.                            ON blog_column.blogColumnId = blog_blog_column.blogColumnId
    141.             ${ew.customSqlSegment}
    142.         ORDER BY blog.blogId desc
    143.     </select>
    144.  
    145.     <select id="searchWhenStatus" resultMap="blogMapper">
    146.         SELECT *
    147.         FROM blog
    148.                  LEFT JOIN user
    149.                            ON blog.userId = user.userId
    150.                  LEFT JOIN blog_type
    151.                            ON blog.blogTypeId = blog_type.blogTypeId
    152.                  LEFT JOIN blog_visibility
    153.                            ON blog.blogVisibilityId = blog_visibility.blogVisibilityId
    154.                  LEFT JOIN blog_blog_tag
    155.                            ON blog.blogId = blog_blog_tag.blogId
    156.                  LEFT JOIN blog_tag
    157.                            ON blog_blog_tag.blogTagId = blog_tag.blogTagId
    158.                  LEFT JOIN blog_blog_column
    159.                            ON blog.blogId = blog_blog_column.blogId
    160.                  LEFT JOIN blog_column
    161.                            ON blog_column.blogColumnId = blog_blog_column.blogColumnId ${ew.customSqlSegment} and blog.blogStatus=1
    162.         ORDER BY blog.blogId desc
    163.     </select>
    164.  
    165.  
    166. </mapper>

    BlogTagMapper

    1. public interface BlogTagMapper extends BaseMapper<BlogTag> {
    2.     //根据标签id删除博客_标签关联表的数据
    3.     void deleteBlog_tagByBlogTagId(Integer blogTagId);
    4. }

    BlogTagMapper.xml

    1. "1.0" encoding="UTF-8"?>
    2. mapper
    3.         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
    4.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    5. <mapper namespace="jkw.mapper.BlogTagMapper">
    6.  
    7.     <delete id="deleteBlog_tagByBlogTagId" parameterType="int">
    8.         DELETE
    9.         FROM blog_blog_tag
    10.         WHERE blogTagId = #{blogTagId}
    11.     delete>
    12.  
    13.  
    14. mapper>

    BlogTypeMapper

    1. public interface BlogTypeMapper extends BaseMapper<BlogType> {
    2. }

    BlogVisibilityMapper

    1. public interface BlogVisibilityMapper extends BaseMapper<BlogVisibility> {
    2. }

    服务层接口

    BlogColumnService

    1. public interface BlogColumnService {
    2.     void add(BlogColumn blogColumn);
    3.  
    4.     void update(BlogColumn blogColumn);
    5.  
    6.     void delete(Integer id);
    7.  
    8.     BlogColumn findById(Integer id);
    9.  
    10.     List<BlogColumn> findAll();
    11.  
    12.     Page<BlogColumn> search(String search, int page, int size);
    13.  
    14.     //根据用户id分页查询专栏
    15.     Page<BlogColumn> searchByUserId(Integer userId, int page, int size);
    16. }

    BlogCommentService

    1. public interface BlogCommentService {
    2.     void add(BlogComment blogComment);
    3.  
    4.     void update(BlogComment blogComment);
    5.  
    6.     void delete(Integer id);
    7.  
    8.     BlogComment findById(Integer id);
    9.  
    10.     List<BlogComment> findAll();
    11.  
    12.     Page<BlogComment> search(String search, int page, int size);
    13.  
    14.     //根据博客id分页查询
    15.     Page<BlogComment> searchByBlogId(Integer blogId, int page, int size);
    16. }

    BlogService

    1. public interface BlogService {
    2.     void add(Blog blog);
    3.  
    4.     void update(Blog blog);
    5.  
    6.     void delete(Integer id);
    7.  
    8.     Blog findById(Integer id);
    9.  
    10.     List<Blog> findAll();
    11.  
    12.     Page<Blog> search(String search, int page, int size);
    13.  
    14.     //分页查询状态为发布的博客
    15.     Page<Blog> searchForStatus(String search, int page, int size);
    16.  
    17.     //更新博客状态
    18.     void updateStatus(Integer id);
    19.  
    20.     //根据用户名分页查找博客文章
    21.     Page<Blog> searchByUserId(Integer userId, int page, int size);
    22.  
    23.     //添加博客_专栏中间表的数据
    24.     void addBlog_column(Integer blogId, Integer blogColumnId);
    25.  
    26.     //删除博客_专栏中间表的数据
    27.     void deleteBlog_column(Integer blogId, Integer blogColumnId);
    28.  
    29.     //根据博客id查询博客_专栏中间表的专栏数据
    30.     List<BlogColumn> findColumnByBlogId(Integer blogId);
    31.  
    32.     //添加博客_标签中间表的数据
    33.     void addBlog_tag(Integer blogId, Integer blogTagId);
    34.  
    35.     //删除博客_标签中间表的数据
    36.     void deleteBlog_tag(Integer blogId, Integer blogTagId);
    37.  
    38.     //根据博客id查询博客_标签中间表的标签数据
    39.     List<BlogTag> findTagByBlogId(Integer blogId);
    40. }

    BlogTagService

    1. public interface BlogTagService {
    2.     void add(BlogTag blogTag);
    3.  
    4.     void update(BlogTag blogTag);
    5.  
    6.     void delete(Integer id);
    7.  
    8.     BlogTag findById(Integer id);
    9.  
    10.     List findAll();
    11.  
    12.     Page search(String search, int page, int size);
    13. }

    BlogTypeService

    1. public interface BlogTypeService {
    2.     void add(BlogType blogType);
    3.  
    4.     void update(BlogType blogType);
    5.  
    6.     void delete(Integer id);
    7.  
    8.     BlogType findById(Integer id);
    9.  
    10.     List findAll();
    11.  
    12.     Page search(String search, int page, int size);
    13. }

    BlogVisibilityService

    1. public interface BlogVisibilityService {
    2.     void add(BlogVisibility blogVisibility);
    3.  
    4.     void update(BlogVisibility blogVisibility);
    5.  
    6.     void delete(Integer id);
    7.  
    8.     BlogVisibility findById(Integer id);
    9.  
    10.     List findAll();
    11.  
    12.     Page search(String search, int page, int size);
    13. }

    服务层实现

    BlogColumnServiceImpl

    1. @Service
    2. @Transactional
    3. public class BlogColumnServiceImpl implements BlogColumnService {
    4.     @Autowired
    5.     private BlogColumnMapper blogColumnMapper;
    6.  
    7.     @Override
    8.     public void add(BlogColumn blogColumn) {
    9.         blogColumnMapper.insert(blogColumn);
    10.     }
    11.  
    12.     @Override
    13.     public void update(BlogColumn blogColumn) {
    14.         blogColumnMapper.updateById(blogColumn);
    15.     }
    16.  
    17.     @Override
    18.     public void delete(Integer id) {
    19.         //删除博客_专栏关联表的数据
    20.         blogColumnMapper.deleteBlog_columnByBlogColumnId(id);
    21.         //删除关联表的数据
    22.         blogColumnMapper.deleteById(id);
    23.     }
    24.  
    25.     @Override
    26.     public BlogColumn findById(Integer id) {
    27.         return blogColumnMapper.selectById(id);
    28.     }
    29.  
    30.     @Override
    31.     public List<BlogColumn> findAll() {
    32.         return blogColumnMapper.selectList(null);
    33.     }
    34.  
    35.     @Override
    36.     public Page<BlogColumn> search(String search, int page, int size) {
    37.         QueryWrapper queryWrapper = new QueryWrapper();
    38.         if (search != null) {
    39.  
    40.         }
    41.         return blogColumnMapper.selectPage(new Page<>(page, size), queryWrapper);
    42.     }
    43.  
    44.     @Override
    45.     public Page<BlogColumn> searchByUserId(Integer userId, int page, int size) {
    46.         QueryWrapper queryWrapper = new QueryWrapper();
    47.         queryWrapper.eq("userId", userId);
    48.         return blogColumnMapper.selectPage(new Page<>(page, size), queryWrapper);
    49.     }
    50. }

    BlogCommentServiceImpl

    1. @Service
    2. @Transactional
    3. public class BlogCommentServiceImpl implements BlogCommentService {
    4.     @Autowired
    5.     private BlogCommentMapper blogCommentMapper;
    6.  
    7.     @Override
    8.     public void add(BlogComment blogComment) {
    9.         blogCommentMapper.insert(blogComment);
    10.     }
    11.  
    12.     @Override
    13.     public void update(BlogComment blogComment) {
    14.         blogCommentMapper.updateById(blogComment);
    15.     }
    16.  
    17.     @Override
    18.     public void delete(Integer id) {
    19.         blogCommentMapper.deleteById(id);
    20.     }
    21.  
    22.     @Override
    23.     public BlogComment findById(Integer id) {
    24.         return blogCommentMapper.selectById(id);
    25.     }
    26.  
    27.     @Override
    28.     public List<BlogComment> findAll() {
    29.         return blogCommentMapper.selectList(null);
    30.     }
    31.  
    32.     @Override
    33.     public Page<BlogComment> search(String search, int page, int size) {
    34.         QueryWrapper queryWrapper = new QueryWrapper();
    35.         if (search != null) {
    36.  
    37.         }
    38.         return blogCommentMapper.selectPage(new Page<>(page, size), queryWrapper);
    39.     }
    40.  
    41.     @Override
    42.     public Page<BlogComment> searchByBlogId(Integer blogId, int page, int size) {
    43.         QueryWrapper queryWrapper = new QueryWrapper();
    44.         queryWrapper.eq("blogId", blogId);
    45.         return blogCommentMapper.selectPage(new Page<>(page, size), queryWrapper);
    46.     }
    47. }

    BlogServiceImpl

    1. @Service
    2. @Transactional
    3. public class BlogServiceImpl implements BlogService {
    4.     @Autowired
    5.     private BlogMapper blogMapper;
    6.  
    7.     @Override
    8.     public void add(Blog blog) {
    9.         blogMapper.insert(blog);
    10.     }
    11.  
    12.     @Override
    13.     public void update(Blog blog) {
    14.         blogMapper.updateById(blog);
    15.     }
    16.  
    17.     @Override
    18.     public void delete(Integer id) {
    19.         //删除博客_专栏中间表的数据
    20.         blogMapper.deleteBlog_columnByBlogId(id);
    21.         //删除博客_标签中间表的数据
    22.         blogMapper.deleteBlog_tagByBlogId(id);
    23.         //删除博客对应的所有评论
    24.         blogMapper.deleteAllComments(id);
    25.         blogMapper.deleteById(id);
    26.     }
    27.  
    28.     @Override
    29.     public Blog findById(Integer id) {
    30.         return blogMapper.findById(id);
    31.     }
    32.  
    33.     @Override
    34.     public List<Blog> findAll() {
    35.         return blogMapper.selectList(null);
    36.     }
    37.  
    38.     @Override
    39.     public Page<Blog> search(String search, int page, int size) {
    40.         QueryWrapper<Blog> queryWrapper = new QueryWrapper();
    41.         if (search != null) {
    42.             queryWrapper.like("blogTitle", search);
    43.         }
    44.         return blogMapper.search(new Page<>(page, size), queryWrapper);
    45.     }
    46.  
    47.     @Override
    48.     public Page<Blog> searchForStatus(String search, int page, int size) {
    49.         QueryWrapper queryWrapper = new QueryWrapper();
    50.         if (search != null) {
    51.  
    52.         }
    53.         return blogMapper.searchWhenStatus(new Page<>(page, size), queryWrapper);
    54.     }
    55.  
    56.  
    57.     @Override
    58.     public Page<Blog> searchByUserId(Integer userId, int page, int size) {
    59.         QueryWrapper queryWrapper = new QueryWrapper();
    60.         queryWrapper.eq("userId", userId);
    61.         return blogMapper.search(new Page<>(page, size), queryWrapper);
    62.     }
    63.  
    64.     @Override
    65.     public void updateStatus(Integer id) {
    66.         Blog blog = blogMapper.selectById(id);
    67.         if (blog.getBlogStatus().equals("1")) {
    68.             blog.setBlogStatus("0");
    69.             blogMapper.updateById(blog);
    70.         } else {
    71.             blog.setBlogStatus("1");
    72.             blogMapper.updateById(blog);
    73.         }
    74.     }
    75.  
    76.     @Override
    77.     public void addBlog_column(Integer blogId, Integer blogColumnId) {
    78.         blogMapper.addBlog_column(blogId, blogColumnId);
    79.     }
    80.  
    81.     @Override
    82.     public void deleteBlog_column(Integer blogId, Integer blogColumnId) {
    83.         blogMapper.deleteBlog_column(blogId, blogColumnId);
    84.     }
    85.  
    86.     @Override
    87.     public List<BlogColumn> findColumnByBlogId(Integer blogId) {
    88.         return blogMapper.findColumnByBlogId(blogId);
    89.     }
    90.  
    91.     @Override
    92.     public void addBlog_tag(Integer blogId, Integer blogTagId) {
    93.         blogMapper.addBlog_tag(blogId, blogTagId);
    94.     }
    95.  
    96.     @Override
    97.     public void deleteBlog_tag(Integer blogId, Integer blogTagId) {
    98.         blogMapper.deleteBlog_tag(blogId, blogTagId);
    99.     }
    100.  
    101.     @Override
    102.     public List<BlogTag> findTagByBlogId(Integer blogId) {
    103.         return blogMapper.findTagByBlogId(blogId);
    104.     }
    105. }

    BlogTagServiceImpl

    1. @Service
    2. @Transactional
    3. public class BlogTagServiceImpl implements BlogTagService {
    4.     @Autowired
    5.     private BlogTagMapper blogTagMapper;
    6.  
    7.     @Override
    8.     public void add(BlogTag blogTag) {
    9.         blogTagMapper.insert(blogTag);
    10.     }
    11.  
    12.     @Override
    13.     public void update(BlogTag blogTag) {
    14.         blogTagMapper.updateById(blogTag);
    15.     }
    16.  
    17.     @Override
    18.     public void delete(Integer id) {
    19.         //删除博客_标签关联表的数据
    20.         blogTagMapper.deleteBlog_tagByBlogTagId(id);
    21.         //删除标签
    22.         blogTagMapper.deleteById(id);
    23.     }
    24.  
    25.     @Override
    26.     public BlogTag findById(Integer id) {
    27.        return blogTagMapper.selectById(id);
    28.     }
    29.  
    30.     @Override
    31.     public List<BlogTag> findAll() {
    32.         return blogTagMapper.selectList(null);
    33.     }
    34.  
    35.     @Override
    36.     public Page<BlogTag> search(String search, int page, int size) {
    37.         QueryWrapper queryWrapper = new QueryWrapper();
    38.         if (search != null) {
    39.  
    40.         }
    41.         return blogTagMapper.selectPage(new Page<>(page, size), queryWrapper);
    42.     }
    43. }

    BlogTypeServiceImpl

    1. @Service
    2. @Transactional
    3. public class BlogTypeServiceImpl implements BlogTypeService {
    4.     @Autowired
    5.     private BlogTypeMapper blogTypeMapper;
    6.  
    7.     @Override
    8.     public void add(BlogType blogType) {
    9.         blogTypeMapper.insert(blogType);
    10.     }
    11.  
    12.     @Override
    13.     public void update(BlogType blogType) {
    14.         blogTypeMapper.updateById(blogType);
    15.     }
    16.  
    17.     @Override
    18.     public void delete(Integer id) {
    19.         blogTypeMapper.deleteById(id);
    20.     }
    21.  
    22.     @Override
    23.     public BlogType findById(Integer id) {
    24.        return blogTypeMapper.selectById(id);
    25.     }
    26.  
    27.     @Override
    28.     public List<BlogType> findAll() {
    29.         return blogTypeMapper.selectList(null);
    30.     }
    31.  
    32.     @Override
    33.     public Page<BlogType> search(String search, int page, int size) {
    34.         QueryWrapper queryWrapper = new QueryWrapper();
    35.         if (search != null) {
    36.  
    37.         }
    38.         return blogTypeMapper.selectPage(new Page<>(page, size), queryWrapper);
    39.     }
    40. }

    BlogVisibilityServiceImpl

    1. @Service
    2. @Transactional
    3. public class BlogVisibilityServiceImpl implements BlogVisibilityService {
    4.     @Autowired
    5.     private BlogVisibilityMapper blogVisibilityMapper;
    6.  
    7.     @Override
    8.     public void add(BlogVisibility blogVisibility) {
    9.         blogVisibilityMapper.insert(blogVisibility);
    10.     }
    11.  
    12.     @Override
    13.     public void update(BlogVisibility blogVisibility) {
    14.         blogVisibilityMapper.updateById(blogVisibility);
    15.     }
    16.  
    17.     @Override
    18.     public void delete(Integer id) {
    19.         blogVisibilityMapper.deleteById(id);
    20.     }
    21.  
    22.     @Override
    23.     public BlogVisibility findById(Integer id) {
    24.         return blogVisibilityMapper.selectById(id);
    25.     }
    26.  
    27.     @Override
    28.     public List<BlogVisibility> findAll() {
    29.         return blogVisibilityMapper.selectList(null);
    30.     }
    31.  
    32.     @Override
    33.     public Page<BlogVisibility> search(String search, int page, int size) {
    34.         QueryWrapper<BlogVisibility> queryWrapper = new QueryWrapper();
    35.         if (search != null) {
    36.  
    37.         }
    38.         return blogVisibilityMapper.selectPage(new Page<>(page, size), queryWrapper);
    39.     }
    40. }

    后台控制层接口

    BlogColumnCon

    1. @CrossOrigin
    2. @RequestMapping("/back/blogColumn")
    3. @RestController
    4. public class BlogColumnCon {
    5.  
    6.     @Autowired
    7.     private BlogColumnService blogColumnService;
    8.  
    9.     /**
    10.      * 新增
    11.      *
    12.      * @param blogColumn
    13.      * @return
    14.      */
    15.     @PostMapping("/add")
    16.     public BaseResult add(BlogColumn blogColumn) {
    17.         blogColumnService.add(blogColumn);
    18.         return BaseResult.ok();
    19.     }
    20.  
    21.     /**
    22.      * 修改
    23.      *
    24.      * @param blogColumn
    25.      * @return
    26.      */
    27.     @PostMapping("/update")
    28.     public BaseResult update(BlogColumn blogColumn) {
    29.         blogColumnService.update(blogColumn);
    30.         return BaseResult.ok();
    31.     }
    32.  
    33.     /**
    34.      * 删除
    35.      *
    36.      * @param blogColumnId
    37.      * @return
    38.      */
    39.     @DeleteMapping("/delete")
    40.     public BaseResult delete(Integer blogColumnId) {
    41.         blogColumnService.delete(blogColumnId);
    42.         return BaseResult.ok();
    43.     }
    44.  
    45.     /**
    46.      * 根据id查询
    47.      *
    48.      * @param blogColumnId
    49.      * @return
    50.      */
    51.     @GetMapping("/findById")
    52.     public BaseResult findById(Integer blogColumnId) {
    53.         BlogColumn blogColumn = blogColumnService.findById(blogColumnId);
    54.         return BaseResult.ok(blogColumn);
    55.     }
    56.  
    57.     /**
    58.      * 查询所有
    59.      *
    60.      * @return
    61.      */
    62.     @GetMapping("/findAll")
    63.     public BaseResult findAll() {
    64.         List<BlogColumn> all = blogColumnService.findAll();
    65.         return BaseResult.ok(all);
    66.     }
    67.  
    68.     /**
    69.      * 分页查询
    70.      *
    71.      * @param page
    72.      * @param size
    73.      * @return
    74.      */
    75.  
    76.     @GetMapping("/search")
    77.     public BaseResult search(String search, int page, int size) {
    78.         Page<BlogColumn> brandPage = blogColumnService.search(search, page, size);
    79.         return BaseResult.ok(brandPage);
    80.     }
    81.  
    82.     /**
    83.      * 根据用户id分页查询
    84.      *
    85.      * @param page
    86.      * @param size
    87.      * @return
    88.      */
    89.  
    90.     @GetMapping("/searchByUserId")
    91.     public BaseResult search(Integer userId, int page, int size) {
    92.         Page<BlogColumn> brandPage = blogColumnService.searchByUserId(userId, page, size);
    93.         return BaseResult.ok(brandPage);
    94.     }
    95. }

    BlogCommentCon

    1. @CrossOrigin
    2. @RequestMapping("/back/blogComment")
    3. @RestController
    4. public class BlogCommentCon {
    5.  
    6.     @Autowired
    7.     private BlogCommentService blogCommentService;
    8.  
    9.     /**
    10.      * 新增
    11.      *
    12.      * @param blogComment
    13.      * @return
    14.      */
    15.     @PostMapping("/add")
    16.     public BaseResult add(BlogComment blogComment) {
    17.         blogCommentService.add(blogComment);
    18.         return BaseResult.ok();
    19.     }
    20.  
    21.     /**
    22.      * 修改
    23.      *
    24.      * @param blogComment
    25.      * @return
    26.      */
    27.     @PostMapping("/update")
    28.     public BaseResult update(BlogComment blogComment) {
    29.         blogCommentService.update(blogComment);
    30.         return BaseResult.ok();
    31.     }
    32.  
    33.     /**
    34.      * 删除
    35.      *
    36.      * @param blogCommentId
    37.      * @return
    38.      */
    39.     @DeleteMapping("/delete")
    40.     public BaseResult delete(Integer blogCommentId) {
    41.         blogCommentService.delete(blogCommentId);
    42.         return BaseResult.ok();
    43.     }
    44.  
    45.     /**
    46.      * 根据id查询
    47.      *
    48.      * @param blogCommentId
    49.      * @return
    50.      */
    51.     @GetMapping("/findById")
    52.     public BaseResult findById(Integer blogCommentId) {
    53.         BlogComment blogComment = blogCommentService.findById(blogCommentId);
    54.         return BaseResult.ok(blogComment);
    55.     }
    56.  
    57.     /**
    58.      * 查询所有
    59.      *
    60.      * @return
    61.      */
    62.     @GetMapping("/findAll")
    63.     public BaseResult findAll() {
    64.         List<BlogComment> all = blogCommentService.findAll();
    65.         return BaseResult.ok(all);
    66.     }
    67.  
    68.     /**
    69.      * 分页查询
    70.      *
    71.      * @param page
    72.      * @param size
    73.      * @return
    74.      */
    75.  
    76.     @GetMapping("/search")
    77.     public BaseResult search(String search, int page, int size) {
    78.         Page<BlogComment> brandPage = blogCommentService.search(search, page, size);
    79.         return BaseResult.ok(brandPage);
    80.     }
    81.  
    82.     /**
    83.      * 根据博客id分页查询
    84.      *
    85.      * @param page
    86.      * @param size
    87.      * @return
    88.      */
    89.     @GetMapping("/searchByBlogId")
    90.     public BaseResult searchByBlogId(Integer blogId, int page, int size) {
    91.         Page<BlogComment> brandPage = blogCommentService.searchByBlogId(blogId, page, size);
    92.         return BaseResult.ok(brandPage);
    93.     }
    94. }

    BlogCon

    1. package jkw.controller.back;
    2.  
    3. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
    4. import jkw.pojo.Blog;
    5. import jkw.pojo.BlogColumn;
    6. import jkw.pojo.BlogTag;
    7. import jkw.service.BlogService;
    8. import jkw.vo.BaseResult;
    9. import org.springframework.beans.factory.annotation.Autowired;
    10. import org.springframework.web.bind.annotation.*;
    11.  
    12. import java.util.List;
    13.  
    14. @CrossOrigin
    15. @RequestMapping("/back/blog")
    16. @RestController
    17. public class BlogCon {
    18.     @Autowired
    19.     private BlogService blogService;
    20.  
    21.     /**
    22.      * 新增
    23.      *
    24.      * @param blog
    25.      * @return
    26.      */
    27.     @PostMapping("/add")
    28.     public BaseResult add(Blog blog) {
    29.         blogService.add(blog);
    30.         return BaseResult.ok();
    31.     }
    32.  
    33.     /**
    34.      * 修改
    35.      *
    36.      * @param blog
    37.      * @return
    38.      */
    39.     @PostMapping("/update")
    40.     public BaseResult update(Blog blog) {
    41.         blogService.update(blog);
    42.         return BaseResult.ok();
    43.     }
    44.  
    45.     /**
    46.      * 删除
    47.      *
    48.      * @param blogId
    49.      * @return
    50.      */
    51.     @DeleteMapping("/delete")
    52.     public BaseResult delete(Integer blogId) {
    53.         blogService.delete(blogId);
    54.         return BaseResult.ok();
    55.     }
    56.  
    57.     /**
    58.      * 根据id查询
    59.      *
    60.      * @param blogId
    61.      * @return
    62.      */
    63.     @GetMapping("/findById")
    64.     public BaseResult findById(Integer blogId) {
    65.         Blog blog = blogService.findById(blogId);
    66.         return BaseResult.ok(blog);
    67.     }
    68.  
    69.     /**
    70.      * 查询所有
    71.      *
    72.      * @return
    73.      */
    74.     @GetMapping("/findAll")
    75.     public BaseResult findAll() {
    76.         List<Blog> all = blogService.findAll();
    77.         return BaseResult.ok(all);
    78.     }
    79.  
    80.     /**
    81.      * 分页查询
    82.      *
    83.      * @param page
    84.      * @param size
    85.      * @return
    86.      */
    87.  
    88.     @GetMapping("/search")
    89.     public BaseResult search(String search, int page, int size) {
    90.         Page<Blog> brandPage = blogService.search(search, page, size);
    91.         return BaseResult.ok(brandPage);
    92.     }
    93.  
    94.     /**
    95.      * 根据用户名分页查找博客文章
    96.      *
    97.      * @param page
    98.      * @param size
    99.      * @return
    100.      */
    101.  
    102.     @GetMapping("/searchByUserId")
    103.     public BaseResult search(Integer userId, int page, int size) {
    104.         Page<Blog> brandPage = blogService.searchByUserId(userId, page, size);
    105.         return BaseResult.ok(brandPage);
    106.     }
    107.  
    108.  
    109.     /**
    110.      * 更新博客状态
    111.      *
    112.      * @param blogId
    113.      * @return
    114.      */
    115.     @PostMapping("/updateStatus")
    116.     public BaseResult update(Integer blogId) {
    117.         blogService.updateStatus(blogId);
    118.         return BaseResult.ok();
    119.     }
    120.  
    121.     /**
    122.      * 添加博客_专栏中间表的数据
    123.      *
    124.      * @param blogId       博客id
    125.      * @param blogColumnId 专栏id
    126.      * @return
    127.      */
    128.     @PostMapping("/addColumn")
    129.     public BaseResult addColumn(Integer blogId, Integer blogColumnId) {
    130.         blogService.addBlog_column(blogId, blogColumnId);
    131.         return BaseResult.ok();
    132.     }
    133.  
    134.     /**
    135.      * 删除博客_专栏中间表的数据
    136.      *
    137.      * @param blogId       博客id
    138.      * @param blogColumnId 专栏id
    139.      * @return
    140.      */
    141.     @DeleteMapping("/deleteColumn")
    142.     public BaseResult deleteColumn(Integer blogId, Integer blogColumnId) {
    143.         blogService.deleteBlog_column(blogId, blogColumnId);
    144.         return BaseResult.ok();
    145.     }
    146.  
    147.     /**
    148.      * 根据博客id查询博客_专栏中间表的专栏数据
    149.      *
    150.      * @param blogId
    151.      * @return
    152.      */
    153.     @GetMapping("/findColumnByBlogId")
    154.     public BaseResult findColumnByBlogId(Integer blogId) {
    155.         List<BlogColumn> blogColumnList = blogService.findColumnByBlogId(blogId);
    156.         return BaseResult.ok(blogColumnList);
    157.     }
    158.  
    159.     /**
    160.      * 添加博客_标签中间表的数据
    161.      *
    162.      * @param blogId    博客id
    163.      * @param blogTagId 标签id
    164.      * @return
    165.      */
    166.     @PostMapping("/addTag")
    167.     public BaseResult addTag(Integer blogId, Integer blogTagId) {
    168.         blogService.addBlog_tag(blogId, blogTagId);
    169.         return BaseResult.ok();
    170.     }
    171.  
    172.     /**
    173.      * 删除博客_标签中间表的数据
    174.      *
    175.      * @param blogId    博客id
    176.      * @param blogTagId 标签id
    177.      * @return
    178.      */
    179.     @DeleteMapping("/deleteTag")
    180.     public BaseResult deleteTag(Integer blogId, Integer blogTagId) {
    181.         blogService.deleteBlog_tag(blogId, blogTagId);
    182.         return BaseResult.ok();
    183.     }
    184.  
    185.     /**
    186.      * 根据博客id查询博客_标签中间表的标签数据
    187.      *
    188.      * @param blogId
    189.      * @return
    190.      */
    191.     @GetMapping("/findTagByBlogId")
    192.     public BaseResult findTagByBlogId(Integer blogId) {
    193.         List<BlogTag> blogTagList = blogService.findTagByBlogId(blogId);
    194.         return BaseResult.ok(blogTagList);
    195.     }
    196.  
    197. }

    BlogTagCon

    1. @CrossOrigin
    2. @RequestMapping("/back/blogTag")
    3. @RestController
    4. public class BlogTagCon {
    5.  
    6.     @Autowired
    7.     private BlogTagService blogTagService;
    8.  
    9.     /**
    10.      * 新增
    11.      *
    12.      * @param blogTag
    13.      * @return
    14.      */
    15.     @PostMapping("/add")
    16.     public BaseResult add(BlogTag blogTag) {
    17.         blogTagService.add(blogTag);
    18.         return BaseResult.ok();
    19.     }
    20.  
    21.     /**
    22.      * 修改
    23.      *
    24.      * @param blogTag
    25.      * @return
    26.      */
    27.     @PostMapping("/update")
    28.     public BaseResult update(BlogTag blogTag) {
    29.         blogTagService.update(blogTag);
    30.         return BaseResult.ok();
    31.     }
    32.  
    33.     /**
    34.      * 删除
    35.      *
    36.      * @param blogTagId
    37.      * @return
    38.      */
    39.     @DeleteMapping("/delete")
    40.     public BaseResult delete(Integer blogTagId) {
    41.         blogTagService.delete(blogTagId);
    42.         return BaseResult.ok();
    43.     }
    44.  
    45.     /**
    46.      * 根据id查询
    47.      *
    48.      * @param blogTagId
    49.      * @return
    50.      */
    51.     @GetMapping("/findById")
    52.     public BaseResult findById(Integer blogTagId) {
    53.         BlogTag blogTag = blogTagService.findById(blogTagId);
    54.         return BaseResult.ok(blogTag);
    55.     }
    56.  
    57.     /**
    58.      * 查询所有
    59.      *
    60.      * @return
    61.      */
    62.     @GetMapping("/findAll")
    63.     public BaseResult findAll() {
    64.         List<BlogTag> all = blogTagService.findAll();
    65.         return BaseResult.ok(all);
    66.     }
    67.  
    68.     /**
    69.      * 分页查询
    70.      *
    71.      * @param page
    72.      * @param size
    73.      * @return
    74.      */
    75.  
    76.     @GetMapping("/search")
    77.     public BaseResult search(String search, int page, int size) {
    78.         Page<BlogTag> brandPage = blogTagService.search(search, page, size);
    79.         return BaseResult.ok(brandPage);
    80.     }
    81. }

    BlogTypeCon

    1. @CrossOrigin
    2. @RequestMapping("/back/blogType")
    3. @RestController
    4. public class BlogTypeCon {
    5.  
    6.     @Autowired
    7.     private BlogTypeService blogTypeService;
    8.  
    9.     /**
    10.      * 新增
    11.      *
    12.      * @param blogType
    13.      * @return
    14.      */
    15.     @PostMapping("/add")
    16.     public BaseResult add(BlogType blogType) {
    17.         blogTypeService.add(blogType);
    18.         return BaseResult.ok();
    19.     }
    20.  
    21.     /**
    22.      * 修改
    23.      *
    24.      * @param blogType
    25.      * @return
    26.      */
    27.     @PostMapping("/update")
    28.     public BaseResult update(BlogType blogType) {
    29.         blogTypeService.update(blogType);
    30.         return BaseResult.ok();
    31.     }
    32.  
    33.     /**
    34.      * 删除
    35.      *
    36.      * @param blogTypeId
    37.      * @return
    38.      */
    39.     @DeleteMapping("/delete")
    40.     public BaseResult delete(Integer blogTypeId) {
    41.         blogTypeService.delete(blogTypeId);
    42.         return BaseResult.ok();
    43.     }
    44.  
    45.     /**
    46.      * 根据id查询
    47.      *
    48.      * @param blogTypeId
    49.      * @return
    50.      */
    51.     @GetMapping("/findById")
    52.     public BaseResult findById(Integer blogTypeId) {
    53.         BlogType blogType = blogTypeService.findById(blogTypeId);
    54.         return BaseResult.ok(blogType);
    55.     }
    56.  
    57.     /**
    58.      * 查询所有
    59.      *
    60.      * @return
    61.      */
    62.     @GetMapping("/findAll")
    63.     public BaseResult findAll() {
    64.         List<BlogType> all = blogTypeService.findAll();
    65.         return BaseResult.ok(all);
    66.     }
    67.  
    68.     /**
    69.      * 分页查询
    70.      *
    71.      * @param page
    72.      * @param size
    73.      * @return
    74.      */
    75.  
    76.     @GetMapping("/search")
    77.     public BaseResult search(String search, int page, int size) {
    78.         Page<BlogType> brandPage = blogTypeService.search(search, page, size);
    79.         return BaseResult.ok(brandPage);
    80.     }
    81. }

    BlogVisibilityCon

    1. @CrossOrigin
    2. @RequestMapping("/back/blogVisibility")
    3. @RestController
    4. public class BlogVisibilityCon {
    5.  
    6.     @Autowired
    7.     private BlogVisibilityService blogVisibilityService;
    8.  
    9.     /**
    10.      * 新增
    11.      *
    12.      * @param blogVisibility
    13.      * @return
    14.      */
    15.     @PostMapping("/add")
    16.     public BaseResult add(BlogVisibility blogVisibility) {
    17.         blogVisibilityService.add(blogVisibility);
    18.         return BaseResult.ok();
    19.     }
    20.  
    21.     /**
    22.      * 修改
    23.      *
    24.      * @param blogVisibility
    25.      * @return
    26.      */
    27.     @PostMapping("/update")
    28.     public BaseResult update(BlogVisibility blogVisibility) {
    29.         blogVisibilityService.update(blogVisibility);
    30.         return BaseResult.ok();
    31.     }
    32.  
    33.     /**
    34.      * 删除
    35.      *
    36.      * @param blogVisibilityId
    37.      * @return
    38.      */
    39.     @DeleteMapping("/delete")
    40.     public BaseResult delete(Integer blogVisibilityId) {
    41.         blogVisibilityService.delete(blogVisibilityId);
    42.         return BaseResult.ok();
    43.     }
    44.  
    45.     /**
    46.      * 根据id查询
    47.      *
    48.      * @param blogVisibilityId
    49.      * @return
    50.      */
    51.     @GetMapping("/findById")
    52.     public BaseResult findById(Integer blogVisibilityId) {
    53.         BlogVisibility blogVisibility = blogVisibilityService.findById(blogVisibilityId);
    54.         return BaseResult.ok(blogVisibility);
    55.     }
    56.  
    57.     /**
    58.      * 查询所有
    59.      *
    60.      * @return
    61.      */
    62.     @GetMapping("/findAll")
    63.     public BaseResult findAll() {
    64.         List<BlogVisibility> all = blogVisibilityService.findAll();
    65.         return BaseResult.ok(all);
    66.     }
    67.  
    68.     /**
    69.      * 分页查询
    70.      *
    71.      * @param page
    72.      * @param size
    73.      * @return
    74.      */
    75.     @GetMapping("/search")
    76.     public BaseResult search(String search, int page, int size) {
    77.         Page<BlogVisibility> blogVisibilityPage = blogVisibilityService.search(search, page, size);
    78.         return BaseResult.ok(blogVisibilityPage);
    79.     }
    80. }

  • 相关阅读:
    基于 Bitbucket 的 CI/CD 在 Flutter 中的应用
    设计模式-适配器模式在Java中应用
    vue封装带确定、取消按钮的弹窗和提示组件，可用promise回调
    CNN卷积神经网络之卷积核及其实现示例
    Redis进阶：主从复制、集群搭建
    使用pyvista显示有透明度信息的点云数据
    Redis常用指令之string、list、set、zset、hash
    Day727.键值数据库的基本架构 -Redis 核心技术与实战
    Python基础之面向对象：3、继承与派生
    Spark 链接 Mongodb 报错：java.lang.NoSuchFieldError: UNSPECIFIED
  • 原文地址：https://blog.csdn.net/m0_63040701/article/details/133133827