Springboot默认的连接池是什么?
Springboot 2.0默认选择Hikari连接池,HiKariCP是一个高性能的JDBC连接池技术,号称目前速度最快的连接池。
简单说,优势是速度快。
什么是Druid连接池,为什么要使用它?
Druid连接池是阿里巴巴开源的数据库连接池项目。Druid连接池为监控而生,内置强大的监控功能,监控特性不影响性能。功能强大,能防SQL注入,内置Loging能诊断Hack应用行为。
Druid连接池内置了一个监控页面,提供了非常完备的监控信息,可以快速诊断系统的瓶颈。
简单说,优势就是监控功能很强大。
Github地址:https://github.com/alibaba/druid/
如何整合Druid连接池
1、在pom.xml中导入druid和log4j
<!--druid-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.23</version>
</dependency>
<!--log4j-->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
2、在application.yml中配置使用druid
在原有datasource中指定type
spring:
datasource:
username: root
password: 123456
url: jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC&useUnicode=yes&characterEncoding=UTF-8&useSSL=false
driver-class-name: com.mysql.jdbc.Driver
type: com.alibaba.druid.pool.DruidDataSource
#Spring Boot 默认是不注入这些属性值的,需要自己绑定
#druid 数据源专有配置
initialSize: 5
minIdle: 5
maxActive: 20
maxWait: 60000
timeBetweenEvictionRunsMillis: 60000
minEvictableIdleTimeMillis: 300000
validationQuery: SELECT 1 FROM DUAL
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
poolPreparedStatements: true
#配置监控统计拦截的filters,stat:监控统计、log4j:日志记录、wall:防御sql注入
#如果允许时报错 java.lang.ClassNotFoundException: org.apache.log4j.Priority 则导入 log4j 依赖
filters: stat,wall,log4j
maxPoolPreparedStatementPerConnectionSize: 20
useGlobalDataSourceStat: true
connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
3、测试数据库是否配置成功
在test.java包下的测试类
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import javax.sql.DataSource;
import java.sql.SQLException;
@SpringBootTest
class DemoApplicationTests {
@Autowired
DataSource dataSource;
@Test
void contextLoads() throws SQLException {
System.out.println(dataSource.getClass());
System.out.println(dataSource.getConnection());
}
}
若不报错且打印出信息,则说明配置成功
4、新建DruidConfig配置类
- 新建DataSource 赋值交给spring
- 配置ServletRegistrationBean ,设置后台监控相关属性
- 配置FilterRegistrationBean ,设置后台过滤
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;
import java.util.Map;
@Configuration
public class DruidConfig {
//新建数据源交给spring,并使用ConfigurationProperties注解给数据源赋值
@ConfigurationProperties(prefix = "spring.datasource")
@Bean
public DataSource druidDataSource(){
return new DruidDataSource();
}
//配置Druid后台监控
@Bean
public ServletRegistrationBean statViewServlet(){
ServletRegistrationBean<StatViewServlet> bean =
new ServletRegistrationBean<>(new StatViewServlet(), "/druid/*");
//增加配置
HashMap<String, String> initParametersMap = new HashMap<>();
//后台需要有人登录,账号密码配置
initParametersMap.put("loginUsername","admin");
initParametersMap.put("loginPassword","123456");
//允许谁可以访问
initParametersMap.put("allow","");
//禁止谁能访问
//initParametersMap.put("deny","127.0.0.1");
//设置初始化参数
bean.setInitParameters(initParametersMap);
return bean;
}
//filter 设置后台监控过滤
@Bean
public FilterRegistrationBean webStatFilter(){
FilterRegistrationBean bean = new FilterRegistrationBean();
WebStatFilter webStatFilter = new WebStatFilter();
bean.setFilter(webStatFilter);
//过滤请求map
Map<String, String> initParametersMap = new HashMap<>();
//忽略的统计
initParametersMap.put("exclusions",".js,.css,/druid/*");
bean.setInitParameters(initParametersMap);
return bean;
}
}
5、运行项目正常测试
6、打开 项目路径+/druid ,登录查看后台监控