modify

Helius

2021-03-18 605ad677377b5aa3e163890ef3ca43df49f57e67

 zq-erp/src/main/java/com/matrix/config/DataSourceConfig.java

@@ -25,80 +25,80 @@
@MapperScan(value = { "com.xincheng.**.dao","com.matrix.**.dao"})
@Configuration
public class DataSourceConfig {

   /**
    * 数据源配置
    *
    * @return
    * @author jiangyouyao
    */
   @ConfigurationProperties(prefix = "spring.datasource")
   @Bean
   public DataSource druid() {

      DruidDataSource druidDataSource = new DruidDataSource();

      List<Filter> filters = new ArrayList<>();
      filters.add(wallFilter());
      druidDataSource.setProxyFilters(filters);

      return druidDataSource;
   }


   /**
    * 注册一个StatViewServlet
    * @return
    */
   @Bean
   public ServletRegistrationBean druidStatViewServlet(){
      //org.springframework.boot.context.embedded.ServletRegistrationBean提供类的进行注册.
      ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(),"/druid/*");

      //添加初始化参数：initParams
      //白名单：
      servletRegistrationBean.addInitParameter("allow","");
      //IP黑名单 (存在共同时，deny优先于allow) : 如果满足deny的话提示:Sorry, you are not permitted to view this page.
      //servletRegistrationBean.addInitParameter("deny","");
      //登录查看信息的账号密码.
      /*servletRegistrationBean.addInitParameter("loginUsername","xc_erp_scop");
      servletRegistrationBean.addInitParameter("loginPassword","xc_erp_scop");*/
      //是否能够重置数据.
      servletRegistrationBean.addInitParameter("resetEnable","false");
      return servletRegistrationBean;
   }

   /**
    * 注册一个：filterRegistrationBean
    * @return
    */
   @Bean
   public FilterRegistrationBean druidStatFilter(){

      FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter());

      //添加过滤规则.
      filterRegistrationBean.addUrlPatterns("/*");

      //添加不需要忽略的格式信息.
      filterRegistrationBean.addInitParameter("exclusions","*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");
      return filterRegistrationBean;
   }

   @Bean
   public WallFilter wallFilter(){
      WallFilter wallFilter = new WallFilter();
      wallFilter.setConfig(wallConfig());
      return wallFilter;
   }

   @Bean
   public WallConfig wallConfig() {
      WallConfig config = new WallConfig();
      config.setMultiStatementAllow(true);//允许一次执行多条语句
      config.setNoneBaseStatementAllow(true);//允许一次执行多条语句
      return config;
   }
//
//   /**
//    * 数据源配置
//    *
//    * @return
//    * @author jiangyouyao
//    */
//   @ConfigurationProperties(prefix = "spring.datasource")
//   @Bean
//   public DataSource druid() {
//
//      DruidDataSource druidDataSource = new DruidDataSource();
//
//      List<Filter> filters = new ArrayList<>();
//      filters.add(wallFilter());
//      druidDataSource.setProxyFilters(filters);
//
//      return druidDataSource;
//   }
//
//
//   /**
//    * 注册一个StatViewServlet
//    * @return
//    */
//   @Bean
//   public ServletRegistrationBean druidStatViewServlet(){
//      //org.springframework.boot.context.embedded.ServletRegistrationBean提供类的进行注册.
//      ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(),"/druid/*");
//
//      //添加初始化参数：initParams
//      //白名单：
//      servletRegistrationBean.addInitParameter("allow","");
//      //IP黑名单 (存在共同时，deny优先于allow) : 如果满足deny的话提示:Sorry, you are not permitted to view this page.
//      //servletRegistrationBean.addInitParameter("deny","");
//      //登录查看信息的账号密码.
//      /*servletRegistrationBean.addInitParameter("loginUsername","xc_erp_scop");
//      servletRegistrationBean.addInitParameter("loginPassword","xc_erp_scop");*/
//      //是否能够重置数据.
//      servletRegistrationBean.addInitParameter("resetEnable","false");
//      return servletRegistrationBean;
//   }
//
//   /**
//    * 注册一个：filterRegistrationBean
//    * @return
//    */
//   @Bean
//   public FilterRegistrationBean druidStatFilter(){
//
//      FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter());
//
//      //添加过滤规则.
//      filterRegistrationBean.addUrlPatterns("/*");
//
//      //添加不需要忽略的格式信息.
//      filterRegistrationBean.addInitParameter("exclusions","*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");
//      return filterRegistrationBean;
//   }
//
//   @Bean
//   public WallFilter wallFilter(){
//      WallFilter wallFilter = new WallFilter();
//      wallFilter.setConfig(wallConfig());
//      return wallFilter;
//   }
//
//   @Bean
//   public WallConfig wallConfig() {
//      WallConfig config = new WallConfig();
//      config.setMultiStatementAllow(true);//允许一次执行多条语句
//      config.setNoneBaseStatementAllow(true);//允许一次执行多条语句
//      return config;
//   }


}