用sqlite3实现表的增删改查(个人学习记录)

本文链接：https://blog.csdn.net/LLL126345/article/details/134625389

1.主功能

void printf_init(sqlite3 *db)
{
   while(1)
   {
       printf("/***************************************************/\n");
       printf("/* 1.插入数据 2.删除数据 3.更新数据 4.查看表 5.退出*/\n");
       printf("/***************************************************/\n");
       printf("input data:");
       int cmd;
       scanf("%d",&cmd);
       getchar();
       if(cmd == 5)
       {
           sqlite3_close(db);
           exit(0);
       }
       switch(cmd)
       {
           case 1:insert_list(db);break;
           case 2:delete_list(db);break;
           case 3:update_list(db);break;
           case 4:select_list(db);break;
           default:printf("error\n");exit(0);
       }
   }
}

2.插入数据

void insert_list(sqlite3 *db)
{
   char sql[1024]={0};
   int id,age,ret;
   float score;
   char name[16]={0};
   char *errmsg;
   printf("input id:");
   scanf("%d",&id);
   getchar();
   printf("input name:");
   scanf("%s",name);
   getchar();
   printf("input age:");
   scanf("%d",&age);
   getchar();
   printf("input score:");
   scanf("%f",&score);
   getchar();

   sprintf(sql,"insert into stu values(%d,'%s',%d,%f);",id,name,age,score);
   ret = sqlite3_exec(db, sql,NULL,NULL,&errmsg);
   if(ret != 0)
   {
       printf("insert %s\n",errmsg);
   }else{
       //printf("insert success\n");
   }
}

3.删除数据

void delete_list(sqlite3 *db)
{
   int id,ret;
   char sql[1024]={0};
   char *errmsg;
   printf("input you want delete id:");
   scanf("%d",&id);
   getchar();
   ret = do_id(db,id);
   if(ret < 0)
   {
       return ;
   }
   sprintf(sql,"delete from stu where id = %d;",id);
   ret = sqlite3_exec(db, sql, NULL, NULL, &errmsg);