SpringBoot资料合集-05【Spring Boot集成MyBatis】

1.整合Durid数据源

1、引入Jar包

1
2 <dependencies> 
3 <dependency> 
4 <groupId>org.springframework.boot</groupId> 
5 <artifactId>spring‐boot‐starter‐jdbc</artifactId> 
6 </dependency> 
7 <dependency> 
8 <groupId>org.springframework.boot</groupId> 
9 <artifactId>spring‐boot‐starter‐web</artifactId> 
10 </dependency> 
11 <!‐‐mybatis的场景启动器 
12 因为MyBatis它是Spring data jpa 
13 <dependency> 
14 <groupId>org.mybatis.spring.boot</groupId> 
15 <artifactId>mybatis‐spring‐boot‐starter</artifactId> 
16 <version>2.1.4</version> 
17 </dependency> 
18 ‐‐> 
19 <dependency> 
20 <groupId>com.alibaba</groupId> 
21 <artifactId>druid</artifactId> 
22 <version>1.2.3</version> 
23 </dependency>
24
25 <dependency> 
26 <groupId>mysql</groupId> 
27 <artifactId>mysql‐connector‐java</artifactId> 
28 <scope>runtime</scope> 
29 </dependency> 
30 <dependency> 
31 <groupId>org.springframework.boot</groupId> 
32 <artifactId>spring‐boot‐starter‐test</artifactId> 
33 <scope>test</scope> 
34 </dependency> 
35 </dependencies> 

2.application.yml配置

1 #数据源 
2 spring: 
3 datasource: 
4 username: root 
5 password: 123456 
6 url: jdbc:mysql://localhost:3306/springboot_mybatis?characterEn 
coding=utf8&useSSL=false&serverTimezone=UTC& 
7 driver‐class‐name: com.mysql.cj.jdbc.Driver 
8 type: com.alibaba.druid.pool.DruidDataSource 
9
10 # 数据源其他配置 
11 initialSize: 5 
12 minIdle: 5 
13 maxActive: 20 
14 maxWait: 60000 
15 timeBetweenEvictionRunsMillis: 60000 
16 minEvictableIdleTimeMillis: 300000 
17 validationQuery: SELECT 1 FROM DUAL 
18 testWhileIdle: true 
19 testOnBorrow: false 
20 testOnReturn: false
21 poolPreparedStatements: true 
22 # 配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于 
防火墙 
23 filters: stat,wall 
24 maxPoolPreparedState