package com.java110.db.druid;
|
|
import org.springframework.boot.web.servlet.ServletRegistrationBean;
|
import org.springframework.context.annotation.Bean;
|
import org.springframework.context.annotation.Configuration;
|
|
import com.alibaba.druid.filter.Filter;
|
import com.alibaba.druid.filter.stat.StatFilter;
|
import com.alibaba.druid.support.http.StatViewServlet;
|
|
/**
|
* durid 配置类
|
*/
|
@Configuration
|
public class DuridConfig {
|
|
|
//sql 显示
|
private static final int DEFAULT_SHOW_SQL_MILLIS = 5000;
|
|
|
/**
|
* 新建Filter
|
* @return Filter
|
*/
|
@Bean
|
public Filter statFilter() {
|
StatFilter filter = new StatFilter();
|
filter.setSlowSqlMillis(DEFAULT_SHOW_SQL_MILLIS);
|
filter.setLogSlowSql(true);
|
filter.setMergeSql(true);
|
return filter;
|
}
|
|
|
/**
|
* servlet注册
|
* @return ServletRegistrationBean
|
*/
|
@Bean
|
public ServletRegistrationBean statViewServlet() {
|
//创建servlet注册实体
|
ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*");
|
//设置ip白名单
|
//servletRegistrationBean.addInitParameter("allow", "127.0.0.1");
|
//设置ip黑名单,如果allow与deny共同存在时,deny优先于allow
|
//servletRegistrationBean.addInitParameter("deny","192.168.0.19");
|
//设置控制台管理用户
|
servletRegistrationBean.addInitParameter("loginUsername", "admin");
|
servletRegistrationBean.addInitParameter("loginPassword", "123456");
|
//是否可以重置数据
|
servletRegistrationBean.addInitParameter("resetEnable", "false");
|
return servletRegistrationBean;
|
}
|
|
}
|