作业要求:
1.思维导图
2.数据库编程
思维导图:
2.数据库编程
#include<myhead.h>
int do_add(sqlite3 *ppDb)
{
char sql[128] = "";
int numb=0,score=0;
char name[20]="";
char *errmsg=NULL;
printf("请输入学号:");
scanf("%d",&numb);
printf("请输入姓名:");
scanf("%s",name);
printf("请输入成绩:");
scanf("%d",&score);
sprintf(sql,"insert into Stu values(%d,\"%s\",%d);",numb,name,score);
if(sqlite3_exec(ppDb,sql,NULL,NULL,&errmsg)!=SQLITE_OK){
printf("exec error:%s\n",errmsg);
sqlite3_free(errmsg);
return -1;
}
return 0;
}
int do_update(sqlite3 *ppDb)
{
char sql[128] = "";
char wbuf[100]="";
char rbuf[100]="";
char *errmsg=NULL;
printf("请输入修改内容>>>");
scanf("%s",wbuf);
printf("请输入限制条件>>>");
scanf("%s",rbuf);
sprintf(sql,"uqdate from Stu set %s where %s",wbuf,rbuf);
if(sqlite3_exec(ppDb,sql,NULL,NULL,&errmsg)!=SQLITE_OK){
printf("exec error:%s\n",errmsg);
sqlite3_free(errmsg);
return -1;
}
return 0;
}
#if 1
int do_search(sqlite3 *ppDb){
char sql[128]="select * from Stu;";
char *errmsg=NULL;
char **retPtr = NULL;
int rows = 0;
int clos=0;
if(sqlite3_get_table(ppDb,sql,&retPtr,&rows,&clos,&errmsg)!=SQLITE_OK){
printf("get table error:%s\n",errmsg);
sqlite3_free(errmsg);
return -1;
}
for(int i=0;i<rows;i++){
for(int j =0;j<clos;j++){
printf("\t%s",*(retPtr+j+clos*i));
}
putchar(10);
}
sqlite3_free_table(retPtr);
return 0;
}
#endif
int main(int argc, const char *argv[])
{
//1、定义数据库句柄指针
sqlite3 *ppDb = NULL;
//2、打开(创建)数据库
if(sqlite3_open("./my.db", &ppDb) != SQLITE_OK)
{
fprintf(stderr, "sqlite3_open error:errmsg = %s, errcode = %d\n",\
sqlite3_errmsg(ppDb), sqlite3_errcode(ppDb));
return -1;
}
printf("sqlite3_open success\n");
//3、创建数据库表
//3.1 准备sql语句
char sql[128] = "create table if not exists Stu(numb int, name char, score double);";
//char *sql = "create table if not exists Stu(numb int, name char, score double);";
char *errmsg = NULL; //用于接收出错时的错误信息
//3.2 执行sql语句
if(sqlite3_exec(ppDb, sql, NULL, NULL, &errmsg) != SQLITE_OK)
{
printf("exec error:%s\n", errmsg);
return -1;
}
printf("create table Stu success\n");
//4、对数据表进行操作
int menu = -1;
while(1)
{
system("clear");
printf("\t\t============XXX 学生管理系统=============\n");
printf("\t\t============1、添加学生信息=============\n");
printf("\t\t============2、删除学生信息=============\n");
printf("\t\t============3、修改学生信息=============\n");
printf("\t\t============4、查找学生信息=============\n");
printf("\t\t============0、退出系统=============\n");
printf("请输入功能:");
scanf("%d", &menu);
getchar();
//对功能多分支选择
switch(menu)
{
case 1:
{
do_add(ppDb);
}
break;
case 2:
{
//do_delete(ppDb);
}
break;
case 3:
{
do_update(ppDb);
}
break;
case 4:
{
do_search(ppDb);
}
break;
case 0:sqlite3_close(ppDb);return 0;
default:printf("您输入的功能有误,请重新输入!!!!\n");
};
printf("请输入任意键,按回车清屏\n");
while(getchar() != '\n');
}
sqlite3_close(ppDb);
return 0;
}