方法 1 :
$transaction = Mage::getModel('core/resource_transaction');
此类中有详细方法
方法2 :
try{
$write = Mage::getSingleton('core/resource')->getConnection('core_write');
$write->beginTransaction();
$sql='';
$write->query($sql);
$sql='';
$write->query($sql);
$write->commit();
}catch (Exception $e){
$write->rollBack();
}