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>

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

    // SSH 连接
    ssh_session session = ssh_new();
    ssh_options_set(session, SSH_OPTIONS_HOST, "your_server_ip");
    ssh_options_set(session, SSH_OPTIONS_USER, "your_username");
    ssh_options_set(session, SSH_OPTIONS_PASSWORD, "your_password");

    int rc = ssh_connect(session);
    if (rc != SSH_OK) {
        fprintf(stderr, "Error: %s\n", ssh_get_error(session));
        return 1;
    }

    // MySQL 连接
    sql::mysql::MySQL_Driver *driver = sql::mysql::get_mysql_driver_instance();
    std::unique_ptr<sql::Connection> con(driver->connect("tcp://127.0.0.1:3306", "your_mysql_username", "your_mysql_password"));

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

    while (res->next()) {
        std::cout << res->getString("column_name") << std::endl;
    }

    // 关闭连接
    ssh_disconnect(session);
    ssh_free(session);

    return a.exec();
}