集成前的数据库准备工作
数据库student表及其字段如图所示:
正式开始整合:1.首先通过IDEA创建一个SpringBoot项目
一直next往下就行了,注意目录结构名。
以下是我的目录结构,注意箭头标注的,是我新建的。
2.在pom.xml里添加所需要的依赖
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.4</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.15</version>
</dependency>
</dependencies>
3.在yml里配置数据库连接和mabatis的映射
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/answer?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
username: root
password: root
mybatis:
mapper-locations: classpath:mapper/*Mapper.xml
type-aliases-package: com.example.yao.springbootcatmybatis.entity
解释一下,
mapper-location:指的是resources/mapper文件夹下所有xxxMapper.xml的文件,SQL语句可以写在这个文件里。
type-aliases-package:用于给实体类取别名,取了别名之后不用在xxxMapper.xml文件里指定实体类的全限定名,如com.example.yao.springbootcatmabatis.entity.Student,由于取了别名,后面我们可以直接在xxxMapper.xml文件的result返回值写成student。
这里我可能表述得不是很清晰,后面我们在Mapper.xml文件里再解释
4.Controller,Service,Mapper,entity类的编写
Student
package com.example.yao.springbootcatmybatis.entity;
import lombok.Data;
/**
* @Author Shinelon
* @Date 2020/12/21 21:01
* @Version 1.0
*/
@Data
public class Student {
private Integer id;
private String stu_name;
private Integer question_id;
}
StudentMapper
package com.example.yao.springbootcatmybatis.mapper;
import com.example.yao.springbootcatmybatis.entity.Student;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;
import java.util.List;
/**
* @Author Shinelon
* @Date 2020/12/21 21:02
* @Version 1.0
*/
@Mapper
@Repository
public interface StudentMapper {
List<Student> getAllStudent();
}
StudentService
package com.example.yao.springbootcatmybatis.service;
import com.example.yao.springbootcatmybatis.entity.Student;
import com.example.yao.springbootcatmybatis.mapper.StudentMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
/**
* @Author Shinelon
* @Date 2020/12/21 21:03
* @Version 1.0
*/
@Service
public class StudentService {
@Autowired
private StudentMapper studentMapper;
public List<Student> getAllStudent() {
return studentMapper.getAllStudent();
}
}
StudentController
package com.example.yao.springbootcatmybatis.controller;
import com.example.yao.springbootcatmybatis.entity.Student;
import com.example.yao.springbootcatmybatis.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import java.util.List;
/**
* @Author Shinelon
* @Date 2020/12/21 20:47
* @Version 1.0
*/
@RestController
public class StudentController {
@Autowired
private StudentService studentService;
@RequestMapping("getAllStudent")
public List<Student> getAllStudent(){
return studentService.getAllStudent();
}
}
5.studentMapper.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.yao.springbootcatmybatis.mapper.StudentMapper">
<select id="getAllStudent" resultType="Student">
select * from student
</select>
</mapper>
可以看到
namespace将studentMapper.xml与数据层的studentMapper绑定起来,
我们的select语句写在<select></select>
之中,这里有两个参数:id和resultType
id:
与studentMapper接口里面的方法名对应
resultType:
与实体类Student对应,还记得我们在application.yml里面配置的type-aliases-package属性吗?这里之所以能直接用Student作为返回值,是因为我们使用了别名扫描了com.example.yao.springbootcatmybatis.entity
这个包,如果没有使用别名的话,这里的resultType我们就需要写全限定名:com.example.yao.springbootcatmybatis.entity.Student
。