1.模块内结构

image.png

2.模块内代码

2.1Course

package com.springboot.mybatis.entity;

import lombok.Data;

@Data
public class Course {
private Long courseId;
private String courseName;
private Long userId;
private String courseClass;
private String cover;
private String courseCode;
private Short finished;
public Long getCourseId() {
return courseId;
}

public void setCourseId(Long courseId) {
    this.courseId = courseId;
}

public String getCourseName() {
    return courseName;
}

public void setCourseName(String courseName) {
    this.courseName = courseName;
}

public Long getUserId() {
    return userId;
}

public void setUserId(Long userId) {
    this.userId = userId;
}

public String getCourseClass() {
    return courseClass;
}

public void setCourseClass(String courseClass) {
    this.courseClass = courseClass;
}

public String getCover() {
    return cover;
}

public void setCover(String cover) {
    this.cover = cover;
}

public String getCourseCode() {
    return courseCode;
}

public void setCourseCode(String courseCode) {
    this.courseCode = courseCode;
}

public Short getFinished() {
    return finished;
}

public void setFinished(Short finished) {
    this.finished = finished;
}

}

2.2CourseMapper

package com.springboot.mybatis.mapper;

import com.springboot.mybatis.entity.Course;
import org.apache.ibatis.annotations.*;

import java.util.List;

public interface CourseMapper {
@Results({
@Result(property = "courseId",column = "course_id"),
@Result(property = "courseName",column = "course_name"),
@Result(property = "userId",column = "user_id"),
@Result(property = "courseClass",column = "course_class"),
@Result(property = "cover",column = "cover"),
@Result(property = "courseCode",column = "course_code"),
@Result(property = "finished",column = "finished"),
})
@Select("SELECT * FROM t_course ")
List<Course> selectAll();

@Results({
        @Result(property = "courseId",column = "course_id"),
        @Result(property = "courseName",column = "course_name"),
        @Result(property = "userId",column = "user_id"),
        @Result(property = "courseClass",column = "course_class"),
        @Result(property = "cover",column = "cover"),
        @Result(property = "courseCode",column = "course_code"),
        @Result(property = "finished",column = "finished"),
})
@Select("SELECT * FROM t_course WHERE course_id = #{courseId} ")
Course getOne(Long courseId);

@Delete("DELETE FROM t_course WHERE course_id = #{courseId} ")
void delete(Long courseId);

@Insert("INSERT INTO t_course(course_name,user_id,course_class,cover,course_code,finished)" +
        " VALUES(#{courseName}, #{userId}, #{courseClass},#{cover},#{courseCode},#{finished}) ")
void insert(Course course);

@Update("UPDATE t_course SET cover=#{cover},finished=#{finished} WHERE course_id =#{courseId}")
void update(Course course);

}

2.3CourseService

package com.springboot.mybatis.service;

import com.springboot.mybatis.entity.Course;

import java.util.List;

public interface CourseService {
List<Course> selectAll();

Course getOne(long courseId);

void delete(long courseId);

void insert(Course course);
void update(Course course);

}

2.4CourseServiceImpl

package com.springboot.mybatis.service.Impl;

import com.springboot.mybatis.entity.Course;
import com.springboot.mybatis.mapper.CourseMapper;
import com.springboot.mybatis.service.CourseService;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.List;

@Service
public class CourseServiceImpl implements CourseService {
@Resource
private CourseMapper courseMapper;

@Override
public List<Course> selectAll(){
    return courseMapper.selectAll();
}

@Override
public Course getOne(long courseId) {
    return courseMapper.getOne(courseId);
}

@Override
public void delete(long courseId) {
    courseMapper.delete(courseId);
}

@Override
public void insert(Course course) {
    courseMapper.insert ( course );    }


@Override
public void update(Course course) {
    courseMapper.update ( course );
}

}

2.5CourseController

package com.springboot.mybatis.controller;

import com.springboot.mybatis.entity.Course;
import com.springboot.mybatis.service.CourseService;
import com.springboot.mybatis.util.RandomUtil;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;
import java.util.List;

@RestController
@RequestMapping(value = "/api")
public class CourseController {
@Resource
private CourseService courseService;

@RequestMapping(value = "/courses",method = RequestMethod.GET)
public List<Course> selectAll(){
    return courseService.selectAll();
}

@RequestMapping(value = "/course/{id}",method = RequestMethod.GET)
public Course getOne(@PathVariable("id") long id){
    return courseService.getOne(id);
}

@RequestMapping(value = "/course/{id}",method = RequestMethod.DELETE)
public void deleteCourse(@PathVariable("id") long id){
    courseService.delete(id);
}

@RequestMapping(value = "/course", method = RequestMethod.POST)
public void addCourse(@RequestBody Course course) {
    course.setCourseCode( RandomUtil.getRandomCode());
    courseService.insert(course);
}

@RequestMapping(value = "/course", method = RequestMethod.PUT)
public void updateCourse(@RequestBody Course course) {
    courseService.update(course);
}

}

3.测试类代码

CourseServiceImplTest

package com.springboot.mybatis.service.Impl;
import com.springboot.mybatis.entity.Course;
import com.springboot.mybatis.service.CourseService;
import com.springboot.mybatis.util.RandomUtil;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

import javax.annotation.Resource;

import java.util.List;

import static org.junit.Assert.*;

@RunWith(SpringRunner.class)
@SpringBootTest
public class CourseServiceImplTest {
@Resource
private CourseService courseService;

@Test
public void selectAll() {
    List<Course> courseList = courseService.selectAll();
    courseList.forEach(course -> System.out.println(course));
}

@Test
public void getOne() {
    Course course = courseService.getOne(1);
    System.out.println(course);
}

@Test
public void delete() {
    courseService.delete(5);
}

@Test
public void insert() {
    Course course = new Course();
    course.setCourseName("微信小程序开发");
    course.setCourseClass("软件1721");
    course.setUserId(1L);
    course.setCover("1.jpg");
    course.setCourseCode(RandomUtil.getRandomCode());
    course.setFinished((short) 0);
    courseService.insert(course);
}

@Test
public void update() {
    Course course = courseService.getOne(5);
    course.setCover("999.jpg");
    course.setFinished((short) 1);
    courseService.update(course);
}

}