2. public Slf4jLogFilter logFilter () {
  4.     Slf4jLogFilter logFilter = new Slf4jLogFilter();
  5.     logFilter.setStatementExecutableSqlLogEnable(true);
  6.     logFilter.setStatementLogEnabled(false);
  7.     return logFilter;
  8. }
  10. @Bean
  11. public StatFilter statFilter () {
  13.     StatFilter statFilter = new StatFilter();
  14.     statFilter.setLogSlowSql(true);
  15.     statFilter.setMergeSql(true);
  17. }
  19. /**
  20.  * sql防火墙过滤器配置
  21.  * @param wallConfig
  22.  * @return
  23.  */
  24. @Bean
  25. public WallFilter wallFilter (WallConfig wallConfig) {
  27.     WallFilter wallFilter = new WallFilter();
  28.     wallFilter.setConfig(wallConfig);
  29.     wallFilter.setLogViolation(true);//对被认为是攻击的SQL进行LOG.error输出
  30.     wallFilter.setThrowException(false);//对被认为是攻击的SQL抛出SQLException
  33. /**
  34.  * sql防火墙配置
  35.  * @return
  36.  */
  37. @Bean
  38. public WallConfig wallConfig () {
  40.     WallConfig wallConfig = new WallConfig();
  41.     wallConfig.setAlterTableAllow(false);
  42.     wallConfig.setCreateTableAllow(false);
  43.     wallConfig.setDeleteAllow(false);
  44.     wallConfig.setMergeAllow(false);
  45.     wallConfig.setDescribeAllow(false);
  46.     wallConfig.setShowAllow(false);