一、pom.xml中添加druid依赖
<!-- druid -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.0.7</version>
</dependency>
二、修改SqlSessionFactory中的dataSource引用
<!--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>
三、web.xml中排除一些不必要的url
<!-- 经常需要排除一些不必要的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>
四、druid监控页面