spring 数据源配制

spring数据源配制 , 用于替代hibernate.cfg.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">

<!-- applicationContext-data.xml 用于配置数据库连接优化等 -->
<beans>



	<!-- 用于加载jdbc.properties文件 -->
	<bean id="placeholderConfig"
		class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
		<property name="locations">
			<list>
				<value>classpath:jdbc.properties</value>
			</list>
		</property>
	</bean>

	<!--	定义一个数据源bean，用于连接数据库,id取名为dataSource. 使用的连接池为c3p0   -->
	<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
		destroy-method="close">

		<property name="driverClass">
			<value>${jdbc.driverClassName}</value>
		</property>
		<property name="jdbcUrl">
			<value>${jdbc.url}</value>
		</property>
		<property name="user">
			<value>${jdbc.username}</value>
		</property>
		<property name="password">
			<value>${jdbc.password}</value>
		</property>
		<!--	定义c3p0优化参数	-->
		<property name="initialPoolSize">
			<value>${c3p0.initialPoolSize}</value>
		</property>
		<property name="minPoolSize">
			<value>${c3p0.minPoolSize}</value>
		</property>
		<property name="maxPoolSize">
			<value>${c3p0.maxPoolSize}</value>
		</property>
		<property name="acquireIncrement">
			<value>${c3p0.acquireIncrement}</value>
		</property>
		<property name="maxIdleTime">
			<value>${c3p0.maxIdleTime}</value>
		</property>
	</bean>


	<!-- 定义hibernate sessionFactory  -->
	<bean id="sessionFactory"
		class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="dataSource">
			<ref bean="dataSource" />
		</property>

		<!--  指定hbm文件所在的目录    -->
		<property name="mappingDirectoryLocations">
			<list>
				<value>classpath:/com/tuozhi/model/</value>
			</list>
		</property>

		<!--   定义hibernate其他属性参数   -->
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</prop>
				<prop key="hibernate.show_sql">true</prop>
				<prop key="hibernate.hbm2ddl.auto">update</prop>
			</props>
		</property>
	</bean>


</beans>

配制jdbc连接属性文件, jdbc.properties

 #jdbc\u914d\u7f6e
jdbc.driverClassName=net.sourceforge.jtds.jdbc.Driver
jdbc.url=jdbc:jtds:sqlserver://localhost:1433/pubs
jdbc.username=sa
jdbc.password=sa


#\u4f18\u5316\u8bbe\u7f6ec3p0\u8fde\u63a5\u6c60\u53c2\u6570
#\u8fde\u63a5\u6c60\u521d\u59cb\u5316\u65f6\u83b7\u53d6\u7684\u94fe\u63a5\u6570
c3p0.initialPoolSize=2
#\u6700\u5c0f\u94fe\u63a5\u6570
c3p0.minPoolSize=2
#\u6700\u5927\u8fde\u63a5\u6570
c3p0.maxPoolSize=30
#\u5728\u5f53\u524d\u8fde\u63a5\u6570\u8017\u5c3d\u7684\u65f6\u5019\uff0c\u4e00\u6b21\u83b7\u53d6\u7684\u65b0\u7684\u8fde\u63a5\u6570
c3p0.acquireIncrement=5
#\u6700\u5927\u7a7a\u95f2\u7684\u65f6\u95f4\uff0c\u5355\u4f4d\u662f\u79d2\uff0c\u65e0\u7528\u7684\u94fe\u63a5\u518d\u8fc7\u65f6\u540e\u4f1a\u88ab\u56de\u6536
c3p0.maxIdleTime=20