网络编程（day7）

关于数据库的API的思维导图

将dict.txt导入到数据库中

#include <myhead.h>

#define ERR_MSG(msg) do{\
	fprintf(stderr,"__%d__:",__LINE__);\
	perror(msg);\
}while(0)

int main(int argc, const char *argv[])
{
	//以只读的方式打开dict.txt文件
	FILE* fd;
	if((fd=fopen("./dict.txt","r")) == NULL){
		ERR_MSG("open");
		return -1;
	}

	//打开数据库
	sqlite3* db=NULL;
	if(sqlite3_open("./dict.db", &db) != 0){
		fprintf(stderr,"__%d__sqlite3_open: %s",\
				__LINE__, sqlite3_errmsg(db));
		return -1;
	}

	//创建数据表
	char sql[128] = "create table if not exists dict(word char,mean char);";
	char *errmsg = NULL;
	if(sqlite3_exec(db,sql,NULL,NULL,&errmsg) != 0){
		fprintf(stderr, "__%d__create:%s\n",\
				__LINE__,errmsg);
		return -1;
	}
	printf("create success\n");

	char buf[128]="";
	char word[64]="";
	char mean[64]="";
	while(fgets(buf,128,fd) != NULL){
		buf[strlen(buf)-1]=0;
		for(int i=0;i<strlen(buf);i++){
			if(buf[i]!=' ' && buf[i+1]==' ' && buf[i+2]==' '){
				strncpy(word,buf,i+1);
			}
			if(buf[i]==' ' && buf[i+1]==' ' && buf[i+2]!=' '){
				strcpy(mean,buf+i+2);
			}
		}
		
		//将word,mean插入到数据库中
		char sql[128]="";
		sprintf(sql,"insert into dict values(\"%s\",\"%s\");", word, mean);
		char *errmsg = NULL;
		if(sqlite3_exec(db,sql,NULL,NULL,&errmsg) !=0){
			fprintf(stderr, "__%d__insert:%s\n",\
					__LINE__,errmsg);
			return -1;
		}

		//清空buf,word,mean
		bzero(buf,128);
		bzero(word,64);
		bzero(mean,64);
	}
 	printf("导入成功\n");

	//关闭文件
	fclose(fd);

	//关闭数据库
	sqlite3_close(db);
	return 0;
}