主函数
#include<stdio.h>
#include<sqlite3.h>
#include<stdlib.h>
#include<sys/types.h>
#include<sys/stat.h>
#include<fcntl.h>
#include<unistd.h>
#include<string.h>
#define MSG_ERR(msg) do{fprintf(stderr," _%d_ ", __LINE__);perror(msg);return -1;}while(0)
int do_insert(sqlite3* db,char word[],char meaning[]);
int main(int argc,const char* atgv[])
{
sqlite3* db = NULL;
if(sqlite3_open("./dict.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 dict (word char,meaning char);";
char* errmsg = NULL;
if(sqlite3_exec(db, sql, NULL, NULL, &errmsg) != SQLITE_OK)
{
fprintf(stderr, "__%d__ sqlite3_exec:%s\n", __LINE__, errmsg);
return -1;
}
printf("create table success\n");
FILE * fp = fopen("dict.txt","r");
if(fp == NULL)
{
MSG_ERR("open");
}
char word[128] = "";
char meaning[128] = "";
char buf[256] = "";
int flag = 0;
int sum = 0;
while(1)
{
bzero(word,sizeof(word));
bzero(meaning,sizeof(meaning));
bzero(buf,sizeof(buf));
if(fgets(buf,sizeof(buf),fp) == NULL)
{
break;
}
int num = 0;
int m = 0;
int n = 0;
while(buf[num] != '\n')
{
if(buf[num] == ' ')
{
flag++;
}
if(flag < 2)
{
word[m] = buf[num];
m++;
}
else
{
meaning[n] = buf[num];
n++;
}
num++;
}
flag = 0;
do_insert(db,word,meaning);
}
return 0;
}
int do_insert(sqlite3* db,char word[],char meaning[])
{
char buf[256] = "";
bzero(buf,sizeof(buf));
sprintf(buf,"insert into dict (word,meaning) values (\"%s\",\'%s\');",word,meaning);
char* errmsg = NULL;
if(sqlite3_exec(db,buf, NULL, NULL, &errmsg) != SQLITE_OK)
{
fprintf(stderr, "__%d__ sqlite3_exec:%s\n", __LINE__, errmsg);
return -1;
}
return 0;
}