项目使用druid连接池

步骤一 ：pom.xml 

  <!--jar package of druid  configuration-->

                 < dependency >

               < groupId > com.alibaba </ groupId >

               < artifactId > druid </ artifactId >

               < version > 1.0.24 </ version >

           </ dependency >

步骤二：   applicationContext.xml

  <!-- 阿里 druid 数据库连接池 -->  

< bean id = "dataSource" class = "com.alibaba.druid.pool.DruidDataSource"

            init-method = "init" destroy-method = "close" >

            <!-- 数据库基本信息配置 -->

            < property name = "driverClassName" value = "${driverClassName}" />

            < property name = "url" value = "${url}" />

            < property name = "username" value = "${username}" />

            < property name = "password" value = "${password}" />            

            <!-- 初始化连接数量 -->

            < property name = "initialSize" value = "${initialSize}" />

            <!-- 最大并发连接数 -->

            < property name = "maxActive" value = "${maxActive}" />

            <!-- 最大空闲连接数 -->

            < property name = "maxIdle" value = "${maxIdle}" />

            <!-- 最小空闲连接数 -->

            < property name = "minIdle" value = "${minIdle}" />

            <!-- 配置获取连接等待超时的时间 -->            

            < property name = "maxWait" value = "${maxWait}" />

            <!-- 超过时间限制是否回收 -->

            < property name = "removeAbandoned" value = "${removeAbandoned}" />

            <!-- 超过时间限制多长； -->

            < property name = "removeAbandonedTimeout" value = "${removeAbandonedTimeout}" />

            <!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 -->

            < property name = "timeBetweenEvictionRunsMillis" value = "${timeBetweenEvictionRunsMillis}" />

            <!-- 配置一个连接在池中最小生存的时间，单位是毫秒 -->

            < property name = "minEvictableIdleTimeMillis" value = "${minEvictableIdleTimeMillis}" />

            <!-- 用来检测连接是否有效的sql，要求是一个查询语句-->      

            < property name = "validationQuery" value = "${validationQuery}" />

            <!-- 申请连接的时候检测 -->

            < property name = "testWhileIdle" value = "${testWhileIdle}" />

            <!-- 申请连接时执行validationQuery检测连接是否有效，配置为true会降低性能 -->

            < property name = "testOnBorrow" value = "${testOnBorrow}" />

            <!-- 归还连接时执行validationQuery检测连接是否有效，配置为true会降低性能  -->

            < property name = "testOnReturn" value = "${testOnReturn}" />

            <!-- 打开PSCache，并且指定每个连接上PSCache的大小 -->

            < property name = "poolPreparedStatements" value = "${poolPreparedStatements}" />        

            < property name = "maxPoolPreparedStatementPerConnectionSize" value = "${maxPoolPreparedStatementPerConnectionSize}" />

            <!--属性类型是字符串，通过别名的方式配置扩展插件，常用的插件有：                     

                     监控统计用的filter:stat

                     日志用的filter:log4j

                     防御SQL注入的filter:wall -->

            < property name = "filters" value = "${filters}" />        

      </ bean >

步骤三：jdbc.properties

       

driverClassName = oracle.jdbc.driver.OracleDriver

url = jdbc:oracle:thin:@127.0.0.1:1521:ORCL

username = apm

password = root

initialSize = 5

maxActive = 10

minIdle = 3

maxIdle = 10

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

步骤四：web.xml

      <!-- 连接池 启用 Web 监控统计功能    start-->  

     < 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 >

  <!-- 连接池 启用 Web 监控统计功能    end-->  

   

监控的url为： http://localhost:8888/xxzx /druid/index.html