数据固定单组的,使用封装类接收
@Override
public CourseInform getCourseInfoById(String courseId) {
CourseInform courseInform = new CourseInform();
EduCourse eduCourse = eduCourseMapper.selectById(courseId);
BeanUtils.copyProperties(eduCourse,courseInform);
EduCourseDescription desbuid = eduCourseDescriptionService.getById(courseId);
String des = desbuid.getDescription();
courseInform.setDescription(des);
return courseInform;
}
@Override
public void updateCourseInfoById(CourseInform courseInform) {
EduCourse eduCourse = new EduCourse();
//把前面复制给后面
BeanUtils.copyProperties(courseInform,eduCourse);
eduCourseMapper.updateById(eduCourse);
String description = courseInform.getDescription();
String id = courseInform.getId();
EduCourseDescription eduCourseDescription = new EduCourseDescription();
eduCourseDescription.setId(id);
eduCourseDescription.setDescription(description);
eduCourseDescriptionService.updateById(eduCourseDescription);
}
}
数据存在多组的,使用List《封装类》接收
@Override
public List<OneSubject> getAllOneTwoSubject() {
//查询所有一级分类 parent_id = 0
QueryWrapper<EduSubject> wrapperOne = new QueryWrapper();
wrapperOne.eq("parent_id","0");
List<EduSubject> oneSubjectsList = baseMapper.selectList(wrapperOne);
//查询所有二级分类 parent_id != 0
QueryWrapper<EduSubject> wrapperTwo = new QueryWrapper();
wrapperTwo.ne("parent_id","0");
List<EduSubject> twoSubjectsList = baseMapper.selectList(wrapperTwo);
//创建list集合,用于封装最终数据
List<OneSubject> finalSubjectList = new ArrayList<>();
//封装一级分类
//查询出来所有的一级分类list集合遍历,得到每个一级分类对象,获取每个一级分类对象值
//封装到要求的最终list集合中
for (int i = 0; i < oneSubjectsList.size(); i++) { //遍历oneSubjectList集合
//得到oneSubjectsList中每个eduSubject对象
EduSubject oSubject = oneSubjectsList.get(i);
//把eduSubject里面值获取出来,放到oneSubject对象中去
OneSubject oneSubject = new OneSubject();
// oneSubject.setId(eduSubject.getId());
// oneSubject.setTitle(eduSubject.getTitle());
//把eduSubject值复制到oneSubject中去【要求两个类的复制注入的属性名一致】
BeanUtils.copyProperties(oSubject,oneSubject);
//多个OneSubject放到finalSubjectList里面
finalSubjectList.add(oneSubject);
//在一级分类循环遍历查询所有的二级分类
//创建list集合封装每个一级分类的二级分类
ArrayList<TwoSubject> finalTwoSubjects = new ArrayList<>();
//遍历二级list集合
for (int j = 0; j < twoSubjectsList.size(); j++) {
//获取每个二级分类
EduSubject tSubject = twoSubjectsList.get(j);
//判断二级分类parentid和一级分类id是否一样
if (tSubject.getParentId().equals(oSubject.getId())){
//把tSubject值复制到TwoSubject,最终放在twoSubjectsList中
TwoSubject twoSubject = new TwoSubject();
BeanUtils.copyProperties(tSubject,twoSubject);
finalTwoSubjects.add(twoSubject);
}
}
//把一级下面所有二级分类放到oneSubject里面
oneSubject.setChildren(finalTwoSubjects);
。。。。。
————————————————
版权声明:本文为CSDN博主「阿昌喜欢吃黄桃」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/qq_43284469/article/details/114241033
@Override
public List<ChapterVo> getChapterVideoByCOurseId(String courseId) {
//最终要的数据列表
ArrayList<ChapterVo> finalChapterVos = new ArrayList<>();
//查询章节信息
QueryWrapper<EduChapter> wrapper = new QueryWrapper<>();
wrapper.eq("course_id",courseId);
List<EduChapter> eduChapters = baseMapper.selectList(wrapper);
//查询小节信息
QueryWrapper<EduVideo> wrapper1 = new QueryWrapper<>();
wrapper1.eq("course_id",courseId);
List<EduVideo> eduVideos = eduVideoService.list(wrapper1);
//填充章节vo数据
for (int i = 0; i < eduChapters.size(); i++) {
EduChapter chapter = eduChapters.get(i);
//创建章节vo对象
ChapterVo chapterVo = new ChapterVo();
BeanUtils.copyProperties(chapter,chapterVo);
finalChapterVos.add(chapterVo);
//填充课时vo对象
ArrayList<VideoVo> finalVideoVos = new ArrayList<>();
for (int j = 0; j < eduVideos.size(); j++) {
EduVideo video = eduVideos.get(j);
if (chapter.getId().equals(video.getChapterId())){
VideoVo videoVo = new VideoVo();
BeanUtils.copyProperties(video,videoVo);
finalVideoVos.add(videoVo);
}
}
chapterVo.setChildren(finalVideoVos);
}
return finalChapterVos;
}
}