spring+Hibernate配置

<bean id="propertyConfigurer"
class="com.nsn.itil.common.annotation.ExtendedPropertyPlaceholderConfigurer">
<property name="locations">
<list>
<value>classpath:appconfig.properties</value>
</list>
</property>
</bean>


    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
    destroy-method="close">
    <property name="driverClassName">
             <value>${driverClassName}</value>
         </property>
   <property name="url">
             <value>${url}</value>
         </property>
         <property name="username">
             <value>${username}</value>
         </property>
         <property name="password">
             <value>${password}</value>
         </property>
         <property name="initialSize">
             <value>${initialSize}</value>
         </property>
         <property name="maxActive">
             <value>${maxActive}</value>
         </property>
         <property name="maxIdle">
             <value>${maxIdle}</value>
         </property>
         <property name="minIdle">
             <value>${minIdle}</value>
         </property>
         <property name="validationQuery">
             <value>SELECT CURRENT_DATE</value>
         </property>
         <property name="testWhileIdle">
             <value>true</value>
         </property>
         <property name="timeBetweenEvictionRunsMillis">
             <value>3600000</value>
         </property>
         <property name="minEvictableIdleTimeMillis">
             <value>18000000</value>
         </property>
         <property name="testOnBorrow">
             <value>true</value>
         </property>
</bean>




<bean id="sessionFactory" class="org.springframework.orm.hibernate3.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.hbm2ddl.auto">update</prop> -->
                <prop key="hibernate.jdbc.batch_size">20</prop>
</props>
</property>
<property name="mappingLocations">
<list>
<value>classpath:/com/nsn/itil/systemMgr/hibernate/*.hbm.xml</value>
<value>classpath:/hibernate/secu/*.hbm.xml</value>
</list>
</property>
</bean>


<bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">
   <property name="sessionFactory">
     <ref bean="sessionFactory"/>
   </property>

  </bean>

<!-- 配置事务管理器 -->
<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory">
<ref bean="sessionFactory"/>
</property>
</bean>

<!-- 那些类那些方法使用事务 -->
<aop:config>
<aop:pointcut id="allManagerMethod" expression="execution(* xxx.xxx.*.*(..))"/>
<aop:advisor pointcut-ref="allManagerMethod" advice-ref="txAdvice"/>
</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="modify*" propagation="REQUIRED"/>
<tx:method name="*" propagation="REQUIRED" read-only="true"/>
</tx:attributes>
</tx:advice>