您好,登錄后才能下訂單哦!
這篇文章將為大家詳細(xì)講解有關(guān)SpringBoot如何自定義數(shù)據(jù)源DruidDataSource代碼,小編覺得挺實(shí)用的,因此分享給大家做個參考,希望大家閱讀完這篇文章后可以有所收獲。
一、添加依賴
<dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.0.26</version> </dependency>
二、配置application.yml
spring: datasource:url: jdbc:mysql://127.0.0.1:3306/mxntest?characterEncoding=UTF-8username: rootpassword: rootdriver-class-name: com.mysql.jdbc.Drivertype: com.alibaba.druid.pool.DruidDataSource# 初始化大小,最小,最大initialSize: 5minIdle: 5maxActive: 50# 配置獲取連接等待超時的時間maxWait: 60000
三、Druid數(shù)據(jù)源配置
package com.example.demo.config;/** * @author 12084 * @create 2018-08-09 11:27 */import com.alibaba.druid.pool.DruidDataSource;import com.alibaba.druid.support.http.StatViewServlet;import com.alibaba.druid.support.http.WebStatFilter;import org.springframework.beans.factory.annotation.Value;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 org.springframework.context.annotation.Primary;import javax.sql.DataSource;import java.sql.SQLException;import java.util.HashMap;import java.util.Map;/** * Druid數(shù)據(jù)源配置 */@Configurationpublic class DataSourceConfig {private static String dbUrl;private static String username;private static String password;private static String driverClassName;private static int initialSize;private static int minIdle;private static int maxActive;private static int maxWait;/** * 注冊DruidServlet * * @return */@Beanpublic ServletRegistrationBean druidServletRegistrationBean() { ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(); servletRegistrationBean.setServlet(new StatViewServlet()); servletRegistrationBean.addUrlMappings("/druid/*"); //登錄查看信息的賬號密碼. servletRegistrationBean.addInitParameter("loginUsername", "admin"); servletRegistrationBean.addInitParameter("loginPassword", "123456"); return servletRegistrationBean;}/** * 注冊DruidFilter攔截 * * @return */@Beanpublic FilterRegistrationBean druidFilterRegistrationBean() { FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(); filterRegistrationBean.setFilter(new WebStatFilter()); Map<String, String> initParams = new HashMap<String, String>(); //設(shè)置忽略請求 initParams.put("exclusions", "*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*"); filterRegistrationBean.setInitParameters(initParams); filterRegistrationBean.addUrlPatterns("/*"); return filterRegistrationBean;}/** * 配置DataSource * @return * @throws SQLException */@Bean(initMethod = "init",destroyMethod = "close")@Primarypublic DataSource dataSource() throws SQLException { DruidDataSource druidDataSource = new DruidDataSource(); druidDataSource.setUsername(username); druidDataSource.setPassword(password); druidDataSource.setUrl(dbUrl); druidDataSource.setFilters("stat,wall"); druidDataSource.setInitialSize(initialSize); druidDataSource.setMinIdle(minIdle); druidDataSource.setMaxActive(maxActive); druidDataSource.setMaxWait(maxWait); druidDataSource.setUseGlobalDataSourceStat(true); druidDataSource.setDriverClassName(driverClassName); return druidDataSource;}@Value("${spring.datasource.url}")public void setDbUrl(String dbUrl) { DataSourceConfig.dbUrl = dbUrl;}@Value("${spring.datasource.username}")public void setUsername(String username) { DataSourceConfig.username = username;}@Value("${spring.datasource.password}")public void setPassword(String password) { DataSourceConfig.password = password;}@Value("${spring.datasource.driver-class-name}")public void setDriverClassName(String driverClassName) { DataSourceConfig.driverClassName = driverClassName;}@Value(value = "${spring.datasource.initialSize}")public void setInitialSize(int initialSize) { DataSourceConfig.initialSize = initialSize;}@Value(value = "${spring.datasource.minIdle}")public void setMinIdle(int minIdle) { DataSourceConfig.minIdle = minIdle;}@Value(value = "${spring.datasource.maxActive}")public void setMaxActive(int maxActive) { DataSourceConfig.maxActive = maxActive;}@Value(value = "${spring.datasource.maxWait}")public void setMaxWait(int maxWait) { DataSourceConfig.maxWait = maxWait;}}
四、http://localhost:8080/druid/index.html 就可以查看,如果配置密碼則輸入密碼
//登錄查看信息的賬號密碼. servletRegistrationBean.addInitParameter("loginUsername", "admin"); servletRegistrationBean.addInitParameter("loginPassword", "123456");
關(guān)于“SpringBoot如何自定義數(shù)據(jù)源DruidDataSource代碼”這篇文章就分享到這里了,希望以上內(nèi)容可以對大家有一定的幫助,使各位可以學(xué)到更多知識,如果覺得文章不錯,請把它分享出去讓更多的人看到。
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。