配置spring数据源

一般我们将数据源dataSource交给spring容器来管理
****Spring自身实现的简单数据源
<bean id="dataSource" class="org.springframework.jdbc.dataSource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.driver" />
<property name="url" value="jdbc:mysql://127.0.0.1:3306/study? useUnicode=true&characterEncoding=GBK" />
<property name="username" value="lai" />
<property name="password" value="123456" />
</bean>
*****Srping第三方依赖库c3p0数据源(需引入c3p0-0.9.0.jar)
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destory-method="close">
<property name="driverClass" value="com.mysql.jdbc.driver" />
<property name="jdbcUrl" value="jdbc:mysql://127.0.0.1:3306/study? useUnicode=true&characterEncoding=GBK" />
<property name="user" value="lai" />
<property name="password" value="123456" />
<property name="maxPoolSize" value="20" />
<property name="minPoolSize" value="1" />
<!--初始连接池数-->
<property name="initialPoolSize" value="1" />
<!--最大的连接时间-->
<property name="maxIdleTime" value="20" />
</bean>
*****Srping第三方依赖库dbcp数据源
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
destory-method="close">
<property name="driverClassName" value="com.mysql.jdbc.driver" />
<property name="url" value="jdbc:mysql://127.0.0.1:3306/study? useUnicode=true&characterEncoding=GBK" />
<property name="username" value="root" />
<property name="password" value="123456" />
</bean>
destory-method="close" 在关闭spring容器时正常关闭数据源(释放连接资源)