src/main/resources/mybatis/blog/CategoryMapper.xml

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<?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="com.angelblog.project.system.blog.mapper.CategoryMapper">
    
    <resultMap type="Category" id="CategoryResult">
        <result property="categoryId"    column="category_id"    />
        <result property="categoryName"    column="category_name"    />
        <result property="parentId"    column="parent_id"    />
        <result property="ancestors"    column="ancestors"    />
        <result property="sort"    column="sort"    />
        <result property="description"    column="description"    />
        <result property="createTime"    column="create_time"    />
        <result property="updateTime"    column="update_time"    />
        <result property="createBy"    column="create_by"    />
        <result property="updateBy"    column="update_by"    />
        <result property="status"    column="status"    />
        <result property="delFlag"    column="del_flag"    />
        <result property="parentName" column="parent_name" />
    </resultMap>

    <resultMap id="rm" type="Category">
        <result property="categoryId"    column="category_id"    />
        <result property="categoryName"    column="category_name"    />
        <result property="parentId"    column="parent_id"    />
        <result property="ancestors"    column="ancestors"    />
        <result property="sort"    column="sort"    />
        <result property="description"    column="description"    />
        <result property="createTime"    column="create_time"    />
        <result property="updateTime"    column="update_time"    />
        <result property="createBy"    column="create_by"    />
        <result property="updateBy"    column="update_by"    />
        <result property="status"    column="status"    />
        <result property="delFlag"    column="del_flag"    />

        <association property="parent" javaType="Category">
            <result property="categoryId"  column="p_id"/>
            <result property="parentId"  column="p_pid"/>
            <result property="categoryName" column="p_name"/>
            <result property="description" column="p_description"/>
            <result property="status" column="p_status"/>
        </association>
        <collection property="nodes" column="n_id" javaType="ArrayList" ofType="Category">
            <result property="categoryId"  column="n_id"/>
            <result property="parentId"  column="n_pid"/>
            <result property="categoryName" column="n_name"/>
            <result property="description" column="n_description"/>
            <result property="status" column="n_status"/>
        </collection>
    </resultMap>

    <select id="selectNavCategories" parameterType="Category" resultMap="rm" >
        select t.*,
        p.category_id p_id,
                p.parent_id p_pid,
                p.`category_name` p_name,
                p.description p_description,
                p.`status` p_status,