druid:配置(监控)

/WebRoot/WEB-INF/lib

ojdbc6.jar、druid-1.1.10.jar

jdbc.properties

jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc\:oracle\:thin\:@xx.xx.xx.xx\:1521\:orcl
jdbc.username=xxxx
jdbc.password=xxxx

spring*.xml 

<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">  
	<property name="driverClassName" value="${jdbc.driverClassName}" />  
	<property name="url" value="${jdbc.url}" />    
	<property name="username" value="${jdbc.username}" />    
	<property name="password" value="${jdbc.password}" />    
	<property name="initialSize" value="2"/>  
	<property name="maxWait" value="60000"/>  
	<property name="maxActive" value="20"/>  
	<property name="maxIdle" value="20"/>  
	<property name="minIdle" value="3"/>  
	<property name="removeAbandoned" value="true"/>  
	<property name="removeAbandonedTimeout" value="180"/>  
	<!-- 配置监控统计拦截的filters,去掉后监控界面sql无法统计 -->  
	<property name="filters" value="stat" />   
</bean>

/WebRoot/WEB-INF/web.xml

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

测试:浏览器

http://IP:PORT/projectName/druid/index.html

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值