<bean id="dataSource"

class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close"

init-method="init">

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

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

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

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

<!-- 配置初始化大小、最小、最大 -->

<property name="initialSize" value="10" />

<property name="minIdle" value="10" />

<property name="maxActive" value="500" />

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

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

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

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

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

<property name="minEvictableIdleTimeMillis" value="300000" />

<property name="validationQuery" value="SELECT 1" />

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

<property name="testOnBorrow" value="false" />

<property name="testOnReturn" value="false" />

<!-- 配置监控统计拦截的filters -->

<property name="filters" value="stat,wall" />

</bean>

<!-- Druid,监控数据库,以及WEB访问连接信息 -->

<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/*,/download/*</param-value>

</init-param>

</filter>

<filter-mapping>

<filter-name>DruidWebStatFilter</filter-name>

<url-pattern>/*</url-pattern>

</filter-mapping>

<!-- 配置 Druid 监控信息显示页面 -->

<servlet>

<servlet-name>DruidStatView</servlet-name>

<servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class>

<!---->

<init-param>

            <param-name>resetEnable</param-name>

            <param-value>false</param-value>

        </init-param>

        <!--

<init-param>

<param-name>loginUsername</param-name>

<param-value>admin</param-value>

</init-param>

<init-param>

<param-name>loginPassword</param-name>

<param-value>ds123</param-value>

</init-param>

-->

</servlet>

<servlet-mapping>

<servlet-name>DruidStatView</servlet-name>

<url-pattern>/druid/*</url-pattern>

</servlet-mapping>