录入电子单词

#include <stdio.h>
#include <sqlite3.h>
#include <stdlib.h>
#include<string.h>
int mystrtok(char *dest,int i);
int callback(void* arg,int columns, char** column_text,char** column_name)
{
	//	printf("columns=%d __%d__")
	int i = 0;
	if(0 == *(int*)arg)
	{
		for(i=0; i<columns; i++)
		{
			printf("%s\t", *(column_name+i));
		}
		printf("\n");
		*(int*)arg = 1;
	}

	for(i=0; i<columns; i++)
	{
		printf("%s\t", *(column_text+i));
	}
	printf("\n");
	return 0; 	//成功返回0，失败返回非0；
}
void do_insert(sqlite3*db)
{
	char name[20];
	char arr[128]="";
	char brr[128]="";
	char mean[20];
	char* sql;
	int i=0;
	char *res=NULL;

	FILE* fp=fopen("./dict.txt","r");
	if(fp==NULL)
	{
		printf("打开失败\n");
		perror("fopen");
		return;
	}
	printf("fopen success\n");

	while(1)
	{
		i=0;
		res=fgets(arr,sizeof(arr),fp);
		arr[strlen(arr)-1]='\0';

		i=mystrtok(arr,i);
		arr[i]=0;
		strcpy(name,arr);

		strcpy(mean,arr+i+2);
	
		printf("name=%s\n",name);
		printf("mean=%s\n",mean);

		if(res==NULL)
		{
			break;
		}

		sprintf(brr,"insert into stu1 values (\"%s\",'%s');",name,mean); 
		printf("brr=%s\n",brr);	
		char* errmsg = NULL;
		if(sqlite3_exec(db, brr, NULL, NULL, &errmsg) != SQLITE_OK)
		{
			fprintf(stderr, "__%d__ sqlite3_exec:%s\n", __LINE__, errmsg);
			return;
		}
		printf("insert into success\n");
	}
	fclose(fp);
}

void do_select(sqlite3* db)
{
	char sql[128]="select *from stu1";
	char* errmsg=NULL;
	int flag=0;
	 if(sqlite3_exec(db, sql, callback, &flag, &errmsg) != SQLITE_OK)
 {
     fprintf(stderr, "__%d__ sqlite3_exec:%s\n", __LINE__, errmsg);
     return;
 }
 printf("select success\n");

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

	//执行sql语句
#if 0
    int sqlite3_exec(
      sqlite3* db,                               /* An open database */
      const char *sql,                           /* SQL to be evaluated */
      int (*callback)(void*,int,char**,char**),  /* Callback function */
      void *arg,                                 /* 1st argument to callback */
      char **errmsg                              /* Error msg written here */
    );

#endif
	//创建一个表格
	char* sql = "create table if not exists stu1 (name char, mean char);" ;
	char* errmsg = NULL;

	if(sqlite3_exec(db, sql, NULL, NULL, &errmsg) != SQLITE_OK)
	{
		fprintf(stderr, "__%d__ sqlite3_exec:%s\n", __LINE__, errmsg);
		return -1;
	}
	printf("create table success\n");


	char choose = 0;
	while(1)
	{
		system("clear");
		printf("---------------------------\n");
		printf("--------1. 插入数据--------\n");
		printf("--------2. 删除数据--------\n");
		printf("--------3. 修改数据--------\n");
		printf("--------4. 查询数据--------\n");
		printf("--------5. 退出------------\n");
		printf("---------------------------\n");

		printf("请输入选项>>>");
		choose = getchar();
		while(getchar()!=10);

		switch(choose)
		{
		case '1':
			do_insert(db);
			break;
		case '2':
		//	do_delete(db);
			break;
		case '3':
		//	do_update(db);
			break;
		case '4':
			do_select(db);
			break;
		case '5':
			goto END;
			break;
		default:
			printf("输入错误，请重新输入\n");
		}

		printf("输入任意字符清屏>>>");
		while(getchar()!=10);

	}
	
END:

	//关闭数据库
	if(sqlite3_close(db) != SQLITE_OK)
	{
		printf("err_code:%d\n", sqlite3_errcode(db));
		printf("errmsg:%s\n", sqlite3_errmsg(db));
		fprintf(stderr, "__%d__ sqlite3_close failed\n", __LINE__);
		return -1;

	}
	printf("sqlite3_close success\n");

	return 0;
}

int mystrtok(char *dest,int i)
{
	char *ch=dest;
	while(*ch!='\0'){
		if(*ch==' '&& *(ch+1)==' '){
			return i;
		}
		i++;
		ch=dest+i;
	}
}