Spring SpringMVC配置Druid数据源（数据库连接池）

约定不等于承诺〃 2022-04-08 12:21 579阅读 0赞

之前分享过Spring boot集成使用Druid的方法，现在分享下Spring，SpringMVC配置Druid的方法。我们一般常用的数据源（数据库连接池）有Druid，HikariCP。

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>*.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>
        <servlet>
            <servlet-name>DruidStatView</servlet-name>
            <servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class>
            <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>

如果不需要输入密码登录Druid后台，那就取消上面的两个注释里的语句。

applicationContext.xml里增加：

重启运行项目访问项目url+/druid/即可。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2pheTEwMDUwMA_size_16_color_FFFFFF_t_70][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2pheTEwMDUwMA_size_16_color_FFFFFF_t_70]: /images/20220405/4e041319c95348bda205300f69be4137.png