将四级单词存入sqlite3数据库中

 将四级单词存入sqlite3数据库中

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

int main(int argc, const char *argv[])
{
	//创建并打开一个数据库
	sqlite3 *db=NULL;
	if(sqlite3_open("./eglish.db",&db) != SQLITE_OK){
		fprintf(stderr,"sqlite3_open failed:%d:%s\n",sqlite3_errcode(db),sqlite3_errmsg(db));
		return -1;
	}
	printf("sqlite3_open success\n");

	//创建一张表格
	char sql[128] = "create table if not exists egdanci(danci char,fanyi char);";
	char *errmsg = NULL;
	if(sqlite3_exec(db,sql,NULL,NULL,&errmsg) != SQLITE_OK){
		fprintf(stderr,"line:%d sqlite3_exec:%s\n",__LINE__,errmsg);
		return -1;
	}
	printf("table stu create success\n");
	//打开文件
	FILE *file=fopen("./dict.txt","r");
	if(NULL==file){
		perror("fopen");
		return -1;
	}
	char danci[20]="";
	char fanyi_1[50]="";
	int renum=0;
	char sdl[128]="";
	while(1){
		bzero(danci,sizeof(danci));
		bzero(fanyi_1,sizeof(fanyi_1));
		bzero(sdl,sizeof(sdl));
		renum=fscanf(file,"%s",danci);
		fgets(fanyi_1,sizeof(fanyi_1),file);
		fanyi_1[strlen(fanyi_1)-1]='\0';
		if(EOF==renum){
			printf("输入数据库完成\n");
			break;
		}
		sprintf(sdl,"insert into egdanci values(\"%s\",\"%s\")",danci,fanyi_1);
		if(sqlite3_exec(db,sdl,NULL,NULL,&errmsg) != SQLITE_OK){
			fprintf(stderr,"line:%d sqlite3_exec:%s\n",__LINE__,errmsg);
			return -1;
		}
	}
	if(sqlite3_close(db) != SQLITE_OK){
		fprintf(stderr,"line:%d sqlite3_close:%d:%s\n",\
				__LINE__,sqlite3_errcode(db),sqlite3_errmsg(db));
		return -1;                                                 
	}
	fclose(file);
	return 0;
}

运行结果：