example?
There are only for a examples, no control, no efficent, is only for understand how can you set a simple query...
//Open mysqlite db
@void sql::connect()
{
bool ok;
//Connect db
db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("test.sqlite");
ok = db.open();
if(!ok)
{
qDebug() << db.lastError();
exit(1);
}
}
@
//Create a table and insert some value
@void sql::test()
{
QSqlQuery query;
QString str = QString("CREATE TABLE t(x INTEGER, y, z, t,PRIMARY KEY(x ASC))");
query.prepare(str);
query.exec();
str = QString("INSERT INTO t VALUES(10, 5, 7, 'test')");
query.prepare(str);
query.exec();
}@
//Simple get some values separate from a ; in a QStringList
@QStringList sql::getActionUser(qint32 iduser)
{
QSqlQuery query;
QString str = QString("SELECT A.id,A.name,A.data FROM Action AS A WHERE A.iduser= '%1' ORDER BY A.data DESC").arg(iduser);
QStringList result;
result.clear();
query.setForwardOnly(1);
query.prepare(str);
if(query.exec())
{
while(query.next())
{
if(query.isValid())
result << query.value(0).toString() + ";" + query.value(1).toString() + ";" + query.value(2).toString();
}
}
query.clear();
return result;
}@
