博客系统mapper接口层编写

Mapper层编写

BlogColumnMapper

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

BlogColumnMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="jkw.mapper.BlogColumnMapper">

    <delete id="deleteBlog_columnByBlogColumnId" parameterType="int">
        DELETE
        FROM blog_blog_column
        WHERE blogColumnId = #{blogColumnId}
    </delete>


</mapper>

BlogCommentMapper

public interface BlogCommentMapper extends BaseMapper<BlogComment> {
}

BlogMapper

public interface BlogMapper extends BaseMapper<Blog> {
    //添加博客_专栏中间表的数据
    void addBlog_column(@Param("blogId") Integer blogId, @Param("blogColumnId") Integer blogColumnId);

    //删除博客_专栏中间表的数据
    void deleteBlog_column(@Param("blogId") Integer blogId, @Param("blogColumnId") Integer blogColumnId);

    //根据博客id删除博客_专栏中间表的数据
    void deleteBlog_columnByBlogId(Integer blogId);

    //根据博客id查询博客_专栏中间表的专栏数据
    List<BlogColumn> findColumnByBlogId(Integer blogId);

    //添加博客_标签中间表的数据
    void addBlog_tag(@Param("blogId") Integer blogId, @Param("blogTagId") Integer blogTagId);

    //删除博客_标签中间表的数据
    void deleteBlog_tag(@Param("blogId") Integer blogId, @Param("blogTagId") Integer blogTagId);

    //根据博客id删除博客_标签中间表的数据
    void deleteBlog_tagByBlogId(Integer blogId);

    //根据博客id查询博客_标签中间表的标签数据
    List<BlogTag> findTagByBlogId(Integer blogId);

    //删除博客对应的所有评论
    void deleteAllComments(Integer blogId);

    //根据id查询博客内容【封装数据】
    Blog findById(Integer blogId);

    //条件分页分页查询博客内容【封装数据】
    Page<Blog> search(Page<Blog> page, @Param(Constants.WRAPPER) Wrapper<Blog> wrapper);

    //条件分页分页查询博客内容【封装数据并且为发布状态】
    Page<Blog> searchWhenStatus(Page<Blog> page, @Param(Constants.WRAPPER) Wrapper<Blog> wrapper);

}

BlogMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="jkw.mapper.BlogMapper">
    <resultMap id="blogMapper" type="jkw.pojo.Blog">
        <id property="blogId" column="blogId"></id>
        <result property="blogTitle" column="blogTitle"></result>
        <result property="blogCoverImg" column="blogCoverImg"></result>
        <result property="blogSummary" column="blogSummary"></result>
        <result property="blogContent" column="blogContent"></result>
        <result property="blogCreateData" column="blogCreateData"></result>
        <result property="blogStatus" column="blogStatus"></result>
        <result property="blogShow" column="blogShow"></result>
        <result property="blogRead" column="blogRead"></result>
        <result property="blogLike" column="blogLike"></result>
        <result property="blogFavorite" column="blogFavorite"></result>
        <result property="userId" column="userId"></result>
        <result property="blogTypeId" column="blogTypeId"></result>
        <result property="blogVisibilityId" column="blogVisibilityId"></result>
        <result property="userId" column="userId"></result>
        <collection property="user" column="userId" ofType="jkw.pojo.User">
            <id property="userId" column="userId"></id>
            <result property="userImg" column="userImg"></result>
            <result property="nickname" column="nickname"></result>
            <result property="email" column="email"></result>
            <result property="username" column="username"></result>
            <result property="signature" column="signature"></result>
        </collection>
        <collection property="blogType" column="blogTypeId" ofType="jkw.pojo.BlogType">
            <id property="blogTypeId" column="blogTypeId"></id>
            <result property="blogTypeName" column="blogTypeName"></result>
        </collection>
        <collection property="blogVisibility" column="blogVisibilityId" ofType="jkw.pojo.BlogVisibility">
            <id property="blogVisibilityId" column="blogVisibilityId"></id>
            <result property="blogVisibilityName" column="blogVisibilityName"></result>
        </collection>
        <collection property="tags" column="blogId" ofType="jkw.pojo.BlogTag">
            <id property="blogTagId" column="blogTagId"></id>
            <result property="blogTagName" column="blogTagName"></result>
        </collection>
        <collection property="columns" column="blogId" ofType="jkw.pojo.BlogColumn">
            <id property="blogColumnId" column="blogColumnId"></id>
            <result property="blogColumnName" column="blogColumnName"></result>
            <result property="blogColumnCoverImg" column="blogColumnCoverImg"></result>
            <result property="blogColumnIntroduction" column="blogColumnIntroduction"></result>
            <result property="userId" column="userId"></result>
        </collection>
    </resultMap>
    <insert id="addBlog_column">
        INSERT INTO blog_blog_column
        VALUES (#{blogId}, #{blogColumnId});
    </insert>
    <delete id="deleteBlog_column" parameterType="int">
        DELETE
        FROM blog_blog_column
        WHERE blogId = #{blogId}
          and blogColumnId = #{blogColumnId});
    </delete>
    <delete id="deleteBlog_columnByBlogId" parameterType="int">
        DELETE
        FROM blog_blog_column
        WHERE blogId = #{blogId}
    </delete>

    <select id="findColumnByBlogId" resultType="jkw.pojo.BlogColumn" parameterType="int">
        select blog_column.*
        from blog_column
                 left join blog_blog_column
                           on blog_blog_column.blogColumnId = blog_column.blogColumnId
        where blog_blog_column.blogId = #{blogId}
    </select>

    <insert id="addBlog_tag">
        INSERT INTO blog_blog_tag
        VALUES (#{blogId}, #{blogTagId});
    </insert>
    <delete id="deleteBlog_tag" parameterType="int">
        DELETE
        FROM blog_blog_tag
        WHERE blogId = #{blogId}
          and blogTagId = #{blogTagId})
    </delete>
    <delete id="deleteBlog_tagByBlogId" parameterType="int">
        DELETE
        FROM blog_blog_tag
        WHERE blogId = #{blogId}
    </delete>

    <select id="findTagByBlogId" resultType="jkw.pojo.BlogTag" parameterType="int">
        select blog_tag.*
        from blog_tag
                 left join blog_blog_tag
                           on blog_blog_tag.blogTagId = blog_tag.blogTagId
        where blog_blog_tag.blogId = #{blogId}
    </select>

    <delete id="deleteAllComments" parameterType="int">
        DELETE
        FROM blog_comment
        WHERE blogId = #{blogId}
    </delete>

    <select id="findById" parameterType="int" resultMap="blogMapper">
        SELECT *
        FROM blog
                 LEFT JOIN user
                           ON blog.userId = user.userId
                 LEFT JOIN blog_type
                           ON blog.blogTypeId = blog_type.blogTypeId
                 LEFT JOIN blog_visibility
                           ON blog.blogVisibilityId = blog_visibility.blogVisibilityId
                 LEFT JOIN blog_blog_tag
                           ON blog.blogId = blog_blog_tag.blogId
                 LEFT JOIN blog_tag
                           ON blog_blog_tag.blogTagId = blog_tag.blogTagId
                 LEFT JOIN blog_blog_column
                           ON blog.blogId = blog_blog_column.blogId
                 LEFT JOIN blog_column
                           ON blog_column.blogColumnId = blog_blog_column.blogColumnId
        WHERE blog.blogId = #{blogId}
    </select>

    <select id="search" resultMap="blogMapper">
        SELECT *
        FROM blog
                 LEFT JOIN user
                           ON blog.userId = user.userId
                 LEFT JOIN blog_type
                           ON blog.blogTypeId = blog_type.blogTypeId
                 LEFT JOIN blog_visibility
                           ON blog.blogVisibilityId = blog_visibility.blogVisibilityId
                 LEFT JOIN blog_blog_tag
                           ON blog.blogId = blog_blog_tag.blogId
                 LEFT JOIN blog_tag
                           ON blog_blog_tag.blogTagId = blog_tag.blogTagId
                 LEFT JOIN blog_blog_column
                           ON blog.blogId = blog_blog_column.blogId
                 LEFT JOIN blog_column
                           ON blog_column.blogColumnId = blog_blog_column.blogColumnId
            ${ew.customSqlSegment}
        ORDER BY blog.blogId desc
    </select>

    <select id="searchWhenStatus" resultMap="blogMapper">
        SELECT *
        FROM blog
                 LEFT JOIN user
                           ON blog.userId = user.userId
                 LEFT JOIN blog_type
                           ON blog.blogTypeId = blog_type.blogTypeId
                 LEFT JOIN blog_visibility
                           ON blog.blogVisibilityId = blog_visibility.blogVisibilityId
                 LEFT JOIN blog_blog_tag
                           ON blog.blogId = blog_blog_tag.blogId
                 LEFT JOIN blog_tag
                           ON blog_blog_tag.blogTagId = blog_tag.blogTagId
                 LEFT JOIN blog_blog_column
                           ON blog.blogId = blog_blog_column.blogId
                 LEFT JOIN blog_column
                           ON blog_column.blogColumnId = blog_blog_column.blogColumnId ${ew.customSqlSegment} and blog.blogStatus=1
        ORDER BY blog.blogId desc
    </select>


</mapper>

BlogTagMapper

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

BlogTagMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="jkw.mapper.BlogTagMapper">

    <delete id="deleteBlog_tagByBlogTagId" parameterType="int">
        DELETE
        FROM blog_blog_tag
        WHERE blogTagId = #{blogTagId}
    </delete>


</mapper>

BlogTypeMapper

public interface BlogTypeMapper extends BaseMapper<BlogType> {
}

BlogVisibilityMapper

public interface BlogVisibilityMapper extends BaseMapper<BlogVisibility> {
}