<?xml version="1.0"?>
<!DOCTYPE hibernate-configuration PUBLIC
    "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
    "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
    <session-factory>
    <!-- 配置hibernate的基本属性 -->
        <!-- 配置数据源 ,因为需要把数据源配置到IOC容器中,所以这里不需要再配置-->
        <!-- 配置数据库方言 -->
        <property name="dialect">org.hibernate.dialect.MySQL5Dialect</property>
        <!-- 显示并格式化sql语句 -->
        <property name="show_sql">true</property>
        <property name="format_sql">true</property>
        <!-- 自动生成数据库表结构 -->
        <property name="hbm2ddl.auto">update</property>
        <!-- 使用getCurrentSession方式打开会话 -->
        <property name="hibernate.current_session_context_class">thread</property>
        
        <!-- 关联的*.hbm.xml也在容器配置sessionFactory实例时在进行配置,这里也不再配置 -->
    </session-factory>
</hibernate-configuration>

<?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:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
    xsi:schemaLocation="http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd
        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-4.2.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.2.xsd">
    <!-- 导入资源文件 -->
    <context:property-placeholder location="db.properties"
        ignore-resource-not-found="false" />
    <!-- 配置c3p0连接池 -->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="user" value="${jdbc.user}"></property>
        <property name="password" value="${jdbc.password}"></property>
        <property name="driverClass" value="${jdbc.driverClass}"></property>
        <property name="jdbcUrl" value="${jdbc.jdbcUrl}"></property>
        <property name="initialPoolSize" value="${jdbc.initialPoolSize}"></property>
        <property name="maxPoolSize" value="${jdbc.maxPoolSize}"></property>
    </bean>
    
    <!--配置hibernate的SessionFactory实例,通过Spring提供的LocalSessionFactorybean进行配置  -->
    <bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
            <!-- 配置数据源属性 -->
        <property name="dataSource" ref="dataSource"></property>
            <!-- 配置hibernate.cfg.xml的位置及名称-->
        <property name="configLocation" value="hibernate.cfg.xml"></property>
            <!-- 配置hibernate映射文件的位置及名称,可以使用通配符-->
        <property name="mappingLocations" value="com/wang/entity/*.hbm.xml"></property>
    </bean>
    <!-- 配置Spring的声明式事务 -->
        <!-- 1.配置事务管理器 -->
        <bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager">
            <property name="sessionFactory" ref="sessionFactory"></property>
        </bean>
        <!-- 2.配置事务属性,需要事务管理器 -->
        <tx:advice id="txAdvice" transaction-manager="transactionManager">
            <tx:attributes>
                <tx:method name="*"/>
                <tx:method name="get*" read-only="true"/>
            </tx:attributes>
        </tx:advice>
        <!-- 3.配置事务切点,并把切点和事务属性关联起来 -->
        <aop:config>
            <aop:pointcut expression="execution(* com.wang.service.*.*(..))" id="pointcut"/>
            <aop:advisor advice-ref="txAdvice" pointcut-ref="pointcut"/>
        </aop:config>
</beans>

<property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</prop>
                <prop key="hibernate.show_sql">true</prop>
                <prop key="hibernate.format_sql">true</prop>
                <prop key="hibernate.hbm2ddl.auto">update</prop>
            </props>
        </property>