1、web.xml
<!-- 添加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/*</param-value></init-param><init-param><param-name>profileEnable</param-name><param-value>true</param-value></init-param><init-param><param-name>principalCookieName</param-name><param-value>USER_COOKIE</param-value></init-param><init-param><param-name>principalSessionName</param-name><param-value>USER_SESSION</param-value></init-param></filter><filter-mapping><filter-name>DruidWebStatFilter</filter-name><url-pattern>/*</url-pattern></filter-mapping>
2、拦截器 SessionFilter
// 以下的文件不进行过滤if (uri.startsWith(projectName + "/druid")//支持连接池页面 ){arg2.doFilter(arg0, arg1);}
3、数据源配置
<?xml version="1.0" encoding="UTF-8"?> <Context path="/erpfoko" ><Resource auth="Container"driverClassName="oracle.jdbc.driver.OracleDriver"maxActive="50"maxIdle="20"maxWait="10000"name="jdbc/btdb1"type="javax.sql.DataSource"factory="com.alibaba.druid.pool.DruidDataSourceFactory"url="jdbc:oracle:thin:@localhost:1521/orcl"username="swyy_0915"password="swyy_0915"filters="stat"/><Resource auth="Container"driverClassName="oracle.jdbc.driver.OracleDriver"maxActive="50"maxIdle="20"maxWait="10000"name="jdbc/btdb2"type="javax.sql.DataSource"factory="com.alibaba.druid.pool.DruidDataSourceFactory"url="jdbc:oracle:thin:@localhost:1521/orcl"username="swyy_0915"password="swyy_0915"filters="stat"/> </Context>