qt中使用sqlite3教程

qt中默认带有sqlite的驱动库，但是实际使用的时候嫌麻烦，所以花时间研究了一下ssqlite默认的，感觉挺精简的，特此记录一下

1.新建一个qt的静态库工程sqlite3_static，然后把建立项目时生成的文件全删掉，叫sqlite源码中的文件

主要是红色圈住的3个

最后编译就会生成

把这个库文件导入要是用的项目中就可以了

2.使用案例

#include "mainwindow.h"
#include <QApplication>
#include <QDebug>
#include "E:\new_qt_prj\sqlite3_static\sqlite3.h"

void print_row(int n_values, char** values)
{
    for (int i = 0; i < n_values; ++i)
        qDebug()<<values[i];
    qDebug()<<"\n";
}

int print_result(void* data, int n_columns, char** column_values, char** column_names)
{
    static int column_names_printed = 0;
    if (column_names_printed++ == 0)
        print_row(n_columns, column_names);
    print_row(n_columns, column_values);
    return 0;
}

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

    sqlite3 *db = NULL;
    char *errMsg = NULL;
    int rc = sqlite3_open("test.db", &db);
    if( rc )
    {
        qDebug()<<"Can't open database: "<<sqlite3_errmsg(db);
        sqlite3_close(db);
        return 0;
    }
    else
        qDebug()<<"open test.db successfully!\n";

    rc = sqlite3_exec(db, "BEGIN TRANSACTION;", NULL, NULL, NULL);
    rc = sqlite3_exec(db, "CREATE TABLE students(number varchar(10), name varchar(10), "
            "sex varchar(6), age varchar(2));", NULL, NULL, NULL);
    rc = sqlite3_exec(db, "INSERT INTO students VALUES('00001','Mary','female','15');"
            "INSERT INTO students VALUES('00002', 'John', 'male', '16');",
                        NULL, NULL, &errMsg);
    rc = sqlite3_exec(db, "SELECT students.* FROM students WHERE sex='female';",
                        print_result, NULL, &errMsg);
    rc = sqlite3_exec(db, "SELECT students.* FROM students WHERE sex='male';",
                        print_result, NULL, &errMsg);
    rc = sqlite3_exec(db, "COMMIT TRANSACTION;", NULL, NULL, NULL);

    qDebug()<<"error code: "<<rc<<"\n";
    qDebug()<<"error message:"<<errMsg<<"\n";

    sqlite3_close(db);


    return a.exec();
}

运行截图