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

《用C语言开发小型数据库管理系统代码》由会员分享，可在线阅读，更多相关《用C语言开发小型数据库管理系统代码（19页珍藏版）》请在装配图网上搜索。

1、#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(t

2、ttt* 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* * * * * * * * * *

3、* *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

4、* 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 *read

5、file() /*/ 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

6、 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+recordi.C; printf( nw= s= n= : ); get

7、char(); /*/ 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.name,&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,reco

8、rdj.name,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(st

9、ruct 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

10、(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(num0.name,filenameF); else strcpy(num0.name,filenameA); num0.num=i; fprintf(fp1,%s,%d,num0.name,num0.num); int ReadComputer2(FILE *fp1) int

11、j,k; fscanf(fp1,%s,%d,num0.name,&num0.num); k=num0.num; return(k);*/void Additive2Two(int i,FILE *fp1) /*/ char str2=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);

12、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,f

13、p1); /*(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.name,recordj.Number,recordj.Math,recordj.C,recordj.Amount); void Name_inquire() /*/ int j,time; char Name10; FILE

14、 *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,recordj.name)=0) printf(nName:%-10s Num:%3ld Math:%3d C:%3d Amount:%3dn,recordj.

15、name,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

16、=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=ReadComputer2Two(fp2); /*/ ReadComputer2(time,fp1); /*(2)*/ fclose(fp1)

17、;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,time; FILE *fp1,*fp2; fp1=readfile(); fp2=readfile2(); /*(*)*/ time=Re

18、adComputer2Two(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.name,recordj.Number,recordj.Math,recordj.C,recordj.Amount); /* * * */void Num_inquire_Del()

19、 /*/ 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:%

20、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 for(j=k;jtime;j+) recordj=recordj+1; time=time-1; fp1=foundfile(); /*/ SaveFile2(time,fp1); /*(2)*/ fp2=foundfile2(); /*/ Additive2Two(time,

21、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,

22、recordj.name,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.name,recordj

23、.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.name,recordj.Number,reco

24、rdj.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();

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

26、(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; SaveFile

27、2(temp1,fp); /*(2)*/ fclose(fp); ffp=readfile2(); /*/ 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)&(locati

28、on=1) DelMenu();location=2; printf(n 1 - 3 ():); while(ch=getchar()!=0) if(ch=1)&(location=2) getchar(); 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=2) MainMenu();location=1; printf(n 1 - 6 ():); break; if(ch=4)&(location=1) RankingMenu();location=3; printf(n 1 - 4 ():); while(ch=getchar()!=0) if(ch=1)&(location=3) getchar(); printf(ntt * - *n); printf(nt * y= n= * : ); if(ch=getchar()=y) /*/ else Inputfilena