当前位置： 首页 > news >正文

做微商童装网站,公司形象vi设计,商城网站主要内容,网站流量如何做文章目录 前言一、启动器二、配置1.JDBC 配置2.连接池配置3. 监控配置 三、配置多数据源1. 添加配置2. 创建数据源 四、配置 Filter1. 配置Filter2. 可配置的Filter 五、获取 Druid 的监控数据六、案例1. 问题2. 引入库3. 配置4. 配置类5. 测试类6. 测试结果 七、案例 ( 推荐 )… 文章目录 前言一、启动器二、配置1.JDBC 配置2.连接池配置3. 监控配置 三、配置多数据源1. 添加配置2. 创建数据源 四、配置 Filter1. 配置Filter2. 可配置的Filter 五、获取 Druid 的监控数据六、案例1. 问题2. 引入库3. 配置4. 配置类5. 测试类6. 测试结果 七、案例 ( 推荐 ) \color{#00FF00}{(推荐)} (推荐)1. 引入库2. 配置3. 测试类4. 测试结果 总结 前言 Druid是Java语言中最好的数据库连接池。Druid能够提供强大的监控和扩展功能。 一、启动器 Druid Spring Boot Starter 用于帮助你在Spring Boot项目中轻松集成Druid数据库连接池和监控。 !– https://mvnrepository.com/artifact/com.alibaba/druid-spring-boot-starter – dependencygroupIdcom.alibaba/groupIdartifactIddruid-spring-boot-starter/artifactIdversion1.2.22/version /dependency二、配置 1.JDBC 配置 spring.datasource.druid.url # 或spring.datasource.url spring.datasource.druid.username # 或spring.datasource.username spring.datasource.druid.password # 或spring.datasource.password spring.datasource.druid.driver-class-name #或 spring.datasource.driver-class-name2.连接池配置 spring.datasource.druid.initial-size spring.datasource.druid.max-active spring.datasource.druid.min-idle spring.datasource.druid.max-wait spring.datasource.druid.pool-prepared-statements spring.datasource.druid.max-pool-prepared-statement-per-connection-size spring.datasource.druid.max-open-prepared-statements #和上面的等价 spring.datasource.druid.validation-query spring.datasource.druid.validation-query-timeout spring.datasource.druid.test-on-borrow spring.datasource.druid.test-on-return spring.datasource.druid.test-while-idle spring.datasource.druid.time-between-eviction-runs-millis spring.datasource.druid.min-evictable-idle-time-millis spring.datasource.druid.max-evictable-idle-time-millis spring.datasource.druid.filters #配置多个英文逗号分隔 ….//more3. 监控配置

WebStatFilter配置说明请参考Druid Wiki配置_配置WebStatFilter

spring.datasource.druid.web-stat-filter.enabled #是否启用StatFilter默认值false spring.datasource.druid.web-stat-filter.url-pattern spring.datasource.druid.web-stat-filter.exclusions spring.datasource.druid.web-stat-filter.session-stat-enable spring.datasource.druid.web-stat-filter.session-stat-max-count spring.datasource.druid.web-stat-filter.principal-session-name spring.datasource.druid.web-stat-filter.principal-cookie-name spring.datasource.druid.web-stat-filter.profile-enable# StatViewServlet配置说明请参考Druid Wiki配置_StatViewServlet配置 spring.datasource.druid.stat-view-servlet.enabled #是否启用StatViewServlet监控页面默认值为false考虑到安全问题默认并未启动如需启用建议设置密码或白名单以保障安全 spring.datasource.druid.stat-view-servlet.url-pattern spring.datasource.druid.stat-view-servlet.reset-enable spring.datasource.druid.stat-view-servlet.login-username spring.datasource.druid.stat-view-servlet.login-password spring.datasource.druid.stat-view-servlet.allow spring.datasource.druid.stat-view-servlet.deny# Spring监控配置说明请参考Druid Github Wiki配置_Druid和Spring关联监控配置 spring.datasource.druid.aop-patterns # Spring监控AOP切入点如x.y.z.service.*,配置多个英文逗号分隔三、配置多数据源

1. 添加配置 spring.datasource.url spring.datasource.username spring.datasource.password# Druid 数据源配置继承spring.datasource.* 配置相同则覆盖 … spring.datasource.druid.initial-size5 spring.datasource.druid.max-active5 …# Druid 数据源 1 配置继承spring.datasource.druid.* 配置相同则覆盖 … spring.datasource.druid.one.max-active10 spring.datasource.druid.one.max-wait10000 …# Druid 数据源 2 配置继承spring.datasource.druid.* 配置相同则覆盖 … spring.datasource.druid.two.max-active20 spring.datasource.druid.two.max-wait20000 …2. 创建数据源 Primary Bean ConfigurationProperties(spring.datasource.druid.one) public DataSource dataSourceOne(){return DruidDataSourceBuilder.create().build(); } Bean ConfigurationProperties(spring.datasource.druid.two) public DataSource dataSourceTwo(){return DruidDataSourceBuilder.create().build(); }四、配置 Filter
2. 配置Filter 你可以通过 spring.datasource.druid.filtersstat,wall,log4j … 的方式来启用相应的内置Filter不过这些Filter都是默认配置。如果默认配置不能满足你的需求你可以放弃这种方式通过配置文件来配置Filter下面是例子。 # 配置StatFilter spring.datasource.druid.filter.stat.enabledtrue spring.datasource.druid.filter.stat.db-typeh2 spring.datasource.druid.filter.stat.log-slow-sqltrue spring.datasource.druid.filter.stat.slow-sql-millis2000# 配置WallFilter spring.datasource.druid.filter.wall.enabledtrue spring.datasource.druid.filter.wall.db-typeh2 spring.datasource.druid.filter.wall.config.delete-allowfalse spring.datasource.druid.filter.wall.config.drop-table-allowfalse# 其他 Filter 配置不再演示2. 可配置的Filter 目前为以下 Filter 提供了配置支持请参考文档或者根据IDE提示spring.datasource.druid.filter.*进行配置。 StatFilterWallFilterConfigFilterEncodingConvertFilterSlf4jLogFilterLog4jFilterLog4j2FilterCommonsLogFilter 要想使自定义 Filter 配置生效需要将对应 Filter 的 enabled 设置为 true Druid Spring Boot Starter 默认禁用 StatFilter你也可以将其 enabled 设置为 true 来启用它。 五、获取 Druid 的监控数据 Druid 的监控数据可以在开启 StatFilter 后通过 DruidStatManagerFacade 进行获取获取到监控数据之后你可以将其暴露给你的监控系统进行使用。Druid 默认的监控系统数据也来源于此。下面给做一个简单的演示在 Spring Boot 中如何通过 HTTP 接口将 Druid 监控数据以 JSON 的形式暴露出去实际使用中你可以根据你的需要自由地对监控数据、暴露方式进行扩展。 RestController public class DruidStatController {GetMapping(/druid/stat)public Object druidStat(){// DruidStatManagerFacade#getDataSourceStatDataList 该方法可以获取所有数据源的监控数据除此之外 DruidStatManagerFacade 还提供了一些其他方法你可以按需选择使用。return DruidStatManagerFacade.getInstance().getDataSourceStatDataList();} }[{Identity: 1583082378,Name: DataSource-1583082378,DbType: h2,DriverClassName: org.h2.Driver,URL: jdbc:h2:file:./demo-db,UserName: sa,FilterClassNames: [com.alibaba.druid.filter.stat.StatFilter],WaitThreadCount: 0,NotEmptyWaitCount: 0,NotEmptyWaitMillis: 0,PoolingCount: 2,PoolingPeak: 2,PoolingPeakTime: 1533782955104,ActiveCount: 0,ActivePeak: 1,ActivePeakTime: 1533782955178,InitialSize: 2,MinIdle: 2,MaxActive: 30,QueryTimeout: 0,TransactionQueryTimeout: 0,LoginTimeout: 0,ValidConnectionCheckerClassName: null,ExceptionSorterClassName: null,TestOnBorrow: true,TestOnReturn: true,TestWhileIdle: true,DefaultAutoCommit: true,DefaultReadOnly: null,DefaultTransactionIsolation: null,LogicConnectCount: 103,LogicCloseCount: 103,LogicConnectErrorCount: 0,PhysicalConnectCount: 2,PhysicalCloseCount: 0,PhysicalConnectErrorCount: 0,ExecuteCount: 102,ErrorCount: 0,CommitCount: 100,RollbackCount: 0,PSCacheAccessCount: 100,PSCacheHitCount: 99,PSCacheMissCount: 1,StartTransactionCount: 100,TransactionHistogram: [55,44,1,0,0,0,0],ConnectionHoldTimeHistogram: [53,47,3,0,0,0,0,0],RemoveAbandoned: false,ClobOpenCount: 0,BlobOpenCount: 0,KeepAliveCheckCount: 0,KeepAlive: false,FailFast: false,MaxWait: 1234,MaxWaitThreadCount: -1,PoolPreparedStatements: true,MaxPoolPreparedStatementPerConnectionSize: 5,MinEvictableIdleTimeMillis: 30001,MaxEvictableIdleTimeMillis: 25200000,LogDifferentThread: true,RecycleErrorCount: 0,PreparedStatementOpenCount: 1,PreparedStatementClosedCount: 0,UseUnfairLock: true,InitGlobalVariants: false,InitVariants: false} ]六、案例
3. 问题 在1.2.13快照版及之后的版本都会去查找一个\({project.version}的属性导致我druid的包一直没有下载下来 就算切换到之前的版本自动注入也无法生效SpringBoot3是已经确定的大版本所以我们只能放弃对start的使用。 parentgroupIdcom.alibaba/groupIdartifactIddruid-parent/artifactIdversion1.2.23-SNAPSHOT/versionrelativePath../pom.xml/relativePath /parent artifactIddruid-spring-boot-3-starter/artifactId也可能是版本问题官方的下一个版本1.2.23-SNAPSHOT才能匹配springboot3版本。 2. 引入库 由于上面的问题我们只能使用spring常规的使用方式但是和mvc中可能会略有区别。 propertiesjava.version17/java.versionspring.version6.1.6/spring.versionspringboo.version3.2.5/springboo.version /propertiesdependencygroupIdorg.springframework/groupIdartifactIdspring-jdbc/artifactIdversion\){spring.version}/version /dependency dependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdversion8.0.19/version /dependency dependencygroupIdcom.alibaba/groupIdartifactIddruid/artifactIdversion1.2.22/version /dependency3. 配置 spring:application:name: spring-boot3#druiddatasource:#type: com.alibaba.druid.pool.DruidDataSourcedruid:driver-class-name: com.mysql.cj.jdbc.Driverurl: jdbc:mysql://localhost:3306/springboot?useUnicodetruecharacterEncodingUTF-8useSSLfalseserverTimezoneGMT%2B8allowPublicKeyRetrievaltrueusername: rootpassword: 123456a?initial-size: 5max-active: 20max-wait: 60000min-idle: 34. 配置类 package org.example.springboot3.druid.config;import com.alibaba.druid.pool.DruidDataSource; import org.springframework.boot.context.properties.ConfigurationProperties; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration;import javax.sql.DataSource;/*** Create by zjg on 2024/5/19*/ Configuration public class DruidConfig {BeanConfigurationProperties(spring.datasource.druid)public DataSource dataSource(){return new DruidDataSource();} }
4. 测试类 package org.example.springboot3.druid.controller;import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import javax.sql.DataSource; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement;/*** Create by zjg on 2024/5/19*/ RestController RequestMapping(/druid/) public class DruidController {AutowiredDataSource dataSource;RequestMapping(001)public String druid001() throws SQLException {Connection connection dataSource.getConnection();Statement statement connection.createStatement();ResultSet resultSet statement.executeQuery(select 1 from dual);String result null;if(resultSet.next()){resultresultSet.getString(1);}statement.close();connection.close();return result;} }
5. 测试结果 1单独使用最新的1.2.22版本是没有问题的。 七、案例 ( 推荐 ) \color{#00FF00}{(推荐)} (推荐) 昨天写了这篇文章之后感觉没有把最好的带给家人们经过一晚上的不断阅读诸佬的经典总算找到了druid对springboot支持的starter可能是阿里的哥哥们太忙了官方文档是一点介绍没有啊 1. 引入库 dependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdversion8.0.19/version /dependency !– https://mvnrepository.com/artifact/com.alibaba/druid-spring-boot-3-starter – dependencygroupIdcom.alibaba/groupIdartifactIddruid-spring-boot-3-starter/artifactIdversion1.2.22/version /dependency2. 配置 spring:application:name: spring-boot3#druiddatasource:#type: com.alibaba.druid.pool.DruidDataSourcedruid:driver-class-name: com.mysql.cj.jdbc.Driverurl: jdbc:mysql://localhost:3306/springboot?useUnicodetruecharacterEncodingUTF-8useSSLfalseserverTimezoneGMT%2B8allowPublicKeyRetrievaltrueusername: rootpassword: 123456a?initial-size: 5max-active: 20max-wait: 60000min-idle: 33. 测试类 package org.example.springboot3.druid.controller;import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import javax.sql.DataSource; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement;/*** Create by zjg on 2024/5/19*/ RestController RequestMapping(/druid/) public class DruidController {AutowiredDataSource dataSource;RequestMapping(001)public String druid001() throws SQLException {Connection connection dataSource.getConnection();Statement statement connection.createStatement();ResultSet resultSet statement.executeQuery(select 1 from dual);String result null;if(resultSet.next()){resultresultSet.getString(1);}statement.close();connection.close();return result;} }
6. 测试结果 1总结 回到顶部 源码仓库 中文文档 Druid Spring Boot Starter 更多内容请参考 【第5章】spring命名空间和数据源的引入 【第21章】spring-mvc之整合druid 推荐大家使用starter的案例。