#include <QSqlDatabase>
#include <QSqlQuery>
#include <QVariant>
#include <stdio.h>
int main(int argc, char * argv[])
{
Q_UNUSED(argc);
Q_UNUSED(argv);
/** Connect to database */
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
/** Set database name (and login for other db drivers) */
db.setDatabaseName(":memory:");
//db.setDatabaseName("test.db");
/** Open database */
if (!db.open())
{
return 1;
}
/* Do some queries with the default connectin */
QSqlQuery query;
query.exec("CREATE TABLE test (id int primary key, name varchar(20))");
query.exec("INSERT INTO test VALUES (1, 'Name 1')");
query.exec("INSERT INTO test VALUES (2, 'Name 2')");
query.exec("INSERT INTO test VALUES (3, 'Name 3')");
query.prepare("INSERT INTO test VALUES (4, :bindval)");
query.bindValue(":bindval", "Name 4");
query.exec();
query.exec("SELECT * FROM test WHERE id > '2'");
while (query.next())
{
QString name = query.value(1).toString();
printf("Name: %s\n", name.toLatin1().constData());
}
/** Database closed in destructor */
return 0;
}