20230414作业(词典拷贝到数据库 sqlite3_exec)

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

int main(int argc, const char *argv[])
{
	//创建数据库
	//如果数据库不存在，创建后打开，如果存在，直接打开
	sqlite3*db = NULL;
	if(sqlite3_open("./sq.db",&db)!= SQLITE_OK)
	{
		fprintf(stderr,"sqlite3_open :%s  errcode:%d\n",sqlite3_errmsg(db),sqlite3_errcode(db));
		return -1;
	}
	printf("sqlites_open success!\n");

	//在数据库中创建一个表
	//注意c代码中编写的sql语句与数据库中编写的一致
	//CREATE TABLE if not exists dict (word char,mean char);";

	char sql[300]="CREATE TABLE if not exists dict (word char,mean char);";
	char *errmsg=NULL;
	if(sqlite3_exec(db,sql,NULL,NULL,&errmsg)!=SQLITE_OK)
	{
		fprintf(stderr,"line = %d  squlite3_exe:%s\n",__LINE__,errmsg);
		return -1;
	}
	strcpy(sql,"delete from dict");
	errmsg=NULL;
	if(sqlite3_exec(db,sql,NULL,NULL,&errmsg)!=SQLITE_OK)
	{
		fprintf(stderr,"line = %d  squlite3_exe:%s\n",__LINE__,errmsg); 
		return -1;
	}

	char buf[100]="";
	char word[50]="";
	char mean[100]="";
	FILE* fp = fopen("./dict.txt","r");
	if(NULL==fp)
	{
		perror("fopen");
		return -1;
	}

	while(1)
	{
		//获取每一行的内容，包括单词和意思
		if(NULL==fgets(buf,sizeof(buf),fp))
		{
			perror("fgets");
			goto END;
		}
		buf[sizeof(buf)-1]='\0';
//		printf("%s\n",buf);
		
	//把每一行的内容分成单词和意思两个字符串
		int i=0,j=0,s=0;
		while(1)
		{
			i++;
			if(buf[i]==' '&&buf[i+1]==' ')
				break;
		}

	//	buf[i]='\0';
	//	printf("i=%d %s\n",i,buf);
		j=i+1;
		while(buf[j]==' ')
		{
			j++;
		}
		while(buf[j]!='\0')
		{
			mean[s]=buf[j];
			s++;j++;
		}
		buf[i]='\0';
		mean[s+1]='\0';

		strcpy(word,buf);

		//将word和mean加入数据库的表格中
		errmsg=NULL;
		strcpy(sql,"INSERT INTO dict VALUES");
		sprintf(sql,"%s(\"%s\",\"%s\")",sql,word,mean);
		if(sqlite3_exec(db,sql,NULL,NULL,&errmsg)!=SQLITE_OK)
		{
			fprintf(stderr,"line = %d  squlite3_exe:%s\n",__LINE__,errmsg);
			return -1;
		}
		bzero(word,sizeof(word));
		bzero(mean,sizeof(mean));
	
	}

	//关闭数据库
END:
	if(sqlite3_close(db) !=SQLITE_OK)
	{
		fprintf(stderr,"sqlite3_close :%s errcode:%d\n:",sqlite3_errmsg(db),sqlite3_errcode(db));
		return -1;
	}
	return 0;
}