Spring整合阿里巴巴开源数据源Druid

r囧r小猫 2022-08-10 13:53 283阅读 0赞

1.web.xml中的配置

<filter>
        <filter-name>druidWebStat</filter-name>
        <filter-class>com.alibaba.druid.support.http.WebStatFilter</filter-class>
        <init-param>
          <param-name>exclusions</param-name>
          <param-value>/css/*,/style/*,/jslib/*,*.js,*.css,/druid*,/attached/*,/uploadFile/*,*.jsp</param-value>
        </init-param>
        <init-param>
          <param-name>principalSessionName</param-name>
          <param-value>sessionInfo</param-value>
        </init-param>
      </filter>
      <filter-mapping>
        <filter-name>druidWebStat</filter-name>
        <url-pattern>/*</url-pattern>
      </filter-mapping>
     
     
      <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>false</param-value>
        </init-param>
      </servlet>
      <servlet-mapping>
        <servlet-name>druidStatView</servlet-name>
        <url-pattern>/druid/*</url-pattern>
      </servlet-mapping>

2.spring.xml中的配置数据源

<bean name="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
    		init-method="init" destroy-method="close">
    		
    		<property name="driverClassName" value="${driverClassName}" />
    		<property name="url" value="${jdbc_url}" />
    		<property name="username" value="${jdbc_username}" />
    		<property name="password" value="${jdbc_password}" />
    
    		
    		<property name="initialSize" value="0" />
    		
    		<property name="maxActive" value="20" />
    		
    		<property name="minIdle" value="0" />
    		
    		<property name="maxWait" value="60000" />
    
    		
    
    		<property name="validationQuery" value="${validationQuery}" />
    		
    		<property name="testOnBorrow" value="false" />
    		<property name="testOnReturn" value="false" />
    		<property name="testWhileIdle" value="true" />
    
    		
    		<property name="timeBetweenEvictionRunsMillis" value="60000" />
    		
    		<property name="minEvictableIdleTimeMillis" value="25200000" />
    
    		
    		<property name="removeAbandoned" value="true" />
    		
    		<property name="removeAbandonedTimeout" value="1800" />
    		
    		<property name="logAbandoned" value="true" />
    
    		
    		
    		
    		<property name="filters" value="stat,config" />
    
    		
    		
    	</bean>

3.配置Spring和Jdbc的关联监控

<bean id="druid-stat-interceptor"
    		class="com.alibaba.druid.support.spring.stat.DruidStatInterceptor" />
    
    	<bean id="druid-stat-pointcut" class="org.springframework.aop.support.JdkRegexpMethodPointcut"
    		scope="prototype">
    		<property name="patterns">
    			<list>
    				<value>gx.service.*</value>
    			</list>
    		</property>
    	</bean>
    	<aop:config>
    		<aop:advisor advice-ref="druid-stat-interceptor"
    			pointcut-ref="druid-stat-pointcut" />
    	</aop:config>

4.当然咯，还有jar包下载地址

*  正式版本下载：  
    maven中央仓库: [ http://central.maven.org/maven2/com/alibaba/druid/][http_central.maven.org_maven2_com_alibaba_druid]  
    Alibaba开源下载: [ http://code.alibabatech.com/mvn/releases/com/alibaba/druid/][http_code.alibabatech.com_mvn_releases_com_alibaba_druid]
 *  快照版本下载

[http://code.alibabatech.com/mvn/snapshots/com/alibaba/druid/][http_code.alibabatech.com_mvn_snapshots_com_alibaba_druid]

5.好啦，现在我们来看看效果

![Center][]

![Center 1][]

6.还有其他的页面，我就不展示了，自己动手搭起来看看啦，哈哈

[http_central.maven.org_maven2_com_alibaba_druid]: http://www.html580.com/?I16qwy0i
[http_code.alibabatech.com_mvn_releases_com_alibaba_druid]: http://www.html580.com/?r6wMpeqd
[http_code.alibabatech.com_mvn_snapshots_com_alibaba_druid]: http://www.html580.com/?U5TtUcES
[Center]: /images/20220810/4e3c2e8bcf31457d9cc53d633ff7b3d4.png
[Center 1]: /images/20220810/71eba4b0a9534a588c8b9e29d0f4440e.png