实现数据库的插入、删除、修改等功能

代码如下：

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

int do_insert(sqlite3 *db);
int do_delete(sqlite3 *db);
int do_update(sqlite3* db);

int main(int argc, const char *argv[])
{
    //创建并打开一个数据库
    sqlite3 * db = NULL;
    if(sqlite3_open("./sq.db",&db) !=SQLITE_OK)
    {
        fprintf(stderr,"sqlite3_open failed:%d:%s\n",sqlite3_errcode(db),sqlite3_errmsg(db));
    }
    printf("sqlite3_open success\n");

    //创建一张表格
    char sql[128] = "create table if not exists stu (id int,name cahr,score float);";
    char *errmsg = NULL;

    if(sqlite3_exec(db,sql,NULL,NULL,&errmsg)!=SQLITE_OK)
    {
        fprintf(stderr,"line:%d sqlite3_exec:%s\n",__LINE__,errmsg);
    }
    printf("table stu create 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();        //查询
            break;
        case '5':
            goto END;
            break;
        default:
            printf("输入错误，请重新输入\n");
        }

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

END:
    if(sqlite3_close(db)!=SQLITE_OK)
    {
        fprintf(stderr,"sqlite3_open failed:%d:%s\n",sqlite3_errcode(db),sqlite3_errmsg(db));
    }

    return 0;
}

int do_insert(sqlite3* db)
{
    //插入数据信息
    int id = 0;
    char name[20]="";
    float score = 0;

    printf("请输入id号>>");
    scanf("%d",&id);
    while(getchar()!=10);
    printf("请输入姓名>>");
    scanf("%s",name);
    while(getchar()!=10);
    printf("请输入分数>>");
    scanf("%f",&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)
    {
        fprintf(stderr,"line:%d sqlite3_exec:%s\n",__LINE__,errmsg);
    }
    printf("学生信息添加成功\n");

    return 0 ;
}

int do_delete(sqlite3*db)
{
    int id = 0;
    printf("请输入要删除的学生的id号>>>>");
    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)
    {
        fprintf(stderr,"line:%d sqlite3_exec:%s\n",__LINE__,errmsg);
    }
    printf("id为%d的学生信息删除成功\n",id);


    return 0;
}

int do_update(sqlite3*db)
{
    int id = 0;
    char name[20]="";
    float score = 0;
    char sql[128] = "";
    char sq[128] = "";

    char *errmsg = NULL;
    printf("请输入要修改学生的id号>>");
    scanf("%d",&id);
    while(getchar()!=10);

    char choose =0 ;
    while(1)
    {
        printf("------------------\n");
        printf("----1.修改姓名----\n");
        printf("----2.修改分数----\n");
        printf("----3.退出--------\n");
        printf("请输入>>>\n");
        choose = getchar();
        while(getchar()!=10);

        switch(choose)
        {
        case '1':
            printf("请输入新名字>>");
            scanf("%s",name);
            while(getchar()!=10);

            sprintf(sql,"update stu set name='%s' where id=%d;",name,id);
                        if(sqlite3_exec(db,sql,NULL,NULL,&errmsg)!=SQLITE_OK)
            {
                fprintf(stderr,"line:%d sqlite3_exec:%s\n",__LINE__,errmsg);
            }
            printf("id为%d的学生姓名修改成功\n",id);
            break;
        case '2':
            printf("请输入新分数>>");
            scanf("%f",&score);
            while(getchar()!=10);

            sprintf(sq,"update stu set score=%f where id=%d;",score,id);

            if(sqlite3_exec(db,sq,NULL,NULL,&errmsg)!=SQLITE_OK)
            {
                fprintf(stderr,"line:%d sqlite3_exec:%s\n",__LINE__,errmsg);
            }
            printf("id为%d的学生成绩修改成功\n",id);
            break;
        case '3':
            goto EEE;

        }
    }
EEE:
    return 0;
}

结果如下：