8.17作业

最新推荐文章于 2024-06-13 09:00:30 发布

jvrm

最新推荐文章于 2024-06-13 09:00:30 发布

阅读量58

点赞数

文章标签：数据库 sqlite sql

本文链接：https://blog.csdn.net/jvrmz/article/details/126396005

版权

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

int do_insert(sqlite3* db, FILE* fp)
{
	//从文件中读数据
	char* res;
	char buf[100]="", word[50]="", mean[50]="";
	int count,i;

	char sql[99] = "";
	char* errmsg = NULL;

	while(1)
	{
		count = 0;
		bzero(buf, sizeof(buf));
		bzero(word, sizeof(word));
		bzero(mean, sizeof(mean));

		res=fgets(buf, sizeof(buf), fp);
		if(NULL == res)
			break;

		while(1)
		{
			if(buf[count] == ' ' && buf[count+1] == ' ')
			{
				for(i=0; i < count; i++)
				{
					word[i] = buf[i];
				}

				strcpy(mean, res+count+2);

				//将数据插入数据库
				sprintf(sql,"insert into stu values (\"%s\",\"%s\");", word, mean);
				if(sqlite3_exec(db, sql, NULL, NULL, &errmsg) != SQLITE_OK)
				{
					fprintf(stderr, "__%d__:sqlite3_exec:%s\n", __LINE__, errmsg);
					return -1;
				}
				break;
			}
			count++;
		}
	}
	return 0;
}

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

	//创建一个表格
	char* sql = "create table if not exists stu (word 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");

	//打开词典文件
	FILE* fp = fopen("dict.txt", "r");
	if(NULL == fp)
	{
		perror("fopen");
		return -1;
	}

	//插入数据到数据库
	do_insert(db, fp);

	//关闭文件描述符
	fclose(fp);

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

	return 0;