druid

server:
  port: 8761

spring:
  datasource:
    driver-class-name: oracle.jdbc.driver.OracleDriver
    url: jdbc:oracle:thin:@192.168.2001:1521:orcl
    username: xxxx
    password: xxxxx
    initialSize: 5
    maxActive: 20
    minIdle: 5
    maxWait: 60000
    # poolPreparedStatements: oracle-true mysql-false
    poolPreparedStatements: true
    validationQuery: SELECT 1 FROM dual
    validationQueryTimeout: 1000
    testOnBorrow: false
    testOnReturn: false
    testWhileIdle: true
    timeBetweenEvictionRunsMillis: 60000
    minEvictableIdleTimeMillis: 300000
    filters: stat,log4j2,wall
    logSlowSql: true

app:
  appKey: sample
  appSecret: 53cbfabfc5884a72a872a7703dc35702

@Configuration
public class DruidConfigurer {

    private static final String DB_PREFIX = "spring.datasource";

    /**
     * 读取数据库属性
     */
    @ConfigurationProperties(DB_PREFIX)
    @Bean
    public DataSource dataSource() {
        return new DruidDataSource();
    }

    /**
     * 配置一个管理后台的Servlet，配置Druid监控
     */
    @Bean
    public ServletRegistrationBean statViewServlet() {
        ServletRegistrationBean bean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*");

        // IP白名单
        bean.addInitParameter("allow", "127.0.0.1");
        // IP黑名单
        bean.addInitParameter("deny", "");
        // 控制台管理用户
        bean.addInitParameter("loginUsername", "admin");
        bean.addInitParameter("loginPassword", "123456");
        // 是否能够重置数据，禁用HTML页面上的"Reset ALL"功能
        bean.addInitParameter("resetEnable", "true");
        return bean;
    }

    /**
     * 配置一个web监控的filter
     */
    @Bean
    public FilterRegistrationBean webStatFilter() {
        FilterRegistrationBean bean = new FilterRegistrationBean();
        bean.setFilter(new WebStatFilter());

        Map<String, String> initParams = new HashMap<>();
        initParams.put("exclusions", "*.js,*.css,/druid/*");

        bean.setInitParameters(initParams);
        bean.setUrlPatterns(Arrays.asList("/*"));
        return bean;
    }

}

转载于:https://my.oschina.net/u/948444/blog/1929428