Druid使用说明

数据库连接池有很多比如c3p0,dbcp等。今天我们说下druid连接池。

druid连接池文档被维护在github

---

1. 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> 
   <servlet>
       <servlet-name>DruidStatView</servlet-name>
       <servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class>   
   </servlet>    
   <servlet-mapping>
       <servlet-name>DruidStatView</servlet-name>
       <url-pattern>/druid/*</url-pattern>
   </servlet-mapping>

2. ds.properties

   driverClassName = oracle.jdbc.driver.OracleDriver
   url = jdbc:oracle:thin:@127.0.0.1:1521:ORCL
   username = ******
   password = ******
   
   initialSize = 5
   maxActive = 10
   minIdle = 3
   maxWait = 60000
   removeAbandoned = true
   removeAbandonedTimeout = 180
   timeBetweenEvictionRunsMillis = 60000
   minEvictableIdleTimeMillis = 300000
   validationQuery = SELECT 1 FROM DUAL
   testWhileIdle = true 
   testOnBorrow = false
   testOnReturn = false
   poolPreparedStatements = true
   maxPoolPreparedStatementPerConnectionSize = 50
   filters = stat

3. spring.xml

   <bean id="druidDataSource" class="com.alibaba.druid.pool.DruidDataSource"
           init-method="init" destroy-method="close">
           <!-- 数据库基本信息配置 -->
           <property name="driverClassName" value="${oracle.driver}" />
           <property name="url" value="${oracle.url}" />
           <property name="username" value="${oracle.username}" />
           <property name="password" value="${oracle.password}" />        
           <!-- 初始化连接数量 -->
           <property name="initialSize" value="${druid.initialSize}" />
           <!-- 最大并发连接数 -->
           <property name="maxActive" value="${druid.maxActive}" />
           <!-- 最大空闲连接数 -->
           <property name="maxIdle" value="${druid.maxIdle}" />
           <!-- 最小空闲连接数 -->
           <property name="minIdle" value="${druid.minIdle}" />
           <!-- 配置获取连接等待超时的时间 -->     
           <property name="maxWait" value="${druid.maxWait}" />
           <!-- 超过时间限制是否回收 -->
           <property name="removeAbandoned" value="${druid.removeAbandoned}" />
           <!-- 超过时间限制多长； -->
           <property name="removeAbandonedTimeout" value="${druid.removeAbandonedTimeout}" />
           <!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 -->
           <property name="timeBetweenEvictionRunsMillis" value="${druid.timeBetweenEvictionRunsMillis}" />
           <!-- 配置一个连接在池中最小生存的时间，单位是毫秒 -->
           <property name="minEvictableIdleTimeMillis" value="${druid.minEvictableIdleTimeMillis}" />
           <!-- 用来检测连接是否有效的sql，要求是一个查询语句-->
           <property name="validationQuery" value="${druid.validationQuery}" />
           <!-- 申请连接的时候检测 -->
           <property name="testWhileIdle" value="${druid.testWhileIdle}" />
           <!-- 申请连接时执行validationQuery检测连接是否有效，配置为true会降低性能 -->
           <property name="testOnBorrow" value="${druid.testOnBorrow}" />
           <!-- 归还连接时执行validationQuery检测连接是否有效，配置为true会降低性能  -->
           <property name="testOnReturn" value="${druid.testOnReturn}" />
           <!-- 打开PSCache，并且指定每个连接上PSCache的大小 -->
           <property name="poolPreparedStatements" value="${druid.poolPreparedStatements}" />     
           <property name="maxPoolPreparedStatementPerConnectionSize" value="${druid.maxPoolPreparedStatementPerConnectionSize}" />
           <!--属性类型是字符串，通过别名的方式配置扩展插件，常用的插件有：                 
                   监控统计用的filter:stat
                   日志用的filter:log4j
                  防御SQL注入的filter:wall -->
           <property name="filters" value="${druid.filters}" />       
       </bean>