Spring连接各种数据库数据源

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>