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();
}
运行截图