ubuntu@ubuntu:~/wanglou$ gcc 1_sql.c -lsqlite3
ubuntu@ubuntu:~/wanglou$ ./a.out
sqlite3_open success
*******************************
**********1.插入***************
**********2.删除***************
**********3.修改***************
**********4.查询***************
**********5.退出***************
*******************************
请输入>>>>1
请输入id name core
123 zxc 45
123
insert into stu success
*******************************
**********1.插入***************
**********2.删除***************
**********3.修改***************
**********4.查询***************
**********5.退出***************
*******************************
请输入>>>>1
请输入id name core
2 asd 45
2
insert into stu success
*******************************
**********1.插入***************
**********2.删除***************
**********3.修改***************
**********4.查询***************
**********5.退出***************
*******************************
请输入>>>>2
请输入要删除的名字>>
asd
delete from stu success
*******************************
**********1.插入***************
**********2.删除***************
**********3.修改***************
**********4.查询***************
**********5.退出***************
*******************************
请输入>>>>3
请输入要修改的名字>>
zxc
请输入要新的名字>>
asd
update success
*******************************
**********1.插入***************
**********2.删除***************
**********3.修改***************
**********4.查询***************
**********5.退出***************
*******************************
请输入>>>>5
sqlite3_close success
ubuntu@ubuntu:~/wanglou$ cat 1_sql.c
#include<string.h>
#include<stdio.h>
#include<stdlib.h>
#include<sqlite3.h>
//插入
void do_insert(sqlite3 *db)
{
int id=0;
char name[28]="";
float core=0;
printf("请输入id name core\n");
scanf("%d %s %f",&id,name,&core);
printf("%d\n",id);
char sql[128]="";
sprintf(sql,"insert into stu values (%d,\"%s\",%f)",id,name,core);
char *errmsg=NULL;
if(sqlite3_exec(db,sql,NULL,NULL,&errmsg)!=SQLITE_OK)
{
printf("line:%d sqlite_exec falied errmsg=%s\n",__LINE__,errmsg);
return ;
}
printf("insert into stu success\n");
}
//删除
void do_delete(sqlite3 *db)
{
char name[28]="";
printf("请输入要删除的名字>>\n");
scanf("%s",name);
char sql[128]="";
sprintf(sql,"delete from stu where \"%s\" ",name);
char *errmsg=NULL;
if(sqlite3_exec(db,sql,NULL,NULL,&errmsg)!=SQLITE_OK)
{
printf("line:%d sqlite_exec falied errmsg=%s\n",__LINE__,errmsg);
return ;
}
printf("delete from stu success\n");
}
//修改
void do_update(sqlite3 *db)
{
char name[28]="";
char newname[28]="";
printf("请输入要修改的名字>>\n");
scanf("%s",name);
printf("请输入要新的名字>>\n");
scanf("%s",newname);
char sql[128]="";
sprintf(sql,"update stu set name= \"%s\" where name=\"%s\" ",newname,name);
char *errmsg=NULL;
if(sqlite3_exec(db,sql,NULL,NULL,&errmsg)!=SQLITE_OK)
{
printf("line:%d sqlite_exec falied errmsg=%s\n",__LINE__,errmsg);
return ;
}
printf("update success\n");
}
int main(int argc, const char *argv[])
{
sqlite3* db=NULL;
if(sqlite3_open("./1shuku.db",&db)!=SQLITE_OK)
{
printf("line:%d sqlite3_open:[%d] %s falied\n ",__LINE__,sqlite3_errcode(db),sqlite3_errmsg(db));
return -1;
}
printf("sqlite3_open success \n");
/* char sql[128]="create table stu (id int,name char,score float)";
char *errmsg=NULL;
if(sqlite3_exec(db,sql,NULL,NULL,&errmsg)!=SQLITE_OK)
{
printf("line:%d sqlite_exec falied errmsg=%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()!='\n');//收'\n'
switch(c)
{
case '1':
do_insert(db);
getchar();
break;
case '2':
do_delete(db);
getchar();
break;
case '3':
do_update(db);
getchar();
break;
case '4':
//do_select();
getchar();
break;
case '5':
goto END;
break;
default:
printf("输入错误,请重新输入\n");
}
}
END:
if(sqlite3_close(db)!=SQLITE_OK)
{
printf("line:%d sqlite3_close:[%d] %s falied\n ",__LINE__,sqlite3_errcode(db),sqlite3_errmsg(db));
return -1;
}
printf("sqlite3_close success\n");
db=NULL;
return 0;
}
4.25作业
最新推荐文章于 2024-10-17 18:58:27 发布