20230816

 

#include <head.h>
#include <sqlite3.h>

void do_insert(sqlite3 *db);
void do_insert(sqlite3 *db)
{
/*	
	int k1;
	char s1[128] = "";
	float k3;
	printf("请输入参数参考格式(1,'MC',99.9)\n");
	printf("请输入参数参考格式:(1)    : ");
	scanf("%d",&k1);
	printf("请输入参数参考格式:('MC') : ");
	scanf("%s",s1);
	printf("请输入参数参考格式:(99.9) : ");
	scanf("%f",&k3);
	getchar();
*/
	int res = 0;
	char buf[128] = "";
	char buf1[128] = "";
	char na[128] = "";
	char dyi[128] = "";
	FILE *fp = fopen("./dict.txt","r");
	if(fp == NULL)
	{
		perror("TXT文件打开失败");
		return ;
	}
	while(1)
	{
		res = fscanf(fp,"%s",buf);
		strcpy(na,buf);
		res = fscanf(fp,"%s",buf1);
		strcpy(dyi,buf1);

		char sql[128] = "";
		//sprintf(sql,"insert into stumc values (%d,'%s',%.1f)",k1,s1,k3);
		sprintf(sql,"insert into stutxt1 values (\"%s\",\"%s\")",na,dyi);
		char *errmsg = NULL;
		if(sqlite3_exec(db,sql,NULL,NULL,&errmsg) != SQLITE_OK)
		{
			fprintf(stderr,"sqlite3_exec:%s %d __%d__\n",errmsg,sqlite3_errcode(db),__LINE__);
			return ;
		}


		if(res == EOF)
		{
			printf("文件读取完毕!\n");
			break;
		}

	}





	printf("数据插入表格<stutxt1>成功!\n");

	return ;
}
	





int main()
{
	//创建数据库
	sqlite3 *db = NULL;
	if(sqlite3_open("./my.db",&db) != SQLITE_OK)
	{
		fprintf(stderr,"库文件打开错误=>[错误消息:%s 错误码:%d] _%d_\n",\
				sqlite3_errmsg(db),sqlite3_errcode(db),__LINE__);
		return -1;
	}
	printf("库文件<my.db>打开成功!\n");

	//创建表格
	char sql[128] = "create table if not exists stutxt1 (单词 char,解释 float);";
	char *errmsg = NULL;
	if(sqlite3_exec(db,sql,NULL,NULL,&errmsg) != SQLITE_OK)
	{
		fprintf(stderr,"sqlite3_exec:%s %d __%d__\n",errmsg,sqlite3_errcode(db),__LINE__);
		return -1;
	}
	printf("库文件表格<stutxt1>创建成功!\n");

	char mo = 0;
	while(1)
	{
		printf("<------------------>\n");
		printf("<------1.插入------>\n");
		printf("<------2.删除------>\n");
		printf("<------3.修改------>\n");
		printf("<------4.查询------>\n");
		printf("<------5.退出------>\n");
		printf("<------------------>\n");

		printf("请按提示输入(1/2/3/4/5)==> ");
		mo = getchar();
		while(getchar() != 10);

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


END:
	//关闭数据库
	if(sqlite3_close(db) != SQLITE_OK)
	{
		fprintf(stderr,"库文件关闭错误=>[错误消息:%s 错误码:%d] _%d_\n",\
				sqlite3_errmsg(db),sqlite3_errcode(db),__LINE__);
		return -1;
	}
	printf("库文件<my.db>关闭成功!\n");


	return 0;
}
------------------------------------------------
库文件<my.db>打开成功!
库文件表格<stutxt1>创建成功!
<------------------>
<------1.插入------>
<------2.删除------>
<------3.修改------>
<------4.查询------>
<------5.退出------>
<------------------>
请按提示输入(1/2/3/4/5)==> 1
文件读取完毕!
数据插入表格<stutxt1>成功!
<------------------>
<------1.插入------>
<------2.删除------>
<------3.修改------>
<------4.查询------>
<------5.退出------>
<------------------>
请按提示输入(1/2/3/4/5)==> ^C