1. 創(chuàng)建springboot項(xiàng)目

2.修改pom.xml

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-spring-boot3-starter</artifactId>
    <version>3.5.12</version>
</dependency>

3.項(xiàng)目配置 application.yml

server:
  port: 8888  # 服務(wù)器端口號(hào)

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/db?characterEncoding=utf8&serverTimezone=GMT%2B8
    username: root
    password: root

4. 新建包,如下:

5.修改DemoApplication主啟動(dòng)類

增加注解

@MapperScan("cn.edu.ccrw.demo.mapper")

5.新建PO類

Student

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import lombok.Data;
//po類作用是封裝數(shù)據(jù),與數(shù)據(jù)庫的表對(duì)應(yīng)
//po類需要定義私有屬性(與表中的列對(duì)應(yīng))
//po類需要定義get/set方法
@Data //自動(dòng)生成 get/set
public class Student  {
    @TableId(type = IdType.AUTO)
    private Integer sno;
    private String  name;
    private String  gender;
    private Integer age;
    private Double  height;
    
}

6.新建Mapper接口

StudentMapper

import cn.edu.ccrw.demo.po.Student;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

//繼承 BaseMapper 會(huì)根據(jù) Student類結(jié)構(gòu)
//自動(dòng)生成 sql語句
public interface StudentMapper extends BaseMapper<Student> {
}

7.新建Service接口及實(shí)現(xiàn)類
StudentService StudentServiceImpl

import cn.edu.ccrw.demo.po.Student;
import java.util.List;

public interface StudentService {

    String addStudent(Student student);
    String removeStudent(int sno);
    String updateStudent(Student student);
    List<Student> queryAllStudent();
}

import cn.edu.ccrw.demo.mapper.StudentMapper;
import cn.edu.ccrw.demo.po.Student;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service
public class StudentServiceImpl implements StudentService {
    @Autowired
    private StudentMapper mapper;//業(yè)務(wù)類依賴 mapper

    @Override
    public String addStudent(Student student) {
        return mapper.insert(student)==1?"增加學(xué)生成功":"增加學(xué)生失敗";
    }

    @Override
    public String removeStudent(int sno) {
        return mapper.deleteById(sno)==1?"刪除學(xué)生成功":"刪除學(xué)生失敗";
    }

    @Override
    public String updateStudent(Student student) {
        return mapper.updateById(student)==1?"修改學(xué)生成功":"修改學(xué)生失敗";
    }

    @Override
    public List<Student> queryAllStudent() {
        return mapper.selectList(null);
    }
}

8.新建Controller

StudentController

import cn.edu.ccrw.demo.po.Student;
import cn.edu.ccrw.demo.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import java.util.List;

@RestController
@RequestMapping("/student")
public class StudentController {
    @Autowired
    private StudentService service = null; //依賴

    @GetMapping //查詢所有數(shù)據(jù)請(qǐng)求
    public List<Student> queryAll() {
        return service.queryAllStudent();
    }

    @PostMapping //增加數(shù)據(jù)請(qǐng)求
    public String add(@RequestBody Student student) {
        return  service.addStudent(student);
    }

    @PutMapping //修改數(shù)據(jù)請(qǐng)求
    public String update(@RequestBody Student student) {
        return service.updateStudent(student);
    }

    @DeleteMapping("/{sno}")   //刪除數(shù)據(jù)請(qǐng)求
    public String delete(@PathVariable("sno") int sno  ) {
        return service.removeStudent(sno);
    }

}