自定义SQL语句并在编译时是自动添加到target中

谷粒学院项目学习

在课程信息查询时，由于有多个表进行关联，所以要进行sql语句编写，即：

在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.*;

/**
 * <p>
 * 课程 前端控制器
 * </p>
 *
 * @author testjava
 * @since 2022-06-08
 */
@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;

/**
 * <p>
 * 课程 服务类
 * </p>
 *
 * @author testjava
 * @since 2022-06-08
 */
public interface EduCourseService extends IService<EduCourse> {

    //添加课程信息基本信息
    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;

/**
 * <p>
 * 课程 服务实现类
 * </p>
 *
 * @author testjava
 * @since 2022-06-08
 */
@Service
public class EduCourseServiceImpl extends ServiceImpl<EduCourseMapper, EduCourse> implements 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 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.xyy.eduservice.mapper.EduCourseMapper">
<!--    根据课程id查询课程确认信息-->
    <select id="getPublishCourseInfo" resultType="com.xyy.eduservice.entity.vo.CoursePublishVo">
        SELECT ec.id,ec.title,ec.price,ec.lesson_num AS lessonNum,ec.cover,
               et.name AS teacherName,
               es1.title AS subjectLevelOne,
               es2.title AS subjectLevelTwo
        FROM edu_course ec LEFT OUTER JOIN edu_course_description ecd ON ec.id=ecd.id
                           LEFT OUTER JOIN edu_teacher et ON ec.teacher_id=et.id
                           LEFT OUTER JOIN edu_subject es1 ON ec.subject_parent_id=es1.id
                   LEFT OUTER JOIN edu_subject es2 ON ec.subject_id=es2.id
        WHERE ec.id=#{courseId}
    </select>
</mapper>

但是，由于.xml文件不会再java编译过程中在target下生成相应的文件，因为编译只会自动将.java文件生成对应的.class文件，处理不了.xml文件，所以需要对自定义的.xml进行资源的声明：

1. 在service_edu项目的pom.xml中定义

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

3. 在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包），解决方案如下：