boot-整合mybatis快速搭建

官网地址：http://mybatis.org/spring/zh/boot.html

注意mybatis-starter启动器与boot的版本，可根据官网选择合适的版本

1 引入依赖

<parent>
    <artifactId>spring-boot-starter-parent</artifactId>
    <groupId>org.springframework.boot</groupId>
    <version>2.3.4.RELEASE</version>
</parent>

<!-- spring-boot对mybatis的支持 -->
<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.1.3</version>
</dependency>

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

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid-spring-boot-starter</artifactId>
    <version>1.1.10</version>
</dependency>

2 application.yml

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/brave-mybatis?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2b8&useSSL=false
    username: root
    password: root
# mybatis相关配置
mybatis:
  type-aliases-package: com.brave.entity # 实体类路径
  configuration:
    map-underscore-to-camel-case: true # 开启驼峰映射
    default-fetch-size: 100
    default-statement-timeout: 30
  mapper-locations: classpath:mapping/*Mapper.xml # *Mapper.xml文件扫描路径

3 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.brave.mapper.UserMapper">

</mapper>

4 项目结构

5 启动壳配置mapper扫描路径