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