如何在yii2中使用ManagerInterface的update()方法？

use yii\db\Connection;
use yii\db\Query;
use yii\db\Transaction;

// 创建数据库连接
$db = new Connection([
    'dsn' => 'mysql:host=localhost;dbname=mydatabase',
    'username' => 'root',
    'password' => 'password',
]);

// 开启事务
$transaction = $db->beginTransaction();

try {
    // 创建查询对象
    $query = new Query();

    // 更新记录
    $db->createCommand()->update('mytable', [
        'column1' => 'value1',
        'column2' => 'value2',
    ], 'condition')->execute();

    // 提交事务
    $transaction->commit();
} catch (\Exception $e) {
    // 回滚事务
    $transaction->rollBack();
    throw $e;
}