在Spring Boot中
使用Druid连接池，你需要进行以下步骤：
1. 引入
Druid的依赖：在你的项目的pom.xml文件中，添加以下依赖：
```xml
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>
druid-spring-boot-starter</artifactId>
<version>1.2.6</version>
</dependency>
```
2. 配置
Druid连接池：在application.properties或application.yml文件中，添加以下配置：
```yaml
spring.
datasource.url=
jdbc:my
sql://localhost:3306/db_example
spring.
datasource.username=dbuser
spring.
datasource.password=dbpass
spring.
datasource.driver-class-name=com.my
sql.
jdbc.Driver
# 配置
Druid连接池
spring.
datasource.type=com.alibaba.
druid.pool.
DruidDataSource
spring.
datasource.
druid.initial-size=5
spring.
datasource.
druid.min-idle=5
spring.
datasource.
druid.max-active=20
spring.
datasource.
druid.max-wait=60000
spring.
datasource.
druid.time-between-eviction-runs-millis=60000
spring.
datasource.
druid.min-evictable-idle-time-millis=300000
spring.
datasource.
druid.validation-query=SELECT 1
spring.
datasource.
druid.test-while-idle=true
spring.
datasource.
druid.test-on-borrow=false
spring.
datasource.
druid.test-on-return=false
spring.
datasource.
druid.pool-prepared-statements=true
spring.
datasource.
druid.max-pool-prepared-statement-per-connection-size=20
spring.
datasource.
druid.filters=stat,wall,log4j
spring.
datasource.
druid.connection-properties=
druid.stat.merge
Sql=true;
druid.stat.slow
SqlMillis=5000
```
3. 配置
Druid监控页面：在你的项目的配置类中，添加以下配置：
```java
@Configuration
public class
DruidConfig {
@Bean
public ServletRegistrationBean
druidServlet() {
ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(), "/
druid/*");
// 配置
Druid监控页面的登录用户名和密码
servletRegistrationBean.addInitParameter("loginUsername", "admin");
servletRegistrationBean.addInitParameter("loginPassword", "admin");
return servletRegistrationBean;
}
@Bean
public FilterRegistrationBean
druidStatFilter() {
FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter());
// 配置
Druid监控页面的过滤规则
filterRegistrationBean.addUrlPatterns("/*");
filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/
druid/*");
return filterRegistrationBean;
}
}
```
以上就是在Spring Boot中
使用Druid连接池的步骤。通过以上配置，你可以
使用Druid提供的强大的监控和扩展功能来管理你的数据库连接池。
最低0.47元/天 解锁文章
2838
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
