jdbc.url=jdbc:hsqldb:hsql://localhost/xdb
jdbc.username=sa
jdbc.password=
jdbc.driver=不同的資料庫廠商驅動,此處不一一列舉
接下來,詳細配置代碼如下:
<beans>
<!-- picks up and registers appconfig as a bean definition -->
<context:component-scan base-package="com.acme"/>
<context:property-placeholder location="classpath:/com/acme/jdbc.properties"/>
<bean class="org.springframework.jdbc.datasource.drivermanagerdatasource">
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</bean>
</beans>
dbcp連接配接池
<bean id="datasource" class="org.apache.commons.dbcp.basicdatasource" destroy-method="close">
<property name="driverclassname" value="${jdbc.driverclassname}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
c3p0
<bean id="datasource" class="com.mchange.v2.c3p0.combopooleddatasource" destroy-method="close">
<property name="driverclass" value="${jdbc.driverclassname}"/>
<property name="jdbcurl" value="${jdbc.url}"/>
<property name="user" value="${jdbc.username}"/>
<context:property-placeholder location="jdbc.properties"/>
proxool
<bean id="datasource" class="org.logicalcobwebs.proxool.proxooldatasource" destroy-method="close">
當然還有druid 、dbpool 、jakarta dbcp 等
最新内容請見作者的github頁:http://qaseven.github.io/