druid

http://10.100.14.220/druid/index.html


druid命令生成二进制密码
D:\maven_repo\com\alibaba\druid\1.0.11>java -cp druid-1.0.11.jar com.alibaba.druid.filter.config.ConfigTools #########
iD3ENHefa8iNSu7C/FxsOl6lpek9balREmHRtmt4jFQyPhyJ4zWTE8H40LQuirJwPCvg7pSuKcgrkKZn9b8oKw++

参考

<beans profile="online-stat">
        <bean id="abstractDataSource" abstract="true" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close" lazy-init="false">
            <!-- 配置初始化大小、最小、最大 -->
            <property name="initialSize" value="15" />
            <property name="minIdle" value="15" />
            <property name="maxActive" value="500" />
            <!-- 配置获取连接等待超时的时间 -->
            <property name="maxWait" value="60000" />
            <!-- 配置一个连接在池中最小生存的时间，单位是毫秒 -->
            <property name="minEvictableIdleTimeMillis" value="300000" />
            <!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 -->
            <property name="timeBetweenEvictionRunsMillis" value="30000" />
            <property name="validationQuery" value="SELECT 'x'" />
            <property name="testWhileIdle" value="true" />
            <property name="testOnBorrow" value="false" />
            <property name="testOnReturn" value="false" />
            <!-- 打开PSCache，并且指定每个连接上PSCache的大小 -->
            <property name="poolPreparedStatements" value="false" />
            <property name="maxPoolPreparedStatementPerConnectionSize" value="0" />
            <property name="filters" value="stat,config" />
        </bean>

修改前

initialSize = 5
maxActive = 10
minIdle = 3
maxWait = 60000
removeAbandoned = true
removeAbandonedTimeout = 180
timeBetweenEvictionRunsMillis = 60000
minEvictableIdleTimeMillis = 300000
validationQuery = SELECT 1 FROM DUAL
testWhileIdle = true
testOnBorrow = false
testOnReturn = false
poolPreparedStatements = true
maxPoolPreparedStatementPerConnectionSize = 50
filters = config
connectionProperties = config.decrypt=true

filters
属性类型是字符串，通过别名的方式配置扩展插件，
常用的插件有：
监控统计用的filter:stat
日志用的filter:log4j
防御sql注入的filter:wall
#对于长时间不使用的连接强制关闭
removeAbandoned:true
#超过30分钟开始关闭空闲连接
removeAbandonedTimeout:1800
修改前

initialSize = 15
maxActive = 500
minIdle = 15
maxWait = 60000
removeAbandoned = true
removeAbandonedTimeout = 180
timeBetweenEvictionRunsMillis = 30000
minEvictableIdleTimeMillis = 300000
validationQuery = SELECT 'x'
testWhileIdle = true
testOnBorrow = false
testOnReturn = false
poolPreparedStatements = false
maxPoolPreparedStatementPerConnectionSize = 0
filters = config
connectionProperties = config.decrypt=true

D:\maven_repo\com\alibaba\druid\1.0.11

在工程中引用druid 包

<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.0.11</version>
</dependency>

到jar包所在工程目录执行

C:\Users\shenweifeng\.m2\repository\com\alibaba\druid\1.0.11>java -cp druid-1.0.11.jar com.alibaba.druid.filter.config.ConfigTools you_password


h9gzp23dkJIZ95Xzj/waxsC2oJ1JoWTh76o4aw7+uGGh63ovAULVOrPewOwHP5i3LCIXqNyvpxJ2nceDFBbzVw==