Spring配置文件所有类型的数据源dataSource

C3P0

1. <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">  
2.     <property name="driverClass" value="${jdbc.driver}" />  
3.     <property name="jdbcUrl" value="${jdbc.url}" />  
4.     <property name="user" value="${jdbc.username}" />  
5.     <property name="password" value="${jdbc.password}" />  
6. </bean></span>  

1. <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">  
2.     <property name="driverClassName" value="${jdbc.driver}" />  
3.     <property name="url" value="${jdbc.url}" />  
4.     <property name="username" value="${jdbc.username}" />  
5.     <property name="password" value="${jdbc.password}" />  
6.   
7.     <property name="maxActive" value="${dbcp.maxActive}" />  
8.     <property name="maxIdle" value="${dbcp.maxIdle}" />  
9.     <property name="defaultAutoCommit" value="false" />  
10.   
11.     <property name="timeBetweenEvictionRunsMillis" value="3600000" />  
12.     <property name="minEvictableIdleTimeMillis" value="3600000" />  
13. </bean></span>  

DriverManagerDataSource

< bean   id = "dataSource"   class = "org.springframework.jdbc.datasource.DriverManagerDataSource" >   

1.     <property name="driverClassName" value="${jdbc.driver}"/>  
2.     <property name="url" value="${jdbc.url}"/>  
3.     <property name="username" value="${jdbc.username}"/>  
4.     <property name="password" value="${jdbc.password}"/>  
5. </bean></span>  

LazyConnectionDataSourceProxy

< bean   id = "dataSource"   class = "org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy" >   

1.     <property name="targetDataSource">  
2.         <bean class="org.logicalcobwebs.proxool.ProxoolDataSource">  
3.             <property name="driver" value="${jdbc.driver}" />  
4.             <property name="driverUrl" value="${jdbc.url}" />  
5.             <property name="user" value="${jdbc.username}" />  
6.             <property name="password" value="${jdbc.password}" />  
7.         </bean>  
8.     </property>  
9. </bean>

SessionFactory

LocalSessionFactoryBean

< bean   id = "sessionFactory"   class = "org.springframework.orm.hibernate4.LocalSessionFactoryBean" >   

1.     <property name="dataSource" ref="dataSource" />  
2.     <property name="mappingResources">  
3.         <list>  
4.             <value>cn/itcast/bean/Employee.hbm.xml</value>  
5.         </list>  
6.     </property>  
7.   
8.     <property name="hibernateProperties">  
9.         <value>  
10.             hibernate.dialect=org.hibernate.dialect.OracleDialect  
11.             hibernate.show_sql=true  
12.             hibernate.format_sql=false  
13.         </value>  
14.     </property>  
15. </bean>