| [备忘]spring里druid连接池的配置 | ||
| 添加日期：2016/8/3 19:57:54 | 快速返回 返回列表 | 阅读2922次 |
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"> <property name="driverClassName" value="${jdbc.driverClassName}" /> <property name="url" value="${jdbc.url}" /> <property name="username" value="${jdbc.username}" /> <property name="password" value="${jdbc.password}" /> <property name="filters" value="stat" /> <property name="maxActive" value="30" /> <property name="initialSize" value="5" /> <property name="maxWait" value="60000" /> <!-- 获取连接时最大等待时间，单位毫秒 --> <property name="validationQuery" value="SE^LECT 'x'" /> <property name="testWhileIdle" value="true" /> <property name="testOnBorrow" value="true" /> <!-- 防止mysql8小时问题 --> <property name="testOnReturn" value="false" /> </bean> （2）Maven项目的pom里加： <!-- https://mvnrepository.com/artifact/com.alibaba/druid --> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.0.22</version> </dependency> （3）web.xml里加： <!-- Druid Monitor--> <filter> <filter-name>DruidWebStatFilter</filter-name> <filter-class>com.alibaba.druid.support.http.WebStatFilter</filter-class> <init-param> <param-name>exclusions</param-name> <param-value>*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*</param-value> </init-param> </filter> <filter-mapping> <filter-name>DruidWebStatFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <servlet> <servlet-name>DruidStatView</servlet-name> <servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class> <init-param> <!-- 用户名 --> <param-name>loginUsername</param-name> <param-value>xxxx</param-value> </init-param> <init-param> <!-- 密码 --> <param-name>loginPassword</param-name> <param-value>yyyy</param-value> </init-param> </servlet> <servlet-mapping> <servlet-name>DruidStatView</servlet-name> <url-pattern>/druid/*</url-pattern> </servlet-mapping> 注意：空间有防注入，内容里不能有sql语句的关键字，故SE^LECT要去掉^ |
||
| 评论 COMMENTS | |
| 没有评论 No Comments. |
