spring配置数据源.docVIP

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中配置数据源，不方便于部署，本人推荐使用每二种方式进行数据源的配置。 ?xml version=1.0 encoding=UTF-8? beans xmlns=/schema/beans xmlns:xsi=/2001/XMLSchema-instance xmlns:aop=/schema/aop xmlns:tx=/schema/tx xsi:schemaLocation=/schema/beans /schema/beans/spring-beans-2.0.xsd /schema/