2022/8/17---网络编程day6

创作本文目的：记录自己的学习历程

---

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

1.要求

1. 导入后检查解释意思是否完整，双词性
2. 中间有空格的单词
3. o’clock

2.代码

#include <stdio.h>
#include <sqlite3.h>
#include <stdlib.h>
#include <string.h>
#include <ctype.h>
#include <unistd.h>

void do_insert(sqlite3 *,char *,char *);

int main(int argc, const char *argv[])
{
	//打开数据库
	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 stu (word char primary key, 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");

	//打开dict文件
	FILE *fd = fopen("./dict.txt","r");
	fseek(fd, 0, SEEK_SET);
	if(NULL==fd)
	{
		perror("open");
		return -1;
	}

	ssize_t res;
	char buf[50]="";
	char *tmp=NULL;
	char word[20]="";
	char *meaning=NULL;
	int i,j;
	int flag=0;
	while(1)
	{
		//读取文件内容
		bzero(buf,sizeof(buf));
		tmp=fgets(buf,sizeof(buf),fd);
		buf[strlen(buf)-1]=0;
		if(NULL==tmp)
		{
			printf("文件读取完毕\n");
			break;
		}
		//取出单行中的单词和意思	
		for(i=0;i<strlen(buf);i++)
		{
			if(flag==0)
			{
				if(32==buf[i] && 32==buf[i+1])
				{
					for(j=0;j<i;j++)
					{
						word[j]=buf[j];
					}
					word[j]=0;
					flag=1;
				}
			}
			else
			{
				if(32!=buf[i] && 32==buf[i-1])
				{
					printf("1\n");
					meaning=buf+i;
					break;
				}
			}
		}
		flag=0;
		//printf("%s1%s\n",word,meaning);
		//sleep(1);

		//写入数据库
		do_insert(db,word,meaning);
	}

	//关闭数据库
	if(sqlite3_close(db) != SQLITE_OK)
	{
		printf("err_code:%d\n", sqlite3_errcode(db));
		printf("errmsg:%s\n", sqlite3_errmsg(db));
		fprintf(stderr, "__%d__ sqlite3_close failed\n", __LINE__);
		return -1;

	}
	printf("sqlite3_close success\n");

	return 0;
}

void do_insert(sqlite3 *db,char *word,char *meaning)
{
	char* errmsg = NULL;
	char buf[128]="";

	sprintf(buf,"insert into stu values (\"%s\",'%s');",word,meaning);
	if(sqlite3_exec(db, buf, NULL, NULL, &errmsg) != SQLITE_OK)
	{
		fprintf(stderr, "__%d__ sqlite3_exec:%s\n", __LINE__, errmsg);
		return;
	}
	printf("insert success\n");
}

3.运行效果

---