yii2快速使用多个数据库的方法

1.在common目录下的config文件夹下的main-local.php中，设置如下

<?php
return [
    'components' => [
        'db' => [
            'class' => 'yii\db\Connection',
            'dsn' => 'mysql:host=127.0.0.1;port=3306;dbname=db',
            'username' => 'root',
            'password' => '',
            'charset' => 'utf8',
        ],

        'db1' => [
            'class' => 'yii\db\Connection',
            'dsn' => 'mysql:host=127.0.0.1;port=3306;dbname=db1',
            'username' => 'root',
            'password' => '',
            'charset' => 'utf8',
        ],

        'mailer' => [
            'class' => 'yii\swiftmailer\Mailer',
            'viewPath' => '@common/mail',
            // send all mails to a file by default. You have to set
            // 'useFileTransport' to false and configure a transport
            // for the mailer to send real emails.
            'useFileTransport' => true,
        ],
    ],
];

2.在models中定义使用数据库db1

    public static function getDb() {
        return Yii::$app->db1;
    }

整体如下

class Model extends \yii\db\ActiveRecord
{
    /**
     * 设置使用db1数据库
     */
    public static function getDb() {
        return Yii::$app->db1;
    }
    /**
     * 操作db1中的表table
     */
    public static function tableName() 
    {
        return 'table';
    }