<?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-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/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">
<!-- hibernate注入 -->
	<!-- 配置C3P0,数据源(营销中心数据库) -->
	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
		<property name="driverClassName">
			<value>com.mysql.jdbc.Driver</value>
		</property>
		<property name="url">
			<value>jdbc:mysql://localhost:3306/yxybase?useUnicode=true&amp;characterEncoding=utf8&amp;autoReconnect=true</value>
		</property>
		<property name="username">
			<value>root</value>
		</property>
		<property name="password">
			<value>sz1234567890</value>
		</property>
		<property name="maxActive">
			<value>100</value>
		</property>
        <property name="maxIdle">
        	<value>50</value>
        </property>
        <property name="initialSize">
        	<value>30</value>
        </property>
        <property name="maxWait">
        	<value>10000</value>
        </property>
        <property name="defaultAutoCommit">
        	<value>true</value>
        </property>
        <property name="removeAbandoned">
			<value>true</value>        
        </property>
        <property name="removeAbandonedTimeout">
        	<value>300</value>
        </property>
        <property name="logAbandoned">
        	<value>false</value>
        </property>
        <property name="validationQuery">
        	<value>select 1</value>
        </property>
        <property name="testOnBorrow">  
        	<value>true</value>
        </property>
	</bean>
	
	<!-- 配置C3P0,数据源(点读数据库)-->
	<bean id="clickdataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
		<property name="driverClassName">
			<value>com.mysql.jdbc.Driver</value>
		</property>
		<property name="url">
			<value>jdbc:mysql://gz-cdb-2xtb8c5k.sql.tencentcdb.com:62529/sqlesmailtrack?useUnicode=true&amp;characterEncoding=utf8&amp;autoReconnect=true</value>
		</property>
		<property name="username">
			<value>root</value>
		</property>
		<property name="password">
			<value>sz1234567890</value>
		</property>
		<property name="maxActive">
			<value>100</value>
		</property>
        <property name="maxIdle">
        	<value>50</value>
        </property>
        <property name="initialSize">
        	<value>30</value>
        </property>
        <property name="maxWait">
        	<value>10000</value>
        </property>
        <property name="defaultAutoCommit">
        	<value>true</value>
        </property>
        <property name="removeAbandoned">
			<value>true</value>        
        </property>
        <property name="removeAbandonedTimeout">
        	<value>300</value>
        </property>
        <property name="logAbandoned">
        	<value>false</value>
        </property>
        <property name="validationQuery">
        	<value>select 1</value>
        </property>
        <property name="testOnBorrow">  
        	<value>true</value>
        </property>
	</bean>
	
	<!--  ================================数据源配置===============================================================-->
	
	<!-- 配置 营销中心数据库 注解sessionFactory -->
	<bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
		<!-- 数据源注入 -->
		<property name="dataSource" ref="dataSource" />
		
		<property name="packagesToScan">
			<list>
				<value>yxy.timer.pojo</value>
			</list>
		</property>
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
				<prop key="hibernate.show_sql">false</prop>
				
				<!-- 如果开启, Hibernate将收集有助于性能调节的统计数据. 取值 true | false -->
				<prop key="hibernate.generate_statistics">true</prop>
				<!-- 指定Hibernate在何时释放JDBC连接. -->
				<prop key="hibernate.connetion.release_mode">auto</prop>
			</props>
		</property>
	</bean>

	<!--配置公共的hibernate方法注解  -->  
	<bean id="AnnhibernateBaseDAO" class="yxy.timer.dao.impl.HibernateBaseDAOImpl" abstract="true" scope="prototype">
		<property name="sessionFactory" ref="sessionFactory"/>
	</bean>
	
	<!--3、配置spring事务(AOP)  -->
		<!-- 事务管理器 -->
		<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
			<property name="sessionFactory" ref="sessionFactory" />
		</bean>
		
		<!-- 事务的传播特性（propagation） -->
		<tx:advice id="txAdvice" transaction-manager="transactionManager">  
	        <tx:attributes>  
	            <tx:method name="del*"/>  
	            <tx:method name="save*" />  
	            <tx:method name="update*" />  
	            <tx:method name="add*" />  
	            <tx:method name="insert*" /> 
	            <tx:method name="get*" propagation="SUPPORTS" read-only="true"/>  
	            <tx:method name="load*" propagation="SUPPORTS" read-only="true"/>  
	            <tx:method name="list*" propagation="SUPPORTS" read-only="true"/>  
	            <tx:method name="*" propagation="SUPPORTS" read-only="true"/> 
	        </tx:attributes>  
   		</tx:advice>  
   		<!-- 配置哪些类哪些方法具有事务 ,采用AOP-->
		<aop:config>
			<aop:pointcut expression="execution(* yxy.timer.service.*.*(..))" id="allMethod"/>
			<aop:advisor pointcut-ref="allMethod" advice-ref="txAdvice"/>
		</aop:config>
	<!-- 注入SpringFactory类 -->
	<bean id="springfactory"  class="yxy.timer.tool.SpringFactory"></bean>
	<!-- dao模块 -->
  	<import resource="applicationContext_dao.xml"/> 
	<!-- service模块 -->
  	<import resource="applicationContext_service.xml"/> 
  	<!-- 邮件timer模块 -->
  	<import resource="applicationContext_timer.xml"/> 
  	<!-- webservice模块 -->
  	<import resource="applicationContext_webservice.xml"/>
  	<!-- sale100个人版模块 -->
  	<import resource="applicationContext_sale100.xml"/>
</beans>