阿里Druid - 为监控而生的数据库连接池的使用

今天药忘吃喽~ 2023-05-22 05:00 25阅读 0赞

【官方项目地址】

项目github：[https://github.com/alibaba/druid][https_github.com_alibaba_druid]

[https://github.com/alibaba/druid/tree/master/druid-spring-boot-starter][https_github.com_alibaba_druid_tree_master_druid-spring-boot-starter]

官方wiki：[https://github.com/alibaba/druid/wiki/][https_github.com_alibaba_druid_wiki]

常见问题(包括配置)：[https://github.com/alibaba/druid/wiki/常见问题][https_github.com_alibaba_druid_wiki 1]

参考配置：[https://github.com/alibaba/druid/wiki/DruidDataSource配置][https_github.com_alibaba_druid_wiki_DruidDataSource]

【普通web项目使用配置】

1.引入依赖

<dependency>
         <groupId>com.alibaba</groupId>
         <artifactId>druid</artifactId>
         <version>1.1.16</version>
    </dependency>

或者springboot版本依赖：

<dependency>
       <groupId>com.alibaba</groupId>
       <artifactId>druid-spring-boot-starter</artifactId>
       <version>1.1.17</version>
    </dependency>

2.集成spring 配置

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
           xmlns:context="http://www.springframework.org/schema/context"
           xmlns:aop="http://www.springframework.org/schema/aop"
           xmlns:tx="http://www.springframework.org/schema/tx"
           xsi:schemaLocation="http://www.springframework.org/schema/beans
                 http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
                 http://www.springframework.org/schema/context
                 http://www.springframework.org/schema/context/spring-context-4.3.xsd
                  http://www.springframework.org/schema/aop
                  http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
                  http://www.springframework.org/schema/tx
                  http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">
        
        <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
            <property name="location" value="classpath:jdbc.properties"/>
        </bean>
        
        
        <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init"
              destroy-method="close">
    
            <property name="driverClassName" value="${jdbc.driver}"/>
            <property name="url" value="${jdbc.url}"/>
            <property name="username" value="${jdbc.username}"/>
            <property name="password" value="${jdbc.password}"/>
    
            
            <property name="filters" value="stat,wall,log4j"/>
            
            <property name="initialSize" value="1"/>
            <property name="minIdle" value="10"/>
            <property name="maxActive" value="20"/>
            
            <property name="maxWait" value="60000"/>
    
            
            <property name="timeBetweenEvictionRunsMillis" value="60000"/>
            
            <property name="minEvictableIdleTimeMillis" value="300000"/>
    
            
            <property name="validationQuery" value="SELECT 'x'" />
            
            <property name="testWhileIdle" value="true"/>
            
            <property name="testOnBorrow" value="false"/>
            
            <property name="testOnReturn" value="false"/>
    
            
            <property name="poolPreparedStatements" value="true"/>
            <property name="maxOpenPreparedStatements" value="20"/>
            
            <property name="asyncInit" value="true" />
        </bean>
    
    
    </beans>

3.监控相关配置

\# web.xml配置

<filter>
      	<filter-name>DruidWebStatFilter</filter-name>
      	<filter-class>com.alibaba.druid.support.http.WebStatFilter</filter-class>
      	<init-param>
      		<param-name>exclusions</param-name>
      		<param-value>*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*</param-value>
      	</init-param>
      </filter>
      <filter-mapping>
      	<filter-name>DruidWebStatFilter</filter-name>
      	<url-pattern>/*</url-pattern>
      </filter-mapping>

更多详细配置见：[https://github.com/alibaba/druid/wiki/配置\_配置WebStatFilter][https_github.com_alibaba_druid_wiki_WebStatFilter]

\# 配置Druid和Spring关联监控配置

<bean id="druid-stat-interceptor"
      	class="com.alibaba.druid.support.spring.stat.DruidStatInterceptor">
      </bean>
      
      <bean id="druid-type-proxyCreator" class="com.alibaba.druid.support.spring.stat.BeanTypeAutoProxyCreator">
      	
      	<property name="targetBeanType" value="xxxx.ABCInterface" />
      	<property name="interceptorNames">
      		<list>
      			<value>druid-stat-interceptor</value>
      		</list>
      	</property>
      </bean>

更多详细配置见：[https://github.com/alibaba/druid/wiki/配置\_Druid和Spring关联监控配置][https_github.com_alibaba_druid_wiki_Druid_Spring]

4.使用Druid的内置监控页面配置：StatViewServlet

\#web.xml

<servlet>  
        <servlet-name>DruidStatView</servlet-name>  
        <servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class>  
        <init-param>  
    	  
    	<param-name>resetEnable</param-name>  
    	<param-value>true</param-value>  
        </init-param>  
        <init-param>  
    	  
    	<param-name>loginUsername</param-name>  
    	<param-value>druid</param-value>  
        </init-param>  
        <init-param>  
    	  
    	<param-name>loginPassword</param-name>  
    	<param-value>druid</param-value>  
        </init-param>  
    </servlet>  
    
    <servlet-mapping>  
        <servlet-name>DruidStatView</servlet-name>  
        <url-pattern>/druid/*</url-pattern>  
    </servlet-mapping>

更多详细配置见： [https://github.com/alibaba/druid/wiki/配置\_StatViewServlet配置][https_github.com_alibaba_druid_wiki_StatViewServlet]

[https_github.com_alibaba_druid]: https://github.com/alibaba/druid
[https_github.com_alibaba_druid_tree_master_druid-spring-boot-starter]: https://github.com/alibaba/druid/tree/master/druid-spring-boot-starter
[https_github.com_alibaba_druid_wiki]: https://github.com/alibaba/druid/wiki/
[https_github.com_alibaba_druid_wiki 1]: https://github.com/alibaba/druid/wiki/%E5%B8%B8%E8%A7%81%E9%97%AE%E9%A2%98
[https_github.com_alibaba_druid_wiki_DruidDataSource]: https://github.com/alibaba/druid/wiki/DruidDataSource%E9%85%8D%E7%BD%AE
[https_github.com_alibaba_druid_wiki_WebStatFilter]: https://github.com/alibaba/druid/wiki/%E9%85%8D%E7%BD%AE_%E9%85%8D%E7%BD%AEWebStatFilter
[https_github.com_alibaba_druid_wiki_Druid_Spring]: https://github.com/alibaba/druid/wiki/%E9%85%8D%E7%BD%AE_Druid%E5%92%8CSpring%E5%85%B3%E8%81%94%E7%9B%91%E6%8E%A7%E9%85%8D%E7%BD%AE
[https_github.com_alibaba_druid_wiki_StatViewServlet]: https://github.com/alibaba/druid/wiki/%E9%85%8D%E7%BD%AE_StatViewServlet%E9%85%8D%E7%BD%AE