《用C语言开发小型数据库管理系统代码文库.doc》由会员分享，可在线阅读，更多相关《用C语言开发小型数据库管理系统代码文库.doc（16页珍藏版）》请在课桌文档上搜索。
1、-用C语言开发小型数据库管理系统代码的文库.t*t如果有来生，要做一棵树，站成永恒，没有悲伤的姿势。一半在土里安详，一半在风里飞扬，一半洒落阴凉，一半沐浴，非常沉默非常骄傲，从不依靠从不寻找。*include *include typedef struct count /*保存记录条数构造体*/ char name10; int num;count;typedef struct st char name10; long Number; int Math; int C; int Amount;st;st record8;count num1; char filename10=0;char fil
2、ename210=0;int Inputnum8;void MainMenu() /*主菜单*/ printf(ntttt* * * * * * * * * *n); printf(tttt* 主菜单 *n); printf(tttt* 1. 创立新文件 *n); printf(tttt* 2. 添加记录 *n); printf(tttt* 3. 删除记录 *n); printf(tttt* 4. 排序 *n); printf(tttt* 5. 查询记录 *n); printf(tttt* 6. 退出 *n); printf(tttt* * * * * * * * * *n);void Del
3、Menu() /*删除菜单*/ printf(ntttt* * * * * * * * * * * *n); printf(tttt* 删除菜单 *n); printf(tttt* 1. *查询删除 *n); printf(tttt* 2. 返回到上级菜单 *n); printf(tttt* * * * * * * * * * * *n);void RankingMenu() /*排序菜单*/ printf(ntttt* * * * * * * * * * * *n); printf(tttt* 排序菜单 *n); printf(tttt* 1. 数学成绩排序 *n); printf(tttt
4、* 2. C语言成绩排序 *n); printf(tttt* 3. 总分排序 *n); printf(tttt* 4. 返回到上级菜单 *n); printf(tttt* * * * * * * * * * * *n);void InquireMenu() /*查讯菜单*/ printf(ntttt* * * * * * * * * * * *n); printf(tttt* 查讯菜单 *n); printf(tttt* 1. *查讯 *n); printf(tttt* 2. *查讯 *n); printf(tttt* 3. 数学成绩查讯 *n); printf(tttt* 4. C语言成绩查
5、讯 *n); printf(tttt* 5. 总分查讯 *n); printf(tttt* 6. 返回到上级菜单 *n); printf(tttt* * * * * * * * * * * *n);char Inputfilename() /*输入文件名同时产生付本文件名*/ char str2=B; printf(* 请输入文件名 * : ); scanf(%s,filename); getchar(); strcpy(filename2,filename); strcat(filename2,str2);FILE *readfile() /*读取文档*/ FILE *fp1; if(fp1
6、=fopen(filename,rb)=NULL) printf(n文件读取错误!n); fclose(fp1); return(fp1);FILE *foundfile() /*新建文档*/ FILE *fp1; if(fp1=fopen(filename,wb)=NULL) printf(n文件创立错误!n); fclose(fp1); return(fp1);FILE *savefile() /*追加文档*/ FILE *fp1; if(fp1=fopen(filename,ab)=NULL) printf(n文件追加错误!n); fclose(fp1); return(fp1);int
7、 InputSave() /*添加数据 */ int i=0,j; char ch=y; while(ch!=w) i=i+1; printf(n* 请输入*(字符型) * :); scanf(%s,recordi.name);Loop1: printf(n* 请输入*(长整型) * :); scanf(%ld,&recordi.Number); if(i!=1) for(j=1;j100|recordi.Math100|recordi.C0) printf(nt输入的分数不服合实际要求! 请重新录入!n); goto Loop3; recordi.Amount=recordi.Math+re
8、cordi.C; printf( nw=完毕录入 s=重新录入此条记录 n=下一条 : ); getchar(); /*吃掉上一个回车符*/ if(ch=getchar()=s) i=i-1; return(i);/*void Readputer(int i,FILE *fp1) (文本式)数据写入机器 int j; for(j=1;ji+1;j+) fscanf(fp1,%s,%ld,%d,%d,%d,recordj.name,&recordj.Number,&recordj.Math,&recordj.C,&recordj.Amount);void SaveFile(int i,FILE
9、*fp1) (文本式)数据写到文件中 int j; for(j=1;ji+1;j+) fprintf(fp1,%s,%ld,%d,%d,%d,recordj.name,recordj.Number,recordj.Math,recordj.C,recordj.Amount);*/ void Readputer2(int i,FILE *fp1) /*(2式)数据写入机器*/ int j; for(j=1;ji+1;j+) if(fread(&recordj,sizeof(struct st),1,fp1)!=1) printf(n主文件数据读取错误! n); fclose(fp1); void
10、 SaveFile2(int i,FILE *fp1) /*(2式)数据写到文件中*/ int j; for(j=1;ji+1;j+) if(fwrite(&recordj,sizeof(struct st),1,fp1)!=1) printf(n主文件数据写入错误! n); fclose(fp1); /* * * */FILE *readfile2() /*读文件付本*/ FILE *fp1; if(fp1=fopen(filename2,rb)=NULL) printf(n付本文件读取错误!n); fclose(fp1); return(fp1);FILE *foundfile2() /*
11、新建文件付本*/ FILE *fp1; if(fp1=fopen(filename2,wb)=NULL) printf(n付本文件创立错误!n); fclose(fp1); return(fp1);FILE *savefile2() /*追加文件付本*/ FILE *fp1; if(fp1=fopen(filename2,ab)=NULL) printf(n付本文件追加错误!n); fclose(fp1); return(fp1);/*void Additive2(int i,FILE *fp1) 数据与入付本文件文本式 int j; char str2=0; if(strcmp(filena
12、meF,str2)!=0) strcpy(num0.name,filenameF); else strcpy(num0.name,filenameA); num0.num=i; fprintf(fp1,%s,%d,num0.name,num0.num); int Readputer2(FILE *fp1) 读出付本中的数据文本式 int j,k; fscanf(fp1,%s,%d,num0.name,&num0.num); k=num0.num; return(k);*/void Additive2Two(int i,FILE *fp1) /*数据写入付本文件二进制式*/ char str2=
13、0; if(strcmp(filename2,str2)!=0) strcpy(num0.name,filename2); else strcpy(num0.name,filename2); num0.num=i; if(fwrite(&num0,sizeof(struct count),1,fp1)!=1) printf(n付本文件数据写入错误! n); fclose(fp1); int Readputer2Two(FILE *fp1) /*读出付本中的数据二进制式*/ int j; if(fread(&num0,sizeof(struct count),1,fp1)!=1) printf(
14、n付本文件数据读取错误! n); fclose(fp1); j=num0.num; return(j);/* * * */void Num_inquire() /*查询*/ int num,j,time; FILE *fp1,*fp2; fp1=readfile(); /*读取文档*/ fp2=readfile2(); /*(开打式读*引用读文件名)读文件付本*/ time=Readputer2Two(fp2); /*读出付本中的数据二进制式*/ Readputer2(time,fp1); /*(2式)数据写入机器*/ fclose(fp1);fclose(fp2); printf(输入*:)
15、; scanf(%ld,&num); /*getchar();*/ for(j=1;jtime+1;j+) if(recordj.Number=num) printf(nName:%-10s Num:%3ld Math:%3d C:%3d Amount:%3dn,recordj.name,recordj.Number,recordj.Math,recordj.C,recordj.Amount); void Name_inquire() /*查询*/ int j,time; char Name10; FILE *fp1,*fp2; fp1=readfile(); fp2=readfile2();
16、 /*(开打式读*引用读文件名)读文件付本*/ time=Readputer2Two(fp2); /*读出付本中的数据二进制式*/ Readputer2(time,fp1); /*(2式)数据写入机器*/ fclose(fp1);fclose(fp2); printf(输入*:); scanf(%s,Name); /*getchar();*/ for(j=1;jtime+1;j+) if(strcmp(Name,recordj.name)=0) printf(nName:%-10s Num:%3ld Math:%3d C:%3d Amount:%3dn,recordj.name,recordj
17、.Number,recordj.Math,recordj.C,recordj.Amount); void Math_inquire() /*数学查询*/ int Math,j,time; FILE *fp1,*fp2; fp1=readfile(); fp2=readfile2(); /*(开打式读*引用读文件名)读文件付本*/ time=Readputer2Two(fp2); /*读出付本中的数据二进制式*/ Readputer2(time,fp1); /*(2式)数据写入机器*/ fclose(fp1);fclose(fp2); printf(输入数学成绩:); scanf(%d,&Mat
18、h); /*getchar();*/ for(j=1;j=Math) printf(nName:%-10s Num:%3ld Math:%3d C:%3d Amount:%3dn,recordj.name,recordj.Number,recordj.Math,recordj.C,recordj.Amount); void C_inquire() /*C查询*/ int C,j,time; FILE *fp1,*fp2; fp1=readfile(); fp2=readfile2(); /*(开打式读*引用读文件名)读文件付本*/ time=Readputer2Two(fp2); /*读出付本
19、中的数据二进制式*/ Readputer2(time,fp1); /*(2式)数据写入机器*/ fclose(fp1);fclose(fp2); printf(输入C语言成绩:); scanf(%d,&C); /*getchar();*/ for(j=1;j=C) printf(nName:%-10s Num:%3ld Math:%3d C:%3d Amount:%3dn,recordj.name,recordj.Number,recordj.Math,recordj.C,recordj.Amount); void Amount_inquire() /*总分查询*/ int Amount,j,
20、time; FILE *fp1,*fp2; fp1=readfile(); fp2=readfile2(); /*(开打式读*引用读文件名)读文件付本*/ time=Readputer2Two(fp2); /*读出付本中的数据二进制式*/ Readputer2(time,fp1); /*(2式)数据写入机器*/ fclose(fp1);fclose(fp2); printf(输入总分:); scanf(%d,&Amount); /*getchar();*/ for(j=1;j=Amount) printf(nName:%-10s Num:%3ld Math:%3d C:%3d Amount:%
21、3dn,recordj.name,recordj.Number,recordj.Math,recordj.C,recordj.Amount); /* * * */void Num_inquire_Del() /*查询删除*/ char ch; int num,j,k,time; FILE *fp1,*fp2; fp1=readfile(); /*读取文档*/ fp2=readfile2(); /*读文件付本*/ time=Readputer2Two(fp2); /*读出付本中的数据二进制式*/ Readputer2(time,fp1); /*(2式)数据写入机器*/ fclose(fp1);f
22、close(fp2); printf(输入*:); scanf(%ld,&num); getchar(); for(j=1;j=time;j+) if(recordj.Number=num) printf(nName:%-10s Num:%3ld Math:%3d C:%3d Amount:%3dn,recordj.name,recordj.Number,recordj.Math,recordj.C,recordj.Amount); k=j; printf(nt* 删除=y 不删除=n * : ); if(ch=getchar()=y) if(k=time) time=time-1; else
23、 for(j=k;jtime;j+) recordj=recordj+1; time=time-1; fp1=foundfile(); /*新建文档*/ SaveFile2(time,fp1); /*(2式)数据写到文件中*/ fp2=foundfile2(); /*新建文件付本*/ Additive2Two(time,fp2); /*数据与入付本文件二进制式*/ printf(n删除成功!目前共有%d条记录!n,time); fclose(fp1);fclose(fp2); else printf(n没有执行删除操作!n); /* * * */void Math_ranking(int i)
24、 /*数学排序函数*/ int j,k; st time; for(j=1;ji;j+) for(k=1;krecordk+1.Math) time=recordk;recordk=recordk+1;recordk+1=time; printf(n); for(j=1;ji+1;j+) printf(nName:%-10s Num:%3ld Math:%3d C:%3d Amount:%3dn,recordj.name,recordj.Number,recordj.Math,recordj.C,recordj.Amount);void C_ranking(int i) /*C排序函数*/ i
25、nt j,k; st time; for(j=1;ji;j+) for(k=1;krecordk+1.C) time=recordk;recordk=recordk+1;recordk+1=time; printf(n); for(j=1;ji+1;j+) printf(nName:%-10s Num:%3ld Math:%3d C:%3d Amount:%3dn,recordj.name,recordj.Number,recordj.Math,recordj.C,recordj.Amount);void Amount_ranking(int i) /*总分排序函数*/ int j,k; st
26、 time; for(j=1;ji;j+) for(k=1;krecordk+1.Amount) time=recordk;recordk=recordk+1;recordk+1=time; printf(n); for(j=1;ji+1;j+) printf(nName:%-10s Num:%3ld Math:%3d C:%3d Amount:%3dn,recordj.name,recordj.Number,recordj.Math,recordj.C,recordj.Amount);/* * * */main() FILE *fp,*ffp; int temp1=0,temp2=0,tem
27、p3; char ch,location; MainMenu(); location=1; printf(n请输入选项 1 - 6 (当前在主菜单):); while(ch=getchar()!=0) if(ch=6)&(location=1) getchar(); printf(nnttt* Y=续继 n=退出 *n); printf(nnttINPUT:); if(ch=getchar()=n) printf(nnttt 您的使用!); e*it(); break; else MainMenu();location=1; printf(n请输入选项 1 - 6 (当前在主菜单):); if(ch=1)&(location=1) temp1=InputSave(); /*添加数据 */ getchar(
