电子词典项目的数据库导入

#include <stdio.h>
#include <sqlite3.h>
#include <string.h>
int main(int argc, const char *argv[])
{
	sqlite3 *db=NULL;
	char* errmsg=NULL;
	if(sqlite3_open("./dict.db",&db)!=SQLITE_OK){
		printf("line:%d errno:%s\n",__LINE__,sqlite3_errmsg(db));
		return -1;
	}
	printf("database open success\n");
	
	char sql[128]="create table if not exists stu (id int PRIMARY KEY,name char,mean char);";
	if(sqlite3_exec(db,sql,NULL,NULL,&errmsg)!=SQLITE_OK){
		printf("line:%d sqlite3_exec:%s\n",__LINE__,errmsg);
		return -1;
	}
	printf("create table success\n");
	char c=0;
	FILE* fp=fopen("./word.txt","r");
	char word[128]={0};
	char mean[128]={0};
	char buf[128]={0};
	int id=0;
	while(1){
		id++;
		bzero(buf,sizeof(buf));
		if(fscanf(fp,"%s   %s",word,mean)==EOF){
			break;
		}
		//printf("%s\n",word);
		//printf("%s\n",mean);
		sprintf(buf,"insert into stu values (%d,\"%s\",\"%s\");",id,word,mean);
		//printf("%s\n",buf);
		if(sqlite3_exec(db,buf,NULL,NULL,&errmsg)!=SQLITE_OK){
			printf("line:%d sqlite3_exec:%s\n",__LINE__,errmsg);
			return -1;
		}
	}
	if(sqlite3_close(db)!=SQLITE_OK){
		printf("line:%d sqlite3_close:%s\n",__LINE__,sqlite3_errmsg(db));
		return -1;
	}
	return 0;
}