JDBC的支持——DataSource的配置

Spring中DataSource 的注入方法：
1） 在进行单元测试或应用系统比较小时，可以使用Spring的DriverManagerDataSource：

Xml代码

1. < bean   id = "ds"    
2. class = "org.springframework.jdbc .datasource .DriverManagerDataSource" >   
3. < property   name = "driverClassName"   value = "com.mysql.jdbc .Driver" />   
4. < property   name = "url"   value = "jdbc :mysql://localhost:3306/payout" />   
5. < property   name = "username"   value = "root" />   
6. < property   name = "password"   value = "admin" />   
7. </ bean >   

<bean id="ds" 
class="org.springframework.jdbc
.datasource
.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc
.Driver"/>
<property name="url" value="jdbc
:mysql://localhost:3306/payout"/>
<property name="username" value="root"/>
<property name="password" value="admin"/>
</bean>

 

注：DriverManagerDataSource不具备连接池的功能

 

2）使用第三方数据库连接池，如DBCP：

Xml代码

1. < bean   id = "dataSource "   
2. class = "org.apache.commons.dbcp.BasicDataSource"    
3. destroy-method = "close"   lazy-init = "true" >   
4. < property   name = "driverClassName"   value = "com.mysql.jdbc .Driver" />   
5. < property   name = "url"   
6.     value = "jdbc :mysql://localhost:3306/payout" />   
7. < property   name = "username"   value = "root" />   
8. < property   name = "password"   value = "admin" />   
9. </ bean >   

<bean id="dataSource
"
class="org.apache.commons.dbcp.BasicDataSource" 
destroy-method="close" lazy-init="true">
<property name="driverClassName" value="com.mysql.jdbc
.Driver"/>
<property name="url"
	value="jdbc
:mysql://localhost:3306/payout"/>
<property name="username" value="root"/>
<property name="password" value="admin"/>
</bean>

 

通过指定destroy-method属性，告诉Spring在关闭时会调用BasicDataSource的close方法，释放资源。

 

3）通过JNDI查找DataSource ：

 

Xml代码

1. < bean   id = "dataSource "   
2. class = "org.springframework.jndi.JndiObjectFactoryBean" >   
3. < property   name = "jndiName" >   
4. < value > java:comp/env/jdbc /myDatasource </ value >   
5. </ property >   
6. </ bean >