数据库连接池--Druid使用总结

你的名字 2022-01-05 12:45 330阅读 0赞

## 一、Druid介绍 ##

Druid是java语言中非常好的数据库连接池，其能提供强大的监控和扩展功能。其源代码仓库地址为： [https://github.com/alibaba/druid][https_github.com_alibaba_druid]。

## 二、maven中配置Druid ##

Druid 0.1.18 之后版本都发布到maven中央仓库中，所以你只需要在项目的pom.xml中加上dependency就可以了。例如：

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

## 三、怎么打开Druid的监控统计功能及内置监控页面 ##

springboot增加配置项

spring.datasource.druid.filters=stat

Druid内置提供了一个StatViewServlet用于展示Druid的统计信息。这个StatViewServlet的用途包括：

*  提供监控信息展示的html页面
 *  提供监控信息的JSON API

@Bean
        @ConditionalOnMissingBean
        public ServletRegistrationBean druidServlet() {
    
            ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*");
    
            //添加初始化参数：initParams
    
            //白名单：
            //servletRegistrationBean.addInitParameter("allow","127.0.0.1");
            //IP黑名单 (存在共同时，deny优先于allow) : 如果满足deny的话提示:Sorry, you are not permitted to view this page.
            //servletRegistrationBean.addInitParameter("deny","192.168.1.73");
            //登录查看信息的账号密码.
            servletRegistrationBean.addInitParameter("loginUsername", "admin");
            servletRegistrationBean.addInitParameter("loginPassword", "admin");
            //是否能够重置数据.
            servletRegistrationBean.addInitParameter("resetEnable", "true");
            return servletRegistrationBean;
    
        }

登录后内置监控网页如下所示：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoYW84MjE_size_16_color_FFFFFF_t_70][]

## 四、Druid典型配置 ##

参考文档：[https://github.com/alibaba/druid/wiki/%E5%B8%B8%E8%A7%81%E9%97%AE%E9%A2%98][https_github.com_alibaba_druid_wiki_E5_B8_B8_E8_A7_81_E9_97_AE_E9_A2_98]

案例参考：[https://github.com/zhonglinlin1305/spring-boot-sample][https_github.com_zhonglinlin1305_spring-boot-sample]

[https_github.com_alibaba_druid]: https://github.com/alibaba/druid
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoYW84MjE_size_16_color_FFFFFF_t_70]: /images/20211229/7cd2d18fb7dc4ec296226a171bdbaafa.png
[https_github.com_alibaba_druid_wiki_E5_B8_B8_E8_A7_81_E9_97_AE_E9_A2_98]: https://github.com/alibaba/druid/wiki/%E5%B8%B8%E8%A7%81%E9%97%AE%E9%A2%98
[https_github.com_zhonglinlin1305_spring-boot-sample]: https://github.com/zhonglinlin1305/spring-boot-sample