课程分类列表后端实现

女爷i 2021-07-25 02:42 401阅读 0赞

# 一 创建vo #

@Data
    public class SubjectVo implements Serializable {
        private static final long serialVersionUID = 1L;
        /**
         * 课程分类id
         */
        private String id;
        /**
         * 标题
         */
        private String title;
        /**
         * 排序
         */
        private Integer sort;
        /**
         * 课程孩子节点
         */
        private List<SubjectVo> children = new ArrayList<>();
    }

# 二 控制器 #

/**
    * @className: SubjectController
    * @description: 课程分类列表
    * @date: 2020/12/2
    * @author: cakin
    */
    @ApiOperation("嵌套数据列表")
    @GetMapping("nested-list")
    public R nestedList() {
        List<SubjectVo> subjectVoList = subjectService.nestedList();
        return R.ok().data("items", subjectVoList);
    }

# 三 服务 #

## 1 接口 ##

/**
    * 功能描述：树形展示
    *
    * @author cakin
    * @date 2020/12/2
    * @return List<SubjectVo> 课程一级分类列表，包含嵌套关系
    */
    List<SubjectVo> nestedList();

## 2 实现 ##

/**
    * 功能描述：课程分类列表展示
    *
    * @author cakin
    * @date 2020/12/2
    * @return List<SubjectVo> 课程一级分类列表，包含嵌套关系
    */
    @Override
    public List<SubjectVo> nestedList() {
        return baseMapper.selectNestedListByParentId("0");
    }

# 四 创建mapper映射 #

## 1 mapper ##

/**
    * 功能描述：课程分类列表展示
    *
    * @author cakin
    * @date 2020/12/2
    * @return List<SubjectVo> 课程一级分类列表，包含嵌套关系
    */
    List<SubjectVo> selectNestedListByParentId(String parentId);

## 2 xml ##

<mapper namespace="com.atguigu.guli.service.edu.mapper.SubjectMapper">
        <resultMap id="nestedSubject" type="com.atguigu.guli.service.edu.entity.vo.SubjectVo">
            <id property="id" column="id" />
            <result property="title" column="title" />
            <result property="sort" column="sort" />
            <collection property="children"
                        column="id"
                        select="selectNestedListByParentId"
                        ofType="com.atguigu.guli.service.edu.entity.vo.SubjectVo" />
        </resultMap>
        <select id="selectNestedListByParentId" resultMap="nestedSubject">
            select id, sort, title from edu_subject where parent_id = #{parentId}
        </select>
    </mapper>

# 五 pom配置，解决打包问题 #

<build>
        
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.xml</include>
                </includes>
                <filtering>false</filtering>
            </resource>
        </resources>
    </build>

# 六 Swagger 测试 #

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5ncWl1bWluZw_size_16_color_FFFFFF_t_70][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5ncWl1bWluZw_size_16_color_FFFFFF_t_70]: /images/20210724/f3042eeda76f4dd994738a9f3a823cd8.png