spring 连数据库的配置文件

Spring 数据库连接配置 一　ＯＲＡＣＬＥ 　　　<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" /> <property name="url" value="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.101)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)(SERVER=DEDICATED)))" /> <property name="username" value="rootl" /> <property name="password" value="1234" /> </bean> 二　DB2 　　　<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="com.ibm.db2.jdbc.app.DB2Driver" /> <property name="url" value="jdbc:db2:thin:@localhost:5000/testDB" /> <property name="username" value="rootl" /> <property name="password" value="1234" /> </bean> 三　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="rootl" /> <property name="password" value="1234" /> </bean> 三　MySQL 　　　<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="org.postgresql.Driver" /> <property name="url" value="jdbc:postgresql://localhost/ testDB" /> <property name="username" value="rootl" /> <property name="password" value="1234" /> </bean>

 

org.apache.commons.dbcp.BasicDataSource 需要commons-pool.jar，commons-dbcp-1.2.2.jar，commons-collections-3.2.jar三个JAR包

转载于:https://www.cnblogs.com/sandybeach/archive/2009/07/01/1514431.html