qtforum.de

Code: Alles auswählen

#include <QtGui/QApplication>
#include <QtGui>
#include <QtSql>
#include <QDebug>
#include "sqlexample1.h"


/* Modify the following to match your environment */
#define DRIVER       "QSQLITE"  /* see the Qt SQL documentation for a list of available drivers */
#define DATABASE     "cdcol" /* the name of your database */
#define USER         "root"   /* user name with appropriate rights */
#define PASSWORD     ""   /* password for USER */
#define HOST         "localhost" /* host on which the database is running */


int main(int argc, char* argv[]) {
   QApplication app(argc, argv);

   QSqlDatabase db = QSqlDatabase::addDatabase(DRIVER);
   db.setHostName(HOST);
   db.setDatabaseName(DATABASE);
   db.setUserName(USER);
   db.setPassword(PASSWORD);

   if (!db.open()) {
      QSqlError err =  db.lastError ();
      QMessageBox::information(0, QObject::tr("Fehler"), err.text());
      return 1;
   }
   QTextEdit edit;
   QSqlQuery query;

   // Alle Daten abfragen
   query.exec("SELECT * FROM cds");
   QSqlRecord record = query.record();
   while (query.next()) {
      QString  line =
         query.value(record.indexOf("titel")).toString();
         line.append(QObject::tr(", "));
         edit.append(line);
   }
  edit.show();
  return app.exec();
}

Code: Alles auswählen

QSqlRecord record = query.record(); 

Code: Alles auswählen

		QString line = query.value(1).toString();

Code: Alles auswählen

db.setHostName(HOST);

Code: Alles auswählen

Buch
     \
      |
      |    /
      |   /
         /
   |     |
   |  T  |
   |  O  |
   |  N  |
   |  N  |
   |  E  |
   |_____|