整合Mybatis

官方文档：http://mybatis.org/spring-boot-starter/mybatis-spring-boot-autoconfigure/

• Maven 坐标
• application.yaml
• 业务类
• mapper.xml

<dependency>

<groupId>org.mybatis.spring.boot</groupId>

<artifactId>mybatis-spring-boot-starter</artifactId>

<version>2.1.1</version>

</dependency>

• 访问http://localhost:8080/user

Mybatis + Druid + 多数据源

• application.yaml
• 数据源配置类
• 主启动类

spring:

datasource:

# username: root

# password: root

# url: jdbc:mysql://localhost:3306/oauth?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8

# driver-class-name: com.mysql.jdbc.Driver

# type: com.alibaba.druid.pool.DruidDataSource

primary:

username: root

password: root

jdbc-url: jdbc:mysql://localhost:3306/oauth?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8

driver-class-name: com.mysql.jdbc.Driver

type: com.alibaba.druid.pool.DruidDataSource

secondary:

username: root

password: root

jdbc-url: jdbc:mysql://localhost:3306/blog?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8

driver-class-name: com.mysql.jdbc.Driver

type: com.alibaba.druid.pool.DruidDataSource

jackson:

date-format: yyyy-MM-dd HH:mm:ss

time-zone: GMT+8

mybatis:

configuration:

map-underscore-to-camel-case: true #驼峰映射

log-impl: org.apache.ibatis.logging.stdout.StdOutImpl #调试打印SQL