增删改查--课程

Course

package com.example.demo2.entity;

import lombok.Data;

@Data
public class Course {

    private String courseId;

    private String courseName;

    private double score;


}

CourseController

package com.example.demo2.controller;

import com.example.demo2.entity.XuanKe;
import com.example.demo2.service.SemesterService;
import com.example.demo2.service.XuanKeService;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.HashMap;
import java.util.Map;

@Slf4j
@RestController
@RequestMapping("/course")
public class CourseController {

    @Autowired
    private XuanKeService xuanKeService;


    @Autowired
    private SemesterService semesterService;

    @PostMapping("/xuanke")
    @ResponseBody
    public Map<String,Object> xuanKe(@RequestBody XuanKe xuanKe){
        Map<String, Object> retData = new HashMap<>();
        if(StringUtils.isEmpty(xuanKe.getStudentId()) || StringUtils.isEmpty(xuanKe.getCourseId() )|| StringUtils.isEmpty(xuanKe.getSemester())){
            retData.put("code", 500);
            retData.put("message", "参数错误!");
        } else {
            retData = xuanKeService.xuanKe(xuanKe.getStudentId(),xuanKe.getCourseId(),xuanKe.getSemester());
        }
        log.debug("retDate ====> {}", retData);
        return retData;
    }


    @RequestMapping("/semester")
    public Map<String,Object> semester(@RequestBody XuanKe xuanKe){
        Map<String,Object> retData = new HashMap<>();
        if(StringUtils.isEmpty(xuanKe.getStudentId())){
            retData.put("code",500);
            retData.put("message","参数错误！");

        }else {
            retData.put("模式一", "根据学生号访问");
            retData = semesterService.semester(xuanKe.getStudentId());
        }
        log.debug("retData ====> {} ",retData);
        return retData;
    }

    @RequestMapping("/semesters")
    public Map<String,Object> semestesr(@RequestBody XuanKe xuanKe){
        Map<String,Object> retData = new HashMap<>();
        if(StringUtils.isEmpty(xuanKe.getStudentId())){
            retData.put("code",500);
            retData.put("message","参数错误！");

        }else {
            retData.put("模式二", "根据学生号和学期访问");
            retData = semesterService.semesters(xuanKe.getStudentId(),xuanKe.getSemester());
        }
        log.debug("retData ====> {} ",retData);
        return retData;
    }

}

CourseMapper

package com.example.demo2.mapper;

import com.example.demo2.entity.Course;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface CourseMapper {

//    public List<Course> getAllCourse();

    public Course getById(String xuankeId);
}

CourseMapper.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.example.demo2.mapper.CourseMapper">

    <resultMap id="course" type="com.example.demo2.entity.Course">
        <id property="courseId" column="course_id"/>
        <result property="courseName" column="course_name"/>
        <result property="score" column="score"/>
    </resultMap>

    <select id="getAllCourse" resultMap="course">
        select * from  t_course;
    </select>

    <select id="getById" resultMap="course">
        select * from t_course where course_id = #{course_id};
    </select>

</mapper>