c++ - Oracle OCCI 'select count(*)' 结果获取

Question

如何获得查询执行的结果 - select count (*) from myTable？代码是:

... 
oc::Statement* stmt = 
    m_cConnection->createStatement(select count (*) from myTable);

oc::ResultSet* res = stmt->executeQuery();
...

如何在 res 中获取行数的值？

Answer 1

随便写

cout << res->getString(1) << endl;

或

cout << "\t... MySQL counts: " << res->getInt(1) << endl;