学步园

共分spring容器自带连接池、项目中创建连接池、服务器创建连接池三种

1、spring容器自带连接池

< bean id = "dataSource" class = "org.springframework.jdbc.datasource.DriverManagerDataSource" ><br /> < property name = "driverClassName" ><br /> < value > com.mysql.jdbc.Driver </ value ><br /> </ property ><br /> < property name = "url" ><br /> < value > jdbc:mysql://127.0.0.1:3306/test </ value ><br /> </ property ><br /> < property name = "username" ><br /> < value > admin </ value ><br /> </ property ><br /> < property name = "password" ><br /> < value /><br /> </ property ><br /> </ bean >

2、项目中创建连接池（一般利用开源项目）

< bean id = "dataSource" class = "org.apache.commons.dbcp.BasicDataSource" destroy-method = "close" ><br /> < property name = "driverClassName" ><br /> < value > com.mysql.jdbc.Driver </ value ><br /> </ property ><br /> < property name = "url" ><br /> < value > jdbc:mysql://127.0.0.1:3306/test </ value ><br /> </ property ><br /> < property name = "username" ><br /> < value > admin </ value ><br /> </ property ><br /> < property name = "password" ><br /> < value /><br /> </ property ><br /> </ bean >  

3、应用服务器创建数据源，项目中通过jndi访问，以tomcat为例

< bean id = "dataSource" class = "org.springframework.jndi.JndiObjectFactoryBean" ><br /> < property name = "jndiName" ><br /> < value > java:comp/env/jdbc/TestDB </ value ><br /> </ property ><br /> </ bean ><br />

转自：www.yoy1.com/thread-19577-1-1.html