1、导入jar包
com.alibaba
druid-spring-boot-starter
1.1.10
和log4j
log4j
log4j
1.2.17
2、配置文件
druid:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://ip:3306/Weld?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&failOverReadOnly=false&serverTimezone=UTC&useSSL=false
username:
password:
filters: stat,wall,log4j,config
max-active: 100
initial-size: 5
max-wait: 60000
min-idle: 5
time-between-eviction-runs-millis: 60000
min-evictable-idle-time-millis: 300000
validation-query: select 1
test-while-idle: true
test-on-return: false
test-on-borrow: false
pool-prepared-statements: true
max-open-prepared-statements: 50
max-pool-prepared-statement-per-connection-size: 20
3、新建configuration类
import javax.servlet.Servlet;
import org.apache.log4j.Logger;
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 com.alibaba.druid.support.http.StatViewServlet;
import com.alibaba.druid.support.http.WebStatFilter;
@Configuration
public class DruidConfiguration {
private static Logger logger=Logger.getLogger(DruidConfiguration.class);
@Bean
public ServletRegistrationBean druidServlet(){
logger.info(“init druid servlet configuraton”);
ServletRegistrationBean servletRegistrationBean=new ServletRegistrationBean(new StatViewServlet(),"/druid/");
//白名单
servletRegistrationBean.addInitParameter(“allow”, “127.0.0.1”);
//黑名单,存在共同时,deny优先于allow
servletRegistrationBean.addInitParameter(“deny”, “192.168.1.100”);
servletRegistrationBean.addInitParameter(“loginUsername”, “admin”);
servletRegistrationBean.addInitParameter(“loginPassword”, “admin”);
//是否能够重置数据,禁用html页面的reset all功能
servletRegistrationBean.addInitParameter(“resetEnable”, “false”);
return servletRegistrationBean;
}
@Bean
public FilterRegistrationBean filterRegistrationBean(){
FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter());
filterRegistrationBean.addUrlPatterns("/");
filterRegistrationBean.addInitParameter(“exclusions”, “.js,.gif,.jpg,.png,.css,.ico,/druid/*”);
return filterRegistrationBean;
}
}