数据库阿里连接池 druid配置详解 - Guoqiangxu1992/SecondHandCarManager GitHub Wiki

jdbc.properties

jdbc.driverClassName=com.mysql.jdbc.Driver jdbc.url=jdbc:mysql://localhost:3306/Second_hand?useUnicode=true&characterEncoding=UTF8&allowMultiQueries=true jdbc.username=root jdbc.password=563102 jdbc.initialSize=1 jdbc.maxActive=50 jdbc.filters: stat jdbc.maxWait: 60000 jdbc.minIdle: 10 jdbc.maxIdle: 15 jdbc.timeBetweenEvictionRunsMillis: 60000 jdbc.minEvictableIdleTimeMillis: 300000 jdbc.validationQuery: SELECT 'x' jdbc.testWhileIdle: true jdbc.testOnBorrow: false jdbc.testOnReturn: false jdbc.maxOpenPreparedStatements: 20 jdbc.removeAbandoned: true jdbc.removeAbandonedTimeout: 1800 jdbc.logAbandoned: true

<context:property-placeholder location="classpath:properties/jdbc.properties" ignore-unresolvable="true"/>

配置监控：

DruidWebStatFilter com.alibaba.druid.support.http.WebStatFilter exclusions *. js ,*. gif ,*. jpg ,*. png ,*. css ,*. ico ,/ druid /* DruidWebStatFilter /* DruidStatView com.alibaba.druid.support.http.StatViewServlet DruidStatView /druid/*

访问界面： http://localhost:8086/SecondHandCarManager/druid/index.html