qt如何ssh连接mysql

#include <QCoreApplication>
#include <libssh/libssh.h>
#include <mysql_driver.h>
#include <mysql_connection.h>
#include <cppconn/statement.h>
#include <cppconn/resultset.h>

void ssh_connect(const std::string &host, const std::string &username, const std::string &password) {
    ssh_session session = ssh_new();
    if (session == nullptr) {
        fprintf(stderr, "Error creating SSH session: %s\n", ssh_get_error(session));
        return;
    }

    ssh_options_set(session, SSH_OPTIONS_HOST, host.c_str());
    ssh_options_set(session, SSH_OPTIONS_USER, username.c_str());

    int rc = ssh_connect(session);
    if (rc != SSH_OK) {
        fprintf(stderr, "Error connecting to %s: %s\n", host.c_str(), ssh_get_error(session));
        ssh_free(session);
        return;
    }

    rc = ssh_userauth_password(session, nullptr, password.c_str());
    if (rc != SSH_AUTH_SUCCESS) {
        fprintf(stderr, "Authentication failed: %s\n", ssh_get_error(session));
        ssh_disconnect(session);
        ssh_free(session);
        return;
    }

    // SSH 连接成功，可以进行后续操作
    ssh_disconnect(session);
    ssh_free(session);
}

void mysql_connect(const std::string &host, const std::string &username, const std::string &password, const std::string &database) {
    sql::mysql::MySQL_Driver *driver = sql::mysql::get_mysql_driver_instance();
    std::unique_ptr<sql::Connection> con(driver->connect(host, username, password));

    con->setSchema(database);

    std::unique_ptr<sql::Statement> stmt(con->createStatement());
    std::unique_ptr<sql::ResultSet> res(stmt->executeQuery("SELECT * FROM your_table"));

    while (res->next()) {
        // 处理查询结果
    }
}

int main(int argc, char *argv[]) {
    QCoreApplication a(argc, argv);

    ssh_connect("your_ssh_host", "your_ssh_username", "your_ssh_password");
    mysql_connect("your_mysql_host", "your_mysql_username", "your_mysql_password", "your_database");

    return a.exec();
}