spring 娌℃湁鎻愪緵鏁版嵁婧愯繛鎺ユ睜錛岀敤 DBCP銆?/p>
涓嬭澆鍦板潃錛?a target="_blank">http://commons.apache.org/downloads/download_dbcp.cgi
鍥犱負(fù)鏁版嵁搴撹繛鎺ョ敤鎴峰悕鍜屽瘑鐮佷箣綾葷殑鏁忔劅淇℃伅錛屼竴鑸笉浼?xì)鏄惧紡鍦板啓鍦ㄩ厤缃枃錃g閲岋紝鎵浠ョ敤鍒?spring 鐨?propertyConfigurer 銆?/p>
鍦?WEB-INF/classes 鐩綍涓嬫柊涓涓?jdbc.properties 鏂囦歡錛?/p>
Properties浠g爜

- #############
- ## MySql
- #############
- jdbc.driverClassName=com.mysql.jdbc.Driver
- jdbc.url=jdbc:mysql://localhost/framework
- jdbc.username=root
- jdbc.password=123
閰嶇疆 Bean錛?#8220;classpath*:”鎸囧悜 WEB-INF/classes 鐩綍錛夛細(xì)
Xml浠g爜
- <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.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}"/>
- </bean>
-
-
-
鍦ㄥ疄闄呴」鐩腑鐨勫簲鐢ㄦ柟寮忥細(xì)
<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location" value="classpath:db.properties" />
</bean>
<!--bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="${jdbc.driver}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
</bean-->
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="${jdbc.driver}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
</bean>