【笔记】SpringBoot项目整合MyBatis

发表于 更新于 阅读次数：

前言

SpringBoot项目整合MyBatis学习笔记

整合MyBatis

添加依赖

  • MyBatis Framework、MySQL Driver
pom.xml
1
2
3
4
5
6
7
8
9
10
11
<dependency>
  <groupId>org.mybatis.spring.boot</groupId>
  <artifactId>mybatis-spring-boot-starter</artifactId>
  <version>2.2.0</version>
</dependency>

<dependency>
  <groupId>mysql</groupId>
  <artifactId>mysql-connector-java</artifactId>
  <scope>runtime</scope>
</dependency>

添加配置

  • SpringBoot2.4.2及之前的的版本driver-class-name必须添加serverTimezone=UTC时区配置
src/main/resources/application.yml
1
2
3
4
5
6
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql:///
    username: 
    password:

持久层

src/main/java/dao/UserDao.java
1
2
3
4
5
6
7
8
package com.dao;

import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface UserDao {
    ...
}

整合数据库连接池

  • 以Druid为例

添加依赖

pom.xml
1
2
3
4
5
<dependency>
  <groupId>com.alibaba</groupId>
  <artifactId>druid</artifactId>
  <version>1.1.16</version>
</dependency>

添加配置

spring.datasource.type：配置数据库连接池

src/main/resources/application.yml
1
2
3
4
5
6
7
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql:///
    username: 
    password: 
    type: com.alibaba.druid.pool.DruidDataSource

完成

参考文献

哔哩哔哩——黑马程序员