SpringBoot继承Mybatis
1. 配置一个druid数据源
直接配置写一个applicationx.yml的配置文件
spring:
datasource:
name: test
url: jdbc:mysql://192.168.16.137:3306/test
username: root
password:
# 使用druid数据源
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.jdbc.Driver
filters: stat
maxActive: 20
initialSize: 1
maxWait: 60000
minIdle: 1
timeBetweenEvictionRunsMillis: 60000
minEvictableIdleTimeMillis: 300000
validationQuery: select 'x'
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
poolPreparedStatements: true
maxOpenPreparedStatements: 20
2. Spring Boot集成Mybatis
2.1 mybatis-spring-boot-starter方式
在pom.xml中添加依赖
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.0.0</version>
</dependency>
在application.yml中增加配置:
mybatis:
mapperLocations: classpath:mapper/*.xml
typeAliasesPackage: tk.mapper.model
除此之外还有
- mybatis.config:mybatis-config.xml配置文件的路径
- mybatis.typeHandlersPackage:扫描typeHandlers的包
- mybatis.checkConfigLocation:检查配置文件是否存在
- mybatis.executorType:设置执行模式(SIMPLE, REUSE, BATCH),默认为SIMPLE