Spring配置dbcp数据源

最新推荐文章于 2019-08-14 23:22:00 发布

xingqibaing

最新推荐文章于 2019-08-14 23:22:00 发布

阅读量2.5k

点赞数

分类专栏： Spring 文章标签：配置dbcp

Spring 专栏收录该内容

11 篇文章

订阅专栏

本文介绍如何配置 Spring 中的 DBCP 数据库连接池，特别是针对数据库连接失败后的恢复策略，如使用 testWhileIdle 和 testOnBorrow 属性确保连接的有效性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.spring的配置文件
springmvc-servlet.xml

<bean id="config" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location">
<value>classpath:jdbc.properties</value>
</property>
</bean>
<context:component-scan base-package="com"/>
<mvc:annotation-driven/>
<mvc:resources location="/js/" mapping="/js/**"/>
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="${driverClassName}"/>
<property name="url" value="${url}"/>
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
<property name="maxActive" value="${maxActive}"/>
<property name="minIdle" value="${minIdle}"/>
<property name="maxIdle" value="${maxIdle}"/>
<property name="initialSize" value="${initialSize}"/>
<property name="logAbandoned" value="${logAbandoned}"/>
<property name="removeAbandoned" value="${removeAbandoned}"/>
<property name="removeAbandonedTimeout" value="${removeAbandonedTimeout}"/>
<property name="maxWait" value="${maxWait}"/>
<property name="timeBetweenEvictionRunsMillis" value="${timeBetweenEvictionRunsMillis}"/>
<property name="numTestsPerEvictionRun" value="${numTestsPerEvictionRun}"/>
<property name="minEvictableIdleTimeMillis" value="${minEvictableIdleTimeMillis}"/>
<property name="validationQuery" value="${validationQuery}"/>
<property name="testOnBorrow" value="${testOnBorrow}"/>
</bean>
<bean class="org.springframework.jdbc.core.JdbcTemplate" id="jdbcTemplate">
<property name="dataSource" ref="dataSource"></property>
</bean>

jdbc.properties

#db:oracle
#driverClassName:oracle.jdbc.driver.OracleDriver
#url:jdbc:oracle:thin:@10.4.39.67:11521/yqdb
#username:om
#password:Om4wd5qa
db:oracle
driverClassName:oracle.jdbc.driver.OracleDriver
url:jdbc:oracle:thin:@localhost:1521:orcl
username:lyx
password:lyx
maxActive:100
initialSize:10
maxWait:60000
minIdle:10
maxIdle:15
logAbandoned:true
removeAbandoned:true
removeAbandonedTimeout:10
timeBetweenEvictionRunsMillis:10000
numTestsPerEvictionRun:10
minEvictableIdleTimeMillis:10000
validationQuery:SELECT 1 FROM DUAL
#\u6821\u9A8C\u94FE\u63A5
testWhileIdle:true
testOnBorrow:true

建立数据库链接：

package com.dbcp.conn;
import java.util.List;
import java.util.Map;
import org.springframework.beans.BeansException;
import org.springframework.context.ApplicationContext;
import org.springframework.context.ApplicationContextAware;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.context.support.FileSystemXmlApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;
public class TestDbcp implements ApplicationContextAware
{
private static ApplicationContext ctx ;
//获取上下文
@Override
public void setApplicationContext(ApplicationContext context)
throws BeansException
{
// TODO Auto-generated method stub
ctx = context;
}
/**
* @param args
*/
public static void main(String[] args)
{
// TODO Auto-generated method stub
if(ctx == null)
{
String path = System.getProperty("user.dir") + "\\src\\springmvc-servlet.xml";
//获取上下文
ctx = new FileSystemXmlApplicationContext(path);
//ClassPathXmlApplicationContext("classpath*:springmvc-servlet.xml");
}
JdbcTemplate jdbcTemplate = (JdbcTemplate) ctx.getBean("jdbcTemplate");
List<Map<String,Object>> resultList = jdbcTemplate.queryForList("select t.singerid,t.singername,t.singercountry from SINGER t");
List<Map<String,Object>> resList = jdbcTemplate.queryForList("select * from COMMENTARY t");
System.out.println("歌手表输出查询结果：-----------------------");
for (Map<String, Object> map : resultList)
{
System.out.println(map.get("singerid")+","+map.get("singername")+","+map.get("singercountry"));
}
System.out.println("评论表输出查询结果：-----------------------");
System.out.println();
for (Map<String, Object> map : resList)
{
System.out.println(map.get("commentaryId")+","+map.get("commentary_context")+","+map.get("commentary_time"));
}
}
}