@Transactional(propagation = Propagation.REQUIRED, rollbackFor = Exception.class)
@Override
public void flushOrderDetail(FlushForm form) {
    // 構(gòu)建批量更新訂單狀態(tài)的參數(shù)集合
    List<FlushOrderParam> flushOrderParamList = payService.createFlushParam(form);
    // 查詢出本次需要更新的訂單記錄
    List<OrderEntity> orderList = orderService.query(form);
    SqlSession sqlSession = null;
    try {
        // 采用MyBatis批處理模式，開(kāi)啟批量執(zhí)行的SqlSession
        sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH);
        // 批量處理訂單狀態(tài)信息
        orderService.batchUpdate(sqlSession, flushOrderParamList, orderList);
        // 提交批量處理事務(wù)
        sqlSession.commit();
    } catch (Exception e) {
        // 出現(xiàn)異常時(shí)，回滾批處理操作
        log.error("批處理訂單狀態(tài)失敗", e);
        if (sqlSession != null) sqlSession.rollback();
        // 將異常拋出，觸發(fā)Spring事務(wù)管理的回滾機(jī)制
        throw e;
    } finally {
        // 關(guān)閉SqlSession，釋放資源
        if (sqlSession != null) {
            try {
                sqlSession.close();
            } catch (Exception e) {
                log.error("關(guān)閉sqlSession異常", e);
            }
        }
    }
    // 批量操作成功后，再次查詢訂單，打印訂單狀態(tài)日志，便于排查和驗(yàn)證
    orderList = orderService.query(form);
    for (OrderEntity order : orderList) {
        logger.debug("訂單 {} 狀態(tài) {}", order.getOrderCode(), order.getStatus());
    }
}

SELECT @@session.transaction_isolation;

mybatis:
  type-aliases-package: com.middol.*.model.**.dao
  mapper-locations: classpath:mapper/**/*Mapper.xml
  configuration:
    map-underscore-to-camel-case: true # 開(kāi)啟駝峰功能
    local-cache-scope: statement