WEB项目引入druid监控配置

 

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>
<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>druid</param-value>
    </init-param>
    <init-param>
        <!-- 密码 -->
        <param-name>loginPassword</param-name>
        <param-value>druid</param-value>
    </init-param>
</servlet>
<servlet-mapping>
    <servlet-name>DruidStatView</servlet-name>
    <url-pattern>/druid/*</url-pattern>
</servlet-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>