<p>一、加入druid依赖</p>
<div class="dp-highlighter bg_html">
<div class="bar">
<div class="tools">
<strong>[html]</strong>
<a class="ViewSource" href="http://blog.csdn.net/liuchuanhong1/article/details/55050131#" rel="noopener noreferrer" target="_blank" title="view plain"> view plain</a>
<a class="CopyToClipboard" href="http://blog.csdn.net/liuchuanhong1/article/details/55050131#" rel="noopener noreferrer" target="_blank" title="copy"> copy</a>
</div>
</div>
<ol class="dp-xml" start="1"><li class="alt"><span class="comments"><!--druid --></span> </li><li> <span class="tag"><</span><span class="tag-name">dependency</span><span class="tag">></span> </li><li class="alt"> <span class="tag"><</span><span class="tag-name">groupId</span><span class="tag">></span>com.alibaba<span class="tag"></</span><span class="tag-name">groupId</span><span class="tag">></span> </li><li> <span class="tag"><</span><span class="tag-name">artifactId</span><span class="tag">></span>druid<span class="tag"></</span><span class="tag-name">artifactId</span><span class="tag">></span> </li><li class="alt"> <span class="tag"><</span><span class="tag-name">version</span><span class="tag">></span>1.0.27<span class="tag"></</span><span class="tag-name">version</span><span class="tag">></span> </li><li> <span class="tag"></</span><span class="tag-name">dependency</span><span class="tag">></span> </li></ol>
</div> 二、在application.properties配置文件中加入druid配置
<div class="dp-highlighter bg_java">
<div class="bar">
<div class="tools">
<strong>[java]</strong>
<a class="ViewSource" href="http://blog.csdn.net/liuchuanhong1/article/details/55050131#" rel="noopener noreferrer" target="_blank" title="view plain"> view plain</a>
<a class="CopyToClipboard" href="http://blog.csdn.net/liuchuanhong1/article/details/55050131#" rel="noopener noreferrer" target="_blank" title="copy"> copy</a>
</div>
</div>
<ol class="dp-j" start="1"><li class="alt"># 初始化大小，最小，最大 </li><li>spring.datasource.initialSize=<span class="number">5</span> </li><li class="alt">spring.datasource.minIdle=<span class="number">5</span> </li><li>spring.datasource.maxActive=<span class="number">20</span> </li><li class="alt"># 配置获取连接等待超时的时间 </li><li>spring.datasource.maxWait=<span class="number">60000</span> </li><li class="alt"># 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 </li><li>spring.datasource.timeBetweenEvictionRunsMillis=<span class="number">60000</span> </li><li class="alt"># 配置一个连接在池中最小生存的时间，单位是毫秒 </li><li>spring.datasource.minEvictableIdleTimeMillis=<span class="number">300000</span> </li><li class="alt"># 校验SQL，Oracle配置 spring.datasource.validationQuery=SELECT <span class="number">1</span> FROM DUAL，如果不配validationQuery项，则下面三项配置无用 </li><li>spring.datasource.validationQuery=SELECT <span class="string">'x'</span> </li><li class="alt">spring.datasource.testWhileIdle=<span class="keyword">true</span> </li><li>spring.datasource.testOnBorrow=<span class="keyword">false</span> </li><li class="alt">spring.datasource.testOnReturn=<span class="keyword">false</span> </li><li># 打开PSCache，并且指定每个连接上PSCache的大小 </li><li class="alt">spring.datasource.poolPreparedStatements=<span class="keyword">true</span> </li><li>spring.datasource.maxPoolPreparedStatementPerConnectionSize=<span class="number">20</span> </li><li class="alt"># 配置监控统计拦截的filters，去掉后监控界面sql无法统计，<span class="string">'wall'</span>用于防火墙 </li><li>spring.datasource.filters=stat,wall,log4j </li><li class="alt"># 通过connectProperties属性来打开mergeSql功能；慢SQL记录 </li><li>spring.datasource.connectionProperties=druid.stat.mergeSql=<span class="keyword">true</span>;druid.stat.slowSqlMillis=<span class="number">5000</span> </li><li class="alt"># 合并多个DruidDataSource的监控数据 </li><li>spring.datasource.useGlobalDataSourceStat=<span class="keyword">true</span> </li></ol>
</div> 三、配置WebFilter
<div class="dp-highlighter bg_java">
<div class="bar">
<div class="tools">
<strong>[java]</strong>
<a class="ViewSource" href="http://blog.csdn.net/liuchuanhong1/article/details/55050131#" rel="noopener noreferrer" target="_blank" title="view plain"> view plain</a>
<a class="CopyToClipboard" href="http://blog.csdn.net/liuchuanhong1/article/details/55050131#" rel="noopener noreferrer" target="_blank" title="copy"> copy</a>
</div>
</div>
<ol class="dp-j" start="1"><li class="alt"><span class="keyword">package</span> com.chhliu.springboot.jpa; </li><li> </li><li class="alt"><span class="keyword">import</span> javax.servlet.annotation.WebFilter; </li><li><span class="keyword">import</span> javax.servlet.annotation.WebInitParam; </li><li class="alt"> </li><li><span class="keyword">import</span> com.alibaba.druid.support.http.WebStatFilter; </li><li class="alt"> </li><li><span class="annotation">@WebFilt |
|
转播
