#include <QtCore/QCoreApplication>
#include <QtSql>
#include <QtDebug>

int main(int argc, char *argv[])
{
    QCoreApplication a(argc, argv);

    QSqlDatabase db = QSqlDatabase::addDatabase("QPSQL");
    db.setHostName("LOCALHOST");
    db.setDatabaseName("/Dokumente/Test2.sql");

    if(db.open())
    {
        qDebug() << "Opened!";
        qDebug() << endl;

        QSqlQuery qry;

        if(qry.exec("SELECT* FROM tb2"))
        {
            while(qry.next())
            {
                qDebug() << "ID:       =" << qry.value(0).toString() << "" << "   "
                         << "Name:     =" << qry.value(1).toString() << "" << "   "
                         << "Passwort: =" << qry.value(2).toString();
                qDebug() << endl;
            }

        }

        else
        {
            qDebug() << qry.lastError().text() << "Sql error code:" << qry.lastError().number() << endl << endl;
        }

        qDebug() << "closing..." << '\n';

        db.close();

        qDebug() << "closed!";
    }
    else
    {
        qDebug() << db.lastError().text() << "Database error code:" << db.lastError().number();
    }

    return a.exec();
}
