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

1、#include #include typedef struct count /*/char name10;int num;count;typedef struct stchar 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;pr

2、intf(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(ntt

3、tt* * * * * * * * * * * *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、 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=NULLprintf(n!n;fclose(fp1;return(fp1;FI

5、LE *foundfile( /*/FILE *fp1;if(fp1=fopen(filename,wb=NULLprintf(n!n;fclose(fp1;return(fp1;FILE *savefile( /*/FILE *fp1;if(fp1=fopen(filename,ab=NULLprintf(n!n;fclose(fp1;return(fp1;int InputSave( /* */int i=0,j;char ch=y;while(ch!=wi=i+1;printf(n* ( * :;scanf(%s,;Loop1: printf(n* ( * :;s

6、canf(%ld,&recordi.Number;if(i!=1for(j=1;j if(recordi.Number=recordj.Numberprintf(nt! ! %d%d!n,i,j;printf(nt!n;goto Loop1; Loop2: printf(n* ( * :;scanf(%d,&recordi.Math;if(recordi.Math100|recordi.Math100|recordi.C=Mathprintf(nName:%-10s Num:%3ld Math:%3d C:%3d Amount:%3dn,,recordj.Number,

7、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 if(recordj.C=Cprintf(nName:%-10s Num:%3ld Math:%3d

8、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

9、(j=1;j if(recordj.Amount=Amountprintf(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; /*/ReadCom

10、puter2(time,fp1; /*(2*/fclose(fp1;fclose(fp2;printf(:;scanf(%ld,#getchar(;for(j=1;j=time;j+if(recordj.Number=numprintf(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(=yif(k=timetime=time-1;else

11、 for(j=k;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;j for(k=1;krecordk+1.Mathtime=recordk;recordk=recor

12、dk+1;recordk+1=time;printf(n;for(j=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;j for(k=1;krecordk+1.Ctime=recordk;recordk=recordk+1;recordk+1=time;printf(n;for(j=1;j pri

13、ntf(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;j for(k=1;krecordk+1.Amounttime=recordk;recordk=recordk+1;recordk+1=time;printf(n;for(j=1;j printf(nName:%-10s Num:%3ld Math:%3d

14、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(!=0if(ch=6&(location=1getchar(;printf(nnttt* Y= n= *n;printf(nnttINPUT:;if(ch=getchar(=np

15、rintf(nnttt !;exit(;break;else MainMenu(;location=1;printf(n 1 - 6 (:;if(ch=1&(location=1temp1=InputSave(; /* */getchar(;printf(tt* y= n= * : ;if(ch=getchar(=yInputfilename(; /*/fp=foundfile(; /*/SaveFile2(temp1,fp; /*(2*/fclose(fp;ffp=foundfile2(; /*(*/Additive2Two(temp1,ffp; /*/fclose(ffp;printf(%

16、d!n,temp1;else printf(t !n;temp1=0;temp2=0;MainMenu(;location=1;printf(n 1 - 6 (:;continue;if(ch=2&(location=1getchar(; printf(nt * y= n= * : ;if(ch=getchar(=yfp=savefile(; /*/else Inputfilename(; /*/fp=savefile(;temp1=InputSave(; /* */temp3=temp1;SaveFile2(temp1,fp; /*(2*/fclose(fp;ffp=readfile2(;

17、/*/temp2=ReadComputer2Two(ffp; /*/fclose(ffp;temp1=temp1+temp2;ffp=foundfile2(; /*/Additive2Two(temp1,ffp; /*/fclose(ffp;printf(n%d!%d!n,temp3,temp1;temp1=0;temp2=0;MainMenu(;location=1;printf(n 1 - 6 (:;continue;if(ch=3&(location=1DelMenu(;location=2;printf(n 1 - 3 (:;while(ch=getchar(!=0if(ch=1&(l

18、ocation=2getchar(;printf(ntt * - *n;printf(nt * y= n= * : ;if(ch=getchar(=y /*/else Inputfilename(; /*/Num_inquire_Del(; /*/DelMenu(;location=2;printf(n 1 - 3 (:;continue;if(ch=2&(location=2MainMenu(;location=1;printf(n 1 - 6 (:;break;if(ch=4&(location=1RankingMenu(;location=3;printf(n 1 - 4 (:;whil

19、e(ch=getchar(!=0if(ch=1&(location=3getchar(;printf(ntt * - *n;printf(nt * y= n= * : ;if(ch=getchar(=y /*/else Inputfilename(;fp=readfile(; /*/ffp=readfile2(; /*(*/temp1=ReadComputer2Two(ffp; /*/ fclose(ffp;ReadComputer2(temp1,fp; /*(2*/fclose(fp;Math_ranking(temp1; /*/temp1=0;temp2=0;RankingMenu(;lo

20、cation=3;printf(n 1 - 4 (:;continue;if(ch=2&(location=3getchar(;printf(ntt * - C*n;printf(nt * y= n= * : ;if(ch=getchar(=y /*/else Inputfilename(;fp=readfile(; /*/ffp=readfile2(; /*(*/temp1=ReadComputer2Two(ffp; /*/fclose(ffp;ReadComputer2(temp1,fp; /*(2*/fclose(fp;C_ranking(temp1; /*/temp1=0;temp2=

21、0;RankingMenu(;location=3;printf(n 1 - 4 (:;continue;if(ch=3&(location=3getchar(;printf(ntt * - *n;printf(nt * y= n= * : ;if(ch=getchar(=y /*/else Inputfilename(;fp=readfile(; /*/ffp=readfile2(; /*(*/temp1=ReadComputer2Two(ffp; /*/fclose(ffp;ReadComputer2(temp1,fp; /*(2*/fclose(fp;Amount_ranking(tem

22、p1; /*/temp1=0;temp2=0;RankingMenu(;location=3;printf(n 1 - 4 (:;continue;if(ch=4&(location=3MainMenu(;location=1;printf(n 1 - 6 (:;break;if(ch=5&(location=1InquireMenu(;location=4;printf(n 1 - 6 (:;while(ch=getchar(!=0if(ch=1&(location=4getchar(;printf(ntt * - *n;printf(nt * y= n= * : ;if(ch=getchar(=y /*/else Inputfilename(;Num_inquire(; /*/InquireMenu(;location=4;printf(n 1 - 6 (:;continue;if(ch=2&(location=4getchar(;prin