Advertisement
marbledeveloper

Untitled

Jun 6th, 2012
34
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C++ 1.09 KB | None | 0 0
  1. #include <QtGui/QApplication>
  2. #include <QtCore/QDir>
  3. #include <QtCore/QSettings>
  4. #ifdef STATIC_BUILD
  5.  #include <QtCore/QtPlugin>
  6.  Q_IMPORT_PLUGIN(qjpeg)
  7.  Q_IMPORT_PLUGIN(qsvg)
  8. #endif
  9. #include <QSqlDatabase>
  10. #include <QSqlQuery>
  11. #include <QSqlRecord>
  12. #include <QDebug>
  13. int main(int argc, char *argv[])
  14. {
  15.     QApplication a(argc, argv);
  16.  
  17.     QSqlDatabase db;
  18.     // Find QSLite driver
  19.     db = QSqlDatabase::addDatabase("QSQLITE");
  20.     db.setDatabaseName("test.db");
  21.     db.open();
  22.     QString query("SELECT field1, field2 FROM table1 WHERE field3 = '1'");
  23.     QSqlQuery sqlQuery(db);
  24.     sqlQuery.exec(query);
  25.  
  26.  
  27.     int columnsNumber = sqlQuery.record().count();
  28.     QList<QStringList*> results;
  29.     while (sqlQuery.next())
  30.     {
  31.         QStringList *record = new QStringList();
  32.         for (int i = 0; i < columnsNumber; i++)
  33.             record->append(sqlQuery.value(i).toString());
  34.         results.append(record);
  35.     }
  36.  
  37.     for (int i(0); i < results.count(); i++)
  38.         qDebug() << "result: " << *results.at(i);
  39.     MarbleWidget w;
  40.     w.show();
  41.     return a.exec();
  42. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement