int main(int argc, const char *argv[])
{
ret = sqlite3_open("./test.db", &db);
if (ret != SQLITE_OK) {
fputs(sqlite3_errmsg(db), stderr);
fputs("\n", stderr);
exit(1);
}
//sql =
// sqlite3_mprintf
// ("create table student(id integer primary key,name text,gender text,age integer);");
//ret = sqlite3_exec(db, sql, 0, 0, &err);
while (1) {
printf("1.Display all records\n");
printf("2.Insert Record\n");
printf("3.Delete Record\n");
printf("4.Exit\n");
printf("Please Select[1-4]:");
int i;
scanf("%d", &i);
switch (i) {
case 1:
xianshi();
empty_cache();
break;
case 2:
charu();
empty_cache();
break;
case 3:
shanchu();
empty_cache();
break;
case 4:
exit(0);
break;
default:
empty_cache();
break;
}
}
if (ret != SQLITE_OK) {
fputs(err, stderr);
fputs("\n", stderr);
sqlite3_close(db);
exit(1);
}
sqlite3_close(db);
return 0;
}
int main()
{
sb();
printf("请选择菜单功能：");
scanf("%d",&u);
q=u; //主函数
while(q!=6)
{
if(q==1){shuru();}
if(q==2){shuchu();}
if(q==3){shanchu();}
if(q==4){charu();}
if(q==5){qingkong();}
scanf("%d",&q);
system("cls");
sb();
}
printf("感谢使用！\n");
return 0;
}
