Qt 創(chuàng)建、操作SQLLite數(shù)據(jù)庫

  項目中需要用到小型數(shù)據(jù)庫，查了一下Qt支持QMYSQL、QSQLITE等很多類型的數(shù)據(jù)庫，使用MySQL需要安裝一些相關軟件或編譯相關開發(fā)庫，故選擇QSQLITE數(shù)據(jù)庫。
  創(chuàng)建數(shù)據(jù)庫及數(shù)據(jù)庫表格可使用軟件手動創(chuàng)建編輯，也可使用程序創(chuàng)建、操作。測試程序代碼如下所示：

//main.cpp

#include <QApplication>
#include <QSqlQuery>
#include <QDebug>

int main(int argc, char *argv[])
{
    QApplication a(argc, argv);

    QSqlDatabase db = QSqlDatabase::addDatabase( "QSQLITE" ); 
    db.setDatabaseName( "test.db" );

    if( !db.open() )
        return false;

    QSqlQuery query;
    query.exec( "CREATE TABLE student("
                "id INTEGER PRIMARY KEY AUTOINCREMENT,"
                "name VARCHAR,"
                "age INT)" );
    query.exec( "insert into student values( 0, 'LL', 16 )" );
    query.exec( "insert into student values( 1, 'MM', 17 )" );
    query.exec( "insert into student values( 2, 'NN', 18 )" );

    query.exec( "select * from student" );

    while( query.isActive() && query.next() )
    {
        qDebug() <<  query.value( 0 ).toInt() << query.value( 1 ).toString() 
        << query.value( 2 ).toInt() << "\n";
    }

    return a.exec();
}

結果：