事务配置

左手的ㄟ右手 2022-05-03 03:26 187阅读 0赞

ApplicationContext.xml
    
    <?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:context="http://www.springframework.org/schema/context"
           xmlns:aop="http://www.springframework.org/schema/aop"
           xmlns:tx="http://www.springframework.org/schema/tx"
           xmlns:p="http://www.springframework.org/schema/p"
           xmlns:c="http://www.springframework.org/schema/c"
           xsi:schemaLocation="http://www.springframework.org/schema/beans
               http://www.springframework.org/schema/beans/spring-beans.xsd
               http://www.springframework.org/schema/context
               http://www.springframework.org/schema/context/spring-context-3.2.xsd
               http://www.springframework.org/schema/aop
               http://www.springframework.org/schema/aop/spring-aop-3.2.xsd
               http://www.springframework.org/schema/tx
               http://www.springframework.org/schema/tx/spring-tx-3.2.xsd">
    
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
            <property name="driverClassName" value="${driver}"/>
            <property name="url" value="${url}"/>
            <property name="username" value="${user}"/>
            <property name="password" value="${password}"/>
     </bean>
     
     <bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            <property name="dataSource" ref="dataSource"></property>
     </bean>
     
        <tx:annotation-driven transaction-manager="txManager"/>
    
    
    
      
        <tx:advice id="txAdvice" transaction-manager="txManager">
            <tx:attributes>
                
                <tx:method name="set*" timeout="1000" propagation="SUPPORTS" read-only="true"/>
                
                
                <tx:method name="*" propagation="REQUIRED"/>
            </tx:attributes>
        </tx:advice>
        
        <aop:config>
            
            <aop:pointcut id="myPoint" expression="execution(* cn.kgc.service..*.*(..))"/>
            
            <aop:advisor advice-ref="txAdvice" pointcut-ref="myPoint"/>
        </aop:config>
    
     </beans>
     
    
     java代码
     @Transactional(timeout = 10,readOnly = false) //事务控制，可以写在类前面
        public int setDetail(Bbs_detail bdsl) {
            int countOne=detailDao.setDetail(bdsl);
            //int i=1/0;
            int countTwo=detailDao.setDetail(bdsl);
            if(countOne>0 && countTwo>0) {
                return 1;
            }else {
                return 0;
            }
        }