<!-- druid -->

        <dependency>

            <groupId>com.alibaba</groupId>

            <artifactId>druid</artifactId>

            <version>1.0.7</version>

        </dependency>

<!--2 配置druid数据源 -->

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

        <!--驱动类名 -->

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

        <!-- url -->

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

        <!-- 用户名 -->

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

        <!-- 密码 -->

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

        <!--初始化连接大小-->

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

        <!--连接池最大使用连接数量-->

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

        <!--连接池最小空间-->

        <property name="maxIdle" value="0"/>

        <!--获取连接最大等待时间-->

        <property name="maxWait" value="60000"/>

        <property name="validationQuery" >

            <value >select 1 from dual</value>

        </property>

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

        <!--打开removeAbandoned功能-->

        <property name="removeAbandoned" value="true"/>

        <!--1800秒 -->

        <property name="removeAbandonedTimeout" value="1800"/>

        <!--关闭abandoned连接是输出错误日志-->

        <property name="logAbandoned" value="true"/>

        <!--监控数据库-->

        <property name="filters" value="mergeStat"/>

    </bean>

 <!-- 经常需要排除一些不必要的url，比如.js,/jslib/等等。配置在init-param中。比如 -->

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

    <!-- druid的Servlet -->

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