09SpringBoot整合MyBatis步骤

ゞ浴缸里的玫瑰 2023-09-26 09:54 55阅读 0赞

![59ac2b7f1b034d33aeedfebb888b0b47.png][]

Spring整合MyBatis时需要进行大量配置，而**SpringBoot****整合MyBatis则可以简化很多配置**：

### 项目结构： ###

![7d80d9d8d9ea45c181d0f5721e216d63.png][]

### 1.准备数据库数据  ###

CREATE DATABASE `student`;
    USE `student`;
    DROP TABLE IF EXISTS `student`;
    CREATE TABLE `student` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(255) DEFAULT NULL,
      `sex` varchar(10) DEFAULT NULL,
      `address` varchar(255) DEFAULT NULL,
      PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
    
    insert  into 
    `student`(`id`,`name`,`sex`,`address`)
    values (1,'程序员1','男','北京'),(2,'程序员2','女','上海');

![2ad6f81e1576437a927b777a694ba5d2.png][]

### 2.创建SpringBoot项目，添加MyBatis起步依赖和Mysql驱动依赖 ###

<dependencies>
            <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.2.2</version>
            </dependency>
    
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <scope>runtime</scope>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
        </dependencies>

### （1）创建项目步骤 ###

**File---> Project--->Spring Initializr--->next--->填信息--->next--->Web--->SpringWeb√--->搜索mybatis、mysql添加--->next--->填信息--->finish**

![09f6511f774e4be3b13bda87bba01782.png][]

![b4f61ad243f94abba5f3f5b2b8674248.png][]

添加这三个依赖，创建项目时会自动生成依赖![ec02a541abe246e3b6873fc3a49e5ad5.png][]

![1e8b1744cae245c1861007b74ae0180a.png][]

### （2）查看maven是否是电脑本地maven ###

如果是本地maven就不用管，如果不是本地maven，需要手动传入maven本地路径地址，不然pom.xml文件中的依赖刷新不出来。

**File--->Settings--->Maven--->更改“Maven home directory、User Settings file”路径**

![f833a67c1de34f059658024796b88231.png][]

### 3.编写实体类 ###

public class Student {
        private int id;
        private String name;
        private String sex;
        private String address;
        
        // 省略构造方法/getter/setter/tostring
    }

### 4.编写Mapper层接口StudentMapper ###

@Mapper
    public interface StudentMapper {
        List<Student> findAll();
    }

### 5.编写Mapper映射文件StudentMapper.xml ###

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper3.0//EN"
            "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace="com.itbaizhan.springbootmybatis.mapper.StudentMapper">
        <select id="findAll" resultType="student">
            select * from student
        </select>
    </mapper>

### 6.编写配置文件 application.yaml（约定大于配置） ###

#数据源
    spring:
      datasource:
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql:///student?serverTimeZone=UTC
        username: root
        password: 123456
    
    mybatis:
      # 注册映射文件的位置
      mapper-locations: com/itbaizhan/springbootmybatis/mapper/*mapper.xml
      # 别名(为domain包下所有类设置别名，别名为类名)
      type-aliases-package: com.itbaizhan.springbootmybatis.domain
    
    #日志格式
    logging:
      pattern:
      console: '%d{HH:mm:ss.SSS} %clr(%-5level) --- [%-15thread]%cyan(%-50logger{50}):%msg%n'

### 7.编写测试类 ###

//测试类注解，可以在运行测试代码时加载Spring容器
    @SpringBootTest
    public class StudentMapperTest {
        @Autowired
        private StudentMapper studentMapper;
    
        @Test
        public void testFindAll(){
            List<Student> all = studentMapper.findAll();
            all.forEach(System.out::println);
        }
    }

### 8.结果显示： ###

![fbdfebb2c1084098a499eccbd0a1deee.png][]

[59ac2b7f1b034d33aeedfebb888b0b47.png]: https://img-blog.csdnimg.cn/59ac2b7f1b034d33aeedfebb888b0b47.png
[7d80d9d8d9ea45c181d0f5721e216d63.png]: https://img-blog.csdnimg.cn/7d80d9d8d9ea45c181d0f5721e216d63.png
[2ad6f81e1576437a927b777a694ba5d2.png]: https://img-blog.csdnimg.cn/2ad6f81e1576437a927b777a694ba5d2.png
[09f6511f774e4be3b13bda87bba01782.png]: https://img-blog.csdnimg.cn/09f6511f774e4be3b13bda87bba01782.png
[b4f61ad243f94abba5f3f5b2b8674248.png]: https://img-blog.csdnimg.cn/b4f61ad243f94abba5f3f5b2b8674248.png
[ec02a541abe246e3b6873fc3a49e5ad5.png]: https://img-blog.csdnimg.cn/ec02a541abe246e3b6873fc3a49e5ad5.png
[1e8b1744cae245c1861007b74ae0180a.png]: https://img-blog.csdnimg.cn/1e8b1744cae245c1861007b74ae0180a.png
[f833a67c1de34f059658024796b88231.png]: https://img-blog.csdnimg.cn/f833a67c1de34f059658024796b88231.png
[fbdfebb2c1084098a499eccbd0a1deee.png]: https://img-blog.csdnimg.cn/fbdfebb2c1084098a499eccbd0a1deee.png