工程ＢLOG的数据库连接

jdbc.properties
jdbc.url=jdbc:oracle:thin:@10.17.37.207:1521:blog
jdbc.driver=oracle.jdbc.driver.OracleDriver
jdbc.username=blog
jdbc.password=blog

applicationContext-Resources.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN"
    "http://www.springframework.org/dtd/spring-beans.dtd">
<beans default-lazy-init="true">
<bean id="propertyConfigurer"
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"
lazy-init="false">
<property name="locations">
<list>
<value>classpath:jdbc.properties</value>
</list>
</property>
</bean>
<bean id="dataSource"
class="org.logicalcobwebs.proxool.ProxoolDataSource" destroy-method="reset">
<property name="driver">
<value>${jdbc.driver}</value>
</property>
<property name="driverUrl">
<value>${jdbc.url}</value>
</property>
<property name="user">
<value>${jdbc.username}</value>
</property>
<property name="password">
<value>${jdbc.password}</value>
</property>
<property name="alias">
<value>community</value>
</property>
<property name="houseKeepingTestSql">
<value>select sysdate from DUAL</value>
</property>
<property name="testBeforeUse">
<value>false</value>
</property>
<property name="maximumConnectionCount">
<value>10</value>
</property>
    <property name="minimumConnectionCount">
      <value>5</value>
    </property>
<property name="delegateProperties">
<value>
user=${jdbc.username},password=${jdbc.password}
</value>
</property>
</bean>
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource">
<ref bean="dataSource" />
</property>
</bean>
<!-- 定义DWR的DAO时使用此模板作为父模板 -->
<bean id="securityTemplate" abstract="true"
class="org.springframework.aop.framework.ProxyFactoryBean">
</bean>
</beans>