參考了很多文章，記錄下自己的學(xué)習(xí)過程！

參考：https://blog.csdn.net/weixin_40776321/article/details/99633110

1. 在pom.xml中添加依賴：

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

2.? 在application-xxx.yaml中添加數(shù)據(jù)源配置

spring:datasource:type: com.alibaba.druid.pool.DruidDataSourceurl: jdbc:mysql://xx.xx.xx.xx:3306/DB?useSSL=false&useTimezone=true&serverTimezone=GMT%2B8&allowMultiQueries=trueusername: rootpassword: 112233driver-class-name: com.mysql.cj.jdbc.Driverdbcp2:min-idle: 3 # 數(shù)據(jù)庫連接池的最小維持連接數(shù)initial-size: 3max-total: 5 # 最大的連接數(shù)max-wait-millis: 200 # 等待連接獲取的最大超時時間

3. 添加一個Druid數(shù)據(jù)源配置文件：DruidConfig.java

package com.joe.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.util.HashMap;@Configuration public class DruidConfig {@Bean@SuppressWarnings("unchecked")public ServletRegistrationBean druidServlet(){var bean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*");var map = new HashMap<String, String>() {{put("allow", "127.0.0.1,192.168.1.10");put("deny", "192.168.1.12");put("loginUsername", "root");put("loginPassword", "root");put("resetEnable", "false");}};bean.setInitParameters(map);return bean;}@Bean@SuppressWarnings("unchecked")public FilterRegistrationBean filterRegistrationBean(){var bean = new FilterRegistrationBean();bean.setFilter(new WebStatFilter());bean.addUrlPatterns("/*");bean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.css,/druid/*");return bean;}@Bean@ConfigurationProperties(prefix = "spring.datasource")public DataSource druidDataSource(){return new DruidDataSource();} }

4. 編譯、運行，測試下數(shù)據(jù)庫操作是否正常！

總結(jié)

以上是生活随笔為你收集整理的springboot中配置mybatis数据源，使用阿里的 Druid 数据库连接池的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。