aop datasource 配置实例

来源：互联网发布：免费发帖软件编辑：程序博客网时间：2024/05/18 02:29

<?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:tx="http://www.springframework.org/schema/tx"
   xmlns:aop="http://www.springframework.org/schema/aop"
   xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
   http://www.springframework.org/schema/tx
   http://www.springframework.org/schema/tx/spring-tx-2.5.xsd
   http://www.springframework.org/schema/aop
   http://www.springframework.org/schema/aop/spring-aop-2.5.xsd"
   default-lazy-init="true">
   <bean
       class="com.xxxxxx.dhm.portalMS.common.util.PortalMSPropertyPlaceholderConfigurer">
       <property name="locations">
           <list>
               <value>datasource.properties</value>
           </list>
       </property>
   </bean>
   
   <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
       destroy-method="close">
       <property name="driverClass">
           <value>${db.driverclass}</value>
       </property>
       <property name="jdbcUrl">
           <value>${db.jdbcurl}</value>
       </property>
       <property name="user">
           <value>${db.user}</value>
       </property>
       <property name="password">
           <value>${db.password}</value>
       </property>
       <property name="minPoolSize">
           <value>${db.minpoolsize}</value>
       </property>
       <property name="maxPoolSize">
           <value>${db.maxpoolsize}</value>
       </property>
       <property name="initialPoolSize">
           <value>${db.initialpoolsize}</value>
       </property>
       <property name="maxIdleTime">
           <value>${db.maxidletime}</value>
       </property>
       <property name="acquireIncrement">
           <value>${db.acquireincrement}</value>
       </property>
       <property name="maxStatements">
           <value>${db.maxstatements}</value>
       </property>
       <property name="idleConnectionTestPeriod">
           <value>${db.idleconnectiontestperiod}</value>
       </property>
       <property name="acquireRetryAttempts">
           <value>${db.acquireretryattempts}</value>
       </property>
       <property name="breakAfterAcquireFailure">
           <value>${db.breakafteracquirefailure}</value>
       </property>
       <property name="testConnectionOnCheckout">
           <value>${db.testconnectiononcheckout}</value>
       </property>
       <property name="numHelperThreads">
           <value>${db.numhelperthreads}</value>
       </property>
       <property name="maxStatementsPerConnection">
           <value>${db.maxstatementsperconnection}</value>
       </property>
       <property name="debugUnreturnedConnectionStackTraces">
           <value>${db.debugunreturnedconnectionstacktraces}</value>
       </property>
       <property name="description">
           <value>${db.description}</value>
       </property>
       <property name="checkoutTimeout">
           <value>${db.checkouttimeout}</value>
       </property>
       <property name="autoCommitOnClose">
           <value>${db.autocommitonclose}</value>
       </property>
       <property name="acquireRetryDelay">
           <value>${db.acquireretrydelay}</value>
       </property>
   </bean>

   <bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
       <property name="configLocation">
           <value>
               classpath:ibatis/${dbType}/sqlMapConfig.xml
            </value>
       </property>
       <property name="dataSource" ref="dataSource" />
   </bean>
   <bean id="dialect" class="com.xxxxxx.dhm.portalMS.base.dialect.${dialect}">
       <property name="limit" value="true" />
   </bean>
   <bean id="sqlExecutor" class="com.xxxxxx.dhm.portalMS.base.executor.LimitSqlExecutor"
       scope="prototype">
       <property name="dialect" ref="dialect" />
       <property name="enableLimit" value="true"></property>
   </bean>
   <bean id="baseDao" abstract="true"
       class="com.xxxxxx.dhm.portalMS.base.dao.ibatis.IbatisDAO" init-method="initialize">
       <property name="sqlMapClient">
           <ref bean="sqlMapClient" />
       </property>
       <property name="sqlExecutor">
           <ref bean="sqlExecutor" />
       </property>
   </bean>

   <bean id="iBatisTransactionManager"
       class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
       <property name="dataSource" ref="dataSource" />
   </bean>
   <tx:advice id="txAdvice" transaction-manager="iBatisTransactionManager">
       <tx:attributes>
       
           <tx:method name="*" propagation="REQUIRED" rollback-for="Exception"></tx:method>
       </tx:attributes>
   </tx:advice>

   <aop:config>
       <aop:pointcut id="tesConntpoint"
           expression="execution(* com.xxxxxx.dhm.portalMS.*.dao..*.*(..)) or execution(* com.xxxxxx.dhm.portalMS.*.service..*.*(..)) " />
       <aop:pointcut id="iepgPoint"
           expression="execution(* com.xxxxxx.dhm.portalMS.*.service..*.*(..)) or execution(* com.xxxxxx.createPortal.*.service..*.*(..)) or execution(* com.xxxxxx.dhm.common.uif.service.impl.MessageSyncServiceImpl.*(..)) " />
       <aop:pointcut id="logpoint"
           expression="execution(* com.xxxxxx.dhm.portalMS.*.service..*.*(..))
           or execution(* com.xxxxxx.dhm.portalMS.*.dao..*.*(..))" />
       <aop:advisor advice-ref="txAdvice" pointcut-ref="iepgPoint" />
       <aop:aspect id="logging" ref="logAspect">
           <aop:around pointcut-ref="logpoint" method="invoke" />
       </aop:aspect>
       <aop:aspect id="testConn" ref="testConnAspect">
           <aop:before method="before" pointcut-ref="tesConntpoint" />
       </aop:aspect>
   </aop:config>
   <bean id="testConnAspect" class="com.xxxxxx.dhm.portalMS.common.aop.JdbcTestAspect" />
   <bean id="logAspect" class="com.xxxxxx.dhm.portalMS.common.aop.LogAspect" />


   <bean id="serviceParaCheckInterceptor"
       class="com.xxxxxx.miss.util.intercaptor.ServiceParaCheckInterceptor">
   </bean>

   <bean id="RegexAdvisor"
       class="org.springframework.aop.support.RegexpMethodPointcutAdvisor">
       <property name="advice">
           <ref local="serviceParaCheckInterceptor" />
       </property>
       <property name="patterns">
           <list>
               <value>com.xxxxxx.dhm.portalMS.sync.portalms.service.*\.execute</value>
               <value>com.xxxxxx.dhm.portalMS.sync.service.*\.execute</value>
               <value>com.xxxxxx.dhm.portalMS.sync.action.*\.execute</value>
               <value>com.xxxxxx.dhm.portalMS.sync.cms.*\.execute</value>
               <value>com.xxxxxx.dhm.portalMS.sync.sme.*\.execute</value>
           </list>
       </property>
   </bean>

   <bean id="paraCheckAop"
       class="org.springframework.aop.framework.autoproxy.BeanNameAutoProxyCreator">
       <property name="beanNames">
           <list>
               <value>SyncColumnServiceImpl</value>
               <value>SyncColumnRankServiceImpl</value>
               <value>SyncUpShelfRankServiceImpl</value>
               <value>DelColumnServiceImpl</value>
               <value>SyncColumnImageServiceImpl</value>
               <value>DelColumnImageServiceImpl</value>
               <value>SyncRelGoodsServiceImpl</value>

               <value>DelUpShelfResourceServiceImpl</value>
               <value>SyncAllUpShelfResourceServiceImpl</value>
               <value>SyncUpShelfResourceServiceImpl</value>
               <value>SyncRecommendAssetServiceImpl</value>
               <value>DelRecommendAssetServiceImpl</value>
               <value>SyncRecommendContentServiceImpl</value>

               <value>SyncVirtualNetWorkServiceImpl</value>
               <value>DelVirtualNetworkServiceImpl</value>
               <value>SyncWidgetServiceImpl</value>
               <value>DelWidgetServiceImpl</value>
               <value>SyncHotelServiceImpl</value>
               <value>DelHotelServiceImpl</value>
               <value>CacheModServiceImpl</value>
               <value>ModNumServiceImpl</value>
               <value>VrecomNumServiceImpl</value>

               <value>SyncTemplateStatusServiceImpl</value>
               <value>SyncTemplateServiceImpl</value>
               <value>DelTemplateServiceImpl</value>
               <value>SyncSiteServiceImpl</value>
               <value>UpdateSiteStatusServiceImpl</value>
               <value>SyncCpServiceImpl</value>
               <value>DelCpServiceImpl</value>
               <value>AssetTypeAddService</value>
               <value>AssetTypeDeleteService</value>
               <value>AssetTypeRelationService</value>
               <value>ResourcePosterAddAction</value>
               <value>ResourcePosterDeleteAction</value>
               <value>POResourceAddAction</value>
               <value>POResourceDeleteAction</value>

               <value>SyncAssetServiceImpl</value>
               <value>DelAssetPackageServiceImpl</value>
               <value>SyncAssetFileServiceImpl</value>
               <value>DelAssetFileServiceImpl</value>
               <value>SyncAssetPackageServiceImpl</value>

               <value>SyncChannelServiceImpl</value>
               <value>DelChannelServiceImpl</value>
               <value>SyncChannelTypeServiceImpl</value>
               <value>DelChannelTypeServiceImpl</value>
               <value>SyncGoodsServiceImpl</value>
               <value>SyncGoodsStatusServiceImpl</value>
               <value>SyncProdOfferingServiceImpl</value>
               <value>SyncProdOfferingStatusServiceImpl</value>

               <value>SyncProviderServiceImpl</value>
               <value>SyncProviderStatusServiceImpl</value>
               <value>SyncUserGroupServiceImpl</value>
               <value>DelUserGroupServiceImpl</value>
           </list>
       </property>
       <property name="interceptorNames">
           <list>
               <value>serviceParaCheckInterceptor</value>
           </list>
       </property>
   </bean>
</beans>

0 0