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.OracleDriverurl = jdbc:oracle:thin:@127.0.0.1:1521:ORCLusername = ******password = ******initialSize = 5maxActive = 10minIdle = 3maxWait = 60000removeAbandoned = trueremoveAbandonedTimeout = 180timeBetweenEvictionRunsMillis = 60000minEvictableIdleTimeMillis = 300000validationQuery = SELECT 1 FROM DUALtestWhileIdle = true testOnBorrow = falsetestOnReturn = falsepoolPreparedStatements = truemaxPoolPreparedStatementPerConnectionSize = 50filters = 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>