一. 整合druid
pom.xml配置
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
yml配置
spring:
datasource:
# 使用druid数据源
druid:
url: jdbc:mysql://url/database?useUnicode=true&characterEncoding=utf-8
username: xx
password: 123456
driver-class-name: com.mysql.jdbc.Driver
filters: stat
maxActive: 300
initialSize: 5
maxWait: 60000
minIdle: 5
timeBetweenEvictionRunsMillis: 60000
minEvictableIdleTimeMillis: 300000
validationQuery: select 'x'
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
poolPreparedStatements: true
maxOpenPreparedStatements: 20
WebStatFilter:
enabled: true #是否启用StatFilter默认值true
urlPattern: /*
exclusions: '*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*'
StatViewServlet:
enabled: true # 是否启用StatViewServlet默认值true
urlPattern: /druid/*
#Spring监控AOP切入点,如x.y.z.service.*,配置多个英文逗号分隔
aop-patterns:
二. 整合mybatis
pom.xml配置
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
</dependency>
yml配置
mybatis:
config-location: classpath:mybatis-config.xml
mapper-locations: classpath*:mapper/**/*.xml