Spring Boot (八):配置Druid 连接池
来源:互联网 发布:软件开发培训中心 编辑:程序博客网 时间:2024/04/20 07:03
springboot 配置 Druid连接池
一、添加依赖
<!-- 驱动 --><dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <scope>runtime</scope></dependency><!-- 连接池 --><dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.1.0</version></dependency>
二、配置application.properties
spring.datasource.type = com.alibaba.druid.pool.DruidDataSourcespring.datasource.driverClassName = com.mysql.jdbc.Driverspring.datasource.url = jdbc:mysql://localhost:3306/admin?useUnicode=true&characterEncoding=utf-8&useSSL=falsespring.datasource.username = usernamespring.datasource.password = password# 下面为连接池的补充设置,应用到上面所有数据源中# 初始化大小,最小,最大spring.druid.datasource.initialSize=5spring.druid.datasource.minIdle=5spring.druid.datasource.maxActive=20# 配置获取连接等待超时的时间spring.druid.datasource.maxWait=60000# 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒spring.druid.datasource.timeBetweenEvictionRunsMillis=60000# 配置一个连接在池中最小生存的时间,单位是毫秒spring.druid.datasource.minEvictableIdleTimeMillis=300000# Oracle请使用select 1 from dualspring.druid.datasource.validationQuery=SELECT 'x'spring.druid.datasource.testWhileIdle=truespring.druid.datasource.testOnBorrow=falsespring.druid.datasource.testOnReturn=false# 打开PSCache,并且指定每个连接上PSCache的大小spring.druid.datasource.poolPreparedStatements=falsespring.druid.datasource.maxPoolPreparedStatementPerConnectionSize=20# 配置监控统计拦截的filters,去掉后监控界面sql无法统计,'wall'用于防火墙spring.druid.datasource.filters=stat,wall,slf4j# 通过connectProperties属性来打开mergeSql功能;慢SQL记录spring.druid.datasource.connectionProperties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
三、新建Druid 配置类
在Spring Boot1.4.0中驱动配置信息没有问题,但是连接池的配置信息不再支持这里的配置项,即无法通过配置项直接支持相应的连接池;这里列出的这些配置项可以通过定制化DataSource来实现。目前Spring Boot中默认支持的连接池有dbcp,dbcp2, tomcat, hikari三种连接池。 由于Druid暂时不在Spring Bootz中的直接支持,故需要进行配置信息的定制:
package com.greatdrive.admin.config;import java.sql.SQLException;import javax.sql.DataSource;import org.apache.log4j.Logger;import org.springframework.beans.factory.annotation.Value;import org.springframework.boot.context.properties.ConfigurationProperties;import org.springframework.boot.web.servlet.FilterRegistrationBean;import org.springframework.boot.web.servlet.ServletRegistrationBean;import org.springframework.context.annotation.Bean;import org.springframework.context.annotation.Primary;import com.alibaba.druid.pool.DruidDataSource;import com.alibaba.druid.support.http.StatViewServlet;import com.alibaba.druid.support.http.WebStatFilter;@ConfigurationProperties(prefix = "spring.druid.datasource")@Configurationpublic class DruidDBConfig { private Logger logger = Logger.getLogger(this.getClass()); @Value("${spring.datasource.url}") private String dbUrl; @Value("${spring.datasource.username}") private String username; @Value("${spring.datasource.password}") private String password; @Value("${spring.datasource.driverClassName}") private String driverClassName; @Value("${spring.datasource.initialSize}") private int initialSize; @Value("${spring.datasource.minIdle}") private int minIdle; @Value("${spring.datasource.maxActive}") private int maxActive; @Value("${spring.datasource.maxWait}") private long maxWait; @Value("${spring.datasource.timeBetweenEvictionRunsMillis}") private int timeBetweenEvictionRunsMillis; @Value("${spring.datasource.minEvictableIdleTimeMillis}") private int minEvictableIdleTimeMillis; @Value("${spring.datasource.validationQuery}") private String validationQuery; @Value("${spring.datasource.testWhileIdle}") private boolean testWhileIdle; @Value("${spring.datasource.testOnBorrow}") private boolean testOnBorrow; @Value("${spring.datasource.testOnReturn}") private boolean testOnReturn; @Value("${spring.datasource.poolPreparedStatements}") private boolean poolPreparedStatements; @Value("${spring.datasource.maxPoolPreparedStatementPerConnectionSize}") private int maxPoolPreparedStatementPerConnectionSize; @Value("${spring.datasource.filters}") private String filters; @Value("{spring.datasource.connectionProperties}") private String connectionProperties; @Bean //声明其为Bean实例 @Primary //在同样的DataSource中,首先使用被标注的DataSource public DataSource dataSource(){ DruidDataSource datasource = new DruidDataSource(); datasource.setUrl(this.dbUrl); datasource.setUsername(username); datasource.setPassword(password); datasource.setDriverClassName(driverClassName); //configuration datasource.setInitialSize(initialSize); datasource.setMinIdle(minIdle); datasource.setMaxActive(maxActive); datasource.setMaxWait(maxWait); datasource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis); datasource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis); datasource.setValidationQuery(validationQuery); datasource.setTestWhileIdle(testWhileIdle); datasource.setTestOnBorrow(testOnBorrow); datasource.setTestOnReturn(testOnReturn); datasource.setPoolPreparedStatements(poolPreparedStatements); datasource.setMaxPoolPreparedStatementPerConnectionSize(maxPoolPreparedStatementPerConnectionSize); try { datasource.setFilters(filters); } catch (SQLException e) { logger.error("druid configuration initialization filter", e); } datasource.setConnectionProperties(connectionProperties); return datasource; } @Bean public ServletRegistrationBean druidServlet() { ServletRegistrationBean reg = new ServletRegistrationBean(); reg.setServlet(new StatViewServlet()); reg.addUrlMappings("/druid/*"); reg.addInitParameter("allow", "127.0.0.1,192.168.1.83"); //白名单 reg.addInitParameter("deny",""); //黑名单 reg.addInitParameter("loginUsername", "admin");//查看监控的用户名 reg.addInitParameter("loginPassword", "nimda");//密码 return reg; } @Bean public FilterRegistrationBean filterRegistrationBean() { FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(); filterRegistrationBean.setFilter(new WebStatFilter()); filterRegistrationBean.addUrlPatterns("/*"); filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*"); return filterRegistrationBean; }}
四、启动测试
登录后
正文到此结束,谢谢观看,觉得有用,点个赞再走可好!!!
我的博客:http://www.lrshuai.top/blog
阅读全文
0 0
- Spring Boot (八):配置Druid 连接池
- spring boot 配置druid连接池
- Spring Boot配置druid连接池
- Spring Boot下Druid连接池的使用配置分析
- Spring Boot下Druid连接池的使用配置分析
- spring-boot 连接池 druid 的配置及监控
- spring boot 学习(四)Druid连接池的使用配置
- Spring Boot下Druid连接池的使用配置分析
- spring boot 学习(四)Druid连接池的使用配置
- spring boot集成druid连接池
- spring boot 配置druid数据源
- Spring Boot 配置Druid数据源
- spring boot配置druid(德鲁伊)
- spring-boot整合druid配置
- Spring boot 配置Druid DataSource
- Druid连接池在spring中的配置
- Spring+Druid连接池简单入门配置
- Druid控制页面配置《Spring连接池》
- shell编程中eval的原理和应用
- ABAP: Excel
- ubuntu16.04+GTX1080ti+Tensorflow 深度学习环境搭建
- Linux CFS中的进程调度
- java.sql.BatchUpdateException
- Spring Boot (八):配置Druid 连接池
- Linux 基础学习篇4
- Git工具将代码上传至GitHub界面或者远端服务器
- javascript知识积累
- Python 命令行参数
- 统一管理所有随机启动的应用程序
- 《设计模式——java版》(三)
- 多媒体应用之简单拍摄照片
- 使用API控制连接到OneNET的物联网设备