qtforum.de

Code: Alles auswählen

static bool database()
{
    QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE","qTest");
    db.setDatabaseName("Subf");
    if (!db.open())
    {
        QMessageBox::critical(0, qApp->tr("Cannot connect to database"),
                                                qApp->tr("Unable to establish a database connection.\n"
                                                                "Error while trying to open SQLite Database.\n"
                                                                "Click Cancel to exit."), QMessageBox::Cancel);
        return false;
    }


    QSqlQuery topgroup = db.exec("CREATE TABLE IF NOT EXISTS topgroup (id INTEGER PRIMARY KEY, name VARCHAR, position INT ) ");

    QSqlQuery q2 = db.exec("INSERT INTO topgroup (name, position) VALUES ('Gesundes Obst',1)");

    QSqlQuery q3 = db.exec("SELECT name FROM topgroup");

    QList<QVariant> list = q3.boundValues().values();
    for (int i = 0; i < list.size(); ++i)
        qDebug() << list.at(i).toString().toAscii().data();

    qDebug() << q3.lastError();

    return true;
}