Spring-配置数据源的4中方式

第一种：使用spring自带的 DriverManagerDataSource

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop"
	xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd  
        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd  
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd  
        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">

	<bean id="dataSource"
		class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName">
			<value>oracle.jdbc.driver.OracleDriver</value>
		</property>
		<property name="url">
			<value>jdbc:oracle:thin:@192.168.24.102:1521:sms</value>
		</property>
		<property name="username">
			<value>test</value>
		</property>
		<property name="password">
			<value>test</value>
		</property>
	</bean>
</beans> 

第二种：DBCP数据源（需要下载的jar包：commons-dbcp.jar，commons-pool.jar）

jar下载地址：http://download.csdn.net/detail/llhhyy1989/4496980

<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:@192.168.24.102:1521:sms" />
	<property name="username" value="test" />
	<property name="password" value="test" />
</bean>

第三种：C3P0数据源

jar下载地址：http://download.csdn.net/detail/llhhyy1989/4496988

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
	destroy-method="close">
	<property name="driverClass" value="oracle.jdbc.driver.OracleDriver" />
	<property name="jdbcUrl" value="jdbc:oracle:thin:@192.168.24.102:1521:sms" />
	<property name="user" value="test" />
	<property name="password" value="test" />
</bean>

报错解决方法：http://kangzye.blog.163.com/blog/static/3681922320091033359708/

第四种：使用hibernate数据源

<bean id="sessionFactory"
	class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
	<property name="configLocations">
		<list>
			<value>classpath:com/config/hibernate.cfg.xml</value>
		</list>
	</property>
	<property name="mappingLocations">
		<!-- 所有的实体类映射文件 -->
		<list>
			<value>classpath:com/hibernate/*.hbm.xml</value>
		</list>
	</property>
</bean>

 

转载于:https://my.oschina.net/chipsy/blog/741050