Spring整合c3p0连接池

1、配置db.properties

jdbc.driverClass=com.mysql.jdbc.Driver
jdbc.jdbcUrl=jdbc:mysql:///ww
jdbc.user=root
jdbc.password=root

2、将连接池配置到Spring中

<!-- 指定Spring读取properties文件 -->
<context:property-placeholder location="classpath:db.properties"/>

<!-- 1、将连接池放入容器中 -->
<bean name="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
	<property name="driverClass" value="${jdbc.driverClass}"></property>
	<property name="jdbcUrl" value="${jdbc.jdbcUrl}"></property>
	<property name="user" value="${jdbc.user}"></property>
	<property name="password" value="${jdbc.password}"></property>
</bean>

3、将连接池注入到sessionFactory中

<!-- 在applicationContext.xml中配置hibernate信息 -->
<bean name="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
	<property name="dataSource" ref="dataSource"></property>
    <property name="hibernateProperties">
		<props>		
			<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
			
			<prop key="hibernate.show_sql">true</prop>
			<prop key="hibernate.format_sql">true</prop>
			<prop key="hibernate.hbm2ddl.auto">update</prop>
		</props>
	</property>
	<!-- 引入orm元数据，指定orm的包路径，Spring会自动提取包中所有的配置 -->
	<property name="mappingDirectoryLocations" value="classpath:club/ityuchao/domain"></property>
</bean>