Hibernate在Spring配dataSource

<!-- mysql数据源的配置 -->

<bean id="dataSource"

       class="org.apache.commons.dbcp.BasicDataSource">

       <property name="driverClassName" value="com.mysql.jdbc.Driver"/>

       <property name="url" value="jdbc:mysql://localhost:3306:dbname?characterEncoding=gb2312"/>

       <property name="username" value="root"/>

       <property name="password" value="root"/>

</bean>

 

<!—Sql Serverl2005数据源的配置 -->

<bean id="dataSource"

       class="org.apache.commons.dbcp.BasicDataSource">

       <property name="driverClassName" value=" com.microsoft.sqlserver.jdbc.SQLServerDriver "/>

       <property name="url" value="jdbc:sqlserver://localhost:1433;DatabaseName=dbname "/>

       <property name="username" value="root"/>

       <property name="password" value="root"/>

</bean>

 

<!—Oracle数据源的配置 -->

<bean id="dataSource"

       class="org.apache.commons.dbcp.BasicDataSource">

       <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>

       <property name="url" value="jdbc:oracle:thin:@localhost:1521:dbname"/>

       <property name="username" value="root"/>

       <property name="password" value="root"/>

</bean>