1. 完成插入、删除、修改(必须完成上交)
插入选择全字段插入、删除、修改选择用id的方式
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include<sqlite3.h>
void do_insert(sqlite3 * db);
void do_delete(sqlite3 * db);
void do_show(sqlite3 * db);
void do_update(sqlite3 * db);
int main(int argc, const char *argv[])
{
//创建并打开一个数据库
sqlite3* db = NULL;
if(sqlite3_open("./stu.db",&db)!=SQLITE_OK)
{
fprintf(stderr,"__%d__ sqlite3_open:%s\n",__LINE__,sqlite3_errmsg(db));
fprintf(stderr,"error_code:%d\n",sqlite3_errcode(db));
return -1;
}
printf("sqlite3_open success\n");
//创建一张表格
char sql[128] = "create table if not exists stu (english char,chinese char);";
char *errmsg = NULL;
if(sqlite3_exec(db,sql,NULL,NULL,&errmsg)!=SQLITE_OK)
{
fprintf(stderr,"--%d__ sqlite3_exec:%s\n",__LINE__,errmsg);
return -1;
}
char c = 0;
while(1)
{
printf(" __________________________ \n");
printf("| |\n");
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;
default:
printf("傻子,菜单中没有这个选项,重新输\n");
}
}
END:
if(sqlite3_close(db)!=SQLITE_OK)
{
fprintf(stderr,"__%d__ sqlite3_close:%s\n",__LINE__,sqlite3_errmsg(db));
fprintf(stderr,"error_code:%d\n",sqlite3_errcode(db));
return -1;
}
printf("sqlite3_close success\n");
return 0;
}
//插入
void do_insert(sqlite3 * db)
{
char eng[60]="";
char chi[68]="";
printf("请输入要添加的英文单词:");
fgets(eng,sizeof(eng),stdin);
printf("请输入中文翻译:");
fgets(chi,sizeof(chi),stdin);
char sql[128] ="";
sprintf(sql,"insert into stu values('%s','%s')",eng,chi);
char *errmsg = NULL;
if(sqlite3_exec(db,sql,NULL,NULL,&errmsg)!=SQLITE_OK)
{
fprintf(stderr,"--%d__ sqlite3:%s\n",__LINE__,errmsg);
return ;
}
}
//删除
void do_delete(sqlite3 * db)
{
char eng[60]="";
char chi[68]="";
printf("请输入要删除的英文单词:");
fgets(eng,sizeof(eng),stdin);
/* printf("请输入中文翻译:");
fgets(chi,sizeof(chi),stdin);*/
char sql[128] ="";
sprintf(sql,"delete from stu where english='%s'",eng);
char *errmsg = NULL;
if(sqlite3_exec(db,sql,NULL,NULL,&errmsg)!=SQLITE_OK)
{
fprintf(stderr,"--%d__ sqlite3:%s\n",__LINE__,errmsg);
return ;
}
}
//修改
void do_update(sqlite3 * db)
{
char eng[60]="";
char chi[68]="";
printf("请输入要修改的英文单词:");
fgets(eng,sizeof(eng),stdin);
printf("请输入修改后的中文翻译:");
fgets(chi,sizeof(chi),stdin);
char sql[128] ="";
sprintf(sql,"update stu set english='%s' where chinese='%s';",eng,chi);
char *errmsg = NULL;
if(sqlite3_exec(db,sql,NULL,NULL,&errmsg)!=SQLITE_OK)
{
fprintf(stderr,"--%d__ sqlite3:%s\n",__LINE__,errmsg);
return ;
}
}
//查询
void do_select()
{
}
功能测试