亚洲国产日韩欧美一区二区三区,精品亚洲国产成人av在线,国产99视频精品免视看7,99国产精品久久久久久久成人热,欧美日韩亚洲国产综合乱

Please use Baidu spring’s transaction management

The first one is to configure transaction management rules. You can search on Baidu on how to write it specifically. I can’t explain it in one or two sentences

    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>
    <aop:config>
        <aop:pointcut id="interceptorPointCuts" expression="execution(* com.web..*.services..*Impl.*(..))"/>
        <aop:advisor advice-ref="txAdvice" pointcut-ref="interceptorPointCuts"/>
    </aop:config>
    <tx:advice id="txAdvice" transaction-manager="transactionManager">
        <tx:attributes>
            <tx:method name="save*" propagation="REQUIRED" rollback-for="java.lang.Exception"/>
            <tx:method name="update*" propagation="REQUIRED" rollback-for="java.lang.Exception"/>
            <tx:method name="insert*" propagation="REQUIRED" rollback-for="java.lang.Exception"/>
            <tx:method name="delete*" propagation="REQUIRED" rollback-for="java.lang.Exception"/>for="java.lang.Exception"/> -->
        </tx:attributes>
    </tx:advice>

The second way to use the annotation @Transactional

   <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>
    <!--聲明使用注解式事務(wù)-->
    <tx:annotation-driven transaction-manager="transactionManager"/>

Programmatic Transaction Management MyBatis SqlSession provides you
with specific methods to handle transactions programmatically. But
when using MyBatis-Spring your beans will be injected with a Spring
managed SqlSession or a Spring managed mapper. That means that Spring
will always handle your transactions.

You cannot call SqlSession.commit(), SqlSession.rollback() or
SqlSession.close() over a Spring managed SqlSession. If you try to do
so, a UnsupportedOperationException exception will be thrown. Note
these methods are not exposed in injected mapper classes.

Regardless of your JDBC connection's autocommit setting, any execution
of a SqlSession data method or any call to a mapper method outside a
Spring transaction will be automatically committed.

If you want to control your transactions programmatically please refer
to chapter 10.6 of the Spring reference manual. This code shows how to
handle a transaction manually using the PlatformTransactionManager
described in section 10.6.2.

mybatis-spring

Spring does not seem to allow manual submission of transactions, the Spring container will automatically manage transactions!

//使用事務(wù)處理，訂單及貨物訂單必須同時(shí)插進(jìn)2個(gè)表里面
@Transactional(rollbackFor=Exception.class)
public void save(PageData pd,Map<String,Integer> map,String uuid,int Uid){
    dao.save("OrderInfoMapper.saveOrderInfo", pd);
    OrderGood orderGood=new OrderGood();
    for(String gid:map.keySet()){
        Goods good=goodService.findOne(gid);
        orderGood.setGname(good.getGname());
        //Integer a=map.get(gid);
        orderGood.setOgamount(map.get(gid));
        orderGood.setGid(Integer.parseInt(gid));                
        orderGood.setOgtotalprize(map.get(gid)*good.getGprice());
        orderGood.setUid(Uid);
        orderGood.setOid(uuid);
        dao.save("OrderInfoMapper.saveOrderGood", orderGood);
        }          
               
}
使用@Transactional  注解則成功解決問題，此注解是spring 的事務(wù)管理，使用前先配置如下：

<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>
    <!--聲明使用注解式事務(wù)-->
    <tx:annotation-driven transaction-manager="transactionManager"/>
        
    
    
    只需要在service層方法中執(zhí)行多條mybatis的mapper并加上注解即可，發(fā)生異常則此方法的事務(wù)會(huì)回滾