Yii 实务的简单操作

$transaction=$connection->beginTransaction();

try{

$connection->createCommand($sql1)->execute();

$connection->createCommand($sql2)->execute();

//.... other SQL executions

$transaction->commit();

}catch(Exception $e){

$transaction->rollBack();

}