// 配置druid数据源(阿里巴巴的Druid数据库连接池)
讯享网 
讯享网&lt;bean id="dataSource-mysql" <span style="color: rgba(0, 0, 255, 1)">class</span>="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close"&gt; <span style="color: rgba(0, 128, 0, 1)">/*</span><span style="color: rgba(0, 128, 0, 1)">基本属性 url、user、password,其中驱动driverClass可配可不配，如果不配置druid会根据url自动识别dbType，然后选择相应的driverClassName</span><span style="color: rgba(0, 128, 0, 1)">*/</span> &lt;property name="url" value="${jdbc.jdbcUrl}" /&gt; &lt;property name="username" value="${jdbc.user}" /&gt; &lt;property name="password" value="${jdbc.password}" /&gt; <span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)"> 配置初始化大小、最小、最大连接数 </span> &lt;property name="initialSize" value="${druid.initialSize}" /&gt; &lt;property name="minIdle" value="${druid.minIdle}" /&gt; &lt;property name="maxActive" value="${druid.maxActive}" /&gt; <span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)"> 配置数据库编码为UTF8MB4 </span> &lt;property name="connectionInitSqls" value="set names utf8mb4;"/&gt; <span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)"> 配置获取连接等待超时的时间 </span> &lt;property name="maxWait" value="${druid.maxWait}" /&gt; <span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)"> 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 </span> &lt;property name="timeBetweenEvictionRunsMillis"<span style="color: rgba(0, 0, 0, 1)"> value</span>="${druid.timeBetweenEvictionRunsMillis}" /&gt; <span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)"> 配置一个连接在池中最小生存的时间，单位是毫秒 </span> &lt;property name="minEvictableIdleTimeMillis"<span style="color: rgba(0, 0, 0, 1)"> value</span>="${druid.minEvictableIdleTimeMillis}" /&gt; &lt;property name="validationQuery" value="${druid.validationQuery}" /&gt; &lt;property name="testWhileIdle" value="${druid.testWhileIdle}" /&gt; &lt;property name="testOnBorrow" value="${druid.testOnBorrow}" /&gt; &lt;property name="testOnReturn" value="${druid.testOnReturn}" /&gt; <span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)"> 打开PSCache，并且指定每个连接上PSCache的大小 </span> &lt;property name="poolPreparedStatements"<span style="color: rgba(0, 0, 0, 1)"> value</span>="${druid.poolPreparedStatements}" /&gt; &lt;property name="maxPoolPreparedStatementPerConnectionSize"<span style="color: rgba(0, 0, 0, 1)"> value</span>="${druid.maxPoolPreparedStatementPerConnectionSize}" /&gt; <span style="color: rgba(0, 128, 0, 1)">/*</span><span style="color: rgba(0, 128, 0, 1)">打开Druid的监控统计功能(Druid内置提供一个StatFilter，用于统计监控信息。StatFilter的别名是stat)</span><span style="color: rgba(0, 128, 0, 1)">*/</span> <span style="color: rgba(0, 128, 0, 1)">/*</span><span style="color: rgba(0, 128, 0, 1)">配置监控统计拦截的filters，去掉后监控界面sql无法统计，常见的filters有stat,wall,log4j等 </span><span style="color: rgba(0, 128, 0, 1)">*/</span> &lt;property name="filters" value="${druid.filters}" /&gt; &lt;/bean&gt;</pre>