springboot整合druid数据连接池 拼搏现实的明天。 2022-05-15 07:57 255阅读 0赞 第一步:导入所需要的jar吧 <dependency> <groupId>com.oracle</groupId> <artifactId>ojdbc8</artifactId> <version>12.1.0.2</version> </dependency> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.1.10</version> </dependency> 第二步:配置application.properties文件 spring.datasource.url=数据库连接 spring.datasource.username=数据库账户 spring.datasource.password=数据库密码 spring.datasource.type=com.alibaba.druid.pool.DruidDataSource spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver # 下面为连接池的补充设置,应用到上面所有数据源中 # 初始化大小,最小,最大 spring.datasource.initialSize=5 spring.datasource.minIdle=5 spring.datasource.maxActive=20 # 配置获取连接等待超时的时间 spring.datasource.maxWait=60000 # 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 spring.datasource.timeBetweenEvictionRunsMillis=60000 # 配置一个连接在池中最小生存的时间,单位是毫秒 spring.datasource.minEvictableIdleTimeMillis=300000 spring.datasource.validationQuery=SELECT 1 FROM DUAL spring.datasource.testWhileIdle=true spring.datasource.testOnBorrow=false spring.datasource.testOnReturn=false # 打开PSCache,并且指定每个连接上PSCache的大小 spring.datasource.poolPreparedStatements=true spring.datasource.maxPoolPreparedStatementPerConnectionSize=20 # 配置监控统计拦截的filters,去掉后监控界面sql无法统计,'wall'用于防火墙 spring.datasource.filters=stat,wall,log4j # 通过connectProperties属性来打开mergeSql功能;慢SQL记录 spring.datasource.connectionProperties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000 # 合并多个DruidDataSource的监控数据 spring.datasource.useGlobalDataSourceStat=true 第三步:编写config做一个filter监听 package com.example.demo.config; import com.alibaba.druid.pool.DruidDataSource; import com.alibaba.druid.support.http.StatViewServlet; import com.alibaba.druid.support.http.WebStatFilter; 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.Configuration; import javax.sql.DataSource; import java.util.Arrays; import java.util.HashMap; import java.util.Map; /** * @作者 Administrator * @创建日期 2018/8/27 0027 * @创建时间 11:28. */ @Configuration public class DruidConfig { @Bean public ServletRegistrationBean statViewServlet() { ServletRegistrationBean druid = new ServletRegistrationBean(); druid.setServlet(new StatViewServlet()); druid.setUrlMappings(Arrays.asList("/druid/*")); /* Map<String,String> params = new HashMap<>(); params.put("loginUsername", "admin"); params.put("loginPassword", "admin"); druid.setInitParameters(params);*/ return druid; } /** * @see WebStatFilter * @return */ @Bean public FilterRegistrationBean webStatFilter(){ FilterRegistrationBean fitler = new FilterRegistrationBean(); fitler.setFilter(new WebStatFilter()); fitler.setUrlPatterns(Arrays.asList("/*")); fitler.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*"); return fitler; } } 最后就可以访问[http://localhost:8080/druid/][http_localhost_8080_druid]了 [http_localhost_8080_druid]: http://localhost:8080/druid/
还没有评论,来说两句吧...