华清远见上海心22071班 9.21作业

1.完成数据库的插入、删除、修改，插入选择全字段插入、删除、修改选择用id的方式

代码：

1.  
   #include <stdio.h>
2.  
   #include <sqlite3.h>
3.  
   #include <string.h>
4.  
   int do_insert(sqlite3*db);
5.  
   int do_delete(sqlite3*db);
6.  
   int do_update(sqlite3*db);
7.  
   int main(int argc, const char *argv[])
8.  
   {
9.  
   sqlite3* db=NULL;
10.  
    if(sqlite3_open("./stu.db",&db)!=SQLITE_OK)
11.  
    {
12.  
    fprintf(stderr,"__%d__ sqlite3_open:%s\n",__LINE__,sqlite3_errmsg(db));
13.  
    fprintf(stderr,"error_code:%d\n",sqlite3_errcode(db));
14.  
    return -1;
15.  
    }
16.  
    printf("sqlite3 open success\n");
17.  
    char sql[128]="create table if not exists stu (id int,name char,score float);";
18.  
    char *errmsg=NULL;
19.  
    if(sqlite3_exec(db,sql,NULL,NULL,&errmsg)!=SQLITE_OK)
20.  
    {
21.  
    fprintf(stderr, "__%d__ sqlite3_exec: %s\n", __LINE__, errmsg);
22.  
    return -1;
23.  
    }
24.  
    printf("create table stu success\n");
25.  
    char c=0;
26.  
    while(1)
27.  
    {
28.  
    printf("--------------------------\n");
29.  
    printf("----------1.插入----------\n");
30.  
    printf("----------2.删除----------\n");
31.  
    printf("----------3.修改----------\n");
32.  
    printf("----------4.查询----------\n");
33.  
    printf("----------5.退出----------\n");
34.  
    printf("--------------------------\n");
35.  
     
36.  
    printf("请输入>>>");
37.  
    c=getchar();
38.  
    while(getchar()!=10);
39.  
    switch(c)
40.  
    {
41.  
    case '1':
42.  
    do_insert(db);
43.  
    break;
44.  
    case '2':
45.  
    do_delete(db);
46.  
    break;
47.  
    case '3':
48.  
    do_update(db);
49.  
    break;
50.  
    case '4':
51.  
    //do_select();
52.  
    break;
53.  
    case '5':
54.  
    goto END;
55.  
    default:
56.  
    printf("输入错误请重新输入");
57.  
    }
58.  
    }
59.  
    END:
60.  
    if(sqlite3_close(db)!=SQLITE_OK)
61.  
    {
62.  
    fprintf(stderr,"__%d__ sqlite3_close:%s\n",__LINE__,sqlite3_errmsg(db));
63.  
    fprintf(stderr,"error_code:%d\n",sqlite3_errcode(db));
64.  
    return -1;
65.  
    }
66.  
    printf("sqlite3 close success\n");
67.  
    return 0;
68.  
    }
69.  
    int do_insert(sqlite3*db)
70.  
    {
71.  
    int id_num;
72.  
    char name[20];
73.  
    float score;
74.  
    char sql[128]="";
75.  
    printf("请输入学号:");
76.  
    scanf("%d",&id_num);
77.  
    while(getchar()!=10);
78.  
    printf("请输入学生姓名:");
79.  
    fgets(name,sizeof(name),stdin);
80.  
    name[strlen(sql)-1]=0;
81.  
    printf("请输入学生成绩:");
82.  
    scanf("%f",&score);
83.  
    while(getchar()!=10);
84.  
    char*errmsg=NULL;
85.  
    sprintf(sql,"insert into stu values (%d,'%s',%f);",id_num,name,score);
86.  
    if(sqlite3_exec(db,sql,NULL,NULL,&errmsg)!=SQLITE_OK)
87.  
    {
88.  
    fprintf(stderr,"__%d__ sqlite3_close:%s\n",__LINE__,errmsg);
89.  
    return -1;
90.  
    }
91.  
    printf("插入完成\n");
92.  
    }
93.  
    int do_delete(sqlite3 *db)
94.  
    {
95.  
    int id_num;
96.  
    printf("请输入要删除的学生学号:");
97.  
    scanf("%d",&id_num);
98.  
    while(getchar()!=10);
99.  
    char *errmsg=NULL;
100.  
     char sql[128]="";
101.  
     sprintf(sql,"delete from stu where id=%d",id_num);
102.  
     if(sqlite3_exec(db,sql,NULL,NULL,&errmsg)!=SQLITE_OK)
103.  
     {
104.  
     fprintf(stderr,"__%d__ sqlite3_close:%s\n",__LINE__,errmsg);
105.  
     return -1;
106.  
     }
107.  
     printf("删除成功\n");
108.  
     }
109.  
     int do_update(sqlite3*db)
110.  
     {
111.  
     int id_num;
112.  
     char name[20];
113.  
     float score;
114.  
     char *errmsg=NULL;
115.  
     char sql[128]="";
116.  
     printf("请输入要修改的学生学号:");
117.  
     scanf("%d",&id_num);
118.  
     while(getchar()!=10);
119.  
     while(1)
120.  
     {
121.  
     char c=0;
122.  
     printf("想要修改学号请按1,想修改姓名请按2,想修改成绩请按3:");
123.  
     c=getchar();
124.  
     while(getchar()!=10);
125.  
     switch(c)
126.  
     {
127.  
     case '1':printf("请输入新学号:");
128.  
     scanf("%d",&id_num);
129.  
     sprintf(sql,"update stu set id=%d where id=%d",id_num,id_num);
130.  
     goto END;
131.  
     case '2':printf("请输入新的学生姓名:");
132.  
     fgets(name,sizeof(name),stdin);
133.  
     name[strlen(name)-1]=0;
134.  
     sprintf(sql,"update stu set name='%s' where id=%d",name,id_num);
135.  
     goto END;
136.  
     case '3':printf("请输入新成绩:");
137.  
     scanf("%f",&score);
138.  
     sprintf(sql,"update stu set score=%f where id=%d",score,id_num);
139.  
     goto END;
140.  
     default:printf("输入错误，没有该学号的学生\n");
141.  
     }
142.  
     }
143.  
     END:
144.  
     if(sqlite3_exec(db,sql,NULL,NULL,&errmsg)!=SQLITE_OK)
145.  
     {
146.  
     fprintf(stderr,"__%d__ sqlite3_close:%s\n",__LINE__,errmsg);
147.  
     return -1;
148.  
     }
149.  
     printf("修改完成\n");
150.  
     }

终端：

这篇好文章是转载于：学新通技术网