1. Oracle数据库数据源配置

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSourcei"? destroy-method="close">
?????? <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
?????? <property name="url" value="jdbc:oracle:thin:@localhost:1521:orcl" />
?????? <property name="username" value="test"/>
?????? <property name="password" value="test"/>
</bean>
?

2. DB2数据库数据源配置

<bean id="dataSource" class="org.apache.commons.dbcpBasicDataSource" Destroy-method="close">
?????? <property name="driverClassName" value="com.ibm.db2.app.DB2Driver"/>
?????? <property name="url" value="jdbc:db2//localhost:5000/testDB"/>
?????? <property name="username" value="test"/>
?????? <property name="password" value="test"/>
</bean>
?

3. SQL Server数据库数据源配置

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"? Destroy-method="close">
?????? <property name="driverClassName"? value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
?????? <property name="url"? value="jdbc:Microsoft:sqlserver://localhost:1433;DatabaseName=testDB"/>
?????? <property name="username" value="test" />
?????? <property name="password" value="test" />

</bean>
?

4. MySQL数据库数据源配置

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" Destroy-method="close">
?????? <property name="driverClassName" value="com.mysql.jdbc.Driver" />
?????? <property name="url" value="jdbc:mysql://localhost:3309/sampledb"/>
?????? <property name="username" value="test"/>
?????? <property name="password" value="test"/>
</bean>
?

5. HSQLDB数据库数据源配置

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" Destroy-method="close">
?????? <property name="driverClassName" value="org.hsqldb.jdbcDriver"/>
?????? <property name="url" value="jdbc:hsqldb:hsql://localhost:9902"/>
?????? <property name="username" value="test"/>
?????? <property name="password" value="test"/>
</bean>
?