sqlite3增删改查C++类实现

直接上代码

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