xueshengshujukuguanli.c

学生数据库的管理与实现

   window(1,1,80,25);       /*恢复原窗口大小*/
   gotoxy(10,21);       /*移动光标*/
   do{
      printf("\n	 Enter you choice(0~2):");    /*在菜单窗口外显示提示信息*/
      scanf("%s",s);           /*输入选择项*/
      c=atoi(s);            /*将输入的字符串转化为整形数*/
   }while(c<0||c>2);    /*选择项不在0~14之间重输*/
   return c;              /*返回选择项，主程序根据该数调用相应的函数*/
}

/*管理员录入菜单*/
menu_select2()
{
   char *menu[]={"******ADMIN LU RU*****",  /*定义菜单字符串数组*/
   " 0. xue sheng shu ju ku", 
   " 1. ke cheng shu ju ku",     
   " 2. mi ma lu ru",
   " 3. fan hui"};              /*退出*/
   char s[3];       /*以字符形式保存选择号*/
   int c,i;        /*定义整形变量*/
   gotoxy(1,25);        /*移动光标*/
   printf("press any key enter menu......\n");   /*压任一键进入主菜单*/
   getch();                       /*输入任一键*/
   clrscr();                     /*清屏幕*/
   gotoxy(1,1);             /*移动光标*/
   textcolor(YELLOW);   /*设置文本显示颜色为黄色*/
   textbackground(BLUE);   /*设置背景颜色为蓝色*/
   gotoxy(10,2);          /*移动光标*/
   putch(0xc9);        /*输出左上角边框┏*/
   for(i=1;i<44;i++)
      putch(0xcd);    /*输出上边框水平线*/
   putch(0xbb);            /*输出右上角边框  ┓*/
   for(i=3;i<20;i++)
   {
      gotoxy(10,i);putch(0xba);   /*输出左垂直线*/
      gotoxy(54,i);putch(0xba);
   }   /*输出右垂直线*/
   gotoxy(10,20);putch(0xc8);  /*输出左上角边框┗*/
   for(i=1;i<44;i++)
      putch(0xcd);      /*输出下边框水平线*/
   putch(0xbc);                 /*输出右下角边框┛*/
   window(11,3,53,19);       /* 制作显示菜单的窗口，大小根据菜单条数设计*/
   clrscr();              /*清屏*/
   for(i=0;i<5;i++)       /*输出主菜单数组*/
   {
      gotoxy(10,i+1);
      cprintf("%s",menu[i]);
   }
   textbackground(BLACK);   /*设置背景颜色为黑色*/
   window(1,1,80,25);       /*恢复原窗口大小*/
   gotoxy(10,21);       /*移动光标*/
   do{
      printf("\n	 Enter you choice(0~3):");    /*在菜单窗口外显示提示信息*/
      scanf("%s",s);           /*输入选择项*/
      c=atoi(s);            /*将输入的字符串转化为整形数*/
   }while(c<0||c>3);    /*选择项不在0~14之间重输*/
   return c;              /*返回选择项，主程序根据该数调用相应的函数*/
}
/*管理员统计菜单*/
menu_select3()
{
   char *menu[]={"******ADMIN TONG JI*****",  /*定义菜单字符串数组*/
   " 0. suo you ren ping zong", 
   " 1. mou ke pin jun zong fen",     
   " 2. fan hui"};              /*退出*/
   char s[3];       /*以字符形式保存选择号*/
   int c,i;        /*定义整形变量*/
   gotoxy(1,25);        /*移动光标*/
   printf("press any key enter menu......\n");   /*压任一键进入主菜单*/
   getch();                       /*输入任一键*/
   clrscr();                     /*清屏幕*/
   gotoxy(1,1);             /*移动光标*/
   textcolor(YELLOW);   /*设置文本显示颜色为黄色*/
   textbackground(BLUE);   /*设置背景颜色为蓝色*/
   gotoxy(10,2);          /*移动光标*/
   putch(0xc9);        /*输出左上角边框┏*/
   for(i=1;i<44;i++)
      putch(0xcd);    /*输出上边框水平线*/
   putch(0xbb);            /*输出右上角边框  ┓*/
   for(i=3;i<20;i++)
   {
      gotoxy(10,i);putch(0xba);   /*输出左垂直线*/
      gotoxy(54,i);putch(0xba);
   }   /*输出右垂直线*/
   gotoxy(10,20);putch(0xc8);  /*输出左上角边框┗*/
   for(i=1;i<44;i++)
      putch(0xcd);      /*输出下边框水平线*/
   putch(0xbc);                 /*输出右下角边框┛*/
   window(11,3,53,19);       /* 制作显示菜单的窗口，大小根据菜单条数设计*/
   clrscr();              /*清屏*/
   for(i=0;i<4;i++)       /*输出主菜单数组*/
   {
      gotoxy(10,i+1);
      cprintf("%s",menu[i]);
   }
   textbackground(BLACK);   /*设置背景颜色为黑色*/
   window(1,1,80,25);       /*恢复原窗口大小*/
   gotoxy(10,21);       /*移动光标*/
   do{
      printf("\n	 Enter you choice(0~2):");    /*在菜单窗口外显示提示信息*/
      scanf("%s",s);           /*输入选择项*/
      c=atoi(s);            /*将输入的字符串转化为整形数*/
   }while(c<0||c>2);    /*选择项不在0~14之间重输*/
   return c;              /*返回选择项，主程序根据该数调用相应的函数*/
}
/*管理员修改菜单*/
menu_select4()
{
   char *menu[]={"******ADMIN XIU GAI*****",  /*定义菜单字符串数组*/
   " 0. tian jia xue sheng", 
   " 1. shan chu xue sheng",
   " 2. mi ma tian jia",
   " 3. mi ma shan chu",   
   " 4. fan hui"};              /*退出*/
   char s[3];       /*以字符形式保存选择号*/
   int c,i;        /*定义整形变量*/
   gotoxy(1,25);        /*移动光标*/
   printf("press any key enter menu......\n");   /*压任一键进入主菜单*/
   getch();                       /*输入任一键*/
   clrscr();                     /*清屏幕*/
   gotoxy(1,1);             /*移动光标*/
   textcolor(YELLOW);   /*设置文本显示颜色为黄色*/
   textbackground(BLUE);   /*设置背景颜色为蓝色*/
   gotoxy(10,2);          /*移动光标*/
   putch(0xc9);        /*输出左上角边框┏*/
   for(i=1;i<44;i++)
      putch(0xcd);    /*输出上边框水平线*/
   putch(0xbb);            /*输出右上角边框  ┓*/
   for(i=3;i<20;i++)
   {
      gotoxy(10,i);putch(0xba);   /*输出左垂直线*/
      gotoxy(54,i);putch(0xba);
   }   /*输出右垂直线*/
   gotoxy(10,20);putch(0xc8);  /*输出左上角边框┗*/
   for(i=1;i<44;i++)
      putch(0xcd);      /*输出下边框水平线*/
   putch(0xbc);                 /*输出右下角边框┛*/
   window(11,3,53,19);       /* 制作显示菜单的窗口，大小根据菜单条数设计*/
   clrscr();              /*清屏*/
   for(i=0;i<6;i++)       /*输出主菜单数组*/
   {
      gotoxy(10,i+1);
      cprintf("%s",menu[i]);
   }
   textbackground(BLACK);   /*设置背景颜色为黑色*/
   window(1,1,80,25);       /*恢复原窗口大小*/
   gotoxy(10,21);       /*移动光标*/
   do{
      printf("\n	 Enter you choice(0~4):");    /*在菜单窗口外显示提示信息*/
      scanf("%s",s);           /*输入选择项*/
      c=atoi(s);            /*将输入的字符串转化为整形数*/
   }while(c<0||c>4);    /*选择项不在0~14之间重输*/
   return c;              /*返回选择项，主程序根据该数调用相应的函数*/
}



/*统计某门课程的平均分和总分*/
void computer1(STUDENT *h)
{
   STUDENT *p;           
   int i=0;              
   long int s=0;             
   float ave=0;           
   int j;
   do{
      printf("na men ke cheng shuxue=0,yuwen=1,yingyu=2\n");
      scanf("%d",&j);
     }while(j>2||j<0);
   p=h;                  
   while(p!=NULL)        
   {
      s+=p->score[j];   
      i++;               
      p=p->next;        
   }
   ave=(float)s/i;       
   printf("\n--This class's sum score is:%ld  average is %5.2f\n",s,ave);
}
/*所有学生的总分和总分的平均分*/
void computer(STUDENT *h)
{
   STUDENT *p;   
   int i=0;  
   long s=0;   
   float average=0;  
   p=h;        
   while(p!=NULL)    
   {
      s+=p->sum;   
      i++;         
      p=p->next;   
   }
   average=(float)s/i;
   printf("\n--All students sum score is:%ld  average is %5.2f\n",s,average);
}

/*管理员和老师查询学生成绩*/
void search1(STUDENT *h)
{
   int i;
   char s[11];
   STUDENT *p;    
   clrscr();   
   printf("please enter num for search\n");
   scanf("%s",s);                               
   p=h;                                     
   while(strcmp(p->num,s)&&p!=NULL)  
   p=p->next;     
   if(p==NULL)       
      printf("\nlist no num %s student\n",s);   
   else          
   {
   	 printf("num:%s\nname:%s\n",p->num,p->name);
   	 for(i=0;i<N;i++)
   	 printf("\n%s:%d",p->kecheng[i],p->score[i]);
   	 printf("\nsum:%f\nave:%f\n",p->sum,p->average);
   }
}
/*学生查询学生成绩*/
void search12(STUDENT *h,char s[11])
{  
   STUDENT *p=h;    
   int i;
   clrscr();                                                                            
   while(strcmp(p->num,s)&&p!=NULL)  
   p=p->next;     
   if(p==NULL)       
      printf("\nlist no num %s student\n",s);   
   else          
   {
   	 printf("\nnum:%s\nname:%s",p->num,p->name);
   	 for(i=0;i<N;i++)
   	 printf("\n%s:%d",p->kecheng[i],p->score[i]);
   	 printf("\nsum:%f\nave:%f\n",p->sum,p->average);
   }
}

/*管理员和老师查询学生基本信息*/
void search(STUDENT *h)
{
   char s[11];
   STUDENT *p=h;    
   char num[11];   
   clrscr();   
   printf("please enter num for search\n");
   scanf("%s",s);    
   while(strcmp(p->num,s)&&p!=NULL)  
   p=p->next;    
   if(p==NULL)       
      printf("\nlist no num %s student\n",s);   
   else          
   {
      printf("\nnum:%s\nname:%s\nsexy:%s\njiguan:%s\nbirthday:%s\naddress:%s\ntelephone:%s\nemail:%s\njiangfa:%s\n",p->num,p->name,p->sexy,p->jiguan,p->birthday,p->adress,p->telephone,p->email,p->jiangfa);
   }
  
}
/*学生查询学生基本信息*/
void search11(STUDENT *h,char s[11])
{
   STUDENT *p=h;       
   clrscr();          
   while(strcmp(p->num,s)&&p!=NULL)  
   p=p->next;    
   if(p==NULL)       
      printf("\nlist no num %s student\n",s);   
   else          
   {
      printf("\nnum:%s\nname:%s\nsexy:%s\njiguan:%s\nbirthday:%s\naddress:%s\ntelephone:%s\nemail:%s\njiangfa:%s\n",p->num,p->name,p->sexy,p->jiguan,p->birthday,p->adress,p->telephone,p->email,p->jiangfa);
   }
}

/*输入字符串并进行长度验证*/
inputs(char *prompt, char *s, int count)
{
   char p[255];
   do{
      printf(prompt);  
      scanf("%s",p); 
      if(strlen(p)>count)printf("\n too long! \n"); 
   }while(strlen(p)>count);
   strcpy(s,p); 
}
/*老师查询主菜单*/
menu_select5()
{
   char *menu[]={"******TEACHER MENU*****", 
   " 0. xiu gai mi ma", 
   " 1. cha xun",   
   " 2. tong ji",  
   " 3. Quit"};             
   char s[3];       
   int c,i;       
   gotoxy(1,25);        
   printf("press any key enter menu......\n");  
   getch();                     
   clrscr();                     
   gotoxy(1,1);            
   textcolor(YELLOW);   
   textbackground(BLUE);   
   gotoxy(10,2);          
   putch(0xc9);       
   for(i=1;i<44;i++)
      putch(0xcd);    
   putch(0xbb);        
   for(i=3;i<20;i++)
   {
      gotoxy(10,i);putch(0xba);  
      gotoxy(54,i);putch(0xba);
   }  
   gotoxy(10,20);putch(0xc8);  
   for(i=1;i<44;i++)
      putch(0xcd);      
   putch(0xbc);                
   window(11,3,53,19);      
   clrscr();              
   for(i=0;i<5;i++)       
   {
      gotoxy(10,i+1);
      cprintf("%s",menu[i]);
   }
   textbackground(BLACK);   
   window(1,1,80,25);      
   gotoxy(10,21);       
   do{
      printf("\n	 Enter you choice(0~3):");    
      scanf("%s",s);          
      c=atoi(s);           
   }while(c<0||c>3);    
   return c;             
}

/*管理员查询菜单*/
menu_select6()
{
   char *menu[]={"******TEACHER CHA XUN*****", 
   " 0. ji ben xin xi", 
   " 1. dan ke cheng ji",    
   " 2. fan hui"};            
   char s[3];     
   int c,i;       
   gotoxy(1,25);       
   printf("press any key enter menu......\n");  
   getch();                  
   clrscr();                   
   gotoxy(1,1);      
   textcolor(YELLOW);   
   textbackground(BLUE);   
   gotoxy(10,2);         
   putch(0xc9);        
   for(i=1;i<44;i++)
      putch(0xcd);    
   putch(0xbb);           
   for(i=3;i<20;i++)
   {
      gotoxy(10,i);putch(0xba);
      gotoxy(54,i);putch(0xba);
   }   
   gotoxy(10,20);putch(0xc8);  
   for(i=1;i<44;i++)
      putch(0xcd);    
   putch(0xbc);               
   window(11,3,53,19);       
   clrscr();              
   for(i=0;i<4;i++)      
   {
      gotoxy(10,i+1);
      cprintf("%s",menu[i]);
   }
   textbackground(BLACK);  
   window(1,1,80,25);    
   gotoxy(10,21);     
   do{
      printf("\n	 Enter you choice(0~3):");  
      scanf("%s",s);         
      c=atoi(s);       
   }while(c<0||c>2);    
   return c;             
}

/*管理员统计菜单*/
menu_select7()
{
   char *menu[]={"******TEACHER TONG JI*****", 
   " 0. xuan ke ren shu", 
   " 1. fen shu duan",     
   " 2. fan hui"};           
   char s[3];      
   int c,i;       
   gotoxy(1,25);        
   printf("press any key enter menu......\n");  
   getch();                    
   clrscr();                    
   gotoxy(1,1);          
   textcolor(YELLOW);  
   textbackground(BLUE);  
   gotoxy(10,2);         
   putch(0xc9);        
   for(i=1;i<44;i++)
      putch(0xcd);    
   putch(0xbb);          
   for(i=3;i<20;i++)
   {
      gotoxy(10,i);putch(0xba);  
      gotoxy(54,i);putch(0xba);
   } 
   gotoxy(10,20);putch(0xc8); 
   for(i=1;i<44;i++)
      putch(0xcd);      
   putch(0xbc);               
   window(11,3,53,19);       
   clrscr();             
   for(i=0;i<4;i++)       
   {
      gotoxy(10,i+1);
      cprintf("%s",menu[i]);
   }
   textbackground(BLACK);  
   window(1,1,80,25);       
   gotoxy(10,21);      
   do{
      printf("\n	 Enter you choice(0~2):");    
      scanf("%s",s);         
      c=atoi(s);          
   }while(c<0||c>2);    
   return c;         
}
/*分数段统计*/
void total(STUDENT *h)
{
   STUDENT *p;                   
   int s,q;
   int a=0,b=0,c=0,d=0,e=0,f=0;   
   int j;                       
   do
     {printf("qing shu ru na ge yi men ke cheng shuxue=0,yuwen=1,yingyu=2\n");
      scanf("%d",&j);
     }while(j>2||j<0);
   p=h;                           
   while(p!=NULL)              
   {
      s=p->score[j];             
      q=s/10;                    
      switch(q)
      {
         case 10:a++;break;
         case 9 :b++;break;
         case 8 :c++;break;
         case 7 :d++;break;
         case 6 :e++;break;
         case 5 :
         case 4 :