SpringBoot詳解如何進行整合Druid數(shù)據(jù)源
Druid是數(shù)據(jù)庫連接池,它能夠提供強大的監(jiān)控和擴展功能。官方文檔
Spring Boot整合第三方技術的兩種方式:
- 自定義
- 找starter場景
1.自定義方式
使用自定義方式整合Druid
1.添加依賴
在pom.xml添加相關依賴
<!--數(shù)據(jù)庫相關--> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-jdbc</artifactId> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.6</version> </dependency> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.2.6</version> </dependency> </dependencies>
2.編寫配置
application.properties
server.port=8080
spring.datasource.url=jdbc:mysql://localhost:3306/db_springtest?useUnicode=true&characterEncoding=utf8
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
配置Druid的監(jiān)控頁功能:
Druid內(nèi)置提供了一個StatViewServlet用于展示Druid的統(tǒng)計信息。官方文檔 - 配置StatViewServlet
這個StatViewServlet的用途包括:
- 提供監(jiān)控信息展示的html頁面
- 提供監(jiān)控信息的JSON API
Druid內(nèi)置提供一個StatFilter,用于統(tǒng)計監(jiān)控信息。官方文檔 - 配置_StatFilter
WebStatFilter用于采集web-jdbc關聯(lián)監(jiān)控的數(shù)據(jù),如SQL監(jiān)控、URI監(jiān)控。官方文檔 - 配置WebStatFilter
Druid提供了WallFilter,它是基于SQL語義分析來實現(xiàn)防御SQL注入攻擊的。官方文檔 - 配置 wallfilter
DataSourceConfig
package com.limi.springboottest2.config; import com.alibaba.druid.pool.DruidDataSource; import com.alibaba.druid.support.http.StatViewServlet; import com.alibaba.druid.support.http.WebStatFilter; import org.springframework.boot.context.properties.ConfigurationProperties; import org.springframework.boot.web.servlet.FilterRegistrationBean; import org.springframework.boot.web.servlet.ServletRegistrationBean; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; import javax.sql.DataSource; import java.sql.SQLException; import java.util.Arrays; @Configuration public class DataSourceConfig { @Bean @ConfigurationProperties("spring.datasource")//復用配置文件的數(shù)據(jù)源配置, 這樣就不用寫代碼一個一個set了 public DataSource dataSource() throws SQLException { DruidDataSource druidDataSource = new DruidDataSource(); //加入監(jiān)控和防火墻功能功能 druidDataSource.setFilters("stat,wall"); return druidDataSource; } /** * 配置 druid的監(jiān)控頁功能 * @return */ @Bean public ServletRegistrationBean statViewServlet(){ StatViewServlet statViewServlet = new StatViewServlet(); ServletRegistrationBean<StatViewServlet> registrationBean = new ServletRegistrationBean<>(statViewServlet, "/druid/*"); //監(jiān)控頁賬號密碼: registrationBean.addInitParameter("loginUsername","admin"); registrationBean.addInitParameter("loginPassword","123456"); return registrationBean; } /** * WebStatFilter 用于采集web-jdbc關聯(lián)監(jiān)控的數(shù)據(jù)。 */ @Bean public FilterRegistrationBean webStatFilter(){ WebStatFilter webStatFilter = new WebStatFilter(); FilterRegistrationBean<WebStatFilter> filterRegistrationBean = new FilterRegistrationBean<>(webStatFilter); filterRegistrationBean.setUrlPatterns(Arrays.asList("/*")); filterRegistrationBean.addInitParameter("exclusions","*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*"); return filterRegistrationBean; } }
3.測試
HelloController
package com.limi.springboottest2.controller; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.ResponseBody; @Controller public class HelloController { @Autowired private JdbcTemplate jdbcTemplate; @ResponseBody @GetMapping("/sql") public String test1(){ String sql = "select count(*) from t_user"; Long i = jdbcTemplate.queryForObject(sql, Long.class); return i.toString(); } }
多次點擊刷新進行訪問
登錄druid后臺查看監(jiān)控信息
賬號admin, 密碼123456
2.starter方式(推薦)
使用場景啟動器整合druid, 效果和自定義方式一樣, 但更加方便
1.添加依賴
在pom.xml添加相關依賴
<!--數(shù)據(jù)庫相關--> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-jdbc</artifactId> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.6</version> </dependency> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid-spring-boot-starter</artifactId> <version>1.1.17</version> </dependency>
pom.xml完整內(nèi)容如下
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>2.7.0</version> <relativePath/> <!-- lookup parent from repository --> </parent> <groupId>com.limi</groupId> <artifactId>springboot-test2</artifactId> <version>0.0.1-SNAPSHOT</version> <name>springboot-test2</name> <description>Demo project for Spring Boot</description> <properties> <java.version>1.8</java.version> </properties> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-devtools</artifactId> <scope>runtime</scope> <optional>true</optional> </dependency> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <optional>true</optional> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-configuration-processor</artifactId> <optional>true</optional> </dependency> <!--數(shù)據(jù)庫相關--> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-jdbc</artifactId> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.6</version> </dependency> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid-spring-boot-starter</artifactId> <version>1.1.17</version> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> <configuration> <excludes> <exclude> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> </exclude> </excludes> </configuration> </plugin> <!-- 下面插件作用是工程打包時,不將spring-boot-configuration-processor打進包內(nèi),讓其只在編碼的時候有用 --> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> <configuration> <excludes> <exclude> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-configuration-processor</artifactId> </exclude> </excludes> </configuration> </plugin> </plugins> </build> </project>
2.編寫配置
application.properties
server.port=8080
spring.datasource.url=jdbc:mysql://localhost:3306/db_springtest?useUnicode=true&characterEncoding=utf8
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver#監(jiān)控SpringBean
spring.datasource.druid.aop-patterns=com.limi.springboottest2.*
# 底層開啟功能,stat(sql監(jiān)控),wall(防火墻)
spring.datasource.druid.filters=stat,wall# 配置監(jiān)控頁功能
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# 監(jiān)控web
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/*'# 對上面filters里面的stat的詳細配置
spring.datasource.druid.filter.stat.slow-sql-millis=1000
spring.datasource.druid.filter.stat.log-slow-sql=true
spring.datasource.druid.filter.stat.enabled=true
spring.datasource.druid.filter.wall.enabled=true
spring.datasource.druid.filter.wall.config.drop-table-allow=false
3.測試
HelloController
package com.limi.springboottest2.controller; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.ResponseBody; @Controller public class HelloController { @Autowired private JdbcTemplate jdbcTemplate; @ResponseBody @GetMapping("/sql") public String test1(){ String sql = "select count(*) from t_user"; Long i = jdbcTemplate.queryForObject(sql, Long.class); return i.toString(); } }
多次點擊刷新進行訪問
登錄druid后臺查看監(jiān)控信息
賬號admin, 密碼123456
到此這篇關于SpringBoot詳解如何進行整合Druid數(shù)據(jù)源的文章就介紹到這了,更多相關SpringBoot Druid數(shù)據(jù)源內(nèi)容請搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關文章希望大家以后多多支持腳本之家!
- 關于springboot配置druid數(shù)據(jù)源不生效問題(踩坑記)
- Springboot mybatis plus druid多數(shù)據(jù)源解決方案 dynamic-datasource的使用詳解
- SpringBoot整合Druid數(shù)據(jù)源過程詳解
- 通過springboot+mybatis+druid配置動態(tài)數(shù)據(jù)源
- springboot 動態(tài)數(shù)據(jù)源的實現(xiàn)方法(Mybatis+Druid)
- SpringBoot使用Druid數(shù)據(jù)源的配置方法
- SpringBoot整合阿里?Druid?數(shù)據(jù)源的實例詳解
相關文章
springboot如何連接兩個數(shù)據(jù)庫(多個)
這篇文章主要介紹了springboot如何連接兩個數(shù)據(jù)庫(多個),具有很好的參考價值,希望對大家有所幫助。如有錯誤或未考慮完全的地方,望不吝賜教2022-01-01詳解在SpringBoot中使用MongoDb做單元測試的代碼
這篇文章主要介紹了詳解在SpringBoot中使用MongoDb做單元測試的代碼,文中通過示例代碼介紹的非常詳細,對大家的學習或者工作具有一定的參考學習價值,需要的朋友們下面隨著小編來一起學習學習吧2020-11-11