druid的springmvc配置和java jdbc配置

女爷i 2022-06-15 06:37 246阅读 0赞

[Java][]程序很大一部分要操作[数据库][Link 1]，为了提高性能操作数据库的时候，有不得不使用数据库连接池。数据库连接池有很多选择，c3p、dhcp、proxool等，druid作为一名后起之秀，凭借其出色的性能，也逐渐印入了大家的眼帘。接下来本教程就说一下druid的简单使用。

首先从 [http://repo1.maven.org/maven2/com/alibaba/druid/][http_repo1.maven.org_maven2_com_alibaba_druid] 下载最新的jar包。如果想使用最新的源码编译，可以从 [https://github.com/alibaba/druid][https_github.com_alibaba_druid] 下载源码，然后使用maven命令行，或者导入到eclipse中进行编译。

和dbcp类似，druid的配置项如下

<table style="font-size:14px; max-width:100%; background-color:rgb(254,254,254); border-spacing:0px; width:605px; margin-bottom:1.5em; border-width:1px 1px 1px 0px; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-color:rgb(221,221,221); border-right-color:rgb(221,221,221); border-bottom-color:rgb(221,221,221); line-height:1.3em; color:rgb(51,51,51); font-family:&quot;Helvetica Neue&quot;,Helvetica,Tahoma,Arial,STXihei,&quot;Microsoft YaHei&quot;,微软雅黑,sans-serif"> 
 <tbody> 
 <tr style="line-height:1.3em"> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top-width:0px; border-left:1px solid rgb(221,221,221); font-size:14px"> 配置</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top-width:0px; border-left:1px solid rgb(221,221,221); font-size:14px"> 缺省值</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top-width:0px; border-left:1px solid rgb(221,221,221); font-size:14px"> 说明</td> 
 </tr> 
 <tr style="line-height:1.3em"> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> name</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> &nbsp;</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> 配置这个属性的意义在于，如果存在多个数据源，监控的时候&nbsp; 可以通过名字来区分开来。如果没有配置，将会生成一个名字，&nbsp; 格式是："DataSource-" + System.identityHashCode(this)</td> 
 </tr> 
 <tr style="line-height:1.3em"> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> jdbcUrl</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> &nbsp;</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> 连接数据库的url，不同数据库不一样。例如：&nbsp; mysql : jdbc:mysql://10.20.153.104:3306/druid2&nbsp;&nbsp; oracle : jdbc:oracle:thin:@10.20.149.85:1521:ocnauto</td> 
 </tr> 
 <tr style="line-height:1.3em"> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> username</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> &nbsp;</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> 连接数据库的用户名</td> 
 </tr> 
 <tr style="line-height:1.3em"> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> password</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> &nbsp;</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> 连接数据库的密码。如果你不希望密码直接写在配置文件中，&nbsp; 可以使用ConfigFilter。详细看这里：&nbsp; <a href="https://github.com/alibaba/druid/wiki/%E4%BD%BF%E7%94%A8ConfigFilter" style="color:rgb(202,0,0)" rel="nofollow">https://github.com/alibaba/druid/wiki/%E4%BD%BF%E7%94%A8ConfigFilter</a></td> 
 </tr> 
 <tr style="line-height:1.3em"> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> driverClassName</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> 根据url自动识别</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> 这一项可配可不配，如果不配置druid会根据url自动识别dbType，然后选择相应的driverClassName</td> 
 </tr> 
 <tr style="line-height:1.3em"> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> initialSize</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> 0</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> 初始化时建立物理连接的个数。初始化发生在显示调用init方法，或者第一次getConnection时</td> 
 </tr> 
 <tr style="line-height:1.3em"> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> maxActive</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> 8</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> 最大连接池数量</td> 
 </tr> 
 <tr style="line-height:1.3em"> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> maxIdle</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> 8</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> 已经不再使用，配置了也没效果</td> 
 </tr> 
 <tr style="line-height:1.3em"> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> minIdle</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> &nbsp;</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> 最小连接池数量</td> 
 </tr> 
 <tr style="line-height:1.3em"> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> maxWait</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> &nbsp;</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> 获取连接时最大等待时间，单位毫秒。配置了maxWait之后，&nbsp; 缺省启用公平锁，并发效率会有所下降，&nbsp; 如果需要可以通过配置useUnfairLock属性为true使用非公平锁。</td> 
 </tr> 
 <tr style="line-height:1.3em"> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> poolPreparedStatements</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> false</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> 是否缓存preparedStatement，也就是PSCache。&nbsp; PSCache对支持游标的数据库性能提升巨大，比如说oracle。&nbsp; 在mysql5.5以下的版本中没有PSCache功能，建议关闭掉。 作者在5.5版本中使用PSCache，通过监控界面发现PSCache有缓存命中率记录，&nbsp; 该应该是支持PSCache。</td> 
 </tr> 
 <tr style="line-height:1.3em"> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> maxOpenPreparedStatements</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> -1</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> 要启用PSCache，必须配置大于0，当大于0时，&nbsp; poolPreparedStatements自动触发修改为true。&nbsp; 在Druid中，不会存在Oracle下PSCache占用内存过多的问题，&nbsp; 可以把这个数值配置大一些，比如说100</td> 
 </tr> 
 <tr style="line-height:1.3em"> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> validationQuery</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> &nbsp;</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> 用来检测连接是否有效的sql，要求是一个查询语句。&nbsp; 如果validationQuery为null，testOnBorrow、testOnReturn、&nbsp; testWhileIdle都不会其作用。</td> 
 </tr> 
 <tr style="line-height:1.3em"> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> testOnBorrow</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> true</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> 申请连接时执行validationQuery检测连接是否有效，做了这个配置会降低性能。</td> 
 </tr> 
 <tr style="line-height:1.3em"> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> testOnReturn</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> false</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> 归还连接时执行validationQuery检测连接是否有效，做了这个配置会降低性能</td> 
 </tr> 
 <tr style="line-height:1.3em"> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> testWhileIdle</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> false</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> 建议配置为true，不影响性能，并且保证安全性。&nbsp; 申请连接的时候检测，如果空闲时间大于&nbsp; timeBetweenEvictionRunsMillis，&nbsp; 执行validationQuery检测连接是否有效。</td> 
 </tr> 
 <tr style="line-height:1.3em"> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> timeBetweenEvictionRunsMillis</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> &nbsp;</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> 有两个含义：&nbsp; 1) Destroy线程会检测连接的间隔时间&nbsp; 2) testWhileIdle的判断依据，详细看testWhileIdle属性的说明</td> 
 </tr> 
 <tr style="line-height:1.3em"> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> numTestsPerEvictionRun</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> &nbsp;</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> 不再使用，一个DruidDataSource只支持一个EvictionRun</td> 
 </tr> 
 <tr style="line-height:1.3em"> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> minEvictableIdleTimeMillis</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> &nbsp;</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> &nbsp;</td> 
 </tr> 
 <tr style="line-height:1.3em"> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> connectionInitSqls</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> &nbsp;</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> 物理连接初始化的时候执行的sql</td> 
 </tr> 
 <tr style="line-height:1.3em"> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> exceptionSorter</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> 根据dbType自动识别</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> 当数据库抛出一些不可恢复的异常时，抛弃连接</td> 
 </tr> 
 <tr style="line-height:1.3em"> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> filters</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> &nbsp;</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> 属性类型是字符串，通过别名的方式配置扩展插件，&nbsp; 常用的插件有：&nbsp; 监控统计用的filter:stat&nbsp;&nbsp; 日志用的filter:log4j&nbsp; 防御sql注入的filter:wall</td> 
 </tr> 
 <tr style="line-height:1.3em"> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> proxyFilters</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> &nbsp;</td> 
 <td style="padding:8px; line-height:1.3em; vertical-align:top; border-top:1px solid rgb(221,221,221); border-left:1px solid rgb(221,221,221); font-size:14px"> 类型是List&lt;com.alibaba.druid.filter.Filter&gt;，&nbsp; 如果同时配置了filters和proxyFilters，&nbsp; 是组合关系，并非替换关系</td> 
 </tr> 
 </tbody> 
</table>

#### 表1.1 配置属性 ####

加入 druid-1.0.9.jar

ApplicationContext.xml

**\[html\]**  [view plain][]   [copy][view plain]

1. **<** **bean** name = "transactionManager" class ="org.springframework.jdbc.datasource.DataSourceTransactionManager" **>**     
2.     **<** **property** name = "dataSource" ref = "dataSource" **>****</** **property** **>**  
3.      **</** **bean** **>**  
4.     **<** **bean** id = "propertyConfigurer" class ="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer" **>**    
5.        **<** **property** name = "locations" **>**    
6.            **<** **list** **>**    
7.                  **<** **value** **>** /WEB-INF/classes/dbconfig.properties **</** **value** **>**    
8.             **</** **list** **>**    
9.         **</** **property** **>**    
10.     **</** **bean** **>**

ApplicationContext.xml配置druid

**\[html\]**  [view plain][]   [copy][view plain]

1.   
2.   **<** **bean** id = "dataSource" class = "com.alibaba.druid.pool.DruidDataSource"destroy\-method = "close" **>**    
3.          
4.        **<** **property** name = "url" value = "$\{url\}" **/>**    
5.        **<** **property** name = "username" value = "$\{username\}" **/>**    
6.        **<** **property** name = "password" value = "$\{password\}" **/>**    
7.        **<** **property** name = "driverClassName" value = "$\{driverClassName\}" **/>**    
8.        **<** **property** name = "filters" value = "$\{filters\}" **/>**    
9.           
10.        **<** **property** name = "maxActive" value = "$\{maxActive\}" **/>**  
11.          
12.        **<** **property** name = "initialSize" value = "$\{initialSize\}" **/>**  
13.          
14.        **<** **property** name = "maxWait" value = "$\{maxWait\}" **/>**  
15.          
16.        **<** **property** name = "minIdle" value = "$\{minIdle\}" **/>**    
17.          
18.        **<** **property** name = "timeBetweenEvictionRunsMillis" value ="$\{timeBetweenEvictionRunsMillis\}" **/>**  
19.          
20.        **<** **property** name = "minEvictableIdleTimeMillis" value ="$\{minEvictableIdleTimeMillis\}" **/>**    
21.        **<** **property** name = "validationQuery" value = "$\{validationQuery\}" **/>**    
22.        **<** **property** name = "testWhileIdle" value = "$\{testWhileIdle\}" **/>**    
23.        **<** **property** name = "testOnBorrow" value = "$\{testOnBorrow\}" **/>**    
24.        **<** **property** name = "testOnReturn" value = "$\{testOnReturn\}" **/>**    
25.        **<** **property** name = "maxOpenPreparedStatements" value ="$\{maxOpenPreparedStatements\}" **/>**  
26.          
27.        **<** **property** name = "removeAbandoned" value = "$\{removeAbandoned\}" **/>**  
28.          
29.        **<** **property** name = "removeAbandonedTimeout" value ="$\{removeAbandonedTimeout\}" **/>**  
30.             
31.        **<** **property** name = "logAbandoned" value = "$\{logAbandoned\}" **/>**  
32.   **</** **bean** **>**

dbconfig.properties

**\[html\]**  [view plain][]   [copy][view plain]

1.  url: jdbc:mysql:// localhost :3306/ newm  
2.  driverClassName: com.mysql.jdbc.Driver  
3.  username: root  
4.  password: root  
5.  filters: stat  
6.  maxActive: 20  
7.  initialSize: 1  
8.  maxWait: 60000  
9.  minIdle: 10  
10. maxIdle: 15  
11. timeBetweenEvictionRunsMillis: 60000  
12. minEvictableIdleTimeMillis: 300000  
13. validationQuery: SELECT 'x'  
14. testWhileIdle: true  
15. testOnBorrow: false  
16. testOnReturn: false  
17. maxOpenPreparedStatements: 20  
18. removeAbandoned: true  
19. removeAbandonedTimeout: 1800  
20. logAbandoned: true

web.xml

**\[html\]**  [view plain][]   [copy][view plain]

1.   
2.   **<** **filter** **>**  
3.      **<** **filter-name** **>** DruidWebStatFilter **</** **filter-name** **>**  
4.      **<** **filter-class** **>** com.alibaba.druid.support.http.WebStatFilter **</** **filter-class** **>**  
5.      **<** **init-param** **>**  
6.          **<** **param-name** **>** exclusions **</** **param-name** **>**  
7.          **<** **param-value** **>** \*. js ,\*. gif ,\*. jpg ,\*. png ,\*. css ,\*. ico ,/ druid /\* **</** **param-value** **>**  
8.      **</** **init-param** **>**  
9.   **</** **filter** **>**  
10.   **<** **filter-mapping** **>**  
11.      **<** **filter-name** **>** DruidWebStatFilter **</** **filter-name** **>**  
12.      **<** **url-pattern** **>** /\* **</** **url-pattern** **>**  
13.   **</** **filter-mapping** **>**  
14.   **<** **servlet** **>**  
15.      **<** **servlet-name** **>** DruidStatView **</** **servlet-name** **>**  
16.      **<** **servlet-class** **>** com.alibaba.druid.support.http.StatViewServlet **</** **servlet-class** **>**  
17.   **</** **servlet** **>**  
18.   **<** **servlet-mapping** **>**  
19.      **<** **servlet-name** **>** DruidStatView **</** **servlet-name** **>**  
20.      **<** **url-pattern** **>** / druid /\* **</** **url-pattern** **>**  
21.   **</** **servlet-mapping** **>**  
22.

访问监控页面： http://ip:port/projectName/druid/index.html

## java jdbc 配置 ##

//打开链接
    		/**
    		 * 获取到数据库的链接
    		 * @author sen
    		 * @param 无参数
    		 * @return 返回数据库连接（Connection）
    		 * @since 2016.3.17
    		 */
    		public static Connection getConnection(){
    			Properties properties=null;
    			try {
    				properties = new Properties();
    				properties=PropertiesLoaderUtils.loadAllProperties("config.properties");
    			} catch (IOException e1) {
    				// TODO Auto-generated catch block
    				e1.printStackTrace();
    			}
    			Connection conn=null;
    			DruidDataSource ds=new DruidDataSource();
    	        ds.setDriverClassName("oracle.jdbc.OracleDriver");
    	        ds.setUrl(properties.getProperty("jdbc_url_cargo"));
    		ds.setUsername(properties.getProperty("jdbc_username_cargo"));
    		ds.setPassword(properties.getProperty("jdbc_password_cargo"));
    	        ds.setMaxActive(10); 
    	        ds.setPoolPreparedStatements(true);
    	        ds.setMaxPoolPreparedStatementPerConnectionSize(30);
    	        ds.setMaxWait(5000);
    	        ds.setTimeBetweenEvictionRunsMillis(60000);
    	        ds.setValidationQuery("select 'X' FROM DUAL");
    	        ds.setTestWhileIdle(true);
    	        ds.setTestOnBorrow(false);
    	        ds.setTestOnReturn(false);
    	      
    			try {
    				ds.setFilters("stat");//开启监控
    				conn = ds.getConnection();
    			} catch (SQLException e) {
    				
    				System.out.println(e.getMessage());

[Java]: http://lib.csdn.net/base/javase
[Link 1]: http://lib.csdn.net/base/mysql
[http_repo1.maven.org_maven2_com_alibaba_druid]: http://repo1.maven.org/maven2/com/alibaba/druid/
[https_github.com_alibaba_druid]: https://github.com/alibaba/druid
[view plain]: http://blog.csdn.net/hj7jay/article/details/51686418#