通过db执行sql语句可以看下面
//添加
Yii::app()->db->createCommand()->insert('tbl_user',
array('username' => 'zhangsan','email' => 'zhangsan@zs.com'));
//修改
Yii::app()->db->createCommand()->update('tbl_user',
array('username' => 'Tester'),
'id=:id',
array(':id' => 3));
//删除
Yii::app()->db->createCommand()->delete('tbl_user',
'id=:id',
array(':id' => 2));
//查询 - 多条数据
$users = Yii::app()->db->createCommand()
->select('*')
->from('tbl_user')
->queryAll();
//查询一条数据
$sql = "SELECT id,name FROM tbl_user WHERE email='123@qq.com'";
$users=Yii::app()->db->createCommand($sql)->queryRow();