目录
代码实现:
#include<stdio.h>
#include<sqlite3.h>
#include<sys/types.h>
#include<sys/stat.h>
#include<fcntl.h>
#include<unistd.h>
#include<strings.h>
#include<stdlib.h>
#include<string.h>
sqlite3* db;
char* errmsg;
int flag;
int download();
int callback(void *arg,int columns,char **column_text,char **column_name);
int do_select();
int do_delete();
int main(int argc, const char *argv[])
{
//打开数据库
db = NULL;
if(sqlite3_open("./my.db", &db) != SQLITE_OK)
{
printf("err_code:%d\n", sqlite3_errcode(db));
printf("errmsg:%s\n", sqlite3_errmsg(db));
fprintf(stderr, "__%d__ sqlite3_open failed\n", __LINE__);
return -1;
}
printf("sqlite3_open success\n");
//创建一个表格
char* sql = "create table if not exists dict2 (word char,mean char);"