SpringBoot与Mybatis案例

SpringBoot与Mybatis案例前端查询代码：

前端添加代码：

后端代码

导入jar包坐标：


   
      org.springframework.boot
      spring-boot-starter-web
   

   
      org.springframework.boot
      spring-boot-devtools
      runtime
      true
   
   
      org.springframework.boot
      spring-boot-configuration-processor
      true
   
   
      org.projectlombok
      lombok
      true
   
   
      org.springframework.boot
      spring-boot-starter-test
      test
   

   
      mysql
      mysql-connector-java
      8.0.25
   
   
      org.mybatis.spring.boot
      mybatis-spring-boot-starter
      2.0.0
   
   
      com.alibaba
      druid
      1.0.9

编写配置文件：

SpringBoot与Mybatis案例前端查询代码：

前端添加代码：

后端代码

导入jar包坐标：


   
      org.springframework.boot
      spring-boot-starter-web
   

   
      org.springframework.boot
      spring-boot-devtools
      runtime
      true
   
   
      org.springframework.boot
      spring-boot-configuration-processor
      true
   
   
      org.projectlombok
      lombok
      true
   
   
      org.springframework.boot
      spring-boot-starter-test
      test
   

   
      mysql
      mysql-connector-java
      8.0.25
   
   
      org.mybatis.spring.boot
      mybatis-spring-boot-starter
      2.0.0
   
   
      com.alibaba
      druid
      1.0.9

编写配置文件：

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-kaP2SdfL-1651074736625)(C:Users下午的光AppDataRoamingTyporatypora-user-imagesimage-20220427233806479.png)]

spring.datasource.url=jdbc:mysql://127.0.0.1:3306/lession?serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.initialSize=20
spring.datasource.minIdle=10
spring.datasource.maxActive=100
mybatis.mapper-locations=classpath:mapper/*.xml

编写mapper：

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-JvgKWWL5-1651074736626)(C:Users下午的光AppDataRoamingTyporatypora-user-imagesimage-20220427233906641.png)]

写sql语句方式一：

@Mapper
public interface StudentMapper {
    @Select("select *from student;")   //这里可以写简单的sql语句。
    public List listAll();


    @Insert("INSERT INTO student(NAME,age,major) VALUES(#{name},#{age},#{major});")
    public int insertStudent(Student student);
}

StudentController代码：

@RestController
public class StudentController {
    @Autowired
    StudentMapper studentMapper;//因为springboot不一定可以给你注入成功，所以会爆红。

    @GetMapping("/stu/getAllStudent")
    @CrossOrigin(origins = "*")
    public List getAllStudent(){
        return studentMapper.listAll();
    }

    @PostMapping("/stu/add")
    @CrossOrigin(origins = "*")
    public String add(@RequestBody Student student){
       studentMapper.insertStudent(student);
        return "OK";
    }
}

解决上面爆红问题：

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-tAkRRTOX-1651074736627)(C:Users下午的光AppDataRoamingTyporatypora-user-imagesimage-20220427234220149.png)]

@MapperScan(basePackages = {"com.demo.mapper"}) //扫描包中的mapper注解
@SpringBootApplication
public class Experiment3Application {

   public static void main(String[] args) {
      SpringApplication.run(Experiment3Application.class, args);
   }

}

方式二通过xml文件写sql语句：




    
        SELECT *from student;
    
    
        INSERT INTO student(NAME,age,major) VALUES(#{name},#{age},#{major});

源文件：后端→experiment3 以及前端→experimentFour

spring.datasource.url=jdbc:mysql://127.0.0.1:3306/lession?serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.initialSize=20
spring.datasource.minIdle=10
spring.datasource.maxActive=100
mybatis.mapper-locations=classpath:mapper/*.xml