spring管理数据源

jdbc.properties

 

###########jdbc datasourc#################
jdbc.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc.url=jdbc:sqlserver://localhost:1433;DatabaseName=szcity
jdbc.username=szcity
jdbc.password=dlrfl!@152

#-----------------------------------------------------------------------------------------
#system hibernate properties 
#------------------------------------------------------------------------------------------
hibernate.system.minPoolSize=2
hibernate.system.acquireIncrement=2
hibernate.system.maxPoolSize=100
hibernate.system.maxIdleTime=10
hibernate.system.maxStatements=100
hibernate.system.idleConnectionTestPeriod=120
hibernate.system.dialect=org.hibernate.dialect.SQLServerDialect
hibernate.system.show_sql=true

通过spring配置文件加载资源文件，读取配置datasource.xml

<?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:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="http://www.springframework.org/schema/beans
                     http://www.springframework.org/schema/beans/spring-beans.xsd
                     http://www.springframework.org/schema/tx
                     http://www.springframework.org/schema/tx/spring-tx.xsd
                     http://www.springframework.org/schema/aop
                     http://www.springframework.org/schema/aop/spring-aop.xsd">

	<bean id="propertyConfigurer"
		class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
		<property name="location" value="classpath:jdbc.properties" />
	</bean>
	<!-- 数据库配置 -->
	<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>

		<!-- 最小连接数 -->
		<property name="minPoolSize">
			<value>${hibernate.system.minPoolSize}</value>
		</property>
		<!-- 达到最大连接数后可以增加的连接数 个 -->
		<property name="acquireIncrement">
			<value>${hibernate.system.acquireIncrement}</value>
		</property>
		<!-- 最大连接数 -->
		<property name="maxPoolSize">
			<value>${hibernate.system.maxPoolSize}</value>
		</property>
		<!-- 最大闲置时间 秒 -->
		<property name="maxIdleTime">
			<value>${hibernate.system.maxIdleTime}</value>
		</property>
		<!-- 最大的PreparedStatement的数量 -->
		<property name="maxStatements">
		    <value>${hibernate.system.maxStatements}</value>
		</property>
		<!-- 闲置的连接测试周期 (秒) -->
		<property name="idleConnectionTestPeriod">
			<value>${hibernate.system.idleConnectionTestPeriod}</value>
		</property>
	</bean>

	<bean id="sessionFactory"
		class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="dataSource">
			<ref bean="dataSource" />
		</property>
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">${hibernate.system.dialect}</prop>
				<prop key="hibernate.show_sql">${hibernate.system.show_sql}</prop>
			</props>
		</property>
		<property name="mappingDirectoryLocations">
			<list>
				<value>classpath:com/lsde/msg/entity/</value>
			</list>
		</property>
	</bean>
	<bean id="baseDao" class="com.lsde.msg.hibernate.dao.impl.BaseDaoImpl">
		<property name="sessionFactory">
			<ref bean="sessionFactory" />
		</property>
	</bean>
	<bean id="baseService"
		class="com.lsde.msg.service.impl.BaseServiceImpl">
		<property name="baseDao">
			<ref bean="baseDao" />
		</property>
	</bean>
	<bean id="transactionManager"
		class="org.springframework.orm.hibernate3.HibernateTransactionManager">
		<property name="sessionFactory">
			<ref local="sessionFactory" />
		</property>
	</bean>
	<aop:config>
		<aop:pointcut id="daoMethods"
			expression="execution(* com.lsde.msg.service.*.*(..))" />
		<aop:advisor advice-ref="txAdvice" pointcut-ref="daoMethods" />
	</aop:config>

	<tx:advice id="txAdvice" transaction-manager="transactionManager">
		<tx:attributes>
			<tx:method name="add*" propagation="REQUIRED" />
			<tx:method name="del*" propagation="REQUIRED" />
			<tx:method name="update*" propagation="REQUIRED" />
			<tx:method name="*" propagation="REQUIRED" />
		</tx:attributes>
	</tx:advice>
</beans>