Spring 事物使用

Springboot项目事物使用方式

	//注入spring事物管理器
	@Autowired
    private DataSourceTransactionManager dataSourceTransactionManager;
        //事物开启
        DefaultTransactionDefinition transDefinition = new DefaultTransactionDefinition();
        transDefinition.setPropagationBehavior(DefaultTransactionDefinition.PROPAGATION_REQUIRES_NEW);
        transDefinition.setReadOnly(false);
        TransactionStatus transactionStatus = dataSourceTransactionManager.getTransaction(transDefinition);
        try {
             //执行方法，插入主数据
             xxxxxTableMapper.batchInsertBySql(insertMainTableSql);
            //插入扩展表数据
  			 xxxxxTableMapper.batchInsertBySql(insertExtendTableSql);
            //提交事物
        	dataSourceTransactionManager.commit(transactionStatus);
        }catch (Throwable e){
            log.error("事务提交失败",e);
			//事物回滚
         	dataSourceTransactionManager.rollback(transactionStatus);
           
        }