(未全部完成)
主函数
1 #include"head.h"
2
3 /*
4 flag = 0;//退出
5 flag = 1;//返回至主菜单
6 flag = 2;//返回上一层
7
8
9 */
10
11
12 void op_table(sqlite3 *db,int* flag);
13
14 void op_data(sqlite3 *db,int *flag);
15
16
17
18 int main(int argc, const char *argv[])
19 {
20
21 int num = -1;
22 int *flag = #
23 sqlite3 *db=NULL;
24 //创建数据库
25 if(sqlite3_open("./data.db",&db) != SQLITE_OK)
26 {
27 fprintf(stderr,"sqlite3_open :%s errcode:%d\n ",sqlite3_errmsg(db),sqlite3_errcode(db));
28 return -1;
29 }
30 printf("create table data sucess\n");
31
32 //创建表格
33 char sql[128] = "create table if not exists stu (id int,name char,score float);";
34 char *errmsg = NULL;
35 if(sqlite3_exec(db,sql,NULL,NULL,&errmsg) != SQLITE_OK)
36 {
37 fprintf(stderr,"line:%d sqlite3_exec:%s\n",__LINE__,errmsg);
38 return -1;
39 }
40
41 int c = -1;
42 while(1)
43 {
44 system("clear");
45 printf("---------------------------------\n");
46 printf("------------1.操作数据库---------\n");
47 printf("------------2.操作表格-----------\n");
48 printf("------------3.操作数据-----------\n");
49 printf("------------4.退出登录-----------\n");
50 printf("---------------------------------\n");
51 printf("请输入>>>\n");
52 c = getchar();
53 while(getchar() != 10);
54 switch(c)
55 {
56 case '1':
57 //op_sqlite3();
58 break;
59 case '2':
60 op_table(db,flag);
61 break;
62 case '3':
63 op_data(db,flag);
64 break;
65 case '4':
66 goto END;
67 break;
68 default:
69 printf("输入错误,请重新输入\n");
70 }
71 if(0 == flag)
72 goto END;
73 printf("请输入任意字符清屏\n");
74