嵌入式学习Day33

电子词典上传数据库

#include <stdio.h> 
#include <stdlib.h> 
#include <sqlite3.h>
#include <unistd.h>
#include <sys/types.h>
#include <sys/stat.h>
#include <fcntl.h>
#include <string.h>
 
int main(int argc, const char *argv[])
{
	//创建并打开数据库
	sqlite3 *db=NULL;
	if(sqlite3_open("./dict.db",&db)!=SQLITE_OK)
	{
		fprintf(stderr,"__%d__sqlite3_open:%s",__LINE__,sqlite3_errmsg(db));
		return -1;
	}
	printf("sqlite3_open success\n");


	//创建表格
	char sql[128]="create table if not exists dict (word char,chinese char);";
	char *errmsg=NULL;
	if(sqlite3_exec(db,sql,NULL,NULL,&errmsg)!=SQLITE_OK)
	{
		fprintf(stderr,"__%d__sqlite3_exec:%s\n",__LINE__,errmsg);
		goto END;
	}
	printf("table dict create success\n");

	
	int fd=open("./dict.txt",O_RDONLY);
	if(fd<0)
	{
		perror("open");
		return -1;
	 }
	char word[50]="";
	char chinese[50]="";
	char buf;
	ssize_t res=0;
	char row[128]="";
	char *q=row;

//循环导入文件
while(1)
{
	bzero(row,sizeof(row));
	bzero(word,sizeof(word));
	bzero(chinese,sizeof(chinese));
	q=row;
	//获取一行
	while(1)
	{
		bzero(&buf,sizeof(buf));
		res=read(fd,&buf,1);
		if(0==res)
		{
			printf("文件读取完毕\n");
			return 0;
		}
		else if(res<0)
		{
			perror("read");
			return -1;
		}
		if(buf=='\n')
		break;
		*q++=buf;

	}
	//获取一行的单词和翻译
	int i,j;
	for( i=0;i<strlen(row);i++)
	{
		if(row[i]==' '&&row[i+1]==' ')
		{
			break;
		}
		word[i]=row[i];
	}
	for( j=0;i<strlen(row);i++,j++)
	{
		if(row[i]==0)
			break;
		chinese[j]=row[i];
	}
//	printf("%s %s\n",word,chinese);
	bzero(sql,sizeof(sql));
	sprintf(sql,"insert into dict values (\"%s\",\"%s\");",word,chinese);
	if(sqlite3_exec(db,sql,NULL,NULL,&errmsg)!=SQLITE_OK)
	{
		fprintf(stderr,"__%d__sqlite3_insert:%s\n",__LINE__,errmsg);
		return -1;
	}
}
END:
	if(sqlite3_close(db)!=SQLITE_OK)
	{
		fprintf(stderr,"__%d__sqlite3_close failed %s\n",__LINE__,sqlite3_errmsg(db));
		return -1;

	}
    printf("sqlite3_close success\n");



          return 0;
}