1.Druid
Druid 是阿里巴巴开源平台上一个数据库连接池实现,结合了 C3P0、DBCP 等 DB 池的优点,同时加入了日志监控。
com.alibaba.druid.pool.DruidDataSource 基本配置参数:
参考博文:https://www.cnblogs.com/kingsonfu/p/10343947.html
2. 整合Druid
1. 导入Druid依赖
<!-- https://mvnrepository.com/artifact/com.alibaba/druid -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.22</version>
</dependency>
2. 配置Application.yml配置文件
- 通过spring.datasource.type: type: com.alibaba.druid.pool.DruidDataSource
指定数据源为Druid
还可以设置数据源的基本设置
spring:
datasource:
data-username: root
password: 001129
#如果报时区错误 就增加一个时区配置就好了
url: jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC&characterEncoding=utf-8
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 依赖即可,Maven 地址:https://mvnrepository.com/artifact/log4j/log4j
filters: stat,wall,log4j
maxPoolPreparedStatementPerConnectionSize: 20
useGlobalDataSourceStat: true
connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
3. 导入log4j依赖
<!-- https://mvnrepository.com/artifact/log4j/log4j -->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
4. 为DruidDataSource绑定配置文件
- 创建一个配置类,将DruidDataSource 注册到bean
@Configuration
public class DruidConfig {
//将自定义的数据源加入到ioc中,不再让springboot自动创建
//ConfigurationProperties 将配置文件中前缀为spring.datasource的属性
//注入到com.alibaba.druid.pool.DruidDataSource同名参数中
@Bean
@ConfigurationProperties(prefix = "spring.datasource")
public DataSource druidDataSource(){
return new DruidDataSource();
}
}
5. 测试
//自动注入数据源
@Autowired
DataSource dataSource;
@Test
void contextLoads() throws SQLException {
//默认数据源:class com.zaxxer.hikari.HikariDataSource
System.out.println(dataSource.getClass());
Connection connection = dataSource.getConnection();
System.out.println(connection);
connection.close();
}
}
以前的默认数据源为:class com.zaxxer.hikari.HikariDataSource
我们设置数据源为Druid后为:com.alibaba.druid.pool.DruidDataSource
6. 配置Druid数据监控
//配置Druid 监控管理后台的servlet
//需要使用内嵌servlet 因为容器没有web.xml配置文件
@Bean
public ServletRegistrationBean servletRegistrationBean(){
ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean
(new StatViewServlet(),"/druid/*");
//这些参数可以在 com.alibaba.druid.support.http.StatViewServlet
//的父类 com.alibaba.druid.support.http.ResourceServlet 中刚找到
Map<String ,String> initParams = new HashMap<>();
//后台管理界面登录账号
initParams.put("loginUsername","admin");
//后台管理界面登录密码
initParams.put("loginPassword","123456");
//后台允许谁可以访问
//initParams.put("allow", "localhost"):表示只有本机可以访问
//initParams.put("allow", ""):为空或者为null时,表示允许所有访问
initParams.put("allow","");
//initParams.put("deny", "192.168.2.176");表示禁止此ip访问
//设置初始化参数
servletRegistrationBean.setInitParameters(initParams);
return servletRegistrationBean;
}
//配置 Druid 监控 之 web 监控的 filter
//WebStatFilter:用于配置Web和Druid数据源之间的管理关联监控统计
@Bean
public FilterRegistrationBean registrationBean(){
FilterRegistrationBean bean = new FilterRegistrationBean();
bean.setFilter(new WebStatFilter());
Map<String,String> initParams = new HashMap<>();
//排除这些请求的拦截
initParams.put("exclusions","*.js,*.css,/druid/*");
bean.setInitParameters(initParams);
bean.setUrlPatterns(Arrays.asList("/*"));
return bean;
}
}
7.访问Druid的login页面
访问: http://localhost:8080/druid/login.html
输入用户名和密码