简单记录一下在java的Mybatis-plus中用一个SQL语句查询一个嵌套的实体类(实体类中有List,List中还有List)

简单记录一下在java的Mybatis-plus中用一个SQL语句查询一个嵌套的实体类(实体类中有List,List中还有List)

也就是KpCourseInfoClientDetailVO课程详情类中含有List courseChapterList章节列表,然后章节列表中含有List lessonList课时列表,通过一个SQL查询得到结果

KpCourseInfoClientDetailVO类

@Data
public class KpCourseInfoClientDetailVO extends BaseEntity {
   
   

    /**
     * 主键ID
     */
    @ApiModelProperty(value = "主键ID",example = "1" , position = 1)
    private Long id;

    /**
     * 图片
     */
    @ApiModelProperty(value = "图片",example = "https://yq-0.obs.cn-east-3.myhuaweicloud.com/12351.bjzgh.org/image/20220824/1661320343049.png" , position = 5)
    private String pic;

    /**
     * 名称
     */
    @ApiModelProperty(value = "名称",example = "Java修仙手册" , position = 11)
    private String title;

    /**
     * 课时数量
     */
    @ApiModelProperty(value = "课时数量",example = "5" , position = 21)
    private Integer lessons;


    /**
     * 最近在学人数
     */
    @ApiModelProperty(value = "最近在学人数",example = "5" , position = 31)
    private Integer clicks;

    /**
     * 总学时
     */
    @ApiModelProperty(value = "总学时(秒)",example = "120" , position = 35)
    private Integer duration;

    /**
     * 已学时长
     */
    @ApiModelProperty(value = "已学时长(秒)",example = "60" , position = 37)
    private Integer studyDuration;