spring配置datasource三种方式spring配置datasource三种方式.doc

spring配置datasource三种方式 1、使用org.springframework.jdbc.datasource.DriverManagerDataSource?DriverManagerDataSource建立connection,根本没有的作用。?bean id=dataSource class=org.springframework.jdbc.datasource.DriverManagerDataSource?????????????? property name=driverClassNamevalue${jdbc.driverClassName}/value/property?????????????? property name=urlvalue${jdbc.url}/value/property?????????????? property name=usernamevalue${jdbc.username}/value/property?????????????? property name=passwordvalue${jdbc.password}/value/property??????? /bean?2、使用mons.dbcp.BasicDataSource?说明:这是一种推荐说明的数据源配置方式，它真正使用了连接池技术?bean id=dataSource class=mons.dbcp.BasicDataSource?????????????? property name=driverClassName????????????????????? valueoracle.jdbc.driver.OracleDriver/value?????????????? /property?????????????? property name=url????????????????????? valuejdbc:oracle:thin:@localhost:1521:orcl/value?????????????? /property?????????????? property name=username????????????????????? valuetest/value?????????????? /property?????????????? property name=password????????????????????? valuetest/value?????????????? /property?????????????? property name=maxActive????????????????????? value255/value?????????????? /property?????????????? property name=maxIdle????????????????????? value2/value?????????????? /property?????????????? property name=maxWait????????????????????? value120000/value?????????????? /property??????? /bean?3、使用org.springframework.jndi.JndiObjectFactoryBean?说明:JndiObjectFactoryBean 能JNDI获取DataSource?bean id=dataSource class=org.springframework.jndi.JndiObjectFactoryBean?????????????? property name=jndiNamevaluejava:comp/env/jdbc/roseindiaDB_local/value/property??????? /bean?总结：3种方式中的第一种没有使用连接池，故少在项目中用到，第三种方式需要在web server中配置数据源，不方便于部署，本人推荐使用?配置一个数据源???? Spring在第三方依赖包中包含了两个数据源的实现类包，其一是Apache的DBCP，其二是 C3P0。可以在Spring配置文件中利用?DBCP数据源???? DBCP类包位于 spring_home/spring_home/lib/jakarta-commons/commons-dbcp.jar，DBCP是一个依 Jakarta commons-pool对象池机制的数据库连接池，所以在类路径下还必须包括s