【项目实践】Druid连接池及在Spring中的监控配置

浅浅的花香味﹌ 2022-07-14 00:08 161阅读 0赞

我就废话少说，word哥直接上代码吧......

1、加载maven依赖

<druid.version>1.0.22</druid.version>

<dependency>
          <groupId>com.alibaba</groupId>
          <artifactId>druid</artifactId>
          <version>${druid.version}</version>
        </dependency>

2、Druid在[spring][]中配置如下：

**特别说明：核心配置是这个 <property name="filters" value="stat"/>，需要注意的参数是这个'filters',其value值有：'stat'：用于统计，'wall'：用于防火墙。如果想使用sql防火墙，必须加上wall。**

3、 监控的 web.xml配置：

<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>/static/*,*.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>

![Center][]

代码如下，方便复制：

<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>zhangsq</param-value>
        </init-param>
        <init-param>
          <param-name>loginPassword</param-name>
          <param-value>zsq!@#0213</param-value>
        </init-param>
      </servlet>
      <servlet-mapping>
        <servlet-name>DruidStatView</servlet-name>
        <url-pattern>/druid/*</url-pattern>
      </servlet-mapping>

以上配置可以访问监控界面，配置好后，访问URL为：

[http://ip][http_ip]地址:端口号/项目名(可有可无)/druid/index.html即可监控[数据库][Link 1]访问性能。

**4、页面效果**

本人配置后页面展示如下：

![Center 1][]

![Center 2][]

完事儿......

[spring]: http://lib.csdn.net/base/javaee
[Center]: /images/20220714/25657b30f6b041d8985da5dc77c774dc.png
[http_ip]: http://ip/
[Link 1]: http://lib.csdn.net/base/mysql
[Center 1]: /images/20220714/83d95493ddca4aaabc02278531237712.png
[Center 2]: /images/20220714/7421cc248f70484ba05f1b4bf620412b.png