8.17-网络编程-作业

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

注意：

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

2. 中间有空格的单词

3. o'clock

#include <stdio.h>
#include <sqlite3.h>
#include <string.h>

int do_insert(sqlite3* db,char* buf);
int main(int argc, const char *argv[])
{
	char buf[100];
	//打开文件
	FILE*fd = fopen("./dict.txt","r");
	if(NULL == fd)
	{
		perror("fopen");
		return -1;
	}
	//打开数据库
	sqlite3* 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;
	}
	//创建一个表格
	char sql[128] = "create table if not exists word (word 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;
	}
	//读取文件内容存储到表格中
	while(1)
	{
		if(NULL == fgets(buf,sizeof(buf),fd))//获取一行的内容
			break;
		do_insert(db,buf);
	}
	sqlite3_close(db);
	fclose(fd);
	return 0;
}
//插入到表格
int do_insert(sqlite3* db,char* buf)
{
	char word[50] = "",mean[50] = "";
	char* q = buf;
	int num = 0;
	char* errmsg = NULL;
	char sql[128] = "";
	//获取一行中的单词,遇到二个空格单个单词结束
	while(1)
	{
		if(*q == ' ' && *(q+1) == ' ')
		{
			while(1)
			{
				if(*q != ' ')//将q指向下个不是空格的位置,即词性的开头
					break;
				q++;
			}
			break;
		}
		word[num] = *q;
		num++;
		q++;
	}
	//q指向后面内容就是单词词性和中文,直接拷贝到mean字符串中
	strcpy(mean,q);
	sprintf(sql,"insert into word values(\"%s\",\"%s\")",word,mean);//存入到表中
	if(sqlite3_exec(db,sql,NULL,NULL,&errmsg) != SQLITE_OK)
	{
		fprintf(stderr,"__%d__ sqlite3_exec:%s\n",__LINE__,errmsg);
		return -1;
	}
	return 0;

}