Druid是Java语言中最好的数据库连接池，能够提供强大的监控和扩展功能。
本文将基于 springboot 2.1.8.RELEASE + mybatis-plus 2.2.0 来整合 Druid 连接池 二、springboot 整合 druid 入门 1、pom.xml 中引入 druid 依赖更多可参考官方文档：https://github.com/alibaba/druid/
com.alibaba
druid
1.1.10
spring:
# 配置数据源
datasource:
url: jdbc:mysql://127.0.0.1:3306/demo?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&useSSL=false # MySQL在高版本需要指明是否进行SSL连接 解决则加上 &useSSL=false
name: demo
username: root
password: root
platform: mysql
driver-class-name: com.mysql.jdbc.Driver
# ===================== ↓↓↓↓↓↓ 使用druid数据源 ↓↓↓↓↓↓ =====================
# 连接池类型，druid连接池springboot暂无法默认支持，需要自己配置bean
type: com.alibaba.druid.pool.DruidDataSource
initialSize: 5 # 连接池初始化连接数量
minIdle: 5# 连接池最小空闲数
maxActive: 20 # 连接池最大活跃连接数
maxWait: 60000 # 配置获取连接等待超时的时间
timeBetweenEvictionRunsMillis: 60000 # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
minEvictableIdleTimeMillis: 300000 # 配置一个连接在池中最小生存的时间，单位是毫秒
validationQuery: SELECt 1 FROM DUAL # 连接是否有效的查询语句
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
# 打开PSCache，并且指定每个连接上PSCache的大小
poolPreparedStatements: true
maxPoolPreparedStatementPerConnectionSize: 20
removeAbandoned: true
# 配置监控统计拦截的filters，去掉后监控界面sql无法统计，【 'stat':监控统计 'wall'：用于防火墙，防御sql注入 'slf4j':日志 】
filters: stat,wall,slf4j
# 通过connectProperties属性来打开mergeSql功能；慢SQL记录
connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
#useGlobalDataSourceStat: true # 合并多个DruidDataSource的监控数据
loginUsername: admin # SQL监控后台登录用户名
loginPassword: admin # SQL监控后台登录用户密码
@Configuration
public class DruidConfig {
@Value("${spring.datasource.loginUsername}")
private String loginUsername;
@Value("${spring.datasource.loginPassword}")
private String loginPassword;
@Bean
public ServletRegistrationBean druidServlet() {
// 注册服务
ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(), "/druid
@Bean
public FilterRegistrationBean webStatFilter() {
FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter());
// 添加过滤规则
Map initParams = new HashMap<>(1);
// 设置忽略请求
initParams.put("exclusions", "*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid
@Bean(name = "dataSource")
@ConfigurationProperties(prefix = "spring.datasource")
public DataSource dataSource() {
return new DruidDataSource();
}
@Bean(name = "transactionManager")
public DataSourceTransactionManager transactionManager() {
return new DataSourceTransactionManager(dataSource());
}
@Bean
public DruidStatInterceptor druidStatInterceptor() {
DruidStatInterceptor dsInterceptor = new DruidStatInterceptor();
return dsInterceptor;
}
@Bean
@Scope("prototype")
public JdkRegexpMethodPointcut druidStatPointcut() {
JdkRegexpMethodPointcut pointcut = new JdkRegexpMethodPointcut();
pointcut.setPattern("com.zhengqing.demo.modules.*.api.*");
return pointcut;
}
@Bean
public DefaultPointcutAdvisor druidStatAdvisor(DruidStatInterceptor druidStatInterceptor, JdkRegexpMethodPointcut druidStatPointcut) {
DefaultPointcutAdvisor defaultPointAdvisor = new DefaultPointcutAdvisor();
defaultPointAdvisor.setPointcut(druidStatPointcut);
defaultPointAdvisor.setAdvice(druidStatInterceptor);
return defaultPointAdvisor;
}
}
https://gitee.com/zhengqingya/java-workspace
