直接上代碼

mydll.cpp代碼如下：

#include <stdio.h>
#include "mydll.h"
#define MYDLL_EXPORTS
#include <cstdlib>
#include <cstdio>
#include "sqlite3.h"
#pragma comment(lib, "sqlite3.lib")

//#include <stdio.h>

const char *select_query = "select * from users";
//int ret = 0;
sqlite3 *db = 0;
char *s;

//打開數據庫，不存在，創建數據庫db
bool sqlite_tb::OpenDB()
{
	int ret = sqlite3_open("./mydb", &db);
	if (ret != SQLITE_OK)
	{
		printf("無法打開數據庫\n");
		return false;
	}
	printf("數據庫連接成功\n");
	return true;
}

//創建數據庫表
bool sqlite_tb::CreateTable()
{
	int ret = sqlite3_exec(db, "create table if not exists users(id int(10),name char(20))", 0, 0, &s);
	if (ret != SQLITE_OK)
	{
		sqlite3_close(db);
		printf("create error\n");
		return false;
	}
	printf("create success\n");
	return true;
}

//插入數據
bool sqlite_tb::InsertData()
{
	int ret = sqlite3_exec(db, "insert into users values(1,'lyl')", 0, 0, &s);
	ret += sqlite3_exec(db, "insert into users values(2,'yy')", 0, 0, &s);
	ret += sqlite3_exec(db, "insert into users values(3,'bb')", 0, 0, &s);
	if (ret != SQLITE_OK)
	{
		sqlite3_close(db);
		printf("insert error\n");
		return false;
	}
	printf("insert success\n");
	return true;
}
//刪除
bool sqlite_tb::DeleteData()
{
	int ret = sqlite3_exec(db, "delete from users where id=1", 0, 0, &s);
	if (ret != SQLITE_OK)
	{
		sqlite3_close(db);
		printf("delete error\n");
		return false;
	}
	printf("delete success\n");
	return true;
}
//更新
bool sqlite_tb::UpdateData()
{
	int ret = sqlite3_exec(db, "update users set name='ld' where id=3", 0, 0, &s);
	if (ret != SQLITE_OK)
	{
		sqlite3_close(db);
		printf("update error\n");
		return false;
	}
	printf("update success\n");
	return true;
}
//查詢
bool sqlite_tb::SelectData()
{
	int nrow, ncolumn;
	char ** db_result;
	int ret = sqlite3_get_table(db, select_query, &db_result, &nrow, &ncolumn, &s);
	if (ret != SQLITE_OK)
	{
		printf("select error\n");
		sqlite3_close(db);
		return false;
	}
	int i, j;
	for (i = 0; i < (nrow + 1)*ncolumn; i += ncolumn)
	{
		for (j = 0; j < ncolumn; j++)
		{
			printf("%s  ", db_result[i + j]);
		}
		printf("\n");
	}
	sqlite3_close(db);
	db = 0;
	return true;
}

mydll.h代碼如下：

#pragma once
#ifndef _MYDLL_H
#define _MYDLL_H

#ifdef MYDLL-EXPORTS
#define MYDLL _declspec(dllexport)
#else
#define MYDLL _declspec(dllimport)
#endif

class sqlite_tb
{
public:
	bool MYDLL OpenDB();//打開數據庫，不存在，創建數據庫db
	bool MYDLL CreateTable();//創建數據庫表
	bool MYDLL InsertData();//插入數據
	bool MYDLL DeleteData();//刪除
	bool MYDLL UpdateData();//更新
	bool MYDLL SelectData();//查詢
};

#endif

vs編譯產生以下2個文件

 調用代碼如下

#include <stdio.h>
#include "mydll.h"

//使用庫
#pragma comment(lib,"sqlite_dll.lib")

int main()
{
	sqlite_tb sql;
    //打開數據庫，不存在，創建數據庫db
	sql.OpenDB();
	//創建表
	sql.CreateTable();
	//插入數據
	sql.InsertData();
	//刪除
	sql.DeleteData();
	//更新
	sql.UpdateData();
	//查詢
	sql.SelectData();
	return 0;
}

運行結果：

  工程下載鏈接：

https://download.csdn.net/download/wzhrsh/12403939