将dict.txt（词典）导入到数据库中

最新推荐文章于 2023-09-04 19:44:26 发布

yayyy4

最新推荐文章于 2023-09-04 19:44:26 发布

阅读量478

点赞数

文章标签：数据库 sqlite

本文链接：https://blog.csdn.net/yayyy4/article/details/126394903

版权

主函数


#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;
}