一、環境配置

操作系統：Windows10

下載地址：

https://www.sqlite.org/download.html

windows環境下載zip版本：

二、編譯

根據官網說明來操作

cmd中輸入cl shell.c sqlite3.c -Fesqlite3.exe

創建一個aaa.db數據庫，創建表test

sqlite3.exe aaa.db
create table test(id integer primary key, value text);

插入三條數據

insert into test(id, value)values (1,'aaa');
insert into test(id, value)values (2,'bbb');
insert into test(value)values ('ccc');

//設置列的模式顯示
.mode column
.headers on
select * from test;

select last_insert_rowid()

插入三條數據

insert into test(id, value)values (1,'aaa');
insert into test(id, value)values (2,'bbb');
insert into test(value)values ('ccc');

設置列的模式顯示

.mode column
.headers on
select * from test;

select last_insert_rowid()

三、使用vs編寫數據庫操作

創建一個控制臺項目，sqlite3.c和sqlite3.h 作為源文件添加到項目中。

操作數據庫代碼：

#include"sqlite3.h"
#include<stdio.h>
#include<stdlib.h>
#include<string.h>

int MyCallback(void* para, int nColumn, char** colValue, char** colName);

int main(int argc, char* argv[])
{
	sqlite3* db = NULL;
	int result = sqlite3_open("test.db", &db);

	if (result != SQLITE_OK)
	{
		printf("open database text.db failed \n");
		return 0;
	}
	else
	{
		printf("open database text.db success \n");
	}
	//開始執行sqlite
	const char* sql = "create table Student(t_id integer primary key autoincrement, t_name varchar(15), t_age integer)";
	char* errMsg = NULL;
	result = sqlite3_exec(db,
		sql,
		NULL,
		NULL,
		&errMsg);
	if (result != SQLITE_OK)
	{
		printf("create table Student failed\n");
		printf("error conde %d \t error message:%s", result, errMsg);
	}
	//插入數據
	errMsg = NULL;
	sql = "insert into Student(t_name, t_age) values ('dwb', 23)";
	result = sqlite3_exec(db,
		sql,
		NULL,
		NULL,
		&errMsg);
	printf("insert message1:%s \n", errMsg);

	errMsg = NULL;
	sql = "insert into Student(t_name, t_age) values ('dhx', 25)";
	result = sqlite3_exec(db,
		sql,
		NULL,
		NULL,
		&errMsg);
	printf("insert message2:%s \n", errMsg);

	errMsg = NULL;
	sql = "insert into Student(t_name, t_age) values ('dwz', 21)";
	result = sqlite3_exec(db,
		sql,
		NULL,
		NULL,
		&errMsg);
	printf("insert message3:%s \n", errMsg);


	errMsg = NULL;
	sql = "select * from Student;";
	result = sqlite3_exec(db, sql, MyCallback, NULL, &errMsg);
	printf("select message:%s \n", errMsg);

	//執行不用回調函數的sql語句，先要設置函數所需的參數
	printf("\nUSEING sqlite3_get_table()----------------------------\n");
	sql = "select * from Student;";

	int nCols;
	int nRows;
	char** azResult;
	errMsg = NULL;
	int index = 0;

	result = sqlite3_get_table(db, sql, &azResult, &nRows, &nCols, &errMsg);
	printf("result = %d \t errMsg = %s \n", result, errMsg);
	printf("rows:%d \t cols: %d \n", nRows, nCols);
	index = nCols;

	printf("++++++++++++++++++++++++++++++++++++++++++++++++++++++++\n");
	for (int i = 0; i < nRows; i++)
	{
		for (int j = 0; j < nCols; j++)
		{
			printf("%s::%s", azResult[j], azResult[index]);
			index++;
			printf("\n");
		}
	}
	printf("++++++++++++++++++++++++++++++++++++++++++++++++++++++++\n");

	sqlite3_free_table(azResult);
	sqlite3_close(db);

	return 0;
}

int MyCallback(void* para, int nColumn, char** colValue, char** colName)
{
	printf("----------------------------------------------------\n");
	printf("包含的列數：%d\n", nColumn);
	for (int i = 0; i < nColumn; i++)
	{
		printf("%s :%s\n", *(colName + i), colValue[i]);//指針和數組的兩種寫法
	}
	printf("----------------------------------------------------\n");
	return 0;
}