用C语言开发小型数据库管理系统代码.doc

#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 filename210=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 DelMenu() /*/ 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* 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 *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=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 InputSave() /* */ int i=0,j; char ch=y; while(ch!=w) i=i+1; printf(n* () * :); scanf(%s,);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+recordi.C; printf( nw= s= n= : ); getchar(); /*/ if(ch=getchar()=s) i=i-1; return(i);/*void ReadComputer(int i,FILE *fp1) () int j; for(j=1;ji+1;j+) fscanf(fp1,%s,%ld,%d,%d,%d,,&recordj.Number,&recordj.Math,&recordj.C,&recordj.Amount);void SaveFile(int i,FILE *fp1) () int j; for(j=1;ji+1;j+) fprintf(fp1,%s,%ld,%d,%d,%d,,recordj.Number,recordj.Math,recordj.C,recordj.Amount);*/ void ReadComputer2(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 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() /*/ 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(filenameF,str2)!=0) strcpy(,filenameF); else strcpy(,filenameA); num0.num=i; fprintf(fp1,%s,%d,,num0.num); int ReadComputer2(FILE *fp1) int j,k; fscanf(fp1,%s,%d,,&num0.num); k=num0.num; return(k);*/void Additive2Two(int i,FILE *fp1) /*/ char str2=0; if(strcmp(filename2,str2)!=0) strcpy(,filename2); else strcpy(,filename2); num0.num=i; if(fwrite(&num0,sizeof(struct count),1,fp1)!=1) printf(n! n); fclose(fp1); int ReadComputer2Two(FILE *fp1) /*/ int j; if(fread(&num0,sizeof(struct count),1,fp1)!=1) printf(n! n); fclose(fp1); j=num0.num; return(j);/* * * */void Num_inquire() /*/ int num,j,time; FILE *fp1,*fp2; fp1=readfile(); /*/ fp2=readfile2(); /*(*)*/ time=ReadComputer2Two(fp2); /*/ ReadComputer2(time,fp1); /*(2)*/ fclose(fp1);fclose(fp2); printf(:); 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.Number,recordj.Math,recordj.C,recordj.Amount); void Name_inquire() /*/ int j,time; char Name10; FILE *fp1,*fp2; fp1=readfile(); fp2=readfile2(); /*(*)*/ time=ReadComputer2Two(fp2); /*/ ReadComputer2(time,fp1); /*(2)*/ fclose(fp1);fclose(fp2); printf(:); scanf(%s,Name); /*getchar();*/ for(j=1;jtime+1;j+) if(strcmp(Name,)=0) printf(nName:%-10s Num:%3ld Math:%3d C:%3d Amount:%3dn,,recordj.Number,recordj.Math,recordj.C,recordj.Amount); void Math_inquire() /*/ int Math,j,time; FILE *fp1,*fp2; fp1=readfile(); fp2=readfile2(); /*(*)*/ time=ReadComputer2Two(fp2); /*/ ReadComputer2(time,fp1); /*(2)*/ fclose(fp1);fclose(fp2); printf(:); scanf(%d,&Math); /*getchar();*/ for(j=1;j=Math) printf(nName:%-10s Num:%3ld Math:%3d C:%3d Amount:%3dn,,recordj.Number,recordj.Math,recordj.C,recordj.Amount); void C_inquire() /*C*/ int C,j,time; FILE *fp1,*fp2; fp1=readfile(); fp2=readfile2(); /*(*)*/ time=ReadComputer2Two(fp2); /*/ ReadComputer2(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.Number,recordj.Math,recordj.C,recordj.Amount); void Amount_inquire() /*/ int Amount,j,time; FILE *fp1,*fp2; fp1=readfile(); fp2=readfile2(); /*(*)*/ time=ReadComputer2Two(fp2); /*/ ReadComputer2(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:%3dn,,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=ReadComputer2Two(fp2); /*/ ReadComputer2(time,fp1); /*(2)*/ fclose(fp1);fclose(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.Number,recordj.Math,recordj.C,recordj.Amount); k=j; printf(nt* =y =n * : ); if(ch=getchar()=y) if(k=time) time=time-1; else 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) /*/ 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.Number,recordj.Math,recordj.C,recordj.Amount);void C_ranking(int i) /*C*/ int 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.Number,recordj.Math,recordj.C,recordj.Amount);void Amount_ranking(int i) /*/ int j,k; st 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.Number,recordj.Math,recordj.C,recordj.Amount);/* * * */main() FILE *fp,*ffp; int temp1=0,temp2=0,temp3; 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 !); exit(); break; else MainMenu();location=1; printf(n 1 - 6 ():); if(ch=1)&(location=1) temp1=InputSave(); /* */ getchar(); printf(tt* y= n= * : ); if(ch=getchar()=y) Inputfilename(); /*/ fp=foundfile(); /*/ SaveFile2(temp1,fp); /*(2)*/ fclose(fp); ffp=foundfile2(); /*()*/ Additive2Two(temp1,ffp); /*/ fclose(ffp); printf(%d!n,temp1); else printf(t !n); temp1=0;temp2=0; MainMenu();location=1; printf(n 1 - 6 ():); continue; if(ch=2)&(location=1) getchar(); printf(nt * y= n= * : ); if(ch=getchar()=y) fp=savefile(); /*/ else Inputfilename(); /*/ fp=savefile(); temp1=InputSave(); /* */ temp3=temp1