/**
* 事务测试
*/
function actionsw(){
$model=Addr::model();
$transaction=$model->dbConnection->beginTransaction();
try
{
$a = $model->dbConnection->createCommand("insert into {{addr}}(`home`) VALUES('天蓝小区')")->execute();
$new_id = Yii::app()->db->getLastInsertID();
$b = $model->dbConnection->createCommand("insert into {{floor}}(`addr_id`,`floor_name`) VALUES('".$new_id."','1楼')")->execute();
$transaction->commit();
}
catch(Exception $e) //一条失败就报错
{
$transaction->rollBack();
}
}
实现mysql并发执行。
Yii事务的使用
最新推荐文章于 2021-12-30 19:47:32 发布