在controller.java中
package com.xyy.eduservice.controller;
import com.xyy.commonutils.R;
import com.xyy.eduservice.entity.vo.CourseInfoVo;
import com.xyy.eduservice.entity.vo.CoursePublishVo;
import com.xyy.eduservice.service.EduCourseService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
@RestController
@RequestMapping("/eduservice/course")
@CrossOrigin
public class EduCourseController {
@Autowired
private EduCourseService courseService;
//添加课程基本信息的方法
@PostMapping("addCourseInfo")
public R addCourseInfo(@RequestBody CourseInfoVo courseInfoVo) {
// // System.out.println("从前端传回来的courseInfoVo:" + courseInfoVo.getDescription());
// courseService.saveCourseInfo(courseInfoVo);
// return R.ok();
//返回添加之后课程id,为了后面添加大纲使用
String id = courseService.saveCourseInfo(courseInfoVo);
return R.ok().data("courseId",id);
}
//id查询课程信息
@GetMapping("getCourseInfo/{courseId}")
public R getCourseInfo(@PathVariable String courseId){
CourseInfoVo courseInfoVo = courseService.getCourseInfo(courseId);
return R.ok().data("courseInfoVo", courseInfoVo);
}
//更新秭归啊
@GetMapping("updateCourseInfo")
public R updateCourseInfo(@RequestBody CourseInfoVo courseInfoVo){
System.out.println("需要修改的课程的信息为 " + courseInfoVo.getTitle());
courseService.updateCourseInfo(courseInfoVo);
return R.ok();
}
//使用自定义的sql语句实现根绝课程id查询课程信息
@GetMapping("getPublishCourseInfo/{id}")
public R getPublishCourseInfo(@PathVariable String id){
CoursePublishVo coursePublishVo = courseService.publishCourseInfo(id);
return R.ok().data("publishCourse", coursePublishVo);
}
}
对应的service.java
package com.xyy.eduservice.service; import com.xyy.eduservice.entity.EduCourse; import com.baomidou.mybatisplus.extension.service.IService; import com.xyy.eduservice.entity.vo.CourseInfoVo; import com.xyy.eduservice.entity.vo.CoursePublishVo; public interface EduCourseService extends IService{ //添加课程信息基本信息 String saveCourseInfo(CourseInfoVo courseInfoVo); CourseInfoVo getCourseInfo(String courseId); void updateCourseInfo(CourseInfoVo courseInfoVo); CoursePublishVo publishCourseInfo(String id); }
对应的service实现类serviceImp.java
package com.xyy.eduservice.service.impl; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.xyy.eduservice.entity.EduCourse; import com.xyy.eduservice.entity.EduCourseDescription; import com.xyy.eduservice.entity.vo.CourseInfoVo; import com.xyy.eduservice.entity.vo.CoursePublishVo; import com.xyy.eduservice.mapper.EduCourseMapper; import com.xyy.eduservice.service.EduCourseDescriptionService; import com.xyy.eduservice.service.EduCourseService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.xyy.servicebase.exceptionHandler.GuliException; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; @Service public class EduCourseServiceImpl extends ServiceImplimplements EduCourseService { //课程描述注入 @Autowired private EduCourseDescriptionService courseDescriptionService; //添加课程基本信息的方法 @Override public String saveCourseInfo(CourseInfoVo courseInfoVo) { //1 向课程表添加课程基本信息 //CourseInfoVo对象转换eduCourse对象 EduCourse eduCourse = new EduCourse(); BeanUtils.copyProperties(courseInfoVo,eduCourse); // courseInfoVo.getSubjectId() System.out.println("eduCourse表中的subjectParentId is " + eduCourse.getSubjectParentId()); int insert = baseMapper.insert(eduCourse); if(insert == 0) { //添加失败 throw new GuliException(20001,"添加课程信息失败"); } //获取添加之后课程id String cid = eduCourse.getId(); //2 向课程简介表添加课程简介 //edu_course_description EduCourseDescription courseDescription = new EduCourseDescription(); courseDescription.setDescription(courseInfoVo.getDescription()); //设置描述id就是课程id courseDescription.setId(cid); courseDescriptionService.save(courseDescription); return cid; } @Override public CourseInfoVo getCourseInfo(String courseId) { CourseInfoVo courseInfoVo = new CourseInfoVo(); EduCourse eduCourse = baseMapper.selectById(courseId); BeanUtils.copyProperties(eduCourse, courseInfoVo); EduCourseDescription courseDescription = courseDescriptionService.getById(courseId); courseInfoVo.setDescription(courseDescription.getDescription()); return courseInfoVo; } @Override public void updateCourseInfo(CourseInfoVo courseInfoVo) { EduCourse eduCourse = new EduCourse(); BeanUtils.copyProperties(courseInfoVo, eduCourse); //更新课程表 int update = baseMapper.updateById(eduCourse); if(update == 0){ throw new GuliException(20001, "修改课程信息失败"); } EduCourseDescription description = new EduCourseDescription(); description.setDescription(courseInfoVo.getDescription()); description.setId(courseInfoVo.getId()); //更新课程描述表 courseDescriptionService.updateById(description); } //根据课程id查询课程确认信息 @Override public CoursePublishVo publishCourseInfo(String id) { //调用mapper,自己写的 CoursePublishVo publishCourseInfo = baseMapper.getPublishCourseInfo(id); return publishCourseInfo; } }
对应的mapper.java
// An highlighted block var foo = 'bar';
对应的mapper.xml
但是,由于.xml文件不会再java编译过程中在target下生成相应的文件,因为编译只会自动将.java文件生成对应的.class文件,处理不了.xml文件,所以需要对自定义的.xml进行资源的声明:
- 在service_edu项目的pom.xml中定义
src/main/java **/*.xml false
- 在service_edu.application.properties中定义
#配置mapper xml文件的路径 mybatis-plus.mapper-locations=classpath:com/xyy/eduservice/mapper/xml/*.xml
idea出现错误:Failed to retrieve application JMX service,解决方案如下,在对应的application上右键,选择configuration:
然后在spring boot中取消JMX选项:
至此解决
仓库中没有maven需要的依赖(jar包),解决方案如下:



