1. Manage DBCP Connection pool * First introduce DBCP 2 jar package * Com.springsource.org.apache.commons.dbcp-1.2.2.osgi.jar * COM.SPRINGSOURC E.org.apache.commons.pool-1.5.3.jar * Writing configuration file <bean id= "DataSource" class= "Org.apache.commons.dbcp.BasicDataSo Urce "> <property name=" driverclassname "value=" Com.mysql.jdbc.Driver "/> <property name=" URL "value=" jdbc:mysql:///spring_day03 "/> <property name=" username "value=" root "/> <prop Erty name= "Password" value= "root"/> </bean>2. Manage C3P0 Connection Pool * First introduce C3P0 jar package * Com.springsource.com.mchange.v2.c3p0-0.9.1.2.jar * Write configuration file <bean id= "data Source "class=" Com.mchange.v2.c3p0.ComboPooledDataSource "> <property name=" driverclass "value=" Com.mysql. Jdbc. Driver "/> <property name=" Jdbcurl "value=" jdbc:mysql:///spring_day03 "/> <property name=" User "value=" root "/> <property name=" password "value=" root "/> </bean>
Spring Framework manages open-source connection pools