工作程式碼片段-qsqlite

開啟資料庫：

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

查詢資料庫：

    QString selectStr = "";    for(
QList<QString>::iterator 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 << "資料庫查詢失敗" << std::endl;        return;    }    if(!queryer->first())    {        std::cout << "沒有資料" << std::endl;        return;    }    do{        proxy->execut(queryer);    }while(queryer->next());
關閉資料庫：
    if(queryer != NULL)    {       delete queryer;    }    database.close();
添加資料庫外掛程式搜尋路經：
    QApplication::addLibraryPath(QObject::tr("./plugins"));
添加編譯選項：
QT       += core gui sql network