完成数据库的增删查

最新推荐文章于 2024-11-15 18:38:47 发布

Hello Lu先生

最新推荐文章于 2024-11-15 18:38:47 发布

阅读量50

点赞数

文章标签：数据库 sqlite

本文链接：https://blog.csdn.net/m0_71186236/article/details/130375158

版权

#include<string.h>
#include<stdio.h>
#include<stdlib.h>
#include<sqlite3.h>
#include<fcntl.h>
#include<sys/stat.h>
#include<unistd.h>
#include<arpa/inet.h>

//插入数据
int do_insert(sqlite3* db)
{
	int id;
	char name[20];
	float score;
	char sql[128];
	char* errmsg = NULL;
	printf("请输入id：");
	scanf("%d",&id);
	printf("请输入姓名：");
	scanf("%s",name);
	printf("请输入分数：");
	scanf("%f",&score);

	sprintf(sql,"INSERT INTO stu VALUES(%d,\"%s\",%f);",id,name,score);

	if(sqlite3_exec(db,sql,NULL,NULL,&errmsg) != SQLITE_OK)
	{
		fprintf(stderr,"line:%d sqlite3_exec:%s\n",__LINE__,errmsg);
		return -1;
	}
	printf("插入成功\n");
}

//删除数据
int do_delete(sqlite3* db)
{
	int id;
	char sql[128] = "";
	char* errmsg = NULL;

	printf("请输入id：");
	scanf("%d",&id);

	sprintf(sql,"DELETE FROM stu WHERE id = %d;",id);
	if(sqlite3_exec(db,sql,NULL,NULL,&errmsg) != SQLITE_OK)
	{
		fprintf(stderr,"line:%d sqlite3_exec:%s\n",__LINE__,errmsg);
		return -1;
	}
	printf("删除成功\n");
}

//查询数据
int do_select(sqlite3* db)
{
	char sql[128] = "";
	char* errmsg = NULL;
	sprintf(sql,"SELECT * FROM stu ");
	if(sqlite3_exec(db,sql,NULL,NULL,&errmsg) != SQLITE_OK)
	{
		fprintf(stderr,"line:%d sqlite3_exec:%s\n",__LINE__,errmsg);
		return -1;
	}
	printf("查询成功\n");

}

int main(int argc, const char *argv[])
{
	//创建并打开数据库
	sqlite3* db = NULL;
	if(sqlite3_open("./my.db",&db) != SQLITE_OK)
	{
		printf("line:%d sqlite3_open:[%d] %s\n",__LINE__,sqlite3_errcode(db),sqlite3_errmsg(db));
		return -1;
	}
	printf("sqlite3_open success\n");
	
	//创建表格create table 表名（字段名 数据类型，字段名 数据类型）；
	//在数据库中怎么写，在c代码中就怎么写
	char sql[128] = "create table if not exists stu (id int ,name char, score float)";
	char* errmsg = NULL;

	if(sqlite3_exec(db,sql,NULL,NULL,&errmsg) != SQLITE_OK)
	{
		printf("line:%d sqlite3_exec:%s\n",__LINE__,errmsg);
		return -1;
	}
	printf("create table stu success\n");
	
	char c =0;
	while(1)
	{
		printf("\t*********************************\n");
		printf("\t************1. 插入**************\n");
		printf("\t************2. 删除**************\n");
		printf("\t************3. 修改**************\n");
		printf("\t************4. 查询**************\n");
		printf("\t************5. 退出**************\n");
		printf("\t*********************************\n");
		printf("\t请输入>>>");
		c = getchar();
		while(getchar() != 10);	

		switch(c)
		{
		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");
		}
	}

END:

	//释放数据库的内存空间
	if(sqlite3_close(db) != SQLITE_OK)
	{
		printf("line :%d sqlite3_close:%s\n",__LINE__,sqlite3_errmsg(db));
		return -1;
	}
	printf("sqlite3_close success\n");

	db = NULL;


	return 0;
}