//package com.iplatform.base.config;
|
//
|
//import com.alibaba.druid.support.http.StatViewServlet;
|
//import com.alibaba.druid.support.http.WebStatFilter;
|
//import com.alibaba.druid.wall.WallConfig;
|
//import com.alibaba.druid.wall.WallFilter;
|
//import com.iplatform.core.PlatformConfiguration;
|
//import org.springframework.boot.autoconfigure.condition.ConditionalOnProperty;
|
//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
|
//@ConditionalOnProperty(prefix = "iplatform.api", name = "time-enabled", havingValue = "true", matchIfMissing = false)
|
//public class DruidMonitorConfig extends PlatformConfiguration {
|
//
|
//// @Bean(name="dataSource")
|
//// public DataSource dataSource(){
|
//// return (DataSource)JdbcInspector.getInstance().getPrimaryDataSourceMeta();
|
//// }
|
//
|
// /**
|
// * MethodName: statViewServlet
|
// * Description: 配置 Druid 监控管理后台的Servlet,
|
// * 内置 Servlet 容器时没有web.xml文件，所以使用 Spring Boot 的注册 Servlet 方式
|
// *
|
// * @return org.springframework.boot.web.servlet.ServletRegistrationBean
|
// * @author Tianjiao
|
// * @date 2021/5/27 10:11
|
// * @params: []
|
// */
|
// @Bean
|
// public ServletRegistrationBean<StatViewServlet> statViewServlet() {
|
// ServletRegistrationBean<StatViewServlet> bean = 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", "druid");
|
// //后台管理界面的登录密码
|
// initParams.put("loginPassword", "druid");
|
//
|
// //后台允许谁可以访问
|
// //initParams.put("allow", "localhost")：表示只有本机可以访问
|
// //initParams.put("allow", "")：为空或者为null时，表示允许所有访问
|
// initParams.put("allow", "");
|
// //deny：Druid 后台拒绝谁访问
|
// //initParams.put("tianjiao", "192.168.1.20");表示禁止此ip访问
|
//
|
// //设置初始化参数
|
// bean.setInitParameters(initParams);
|
// logger.info("druid监控设置参数 = {}", initParams);
|
// return bean;
|
// }
|
//
|
// @Bean("webStatFilter")
|
// public FilterRegistrationBean<WebStatFilter> webStatFilter(DataSource dataSource) {
|
// FilterRegistrationBean<WebStatFilter> bean = new FilterRegistrationBean<>();
|
//// WebStatFilter webStatFilter = new WebStatFilter();
|
//// WebAppStat webAppStat = new WebAppStat();
|
// bean.setFilter(new WebStatFilter());
|
// Map<String, String> initParams = new HashMap<>();
|
//// 这些东西不进行统计
|
// initParams.put("exclusions", "*.js,*.css,/druid/*");
|
// bean.setInitParameters(initParams);
|
//// bean.setUrlPatterns(Arrays.asList("/*"));
|
// bean.addUrlPatterns("/*");
|
// logger.info("druid WebStatFilter = {}", initParams);
|
//
|
//// List<Filter> filters = new ArrayList<>(4);
|
//// filters.add(bean.getFilter());
|
//// DruidDataSource druidDataSource = (DruidDataSource)dataSource;
|
//// druidDataSource.setProxyFilters(filters);
|
// return bean;
|
// }
|
//
|
// @Bean
|
// public WallFilter wallFilter(){
|
// WallFilter wallFilter = new WallFilter();
|
// wallFilter.setConfig(wallConfig());
|
//
|
// //
|
//// DruidDataSource druidDataSource = (DruidDataSource)dataSource;
|
//// try {
|
//// druidDataSource.setFilters("webStatFilter");
|
//// } catch (SQLException e) {
|
//// throw new RuntimeException(e);
|
//// }
|
//
|
//// StatFilter statFilter = new StatFilter();
|
//// statFilter.setLogSlowSql(true);
|
//// statFilter.setSlowSqlMillis(200);
|
////
|
//// List<Filter> filters = new ArrayList<>(4);
|
//// filters.add(statFilter);
|
//// druidDataSource.setProxyFilters(filters);
|
//// logger.info("--------------> 设置了druid过滤器!");
|
//
|
// return wallFilter;
|
// }
|
//
|
// @Bean
|
// public WallConfig wallConfig(){
|
// WallConfig wallConfig = new WallConfig();
|
// wallConfig.setMultiStatementAllow(true);
|
// //允许一次执行多条语句
|
// wallConfig.setNoneBaseStatementAllow(true);
|
// //是否允许非以上基本语句的其他语句
|
// wallConfig.setStrictSyntaxCheck(false);
|
// //是否进行严格的语法检测
|
// return wallConfig;
|
// }
|
//}
|
