PDO事务同时使用多个方法和直接查询？

// 使用多个方法进行事务操作
try {
    $pdo->beginTransaction();

    // 执行数据库操作1
    $pdo->prepare("INSERT INTO table1 (column1) VALUES (:value1)")
        ->execute(['value1' => 'data1']);

    // 执行数据库操作2
    $pdo->prepare("UPDATE table2 SET column2 = :value2 WHERE id = :id")
        ->execute(['value2' => 'data2', 'id' => 1]);

    // 执行数据库操作3
    $pdo->prepare("DELETE FROM table3 WHERE id = :id")
        ->execute(['id' => 2]);

    $pdo->commit();
} catch (PDOException $e) {
    $pdo->rollBack();
    echo "Transaction failed: " . $e->getMessage();
}

// 直接查询
try {
    $pdo->beginTransaction();

    // 执行INSERT操作
    $pdo->exec("INSERT INTO table1 (column1) VALUES ('data1')");

    // 执行UPDATE操作
    $pdo->exec("UPDATE table2 SET column2 = 'data2' WHERE id = 1");

    // 执行DELETE操作
    $pdo->exec("DELETE FROM table3 WHERE id = 2");

    $pdo->commit();
} catch (PDOException $e) {
    $pdo->rollBack();
    echo "Transaction failed: " . $e->getMessage();
}