SpringBoot如何自定義數據源DruidDataSource代碼

這篇文章將為大家詳細講解有關(guān)SpringBoot如何自定義數據源DruidDataSource代碼，小編覺(jué)得挺實(shí)用的，因此分享給大家做個(gè)參考，希望大家閱讀完這篇文章后可以有所收獲。

一、添加依賴(lài)

<dependency>    <groupId>com.alibaba</groupId>    <artifactId>druid</artifactId>    <version>1.0.26</version>  </dependency>

二、配置application.yml

spring:  datasource:url: jdbc:://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# 配置獲取連接等待超時(shí)的時(shí)間maxWait: 60000

三、Druid數據源配置

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數據源配置 */@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>();  //設置忽略請求  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");