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;