直接上代码
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