druid 相关配置

在maven中央仓库下载 druid-1.1.21.jar(我下载的是1.1.21版本，根据自己的需求选择下载的版本) 

注意：druid-1.1.21.jar包是需要放在Tomcat下的lib文件夹下，而不是项目的lib文件夹下

下载地址：https://mvnrepository.com/artifact/com.alibaba/druid

1，web.xml 配置

    <!-- Servlet 配置druid -->
	<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 监控信息显示页面 -->  
	<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>true</param-value>  
	    </init-param>  
	    <init-param>  
		<!-- 用户名 -->  
		<param-name>loginUsername</param-name>  
		<param-value>*****</param-value>  
	    </init-param>  
	    <init-param>  
		<!-- 密码 -->  
		<param-name>loginPassword</param-name>  
		<param-value>*****</param-value>  
	    </init-param>   
	</servlet>   

   <!-- filter  配置druid --> 
   <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>
         <init-param>
		 <param-name>profileEnable</param-name>
		 <param-value>true</param-value>
	 </init-param>
   </filter>
   <filter-mapping>
  	 <filter-name>DruidWebStatFilter</filter-name>
  	 <url-pattern>/*</url-pattern>
   </filter-mapping>

2，Bean 的配置

<bean id="stat-filter" class="com.alibaba.druid.filter.stat.StatFilter">
		<property name="mergeSql" value="true" />
	 </bean> 
	
	 <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close">
	  
	  	<property name="url" value="jdbc:oracle:thin:@****:1521/hrsw" />
	  	<property name="username" value="********" />
	  	<property name="password" value="******" />
	  	<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
	  	<property name="maxActive" value="100" />
	  	<property name="minIdle" value="10" />
	  	<property name="maxWait" value="10000" />
	  	
	  	<property name="proxyFilters"> 
			<list>
				<ref bean="stat-filter" /> 
			</list>
		</property>

	  	<property name="removeAbandoned" value="true" /> <!-- 打开removeAbandoned功能 -->
	  	<property name="removeAbandonedTimeout" value="1800" /> <!-- 1800秒，也就是30分钟 -->
	  	<property name="logAbandoned" value="true" /> <!-- 关闭abanded连接时输出错误日志 -->
	</bean>

 

3，配置成功后页面如下

更多配置请参考：https://github.com/alibaba/druid/wiki/%E5%B8%B8%E8%A7%81%E9%97%AE%E9%A2%98