数据源druid参考配置

我会带着你远行 2022-12-30 08:04 130阅读 0赞

<?xml version="1.0" encoding="UTF-8"?>
    <druid>
    	
    	<property name="driverClassName">com.mysql.jdbc.Driver</property>
    	<property name="url">
    		jdbc:mysql://localhost:3307/itp?autoReconnect=true&failOverReadOnly=false&useUnicode=true&characterEncoding=UTF-8
    	</property>
    	<property name="username">root</property>
    	<property name="password">123456</property>
    	
    	
    	<property name="initialSize">1</property>
    	<property name="maxActive">20</property>
    	<property name="minIdle">10</property>
    	<property name="maxIdle">15</property>
    	
    	
    	<property name="maxWait">60000</property>
    	
    	
    	<property name="testWhileIdle">true</property>
    	<property name="testOnBorrow">true</property>
    	<property name="testOnReturn">false</property>
    	
    	
    	<property name="timeBetweenEvictionRunsMillis">60000</property>
    	<property name="minEvictableIdleTimeMillis">300000</property>
    	
    	
    	<property name="validationQuery">SELECT 'x'</property>
    	<property name="validationQueryTimeout">300000</property>
    	
    	
    	<property name="removeAbandoned">true</property>
    	<property name="removeAbandonedTimeout">1800</property>
    	
    	
    	<property name="logAbandoned">true</property>
    	
    	
    	<property name="poolPreparedStatements">true</property>
    	<property name="maxOpenPreparedStatements">20</property>
    	
    	<property name="init">true</property>
    </druid>

DruidPlugin 中有很多 setter 方法，使用其配置其它选项即可，如果碰到无法实现的，可以先 druidPlugin.dataSource() 然后强制转成 DruidDataSource 类型后使用它的 setter 方法即可打完收工