main.cpp

连接到数据库（sql和access）

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->S_BIRTHDAY,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->S_DATE,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->S_SCHOOL,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					p->S_GRADE=atof((char *)_bstr_t(var));
				}
				 
				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->S_PHONE,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->S_ADDRESS,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->SP_NO,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->CNO,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->CH_NO,"%s",(char *)_bstr_t(var));
				}

				q->next=p;
				q=p;
				pRs->MoveNext();
			}
			break;
		}
	//从教师表中读取数据
	case 2:
		{
			TEACHER *p,*q;
			q=all->teacherhead;			
			while(!pRs->EndOfFile)
			{
				i=1;
				p=(TEACHER *)malloc(sizeof(TEACHER));
				p->next=NULL;

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->TNO,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->TN,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->T_SEX,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->T_PROF,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->T_BIRTHDAY,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->T_DATE,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					p->T_SALARY=atof((char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->DNO,"%s",(char *)_bstr_t(var));
				}

				q->next=p;
				q=p;
				pRs->MoveNext();
			}
			break;
		}
	//从课程表中读取数据
	case 3:
		{
			COURSE *p,*q;
			q=all->coursehead;			
			while(!pRs->EndOfFile)
			{
				i=1;
				p=(COURSE *)malloc(sizeof(COURSE));
				p->next=NULL;

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->CO_NO,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->CO_N,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					p->CO_T_TIME=atoi((char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					p->CO_E_TIME=atoi((char *)_bstr_t(var));
				}
				else
				{
					p->CO_E_TIME=0;
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					p->CO_S=atoi((char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->CO_BOOK,"%s",(char *)_bstr_t(var));
				}
				else
				{
					sprintf(p->CO_BOOK,"");
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->DNO,"%s",(char *)_bstr_t(var));
				}

				q->next=p;
				q=p;
				pRs->MoveNext();
			}
		}
	//从专业表中读取数据
	case 4:
		{
			SPECIALITY *p,*q;
			q=all->specialityhead;			
			while(!pRs->EndOfFile)
			{
				i=1;
				p=(SPECIALITY *)malloc(sizeof(SPECIALITY));
				p->next=NULL;

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->SP_NO,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->SP_N,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->SP_DATE,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					p->SP_NUM=atoi((char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->DNO,"%s",(char *)_bstr_t(var));
				}
				q->next=p;
				q=p;
				pRs->MoveNext();
			}
			break;
		}
	//从院系表中读取数据
	case 5:
		{
			DEPARTMENT *p,*q;
			q=all->departmenthead;			
			while(!pRs->EndOfFile)
			{
				i=1;
				p=(DEPARTMENT *)malloc(sizeof(DEPARTMENT));
				p->next=NULL;

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->DNO,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->DN,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->D_DATE,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->D_HEAD,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->D_ADDRESS,"%s",(char *)_bstr_t(var));
				}
				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->D_PHONE,"%s",(char *)_bstr_t(var));
				}
				q->next=p;
				q=p;
				pRs->MoveNext();
			}
			break;
		}
	//从班级表中读取数据
	case 6:
		{
			CLASS *p,*q;
			q=all->classhead;			
			while(!pRs->EndOfFile)
			{
				i=1;
				p=(CLASS *)malloc(sizeof(CLASS));
				p->next=NULL;

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->CNO,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->CN,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->C_DATE,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->C_CLASSROOM,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					p->C_NUM=atoi((char *)_bstr_t(var));
				}
				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->TNO,"%s",(char *)_bstr_t(var));
				}
				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->DNO,"%s",(char *)_bstr_t(var));
				}
				q->next=p;
				q=p;
				pRs->MoveNext();
			}
			break;
		}
	//从教学计划表中读取数据
	case 7:
		{
			PROJECT *p,*q;
			q=all->projecthead;			
			while(!pRs->EndOfFile)
			{
				i=1;
				p=(PROJECT *)malloc(sizeof(PROJECT));
				p->next=NULL;

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->SP_NO,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->CO_NO,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->CLASS,"%s",(char *)_bstr_t(var));
				}
				q->next=p;
				q=p;
				pRs->MoveNext();
			}
			break;
		}
	//从入校报到表中读取数据
	case 8:
		{
			REGISTER *p,*q;
			q=all->registerhead;			
			while(!pRs->EndOfFile)
			{
				i=1;
				p=(REGISTER *)malloc(sizeof(REGISTER));
				p->next=NULL;

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->RNO,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->DNO,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					p->R_COST=atoi((char *)_bstr_t(var));
				}
				q->next=p;
				q=p;
				pRs->MoveNext();
			}
			break;
		}
	//从选修表中读取数据
	case 9:
		{
			SC *p,*q;
			q=all->schead;			
			while(!pRs->EndOfFile)
			{
				i=1;
				p=(SC *)malloc(sizeof(SC));
				p->next=NULL;

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->SNO,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->CO_NO,"%s",(char *)_bstr_t(var));
				}

				var=pRs->GetCollect(row_num[choice][i]);
				i++;
				if(var.vt!=VT_NULL)
				{
					sprintf(p->SC_CLASS,"%s",(char *)_bstr_t(var));