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

1、用C语言开发小型数据库管理系统代码的文库.txt如果有来生，要做一棵树，站成永恒，没有悲伤的姿势。一半在土里安详，一半在风里飞扬，一半洒落阴凉，一半沐浴阳光，非常沉默非常骄傲，从不依靠从不寻找。#include <stdio.h>#include <string.h>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

2、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"); p

3、rintf("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"

4、;); 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(&quo

5、t;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&q

6、uot;); 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("* 请输入文件

7、名 * : "); 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(fil

8、ename,"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')

9、 i=i+1; printf("n* 请输入姓名(字符型) * :"); scanf("%s",);Loop1: printf("n* 请输入学号(长整型) * :"); scanf("%ld",&recordi.Number); if(i!=1) for(j=1;j<i;j+) if(recordi.Number=recordj.Number) printf("nt警告! 输入了二个同样的学号! 第%d条和第%d学号相同!n",i,j); printf(&

10、quot;nt请重新输入!n"); goto Loop1; Loop2: printf("n* 请输入数学成绩(整型) * :"); scanf("%d",&recordi.Math); if(recordi.Math>100|recordi.Math<0) printf("nt输入的分数不服合实际要求! 请重新录入!n"); goto Loop2; Loop3: printf("n* 请输入C语言成绩(整型) * :"); scanf("%d",&reco

11、rdi.C); if(recordi.C>100|recordi.C<0) printf("nt输入的分数不服合实际要求! 请重新录入!n"); goto Loop3; recordi.Amount=recordi.Math+recordi.C; printf(" n'w'=结束录入 's'=重新录入此条记录 'n'=下一条 : "); getchar(); /*吃掉上一个回车符*/ if(ch=getchar()='s') i=i-1; return(i);/*void Rea

12、dComputer(int i,FILE *fp1) (文本方式)数据写入机器 int j; for(j=1;j<i+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;j<i+1;j+) fprintf(fp1,"%s,%ld,%d,%d,%d

13、",,recordj.Number,recordj.Math,recordj.C,recordj.Amount);*/ void ReadComputer2(int i,FILE *fp1) /*(2方式)数据写入机器*/ int j; for(j=1;j<i+1;j+) if(fread(&recordj,sizeof(struct st),1,fp1)!=1) printf("n主文件数据读取错误! n"); fclose(fp1); void SaveFile2(int i,FILE *fp1) /*(2方式)数据写到文

14、件中*/ int j; for(j=1;j<i+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

15、() /*新建文件付本*/ 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 *

16、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",,&

17、amp;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付本文件数据写入错误!

18、 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(); /*读取文档*/ f

19、p2=readfile2(); /*(开打方式'读'*'引用读文件名')读文件付本*/ time=ReadComputer2Two(fp2); /*读出付本中的数据（二进制方式）*/ ReadComputer2(time,fp1); /*(2方式)数据写入机器*/ fclose(fp1);fclose(fp2); printf("输入学号:"); scanf("%ld",&num); /*getchar();*/ for(j=1;j<time+1;j+) if(recordj.Number=num) prin

20、tf("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(

21、fp2); /*读出付本中的数据（二进制方式）*/ ReadComputer2(time,fp1); /*(2方式)数据写入机器*/ fclose(fp1);fclose(fp2); printf("输入姓名:"); scanf("%s",Name); /*getchar();*/ for(j=1;j<time+1;j+) if(strcmp(Name,)=0) printf("nName:%-10s Num:%3ld Math:%3d C:%3d Amount:%3dn",,re

22、cordj.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(

23、fp2); printf("输入数学成绩:"); scanf("%d",&Math); /*getchar();*/ for(j=1;j<time+1;j+) if(recordj.Math>=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

24、,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&l

25、t;time+1;j+) if(recordj.C>=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(); /*(开打方式'读'*'引用读文件名

26、9;)读文件付本*/ time=ReadComputer2Two(fp2); /*读出付本中的数据（二进制方式）*/ ReadComputer2(time,fp1); /*(2方式)数据写入机器*/ fclose(fp1);fclose(fp2); printf("输入总分:"); scanf("%d",&Amount); /*getchar();*/ for(j=1;j<time+1;j+) if(recordj.Amount>=Amount) printf("nName:%-10s Num:%3ld Math:%3d C

27、:%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)

28、; /*(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;

29、printf("nt* 删除='y' 不删除='n' * : "); if(ch=getchar()='y') if(k=time) time=time-1; else for(j=k;j<time;j+) recordj=recordj+1; time=time-1; fp1=foundfile(); /*新建文档*/ SaveFile2(time,fp1); /*(2方式)数据写到文件中*/ fp2=foundfile2(); /*新建文件付本*/ Additive2Two(time,fp2); /*数据与入付本文件

30、（二进制方式）*/ 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<i;j+) for(k=1;k<=i-j;k+) if(recordk.Math>recordk+1.Math) time=recordk;recordk=recordk+1;recordk+1=tim

31、e; printf("n"); for(j=1;j<i+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<i;j+) for(k=1;k<=i-j;k+) if(recordk.C>recordk+1.C)

32、 time=recordk;recordk=recordk+1;recordk+1=time; printf("n"); for(j=1;j<i+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;j<i;j+)

33、 for(k=1;k<=i-j;k+) if(recordk.Amount>recordk+1.Amount) time=recordk;recordk=recordk+1;recordk+1=time; printf("n"); for(j=1;j<i+1;j+) printf("nName:%-10s Num:%3ld Math:%3d C:%3d Amount:%3dn",,recordj.Number,recordj.Math,recordj.C,recordj.Amount);/* * * */main

34、() 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"); prin

35、tf("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* '

36、;y'=保存 'n'=不保存 * : "); if(ch=getchar()='y') Inputfilename(); /*输入文件名同时产生付本文件名*/ fp=foundfile(); /*新建文档*/ SaveFile2(temp1,fp); /*(2方式)数据写到文件中*/ fclose(fp); ffp=foundfile2(); /*(开打方式'新建')新建文件付本*/ Additive2Two(temp1,ffp); /*新建付本文件数据（文本方式）*/ fclose(ffp); printf("保存了

37、%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=ge

38、tchar()='y') fp=savefile(); /*追加文档*/ else Inputfilename(); /*输入文件名同时产生付本文件名*/ fp=savefile(); temp1=InputSave(); /*添加数据 */ temp3=temp1; SaveFile2(temp1,fp); /*(2方式)数据写到文件中*/ fclose(fp); ffp=readfile2(); /*读文件付本*/ temp2=ReadComputer2Two(ffp); /*读出付本中的数据（文本方式）*/ fclose(ffp); temp1=temp1+temp2;

39、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='1') DelMenu();location='2' printf("n请输入选项 1 - 3 (当前在删除菜单):"); while(ch=getchar()!='0') if(ch='1')&&(location='2') getchar(); printf("ntt *现在位置在删除菜单 - 学号删除*n"); printf("nt *