1,打开idea创建springboot项目,点击Spring Initializr
2,随便填写点击next,java version是jdk版本
3,就选一个lombok,其他jar包在pom手动导入
4,直接finish
5,在pom.xml文件中导入三个整合mybatis所需的依赖jar包
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.4.1</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.ph</groupId>
<artifactId>springboot-mybatis</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>springboot-mybatis</name>
<description>Demo project for Spring Boot</description>
<properties>
<java.version>1.8</java.version>
</properties>
<dependencies>
<!-- mybatis整合springboot jar包 -->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.2</version>
</dependency>
<!-- driud整合springboot jar包 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.10</version>
</dependency>
<!-- mysql驱动 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter</artifactId>
</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>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
<configuration>
<excludes>
<exclude>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</exclude>
</excludes>
</configuration>
</plugin>
</plugins>
</build>
</project>
6,在application.yml中配置druid连接池(只是简单配置)
spring:
#druid连接池配置
datasource:
druid:
username: root
password: 123456
url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC
driver-class-name: com.mysql.jdbc.Driver
db-type: com.alibaba.druid.pool.DruidDataSource
7,创建实体类
package com.ph.springbootmybatis.entity;
import lombok.Data;
@Data
public class Student {
private long id;
private String name;
}
8,创建mapper接口
package com.ph.springbootmybatis.mapper;
import com.ph.springbootmybatis.entity.Student;
import org.apache.ibatis.annotations.Mapper;
import java.util.List;
@Mapper
public interface StudentMapper {
List<Student> findAll();
}
9,在启动类上添加注解扫描(用来扫描mapper类)
package com.ph.springbootmybatis;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
@MapperScan("com.ph.mapper")//扫描mapper包下的所有类
public class SpringbootMybatisApplication {
public static void main(String[] args) {
SpringApplication.run(SpringbootMybatisApplication.class, args);
}
}
10,创建mapper.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.ph.springbootmybatis.mapper.StudentMapper">
<select id="findAll" resultType="com.ph.springbootmybatis.entity.Student">
select * from student
</select>
</mapper>
11,在application.yml中配置扫描映射文件
#配置mybatis
mybatis:
#扫描xml文件
mapper-locations: classpath:mapper/*.xml
configuration:
#开启驼峰命名法
map-underscore-to-camel-case: true
12,测试
package com.ph.springbootmybatis.mapper;
import com.ph.springbootmybatis.entity.Student;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import java.util.List;
import static org.junit.jupiter.api.Assertions.*;
@SpringBootTest
class StudentMapperTest {
@Autowired
private StudentMapper studentMapper;
@Test
void findAll() {
List<Student> students = studentMapper.findAll();
for (Student student : students) {
System.out.println(student);
}
}
}
测试结果:
总结:
根据以上操作就能把springboot与mybatis整合,注意点就是mybatis的jar包是整合包mybatis-spring-boot-starter,然后就是在启动类上需要加上注解@MapperScan(“mapper包的路径”)或者在需要交给spring容器管理的mapper接口上加上@Mapper注解(以上操作中两种方式都实现了,一种即可生效),还有application配置文件中需要配置需要扫描的mapper映射文件的位置,mybatis的其他配置看项目需求。