#include<stdio.h>
#include<string.h>
#include<stdlib.h>
#include<sqlite3.h>
int do_insert(sqlite3* db)
{
printf("请输入需要添加的id name score\n");
int id=0;
char name[20]="";
float score;
scanf("%d %s %f",&id,name,&score);
while(getchar()!=10);
char sql[128]="";
sprintf(sql,"insert into stu values( %d , '%s' ,%f)",id,name,score);
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("数据加入成功\n");
return 1;
}
int do_delete(sqlite3* db)
{
printf("请输入要删除的id:\n");
int id=0;
scanf("%d",&id);
while(getchar()!=10);
char sql[128]="";
sprintf(sql,"delete from stu where id=%d",id);
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("删除成功\n");
return 1;
}
int do_update(sqlite3* db)
{
printf("请输入要修改数据的id号和分数:\n");
int id=0;
float score;
scanf("%d %f",&id,&score);
while(getchar()!=10);
char sql[128]="";
sprintf(sql,"update stu set score = %f where id=%d",score,id);
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("修改成功\n");
return 1;
}
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 primary key ,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("*******************\n");
printf("*******1.插入******\n");
printf("*******2.删除******\n");
printf("*******3.修改******\n");
printf("*******4.查询******\n");
printf("*******5.退出******\n");
printf("*******************\n");
printf("请输入>>>>");
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();
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;
}
数据库的增删改
最新推荐文章于 2024-07-22 15:12:37 发布