用C語(yǔ)言開(kāi)發(fā)小型數(shù)據(jù)庫(kù)管理系統(tǒng)代碼文庫(kù)

1、用C語(yǔ)言開(kāi)發(fā)小型數(shù)據(jù)庫(kù)管理系統(tǒng)代碼文庫(kù).txt如果有來(lái)生，要做一棵樹(shù)，站成永恒，沒(méi)有悲傷的姿勢(shì)。一半在土里安詳，一半在風(fēng)里飛揚(yáng)，一半灑落陰涼，一半沐浴陽(yáng)光，非常沉默非常驕傲，從不依靠從不尋找。#include #include typedef struct count /*保存記錄條數(shù)結(jié)構(gòu)體*/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

2、 filename210="0"int Inputnum8;void MainMenu( /*主菜單*/printf("ntttt* * * * * * * * * *n"printf("tttt* 主菜單 *n"printf("tttt* 1. 創(chuàng)建新文件 *n"printf("tttt* 2. 添加記錄 *n"printf("tttt* 3. 刪除記錄 *n"printf("tttt* 4. 排序 *n"printf("tttt* 5. 查詢(xún)

3、記錄 *n"printf("tttt* 6. 退出 *n"printf("tttt* * * * * * * * * *n"void DelMenu( /*刪除菜單*/printf("ntttt* * * * * * * * * * * *n"printf("tttt* 刪除菜單 *n"printf("tttt* 1. 學(xué)號(hào)查詢(xún)刪除 *n"printf("tttt* 2. 返回到上級(jí)菜單 *n"printf("tttt* * * * * * * * * *

4、 * *n"void RankingMenu( /*排序菜單*/printf("ntttt* * * * * * * * * * * *n"printf("tttt* 排序菜單 *n"printf("tttt* 1. 數(shù)學(xué)成績(jī)排序 *n"printf("tttt* 2. C語(yǔ)言成績(jī)排序 *n"printf("tttt* 3. 總分排序 *n"printf("tttt* 4. 返回到上級(jí)菜單 *n"printf("tttt* * * * * * * * *

5、* * *n"void InquireMenu( /*查訊菜單*/printf("ntttt* * * * * * * * * * * *n"printf("tttt* 查訊菜單 *n"printf("tttt* 1. 學(xué)號(hào)查訊 *n"printf("tttt* 2. 姓名查訊 *n"printf("tttt* 3. 數(shù)學(xué)成績(jī)查訊 *n"printf("tttt* 4. C語(yǔ)言成績(jī)查訊 *n"printf("tttt* 5. 總分查訊 *n"pr

6、intf("tttt* 6. 返回到上級(jí)菜單 *n"printf("tttt* * * * * * * * * * * *n"char Inputfilename( /*輸入文件名同時(shí)產(chǎn)生付本文件名*/char str2="B"printf("* 請(qǐng)輸入文件名 * : "scanf("%s",filename;getchar(;strcpy(filename2,filename;strcat(filename2,str2;FILE *readfile( /*讀取文檔*/FILE *fp1;if(

7、fp1=fopen(filename,"rb"=NULLprintf("n文件讀取錯(cuò)誤!n"fclose(fp1;return(fp1;FILE *foundfile( /*新建文檔*/FILE *fp1;if(fp1=fopen(filename,"wb"=NULLprintf("n文件創(chuàng)建錯(cuò)誤!n"fclose(fp1;return(fp1;FILE *savefile( /*追加文檔*/FILE *fp1;if(fp1=fopen(filename,"ab"=NULLprintf(&quo

8、t;n文件追加錯(cuò)誤!n"fclose(fp1;return(fp1;int InputSave( /*添加數(shù)據(jù) */int i=0,j;char ch='y'while(ch!='w'i=i+1;printf("n* 請(qǐng)輸入姓名(字符型 * :"scanf("%s",;Loop1: printf("n* 請(qǐng)輸入學(xué)號(hào)(長(zhǎng)整型 * :"scanf("%ld",&recordi.Number;if(i!=1for(j=1;j if(recordi.

9、Number=recordj.Numberprintf("nt警告! 輸入了二個(gè)同樣的學(xué)號(hào)! 第%d條和第%d學(xué)號(hào)相同!n",i,j;printf("nt請(qǐng)重新輸入!n"goto Loop1; Loop2: printf("n* 請(qǐng)輸入數(shù)學(xué)成績(jī)(整型 * :"scanf("%d",&recordi.Math;if(recordi.Math>100|recordi.Math<0printf("nt輸入的分?jǐn)?shù)不服合實(shí)際要求! 請(qǐng)重新錄入!n"goto Loop2;Loop3: p

10、rintf("n* 請(qǐng)輸入C語(yǔ)言成績(jī)(整型 * :"scanf("%d",&recordi.C;if(recordi.C>100|recordi.C<0printf("nt輸入的分?jǐn)?shù)不服合實(shí)際要求! 請(qǐng)重新錄入!n"goto Loop3;recordi.Amount=recordi.Math+recordi.C;printf(" n'w'=結(jié)束錄入 's'=重新錄入此條記錄 'n'=下一條 : "getchar(; /*吃掉上一個(gè)回車(chē)符*/if(c

11、h=getchar(='s'i=i-1;return(i;/*void ReadComputer(int i,FILE *fp1 (文本方式數(shù)據(jù)寫(xiě)入機(jī)器int j;for(j=1;j fscanf(fp1,"%s,%ld,%d,%d,%d",,&recordj.Number,&recordj.Math,&recordj.C,&recordj.Amount;void SaveFile(int i,FILE *fp1 (文本方式數(shù)據(jù)寫(xiě)到文件中int j;for(j=1;j fprintf(fp1,"

12、;%s,%ld,%d,%d,%d",,recordj.Number,recordj.Math,recordj.C,recordj.Amount;*/ void ReadComputer2(int i,FILE *fp1 /*(2方式數(shù)據(jù)寫(xiě)入機(jī)器*/int j;for(j=1;j if(fread(&recordj,sizeof(struct st,1,fp1!=1printf("n主文件數(shù)據(jù)讀取錯(cuò)誤! n"fclose(fp1;void SaveFile2(int i,FILE *fp1 /*(2方式數(shù)據(jù)寫(xiě)到文件中*/int j;f

13、or(j=1;j if(fwrite(&recordj,sizeof(struct st,1,fp1!=1printf("n主文件數(shù)據(jù)寫(xiě)入錯(cuò)誤! n"fclose(fp1;/* * * */FILE *readfile2( /*讀文件付本*/FILE *fp1;if(fp1=fopen(filename2,"rb"=NULLprintf("n付本文件讀取錯(cuò)誤!n"fclose(fp1;return(fp1;FILE *foundfile2( /*新建文件付本*/FILE *fp1;if(fp1=fopen(filename2,

14、"wb"=NULLprintf("n付本文件創(chuàng)建錯(cuò)誤!n"fclose(fp1;return(fp1;FILE *savefile2( /*追加文件付本*/FILE *fp1;if(fp1=fopen(filename2,"ab"=NULLprintf("n付本文件追加錯(cuò)誤!n"fclose(fp1;return(fp1;/*void Additive2(int i,FILE *fp1 數(shù)據(jù)與入付本文件（文本方式）int j;char str2="0"if(strcmp(filenameF,st

15、r2!=0strcpy(,filenameF;elsestrcpy(,filenameA;num0.num=i;fprintf(fp1,"%s,%d",,num0.num;int ReadComputer2(FILE *fp1 讀出付本中的數(shù)據(jù)（文本方式）int j,k;fscanf(fp1,"%s,%d",,&num0.num;k=num0.num;return(k;*/void Additive2Two(int i,FILE *fp1 /*數(shù)據(jù)寫(xiě)入付本文件（二進(jìn)制方式）*

16、/char str2="0"if(strcmp(filename2,str2!=0strcpy(,filename2;elsestrcpy(,filename2;num0.num=i;if(fwrite(&num0,sizeof(struct count,1,fp1!=1printf("n付本文件數(shù)據(jù)寫(xiě)入錯(cuò)誤! n"fclose(fp1;int ReadComputer2Two(FILE *fp1 /*讀出付本中的數(shù)據(jù)（二進(jìn)制方式）*/int j;if(fread(&num0,sizeof(struct

17、 count,1,fp1!=1printf("n付本文件數(shù)據(jù)讀取錯(cuò)誤! n"fclose(fp1;j=num0.num;return(j;/* * * */void Num_inquire( /*學(xué)號(hào)查詢(xún)*/int num,j,time;FILE *fp1,*fp2;fp1=readfile(; /*讀取文檔*/fp2=readfile2(; /*(開(kāi)打方式'讀'*'引用讀文件名'讀文件付本*/time=ReadComputer2Two(fp2; /*讀出付本中的數(shù)據(jù)（二進(jìn)制方式）*/ReadComputer2(time,fp1; /*(2方

18、式數(shù)據(jù)寫(xiě)入機(jī)器*/fclose(fp1;fclose(fp2;printf("輸入學(xué)號(hào):"scanf("%ld",#/*getchar(;*/for(j=1;j if(recordj.Number=numprintf("nName:%-10s Num:%3ld Math:%3d C:%3d Amount:%3dn",,recordj.Number,recordj.Math,recordj.C,recordj.Amount;void Name_inquire( /*姓名查詢(xún)*/int j,time;char Na

19、me10;FILE *fp1,*fp2;fp1=readfile(;fp2=readfile2(; /*(開(kāi)打方式'讀'*'引用讀文件名'讀文件付本*/time=ReadComputer2Two(fp2; /*讀出付本中的數(shù)據(jù)（二進(jìn)制方式）*/ReadComputer2(time,fp1; /*(2方式數(shù)據(jù)寫(xiě)入機(jī)器*/fclose(fp1;fclose(fp2;printf("輸入姓名:"scanf("%s",Name;/*getchar(;*/for(j=1;j if(strcmp(Name,=0

20、printf("nName:%-10s Num:%3ld Math:%3d C:%3d Amount:%3dn",,recordj.Number,recordj.Math,recordj.C,recordj.Amount;void Math_inquire( /*數(shù)學(xué)查詢(xún)*/int Math,j,time;FILE *fp1,*fp2;fp1=readfile(;fp2=readfile2(; /*(開(kāi)打方式'讀'*'引用讀文件名'讀文件付本*/time=ReadComputer2Two(fp2; /*讀出付本中的數(shù)據(jù)

21、（二進(jìn)制方式）*/ReadComputer2(time,fp1; /*(2方式數(shù)據(jù)寫(xiě)入機(jī)器*/fclose(fp1;fclose(fp2;printf("輸入數(shù)學(xué)成績(jī):"scanf("%d",&Math;/*getchar(;*/for(j=1;j if(recordj.Math>=Mathprintf("nName:%-10s Num:%3ld Math:%3d C:%3d Amount:%3dn",,recordj.Number,recordj.Math,recordj.C,recordj.A

22、mount;void C_inquire( /*C查詢(xún)*/int C,j,time;FILE *fp1,*fp2;fp1=readfile(;fp2=readfile2(; /*(開(kāi)打方式'讀'*'引用讀文件名'讀文件付本*/time=ReadComputer2Two(fp2; /*讀出付本中的數(shù)據(jù)（二進(jìn)制方式）*/ReadComputer2(time,fp1; /*(2方式數(shù)據(jù)寫(xiě)入機(jī)器*/fclose(fp1;fclose(fp2;printf("輸入C語(yǔ)言成績(jī):"scanf("%d",&C;/*getchar(

23、;*/for(j=1;j if(recordj.C>=Cprintf("nName:%-10s Num:%3ld Math:%3d C:%3d Amount:%3dn",,recordj.Number,recordj.Math,recordj.C,recordj.Amount;void Amount_inquire( /*總分查詢(xún)*/int Amount,j,time;FILE *fp1,*fp2;fp1=readfile(;fp2=readfile2(; /*(開(kāi)打方式'讀'*'引用讀文件名'讀文件付本*/ti

24、me=ReadComputer2Two(fp2; /*讀出付本中的數(shù)據(jù)（二進(jìn)制方式）*/ReadComputer2(time,fp1; /*(2方式數(shù)據(jù)寫(xiě)入機(jī)器*/fclose(fp1;fclose(fp2;printf("輸入總分:"scanf("%d",&Amount;/*getchar(;*/for(j=1;j if(recordj.Amount>=Amountprintf("nName:%-10s Num:%3ld Math:%3d C:%3d Amount:%3dn",,recordj.

25、Number,recordj.Math,recordj.C,recordj.Amount;/* * * */void Num_inquire_Del( /*學(xué)號(hào)查詢(xún)刪除*/char ch;int num,j,k,time;FILE *fp1,*fp2;fp1=readfile(; /*讀取文檔*/fp2=readfile2(; /*讀文件付本*/time=ReadComputer2Two(fp2; /*讀出付本中的數(shù)據(jù)（二進(jìn)制方式）*/ReadComputer2(time,fp1; /*(2方式數(shù)據(jù)寫(xiě)入機(jī)器*/fclose(fp1;fclose(fp2;printf("輸入學(xué)號(hào):&q

26、uot;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(='y'i

27、f(k=timetime=time-1;else for(j=k;j recordj=recordj+1;time=time-1;fp1=foundfile(; /*新建文檔*/SaveFile2(time,fp1; /*(2方式數(shù)據(jù)寫(xiě)到文件中*/fp2=foundfile2(; /*新建文件付本*/Additive2Two(time,fp2; /*數(shù)據(jù)與入付本文件（二進(jìn)制方式）*/printf("n刪除成功!目前共有%d條記錄!n",time;fclose(fp1;fclose(fp2;else printf("n沒(méi)有執(zhí)行刪除操作!n"/* * * *

28、/void Math_ranking(int i /*數(shù)學(xué)排序函數(shù)*/int j,k;st time;for(j=1;j for(k=1;k<=i-j;k+if(recordk.Math>recordk+1.Mathtime=recordk;recordk=recordk+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,re

29、cordj.C,recordj.Amount;void C_ranking(int i /*C排序函數(shù)*/int j,k;st time;for(j=1;j for(k=1;k<=i-j;k+if(recordk.C>recordk+1.Ctime=recordk;recordk=recordk+1;recordk+1=time;printf("n"for(j=1;j printf("nName:%-10s Num:%3ld Math:%3d C:%3d Amount:%3dn",,recordj.Number,rec

30、ordj.Math,recordj.C,recordj.Amount;void Amount_ranking(int i /*總分排序函數(shù)*/int j,k;st time;for(j=1;j for(k=1;k<=i-j;k+if(recordk.Amount>recordk+1.Amounttime=recordk;recordk=recordk+1;recordk+1=time;printf("n"for(j=1;j printf("nName:%-10s Num:%3ld Math:%3d C:%3d Amount:%3dn",rec

31、,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請(qǐng)輸入選項(xiàng) 1 - 6 (當(dāng)前在主菜單:"while(ch=getchar(!='0'if(ch='6'&&(location='1'getchar(;printf(&q

32、uot;nnttt* 'Y'=續(xù)繼 'n'=退出 *n"printf("nnttINPUT:"if(ch=getchar(='n'printf("nnttt 謝謝您的使用!"exit(;break;else MainMenu(;location='1'printf("n請(qǐng)輸入選項(xiàng) 1 - 6 (當(dāng)前在主菜單:"if(ch='1'&&(location='1'temp1=InputSave(; /*添加數(shù)據(jù) */ge

33、tchar(;printf("tt* 'y'=保存 'n'=不保存 * : "if(ch=getchar(='y'Inputfilename(; /*輸入文件名同時(shí)產(chǎn)生付本文件名*/fp=foundfile(; /*新建文檔*/SaveFile2(temp1,fp; /*(2方式數(shù)據(jù)寫(xiě)到文件中*/fclose(fp;ffp=foundfile2(; /*(開(kāi)打方式'新建'新建文件付本*/Additive2Two(temp1,ffp; /*新建付本文件數(shù)據(jù)（文本方式）*/fclose(ffp;printf(&qu

34、ot;保存了%d條記錄!n",temp1;else printf("t 沒(méi)有保存!n"temp1=0;temp2=0;MainMenu(;location='1'printf("n請(qǐng)輸入選項(xiàng) 1 - 6 (當(dāng)前在主菜單:"continue;if(ch='2'&&(location='1'getchar(; printf("nt * 'y'=使用當(dāng)前文件名 'n'=輸入新文件名 * : "if(ch=getchar(='y&

35、#39;fp=savefile(; /*追加文檔*/else Inputfilename(; /*輸入文件名同時(shí)產(chǎn)生付本文件名*/fp=savefile(;temp1=InputSave(; /*添加數(shù)據(jù) */temp3=temp1;SaveFile2(temp1,fp; /*(2方式數(shù)據(jù)寫(xiě)到文件中*/fclose(fp;ffp=readfile2(; /*讀文件付本*/temp2=ReadComputer2Two(ffp; /*讀出付本中的數(shù)據(jù)（文本方式）*/fclose(ffp;temp1=temp1+temp2;ffp=foundfile2(; /*新建文件付本*/Additive2Tw

36、o(temp1,ffp; /*新建付本文件數(shù)據(jù)（文本方式）*/fclose(ffp;printf("n添加拉%d條數(shù)據(jù)!共保存%d條數(shù)據(jù)!n",temp3,temp1;temp1=0;temp2=0;MainMenu(;location='1'printf("n請(qǐng)輸入選項(xiàng) 1 - 6 (當(dāng)前在主菜單:"continue;if(ch='3'&&(location='1'DelMenu(;location='2'printf("n請(qǐng)輸入選項(xiàng) 1 - 3 (當(dāng)前在刪除菜單

37、:"while(ch=getchar(!='0'if(ch='1'&&(location='2'getchar(;printf("ntt *現(xiàn)在位置在刪除菜單 - 學(xué)號(hào)刪除*n"printf("nt * 'y'=使用當(dāng)前文件名 'n'=輸入新文件名 * : "if(ch=getchar(='y' /*追加文檔*/else Inputfilename(; /*輸入文件名同時(shí)產(chǎn)生付本文件名*/Num_inquire_Del(; /*學(xué)號(hào)查

38、詢(xún)刪除*/DelMenu(;location='2'printf("n請(qǐng)輸入選項(xiàng) 1 - 3 (當(dāng)前在刪除菜單:"continue;if(ch='2'&&(location='2'MainMenu(;location='1'printf("n請(qǐng)輸入選項(xiàng) 1 - 6 (當(dāng)前在主菜單:"break;if(ch='4'&&(location='1'RankingMenu(;location='3'printf(&quo

39、t;n請(qǐng)輸入選項(xiàng) 1 - 4 (當(dāng)前在排序菜單:"while(ch=getchar(!='0'if(ch='1'&&(location='3'getchar(;printf("ntt *現(xiàn)在位置在排序菜單 - 數(shù)學(xué)排序*n"printf("nt * 'y'=使用當(dāng)前文件名 'n'=輸入新文件名 * : "if(ch=getchar(='y' /*追加文檔*/else Inputfilename(;fp=readfile(; /*讀取文

40、檔*/ffp=readfile2(; /*(開(kāi)打方式'讀'*'引用讀文件名'讀文件付本*/temp1=ReadComputer2Two(ffp; /*讀出付本中的數(shù)據(jù)（二進(jìn)制方式）*/ fclose(ffp;ReadComputer2(temp1,fp; /*(2方式數(shù)據(jù)寫(xiě)入機(jī)器*/fclose(fp;Math_ranking(temp1; /*數(shù)學(xué)排序函數(shù)*/temp1=0;temp2=0;RankingMenu(;location='3'printf("n請(qǐng)輸入選項(xiàng) 1 - 4 (當(dāng)前在排序菜單:"continue;if(

41、ch='2'&&(location='3'getchar(;printf("ntt *現(xiàn)在位置在排序菜單 - C語(yǔ)言排序*n"printf("nt * 'y'=使用當(dāng)前文件名 'n'=輸入新文件名 * : "if(ch=getchar(='y' /*追加文檔*/else Inputfilename(;fp=readfile(; /*讀取文檔*/ffp=readfile2(; /*(開(kāi)打方式'讀'*'引用讀文件名'讀文件付本*/t

42、emp1=ReadComputer2Two(ffp; /*讀出付本中的數(shù)據(jù)（二進(jìn)制方式）*/fclose(ffp;ReadComputer2(temp1,fp; /*(2方式數(shù)據(jù)寫(xiě)入機(jī)器*/fclose(fp;C_ranking(temp1; /*數(shù)學(xué)排序函數(shù)*/temp1=0;temp2=0;RankingMenu(;location='3'printf("n請(qǐng)輸入選項(xiàng) 1 - 4 (當(dāng)前在排序菜單:"continue;if(ch='3'&&(location='3'getchar(;printf("

43、;ntt *現(xiàn)在位置在排序菜單 - 總分排序*n"printf("nt * 'y'=使用當(dāng)前文件名 'n'=輸入新文件名 * : "if(ch=getchar(='y' /*追加文檔*/else Inputfilename(;fp=readfile(; /*讀取文檔*/ffp=readfile2(; /*(開(kāi)打方式'讀'*'引用讀文件名'讀文件付本*/temp1=ReadComputer2Two(ffp; /*讀出付本中的數(shù)據(jù)（二進(jìn)制方式）*/fclose(ffp;ReadComput

44、er2(temp1,fp; /*(2方式數(shù)據(jù)寫(xiě)入機(jī)器*/fclose(fp;Amount_ranking(temp1; /*數(shù)學(xué)排序函數(shù)*/temp1=0;temp2=0;RankingMenu(;location='3'printf("n請(qǐng)輸入選項(xiàng) 1 - 4 (當(dāng)前在排序菜單:"continue;if(ch='4'&&(location='3'MainMenu(;location='1'printf("n請(qǐng)輸入選項(xiàng) 1 - 6 (當(dāng)前在主菜單:"break;if(ch=&

45、#39;5'&&(location='1'InquireMenu(;location='4'printf("n請(qǐng)輸入選項(xiàng) 1 - 6 (當(dāng)前在查詢(xún)菜單:"while(ch=getchar(!='0'if(ch='1'&&(location='4'getchar(;printf("ntt *現(xiàn)在位置在查詢(xún)菜單 - 學(xué)號(hào)查詢(xún)*n"printf("nt * 'y'=使用當(dāng)前文件名 'n'=輸入新文件名 * : "if(ch=getchar(='y' /*追加文檔*/else Inputfilename(;Num_inquire(; /*學(xué)號(hào)查詢(xún)*/Inquire