SpringBoot项目(10)—配置MyBatis
JDBC是Java提供的一个操作数据库的API;MyBatis是一个支持普通SQL查询,存储过程和高级映射的优秀持久层框架。MyBatis是对JDBC的封装。所以不需要添加jdbc启动器坐标
修改POM.XML文件:
1.MyBatis要添加相应的启动器
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.2</version>
</dependency>
这里最好不要手动创建,而是建一个项目,让springboot自动注入相关依赖
在SQL里要勾选MyBatis Framework选项
会发现有,因为这并不是springboot官方的MyBatis启动器,而是MyBatis提供给springboot的启动器
2.添加数据库驱动坐标,这里需要手动添加
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
3.添加Druid数据源依赖
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.10</version>
</dependency>
4.配置数据源
spring:
datasource:
type: com.alibaba.druid.pool.DruidDataSource
druid:
driver-class-name: com.mysql.cj.jdbc.Driver
url: 'jdbc:mysql://localhost:3306/test?characterEncoding=UTF-8&useSSL=false&autoReconnect=true&failOverReadOnly=false&serverTimezone=Asia/Shanghai&rewriteBatchStatements=true'
username: root
password: root
initial-size: 10
max-active: 100
min-idle: 10
max-wait: 60000
pool-prepared-statements: true
max-pool-prepared-statement-per-connection-size: 20
time-between-eviction-runs-millis: 60000
min-evictable-idle-time-millis: 300000
#Oracle需要打开注释
#validation-query: SELECT 1 FROM DUAL
test-while-idle: true
test-on-borrow: false
test-on-return: false
stat-view-servlet:
enabled: true
url-pattern: /druid/*
#login-username: admin
#login-password: admin
filter:
stat:
log-slow-sql: true
slow-sql-millis: 5000
merge-sql: false
wall:
config:
multi-statement-allow: true