Work code snippet-qsqlite

Open the database:

QSqlDatabase database = QSqlDatabase: addDatabase ("QSQLITE ");
Database. setDatabaseName (mDataName );
If (! Database. open ()){
P; return false;
}
QSqlQuery * queryer = new QSqlQuery ();

Query database: www.2cto.com

QString selectStr = "";
For (<pre name = "code" class = "cpp"> QList <QString>: iterator = args. begin (); iterator <args. end (); iterator ++)
{
SelectStr + = * iterator + ",";
}
SelectStr. remove (selectStr. size ()-1, 1 );
QString queryStr = QObject: tr ("select % 1 from % 2"). arg (selectStr, table );
Bool flag = queryer-> exec (queryStr );
If (! Flag ){
Std: cout <"database query failed" <std: endl;
Return;
}
If (! Queryer-> first ())
{
Std: cout <"no data" <std: endl;
Return;
}
Do {
Proxy-> execut (queryer );
 
} While (queryer-> next ());
Close the database:

If (queryer! = NULL)
{
Delete queryer;
}
Database. close ();

Add database plug-in search path:

QApplication: addLibraryPath (QObject: tr ("./plugins "));

Add compilation options:

QT + = core gui SQL network

Source