src/examples/sql_record_example.cpp

Go to the documentation of this file.

#include <QApplication>
#include <QtSql>

#include <iostream>
using namespace std;

/* Change these to match your database */
#define HOST   "127.0.0.1"
#define DB     "xe"
#define PORT   1521
#define USER   "testbed"
#define PASSWD "secret"

int main(int argc, char *argv[])
{
    QApplication app(argc, argv);
 
    QSqlDatabase qDB = QSqlDatabase::addDatabase("QOpenOCCI");
    
    qDB.setHostName(HOST);
    qDB.setDatabaseName(DB);
    qDB.setPort(PORT);
    qDB.setUserName(USER);
    qDB.setPassword(PASSWD);
    
    /* Probably overkill ;) */
    qDB.setConnectOptions("Prefetch_Memory=5242880;Prefetch_Rows=250");
    
    if (qDB.open() == FALSE) {
        cerr << "Error: opening DB failed because " << qDB.lastError().text().toStdString() << endl;
        return -1;
    }

    QSqlQuery query(qDB);
    
    if (query.exec("select * from user_tables") == FALSE) {
        cerr << "Error: query failed because " << query.lastError().text().toStdString() << endl;
        return -1;
    }
    
    QSqlRecord rec = query.record();
    
    cout << "Fields: ";
    for (int c = 0; c < rec.count(); c++) {
        cout << rec.fieldName(c).toStdString() << " ";
    }
    cout << "\n\n";
    
    while (query.next()) {
        for (int c = 0; c < rec.count(); c++) {
            cout << query.value(c).toString().toStdString() << " ";
        }
        cout << endl;        
            
    }
    
    return 0;
}

---