yii model中切换数据库

1.配置文件

'db' => array (
'connectionString' => 'mysql:host=172.16.160.65;dbname=sy_db;port=3306',
'emulatePrepare' => true,
'username' => 'root',
'password' => '1256!',
'charset' => 'utf8',
),
'dboa' => array (
'class' => 'CDbConnection',
'connectionString' => 'mysql:host=172.16.160.65;dbname=sy_oadb;port=3306',
'emulatePrepare' => true,
'username' => 'root',
'password' => '1456!',
'charset' => 'utf8',
),

2.model文件

class DepartmentModel extends BaseModel
{


public function getDbConnection()
{
self::$db=Yii::app()->db;
if(self::$db instanceof CDbConnection)
return self::$db;
else
throw new CDbException(Yii::t('yii','Active Record requires a "dboa" CDbConnection application component.'));
}

}

3.controller调用

$modeldepart=new DepartmentModel();

即可得到指定的链接下的数据表