接上一篇博文,在 springboot-jdbc 这个项目的基础上,进行整合 Druid 数据源(如果离开数据库的连接,单独整合一个数据源,没什么意义)。
1、引入依赖
在 pom.xml 文件中引入以下依赖
<!--druid数据源-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.2.11</version>
</dependency>
2、配置数据源
在 application.yaml 配置文件中,加入以下配置
spring:
datasource:
username: root
password: pan
url: jdbc:mysql://localhost:3306/mybatis?useSSL=true&useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC
driver-class-name: com.mysql.cj.jdbc.Driver
#druid数据源配置
type: com.alibaba.druid.pool.DruidDataSource
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,wall,log4j
maxPoolPreparedStatementPerConnectionSize: 20
useGlobalDataSourceStat: true
connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
3、使用
新建一个 DruidConfig.java 类,进行登录拦截和过滤,内容如下
package com.yuhuofei.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;
import java.util.Map;
/**
* @Description
* @ClassName DruidConfig
* @Author yuhuofei
* @Date 2022/7/26 21:20
* @Version 1.0
*/
@Configuration
public class DruidConfig {
@Bean
@ConfigurationProperties(prefix = "spring.datasource")
public DataSource druidDataSource() {
return new DruidDataSource();
}
//后台监控,相当于配置web.xml,由于springboot内置了servlet容器,所以没有web.xml,替代方法为ServletRegistrationBean
@Bean
public ServletRegistrationBean servletRegistrationBean() {
ServletRegistrationBean<StatViewServlet> registrationBean = new ServletRegistrationBean<>(new StatViewServlet());
//配置登录账号密码
Map<String, String> initParameters = new HashMap<>();
//增加配置
initParameters.put("loginUsername", "admin");
initParameters.put("loginPassword", "123456");
//允许谁可以访问
initParameters.put("allow", "");
//禁止谁能访问
initParameters.put("xiaoming", "192.168.11.31");
//设置初始化参数
registrationBean.setInitParameters(initParameters);
return registrationBean;
}
//注册过滤器
@Bean
public FilterRegistrationBean webStatFilter() {
FilterRegistrationBean bean = new FilterRegistrationBean();
bean.setFilter(new WebStatFilter());
Map<String, String> stringMap = new HashMap<>();
//以下配置的东西不进行统计
stringMap.put("exclusions", "*.js,*.css,/druid/*");
bean.setInitParameters(stringMap);
return bean;
}
}
4、测试
启动项目,用浏览器访问 http://localhost:8080/login.html ,得到如下结果。
用配置的账号密码登录,得到如下结果。