spring配置datasource三种方式.doc

HYPERLINK /batys/archive/2012/10/17/2727637.html 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/spr