Spring连接各种数据库数据源
1. Oracle数据库数据源配置
<bean id="dataSource" 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" 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" value="test" />
?????? <property name="password" value="test" />
</bean>
?
4. MySQL数据库数据源配置
<bean id="dataSource" 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" 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>
?
