首页 > 解决方案 > 使用 C++ 的 Oracle 数据库

问题描述

我正在尝试打印“仓库”表中的所有内容。下面是我的代码。

ISSUE: 只打印 3/10 行。

应该打印这个 但是打印这个

try
{
    env = Environment::createEnvironment(Environment::DEFAULT);
    conn = env->createConnection(usr, pass, srv);
    Statement* stmt = conn->createStatement("SELECT * FROM warehouses");
    /*---------------------CODE-------------------------------*/
    
    ResultSet* rs = stmt->executeQuery();

    if (!rs->next())
    {
        cout << "ResultSet is empty." << endl;
    }
    else
    {
        while (rs->next())
        {
            cout << "Warehouse ID: " << rs->getInt(1) << "Warehouse Name: " << rs->getString(2) << "     " << "Location ID: " << rs->getInt(3) << endl;
        }
    }
    /*---------------------CODE-------------------------------*/
    conn->terminateStatement(stmt);
    env->terminateConnection(conn);
    Environment::terminateEnvironment(env);
}

标签: c++oracle

解决方案


推荐阅读