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

<span style="background-color: rgb(255, 0, 0);"></span><pre name="code" class="html"><pre name="code" class="html"><span style="background-color: rgb(255, 0, 0);"><span style="font-size:18px;">一、<span style="font-family:Arial, Helvetica, sans-serif;">DBCP</span></span></span>

<span style="font-size:18px;"><bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"><property name="driverClass" value="${jdbc.driver}" /><property name="jdbcUrl" value="${jdbc.url}" /><property name="user" value="${jdbc.username}" /><property name="password" value="${jdbc.password}" /></bean></span>

二、C3P0

<span style="background-color: rgb(255, 0, 0);"><span style="font-size:18px;"><span style="font-family: Arial, Helvetica, sans-serif;"></span></span></span><pre name="code" class="html"><span style="font-size:18px;"><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}" /><property name="maxActive" value="${dbcp.maxActive}" /><property name="maxIdle" value="${dbcp.maxIdle}" /><property name="defaultAutoCommit" value="false" /><property name="timeBetweenEvictionRunsMillis" value="3600000" /><property name="minEvictableIdleTimeMillis" value="3600000" /></bean></span>

<span style="background-color: rgb(255, 0, 0);"><span style="font-family: Arial, Helvetica, sans-serif;"></span></span>

<span style="background-color: rgb(255, 0, 0);"><span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size:18px;"><strong>三、DriverManagerDataSource</strong></span></span></span>

<span style="background-color: rgb(255, 0, 0);"><span style="font-family: Arial, Helvetica, sans-serif;"></span></span><pre name="code" class="html"><span style="font-size:18px;"><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></span>

<span style="background-color: rgb(255, 0, 0);"><span style="font-family: Arial, Helvetica, sans-serif;"></span></span>

四、LazyConnectionDataSourceProxy

<span style="background-color: rgb(255, 0, 0);"><span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size:18px;"></span></span></span><pre name="code" class="html"><bean id="dataSource" class="org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy"><property name="targetDataSource"><bean class="org.logicalcobwebs.proxool.ProxoolDataSource"><property name="driver" value="${jdbc.driver}" /><property name="driverUrl" value="${jdbc.url}" /><property name="user" value="${jdbc.username}" /><property name="password" value="${jdbc.password}" /></bean></property></bean><strong> </strong>

<span style="background-color: rgb(255, 0, 0);"><span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size:18px;"><strong></strong></span></span></span>

SessionFactory

<span style="background-color: rgb(255, 0, 0);"><span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size:18px;"><strong>类型一、LocalSessionFactoryBean</strong></span></span></span>

<span style="background-color: rgb(255, 0, 0);"><span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size:18px;"></span></span></span><pre name="code" class="html"><bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean"><property name="dataSource" ref="dataSource" /><property name="mappingResources"><list><value>cn/itcast/bean/Employee.hbm.xml</value></list></property><property name="hibernateProperties"><value>hibernate.dialect=org.hibernate.dialect.OracleDialecthibernate.show_sql=truehibernate.format_sql=false</value></property></bean>