c3p0配置

<?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:context="http://www.springframework.org/schema/context"
	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-3.0.xsd
			http://www.springframework.org/schema/context
			http://www.springframework.org/schema/context/spring-context-3.0.xsd
			http://www.springframework.org/schema/tx
			http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
			http://www.springframework.org/schema/aop
			http://www.springframework.org/schema/aop/spring-aop-3.0.xsd">
	<!-- 使用注解 -->
	<context:component-scan base-package="cn.dental" />

	<!-- 引入jdbc配置文件参数 -->
	<context:property-placeholder location="classpath:jdbc.properties" />

	<!-- 配置DataSource -->
	<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
		<property name="driverClass" value="${jdbc.driverClass}" />
		<property name="jdbcUrl" value="${jdbc.jdbcUrl}" />
		<property name="user" value="${jdbc.user}" />
		<property name="password" value="${jdbc.password}" />
		<!-- c3p0连接池配置 -->
		<!-- 初始化连接 -->
		<property name="initialPoolSize" value="3" />
		<!-- 保留最小连接数 -->
		<property name="minPoolSize" value="3" />
		<!-- 保留最大连接数 -->
		<property name="maxPoolSize" value="15" />
		<!-- 当连接池用光后,再次获取最多获取3个 -->
		<property name="acquireIncrement" value="3" />
		<!-- SQL语句最多执行个数 -->
		<property name="maxStatements" value="8" />
		<!-- 定义最大缓存数 -->
		<property name="maxStatementsPerConnection" value="5" />
		<!-- 最大空闲时间,如果没使用将回收 -->
		<property name="maxIdleTime" value="1800" />
	</bean>

	<!-- 创建sessionFactory -->
	<bean id="sessionFactory"
		class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="dataSource" ref="dataSource"/>
		<property name="hibernateProperties">
			<props>
				<!-- 方言 -->
				<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
				<!-- 其它配置 -->
				<prop key="hibernate.show_sql">true</prop>
				<prop key="hibernate.hbm2ddl.auto">update</prop>
			</props>
		</property>
		<property name="mappingDirectoryLocations">
			<list>
				<value>cn/dental/domain/</value>
			</list>
		</property>
	</bean>

	<!-- 配置事务 -->
	<bean id="txManager"
		class="org.springframework.orm.hibernate3.HibernateTransactionManager">
		<property name="sessionFactory" ref="sessionFactory" />
	</bean>
	<!-- 声明事务(使用注解方式) -->
	<tx:annotation-driven transaction-manager="txManager" />
</beans>