第SpringBoot詳解如何進(jìn)行整合Druid數(shù)據(jù)源目錄1.自定義方式1.添加依賴2.編寫配置3.測試2.starter方式(推薦)1.添加依賴2.編寫配置3.測試Druid是數(shù)據(jù)庫連接池，它能夠提供強(qiáng)大的監(jiān)控和擴(kuò)展功能。官方文檔

SpringBoot整合第三方技術(shù)的兩種方式：

自定義找starter場景

1.自定義方式

使用自定義方式整合Druid

1.添加依賴

在pom.xml添加相關(guān)依賴

!--數(shù)據(jù)庫相關(guān)--

dependency

groupIdorg.springframework.boot/groupId

artifactIdspring-boot-starter-data-jdbc/artifactId

/dependency

dependency

groupIdmysql/groupId

artifactIdmysql-connector-java/artifactId

version5.1.6/version

/dependency

dependency

groupIdcom.alibaba/groupId

artifactIddruid/artifactId

version1.2.6/version

/dependency

/dependencies

2.編寫配置

perties

server.port=8080

spring.datasource.url=jdbc:mysql://localhost:3306/db_springtestuseUnicode=truecharacterEncoding=utf8

spring.datasource.username=root

spring.datasource.password=123456

spring.datasource.driver-class-name=com.mysql.jdbc.Driver

配置Druid的監(jiān)控頁功能：

Druid內(nèi)置提供了一個(gè)StatViewServlet用于展示Druid的統(tǒng)計(jì)信息。官方文檔-配置StatViewServlet

這個(gè)StatViewServlet的用途包括：

提供監(jiān)控信息展示的html頁面提供監(jiān)控信息的JSONAPI

Druid內(nèi)置提供一個(gè)StatFilter，用于統(tǒng)計(jì)監(jiān)控信息。官方文檔-配置_StatFilter

WebStatFilter用于采集web-jdbc關(guān)聯(lián)監(jiān)控的數(shù)據(jù)，如SQL監(jiān)控、URI監(jiān)控。官方文檔-配置WebStatFilter

Druid提供了WallFilter，它是基于SQL語義分析來實(shí)現(xiàn)防御SQL注入攻擊的。官方文檔-配置wallfilter

DataSourceConfig

packagecom.limi.springboottest2.config;

importcom.alibaba.druid.pool.DruidDataSource;

importcom.alibaba.druid.support.http.StatViewServlet;

importcom.alibaba.druid.support.http.WebStatFilter;

importperties.ConfigurationProperties;

importorg.springframework.boot.web.servlet.FilterRegistrationBean;

importorg.springframework.boot.web.servlet.ServletRegistrationBean;

importorg.springframework.context.annotation.Bean;

importorg.springframework.context.annotation.Configuration;

importjavax.sql.DataSource;

importjava.sql.SQLException;

importjava.util.Arrays;

@Configuration

publicclassDataSourceConfig{

@Bean

@ConfigurationProperties("spring.datasource")//復(fù)用配置文件的數(shù)據(jù)源配置,這樣就不用寫代碼一個(gè)一個(gè)set了

publicDataSourcedataSource()throwsSQLException{

DruidDataSourcedruidDataSource=newDruidDataSource();

//加入監(jiān)控和防火墻功能功能

druidDataSource.setFilters("stat,wall");

returndruidDataSource;

*配置druid的監(jiān)控頁功能

*@return

@Bean

publicServletRegistrationBeanstatViewServlet(){

StatViewServletstatViewServlet=newStatViewServlet();

ServletRegistrationBeanStatViewServletregistrationBean=

newServletRegistrationBean(statViewServlet,"/druid/*");

//監(jiān)控頁賬號密碼：

registrationBean.addInitParameter("loginUsername","admin");

registrationBean.addInitParameter("loginPassword","123456");

returnregistrationBean;

*WebStatFilter用于采集web-jdbc關(guān)聯(lián)監(jiān)控的數(shù)據(jù)。

@Bean

publicFilterRegistrationBeanwebStatFilter(){

WebStatFilterwebStatFilter=newWebStatFilter();

FilterRegistrationBeanWebStatFilterfilterRegistrationBean=newFilterRegistrationBean(webStatFilter);

filterRegistrationBean.setUrlPatterns(Arrays.asList("/*"));

filterRegistrationBean.addInitParameter("exclusions","*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");

returnfilterRegistrationBean;

}

3.測試

HelloController

packagecom.limi.springboottest2.controller;

importorg.springframework.beans.factory.annotation.Autowired;

importorg.springframework.jdbc.core.JdbcTemplate;

importorg.springframework.stereotype.Controller;

importorg.springframework.web.bind.annotation.GetMapping;

importorg.springframework.web.bind.annotation.ResponseBody;

@Controller

publicclassHelloController{

@Autowired

privateJdbcTemplatejdbcTemplate;

@ResponseBody

@GetMapping("/sql")

publicStringtest1(){

Stringsql="selectcount(*)fromt_user";

Longi=jdbcTemplate.queryForObject(sql,Long.class);

returni.toString();

}

多次點(diǎn)擊刷新進(jìn)行訪問

登錄druid后臺查看監(jiān)控信息

賬號admin,密碼123456

2.starter方式(推薦)

使用場景啟動(dòng)器整合druid,效果和自定義方式一樣,但更加方便

1.添加依賴

在pom.xml添加相關(guān)依賴

!--數(shù)據(jù)庫相關(guān)--

dependency

groupIdorg.springframework.boot/groupId

artifactIdspring-boot-starter-data-jdbc/artifactId

/dependency

dependency

groupIdmysql/groupId

artifactIdmysql-connector-java/artifactId

version5.1.6/version

/dependency

dependency

groupIdcom.alibaba/groupId

artifactIddruid-spring-boot-starter/artifactId

version1.1.17/version

/dependency

pom.xml完整內(nèi)容如下

xmlversion="1.0"encoding="UTF-8"

projectxmlns="/POM/4.0.0"xmlns:xsi="/2001/XMLSchema-instance"

xsi:schemaLocation="/POM/4.0.0/xsd/maven-4.0.0.xsd"

modelVersion4.0.0/modelVersion

parent

groupIdorg.springframework.boot/groupId

artifactIdspring-boot-starter-parent/artifactId

version2.7.0/version

relativePath/!--lookupparentfromrepository--

/parent

groupIdcom.limi/groupId

artifactIdspringboot-test2/artifactId

version0.0.1-SNAPSHOT/version

namespringboot-test2/name

descriptionDemoprojectforSpringBoot/description

properties

java.version1.8/java.version

/properties

dependencies

dependency

groupIdorg.springframework.boot/groupId

artifactIdspring-boot-starter-web/artifactId

/dependency

dependency

groupIdorg.springframework.boot/groupId

artifactIdspring-boot-devtools/artifactId

scoperuntime/scope

optionaltrue/optional

/dependency

dependency

groupIdjectlombok/groupId

artifactIdlombok/artifactId

optionaltrue/optional

/dependency

dependency

groupIdorg.springframework.boot/groupId

artifactIdspring-boot-starter-test/artifactId

scopetest/scope

/dependency

dependency

groupIdorg.springframework.boot/groupId

artifactIdspring-boot-configuration-processor/artifactId

optionaltrue/optional

/dependency

!--數(shù)據(jù)庫相關(guān)--

dependency

groupIdorg.springframework.boot/groupId

artifactIdspring-boot-starter-data-jdbc/artifactId

/dependency

dependency

groupIdmysql/groupId

artifactIdmysql-connector-java/artifactId

version5.1.6/version

/dependency

dependency

groupIdcom.alibaba/groupId

artifactIddruid-spring-boot-starter/artifactId

version1.1.17/version

/dependency

/dependencies

build

plugins

plugin

groupIdorg.springframework.boot/groupId

artifactIdspring-boot-maven-plugin/artifactId

configuration

excludes

exclude

groupIdjectlombok/groupId

artifactIdlombok/artifactId

/exclude

/excludes

/configuration

/plugin

!--下面插件作用是工程打包時(shí)，不將spring-boot-configuration-processor打進(jìn)包內(nèi)，讓其只在編碼的時(shí)候有用--

plugin

groupIdorg.springframework.boot/groupId

artifactIdspring-boot-maven-plugin/artifactId

configuration

excludes

exclude

groupIdorg.springframework.boot/groupId

artifactIdspring-boot-configuration-processor/artifactId

/exclude

/excludes

/configuration

/plugin

/plugins

/build

/project

2.編寫配置

perties

server.port=8080

spring.datasource.url=jdbc:mysql://localhost:3306/db_springtestuseUnicode=truecharacterEncoding=utf8

spring.datasource.username=root

spring.datasource.password=123456

spring.datasource.driver-class-name=com.mysql.jdbc.Driver

spring.datasource.druid.aop-patterns=com.limi.springboottest2.*

spring.datasource.druid.filters=stat,wall

spring.datasource.druid.stat-view-servlet.enabled=true

spring.datasource.druid.stat-view-servlet.login-username=admin

spring.datasource.druid.stat-view-servlet.login-password=123456

spring.datasource.druid.stat-view-servlet.reset-enable=false

spring.datasource.druid.web-stat-filter.enabled=true

spring.datasource.druid.web-stat-filter.url-pattern=/*

spring.datasource.druid.web-stat-filter.exclusions=*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*

spring.datasource.druid.filter.stat.slow-sql-millis=1000

spring.datasource.druid.filter.stat.log-sl