8.17日作业

将dict.txt中的内容导入到数据库中

1. 导入后检查解释意思是否完整，双词性

2. 中间有空格的单词

3. o'clock

代码部分

#include<stdio.h>
#include<sys/stat.h>
#include<fcntl.h>
#include<string.h>
#include<sqlite3.h>
#define ERR_MSG(msg) do{ \
	fprintf(stderr,"line: %d ", __LINE__); \
	perror(msg);\
}while(0) 


int do_insert(sqlite3* db,char* world,char* mean);
int main(int argc, const char *argv[])
{
	//创建数据库
	sqlite3* db = NULL;
	if(sqlite3_open("./my.db",&db) != SQLITE_OK)
	{
		fprintf(stderr,"__%d__ sqlite3_open failed\n",__LINE__);
		return -1;
	}
	//创建一个表格
	char* sql = "create table if not exists worlds(world char,mean 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(NULL == fp)
	{
		ERR_MSG("fopen");
		return -1;
	}



	//将数据从txt文件中读取出来
	char buf[128] = "";
	while(1)
	{	
		if(fgets(buf,sizeof(buf),fp) == NULL)
		{
			printf("已读完\n");
			break;
		}
		buf[strlen(buf)-1] = 0;

		//将单词和词义部分分离开
		char world[20] = "";
		char mean[100] = "";
		int flag = 0;
		int i=0;

		//找到三个空格
		for(i = 0;i<strlen(buf);i++)
		{
			if(flag != 3)
			{
				//如果不是空格则跳过，并把flag置0
				if(buf[i] != ' ')
				{
					flag = 0;
					continue;
				}
				else     //如果为空格，flag+1
				{
					flag++;
				}
			}else
			{
				break;
			}
		}
		//将单词填入数组
		bzero(world,sizeof(world));
		for(int j = 0;j<i-3;j++)
		{
			world[j] = buf[j];
		}

		//将词义存入数组
		bzero(mean,sizeof(mean));	
		int k = 0;

		while(buf[i] != 0)
		{
			mean[k] = buf[i];
			k++;
			i++;
		}
		/*
		for(int k = 0;k<strlen(buf)-i;k++)
		{
			mean[k] = buf[i];
			i++;
		}
*/
		//调用插入函数
		do_insert(db,world,mean);
		
	}


	//关闭文件
	fclose(fp);
	return 0;
}
//将数据写入数据库中
int do_insert(sqlite3* db,char* world,char* mean)
{
	//把单词和词义嵌入数据库插入指令
	char sql[128] = "";
	sprintf(sql,"insert into worlds values(\"%s\",\"%s\");",world,mean);
	printf("sql=%s\n",sql);

	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("插入成功\n");
}

运行结果