Spring连接各种数据库数据源

来源：互联网发布：aisino金税盘开票软件编辑：程序博客网时间：2024/05/22 05:09

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>

1 0