⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 statics.cpp

📁 分管理员和学生界面
💻 CPP
📖 第 1 页 / 共 5 页
字号:
🔍
12345 

}

connection1.m_pRecordset->MoveNext();
}   
connection1.Unitialize();
}


if(chose==3)//按教师姓名输出
{UpdateData(true);
list.DeleteAllItems();int flag=0;int nIndex;
CString course="",a="",b="",c="",d="",e="",f="",g="",h="",sSql="",sql="",number="",name="",sex="";
CString teachernum="";

connection1.Initialize();
sSql.Format("select * from 教职工 where 姓名='%s'",data);
connection1.Connect(sSql);
 if((connection1.m_pRecordset->adoEOF))
  {AfxMessageBox("没有教师记录");
   connection1.Unitialize();	
   return ;}
   connection1.m_pRecordset->MoveFirst();
while(!connection1.m_pRecordset->adoEOF)
{  _variant_t TheValue; 
	    TheValue = connection1.m_pRecordset->Fields->GetItem("职工号")->Value;
		teachernum=TheValue.bstrVal;

connection1.m_pRecordset->MoveNext();
}
connection1.Unitialize(); 

flag=0;
 connection5.Initialize();
 sql.Format("select * from 教学 where 职工号='%s'",teachernum);
 connection5.Connect(sql);
if(connection5.m_pRecordset->adoEOF)
{connection5.Unitialize(); flag=1;}
if(flag==0)
{
connection5.m_pRecordset->MoveFirst();
while(!connection5.m_pRecordset->adoEOF)
{      _variant_t TheValue; 
	    TheValue = connection5.m_pRecordset->Fields->GetItem("职工号")->Value;
		e=TheValue.bstrVal;
	
		TheValue = connection5.m_pRecordset->Fields->GetItem("上课时间")->Value;
		f=TheValue.bstrVal;

	    TheValue = connection5.m_pRecordset->Fields->GetItem("上课地点")->Value;
		g=TheValue.bstrVal;

		TheValue = connection5.m_pRecordset->Fields->GetItem("考试时间")->Value;
		h=TheValue.bstrVal;
		connection5.m_pRecordset->MoveNext();
}  
connection5.Unitialize(); 
}



flag=0;
connection1.Initialize();
sSql.Format("select * from 教学 where 职工号='%s'order by 课程号 desc",teachernum);
connection1.Connect(sSql);
 if((connection1.m_pRecordset->adoEOF))
 {
   connection1.Unitialize();	
   flag=1;}
if(flag==0)
{connection1.m_pRecordset->MoveFirst();
while(!connection1.m_pRecordset->adoEOF)
{  _variant_t TheValue; 
   TheValue = connection1.m_pRecordset->Fields->GetItem("课程号")->Value;
   course=TheValue.bstrVal;//得该教师教的每个课程号

nIndex= list.InsertItem(0,"");
list.SetItemText(nIndex,1,"");
list.SetItemText(nIndex,2,"");
list.SetItemText(nIndex,3,"");
list.SetItemText(nIndex,4,"");
list.SetItemText(nIndex,5,"");

nIndex= list.InsertItem(0,"");
list.SetItemText(nIndex,1,"");
list.SetItemText(nIndex,2,"");
list.SetItemText(nIndex,3,"");
list.SetItemText(nIndex,4,"");
list.SetItemText(nIndex,5,"");

 connection2.Initialize(); 
 sql.Format("select * from 课程 where 课程号='%s' ",course);
 connection2.Connect(sql);
 connection2.m_pRecordset->MoveFirst();
while(!connection2.m_pRecordset->adoEOF)
{  _variant_t TheValue; 

	    TheValue = connection2.m_pRecordset->Fields->GetItem("课程号")->Value;
		a=TheValue.bstrVal;

	    TheValue = connection2.m_pRecordset->Fields->GetItem("课程名称")->Value;
		b=TheValue.bstrVal;
	
		float credit = connection2.m_pRecordset->Fields->GetItem("学分")->Value;
		c.Format("%g",credit);

	    TheValue = connection2.m_pRecordset->Fields->GetItem("学时")->Value;
		d=TheValue.bstrVal;
connection2.m_pRecordset->MoveNext();
}
connection2.Unitialize(); 
//得每个课程号的属性


flag=0;
connection3.Initialize();
sql.Format("select * from 选修 where 课程号='%s'and 教师号='%s' order by 学号 desc",course,teachernum);
 connection3.Connect(sql);
if(connection3.m_pRecordset->adoEOF)
{connection3.Unitialize(); flag=1;}
if(flag==0)
{connection3.m_pRecordset->MoveFirst();
while(!connection3.m_pRecordset->adoEOF)
{     _variant_t TheValue; 
        TheValue = connection3.m_pRecordset->Fields->GetItem("学号")->Value;
		number=TheValue.bstrVal;//得到一个课程的每一个学生的学号
		
flag=0;		
connection4.Initialize();
sql.Format("select * from 学生 where 学号='%s' ",number);
connection4.Connect(sql);
if(connection4.m_pRecordset->adoEOF)
{connection4.Unitialize(); flag=1;}
if(flag==0)
{connection4.m_pRecordset->MoveFirst();
while(!connection4.m_pRecordset->adoEOF)
{      _variant_t TheValue; 
		
		TheValue = connection4.m_pRecordset->Fields->GetItem("姓名")->Value;
		name=TheValue.bstrVal;
		
		TheValue = connection4.m_pRecordset->Fields->GetItem("性别")->Value;
		sex=TheValue.bstrVal;
		//得到一个学生的资料
        nIndex= list.InsertItem(0,number);
		list.SetItemText(nIndex,1,name);
        list.SetItemText(nIndex,2,sex);
		list.SetItemText(nIndex,3,"");
		list.SetItemText(nIndex,4,"" );
		

connection4.m_pRecordset->MoveNext();
}
connection4.Unitialize(); //得学号
}
connection3.m_pRecordset->MoveNext();
}
connection3.Unitialize(); 
}


 nIndex= list.InsertItem(0,"学号");
 list.SetItemText(nIndex,1,"姓名");
 list.SetItemText(nIndex,2,"性别");
 list.SetItemText(nIndex,3,"平时成绩");
 list.SetItemText(nIndex,4,"考试成绩"); 
 list.SetItemText(nIndex,5,"总评成绩");	

 nIndex= list.InsertItem(0,"职工号：");
list.SetItemText(nIndex,1,e);
list.SetItemText(nIndex,2,"上课时间：");
list.SetItemText(nIndex,3,f);
list.SetItemText(nIndex,4,"上课地点：");
list.SetItemText(nIndex,5,g);
list.SetItemText(nIndex,6,"考试时间：");
list.SetItemText(nIndex,7,h);

nIndex= list.InsertItem(0,"课程号：");
list.SetItemText(nIndex,1,a);
list.SetItemText(nIndex,2,"课程名称：");
list.SetItemText(nIndex,3,b);
list.SetItemText(nIndex,4,"学分：");
list.SetItemText(nIndex,5,c);
list.SetItemText(nIndex,6,"学时：");
list.SetItemText(nIndex,7,d);
connection1.m_pRecordset->MoveNext();
}//con1
connection1.Unitialize(); 
}//if



}//chose3
//////////////////////////////////////////////////////////////////////////////////////////////////
if(chose==4)
{UpdateData(true);
list.DeleteAllItems();int flag=0;int nIndex;
CString course="",a="",b="",c="",d="",e="",f="",g="",h="",sSql="",sql="",number="",name="",sex="";
CString teachernum="";

connection1.Initialize();
sSql.Format("select * from 系 where 系号='%s'",data);
connection1.Connect(sSql);
 if((connection1.m_pRecordset->adoEOF))
  {AfxMessageBox("没有该系记录");
   connection1.Unitialize();	
   return ;}
connection1.Unitialize();
flag=0;
connection1.Initialize();
sSql.Format("select * from 教职工 where 所在系号='%s'",data);
connection1.Connect(sSql);
if(connection1.m_pRecordset->adoEOF)
{connection1.Unitialize(); flag=1;}
if(flag==0)
{
connection1.m_pRecordset->MoveFirst();
while(!connection1.m_pRecordset->adoEOF)
{ _variant_t TheValue;
	    TheValue = connection1.m_pRecordset->Fields->GetItem("职工号")->Value;
		teachernum=TheValue.bstrVal;



flag=0;
 connection5.Initialize();
 sql.Format("select * from 教学 where 职工号='%s'",teachernum);
 connection5.Connect(sql);
if(connection5.m_pRecordset->adoEOF)
{connection5.Unitialize(); flag=1;}
if(flag==0)
{
connection5.m_pRecordset->MoveFirst();
while(!connection5.m_pRecordset->adoEOF)
{      _variant_t TheValue; 
	    TheValue = connection5.m_pRecordset->Fields->GetItem("职工号")->Value;
		e=TheValue.bstrVal;
	
		TheValue = connection5.m_pRecordset->Fields->GetItem("上课时间")->Value;
		f=TheValue.bstrVal;

	    TheValue = connection5.m_pRecordset->Fields->GetItem("上课地点")->Value;
		g=TheValue.bstrVal;

		TheValue = connection5.m_pRecordset->Fields->GetItem("考试时间")->Value;
		h=TheValue.bstrVal;
		connection5.m_pRecordset->MoveNext();
}  
connection5.Unitialize(); 
}



flag=0;
connection6.Initialize();
sSql.Format("select * from 教学 where 职工号='%s'order by 课程号 desc",teachernum);
connection6.Connect(sSql);
 if((connection6.m_pRecordset->adoEOF))
 {
   connection6.Unitialize();	
   flag=1;}
if(flag==0)
{connection6.m_pRecordset->MoveFirst();
while(!connection6.m_pRecordset->adoEOF)
{  _variant_t TheValue; 
   TheValue = connection6.m_pRecordset->Fields->GetItem("课程号")->Value;
   course=TheValue.bstrVal;//得该教师教的每个课程号

nIndex= list.InsertItem(0,"");
list.SetItemText(nIndex,1,"");
list.SetItemText(nIndex,2,"");
list.SetItemText(nIndex,3,"");
list.SetItemText(nIndex,4,"");
list.SetItemText(nIndex,5,"");

nIndex= list.InsertItem(0,"");
list.SetItemText(nIndex,1,"");
list.SetItemText(nIndex,2,"");
list.SetItemText(nIndex,3,"");
list.SetItemText(nIndex,4,"");
list.SetItemText(nIndex,5,"");

 connection2.Initialize(); 
 sql.Format("select * from 课程 where 课程号='%s' ",course);
 connection2.Connect(sql);
 connection2.m_pRecordset->MoveFirst();
while(!connection2.m_pRecordset->adoEOF)
{  _variant_t TheValue; 

	    TheValue = connection2.m_pRecordset->Fields->GetItem("课程号")->Value;
		a=TheValue.bstrVal;

	    TheValue = connection2.m_pRecordset->Fields->GetItem("课程名称")->Value;
		b=TheValue.bstrVal;
	
		float credit = connection2.m_pRecordset->Fields->GetItem("学分")->Value;
		c.Format("%g",credit);

	    TheValue = connection2.m_pRecordset->Fields->GetItem("学时")->Value;
		d=TheValue.bstrVal;
connection2.m_pRecordset->MoveNext();
}
connection2.Unitialize(); 
//得每个课程号的属性


flag=0;
connection3.Initialize();
sql.Format("select * from 选修 where 课程号='%s'and 教师号='%s'order by 学号 desc",course,teachernum);
 connection3.Connect(sql);
if(connection3.m_pRecordset->adoEOF)
{connection3.Unitialize(); flag=1;}
if(flag==0)
{connection3.m_pRecordset->MoveFirst();
while(!connection3.m_pRecordset->adoEOF)
{     _variant_t TheValue; 
        TheValue = connection3.m_pRecordset->Fields->GetItem("学号")->Value;
		number=TheValue.bstrVal;//得到一个课程的每一个学生的学号
		
flag=0;		
connection4.Initialize();
sql.Format("select * from 学生 where 学号='%s' ",number);
connection4.Connect(sql);
if(connection4.m_pRecordset->adoEOF)
{connection4.Unitialize(); flag=1;}
if(flag==0)
{connection4.m_pRecordset->MoveFirst();
while(!connection4.m_pRecordset->adoEOF)
{      _variant_t TheValue; 
		
		TheValue = connection4.m_pRecordset->Fields->GetItem("姓名")->Value;
		name=TheValue.bstrVal;
		
		TheValue = connection4.m_pRecordset->Fields->GetItem("性别")->Value;
		sex=TheValue.bstrVal;
		//得到一个学生的资料
        nIndex= list.InsertItem(0,number);
		list.SetItemText(nIndex,1,name);
        list.SetItemText(nIndex,2,sex);
		list.SetItemText(nIndex,3,"");
		list.SetItemText(nIndex,4,"" );
		

connection4.m_pRecordset->MoveNext();
}
connection4.Unitialize(); //得学号
}
connection3.m_pRecordset->MoveNext();
}
connection3.Unitialize(); 
}


 nIndex= list.InsertItem(0,"学号");
 list.SetItemText(nIndex,1,"姓名");
 list.SetItemText(nIndex,2,"性别");
 list.SetItemText(nIndex,3,"平时成绩");
 list.SetItemText(nIndex,4,"考试成绩"); 
 list.SetItemText(nIndex,5,"总评成绩");	

 nIndex= list.InsertItem(0,"职工号：");
list.SetItemText(nIndex,1,e);
list.SetItemText(nIndex,2,"上课时间：");
list.SetItemText(nIndex,3,f);
list.SetItemText(nIndex,4,"上课地点：");
list.SetItemText(nIndex,5,g);
list.SetItemText(nIndex,6,"考试时间：");
list.SetItemText(nIndex,7,h);

nIndex= list.InsertItem(0,"课程号：");
list.SetItemText(nIndex,1,a);
list.SetItemText(nIndex,2,"课程名称：");
list.SetItemText(nIndex,3,b);
list.SetItemText(nIndex,4,"学分：");
list.SetItemText(nIndex,5,c);
list.SetItemText(nIndex,6,"学时：");
list.SetItemText(nIndex,7,d);
connection6.m_pRecordset->MoveNext();
}//con1
connection6.Unitialize(); 
}//if
connection1.m_pRecordset->MoveNext();
}
connection1.Unitialize(); 
}
}
}
if(select==2)/////cccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc////////
{float p9=0,p8=0,p7=0,p6=0,pf=0;
if(chose==1)//按课程号输出
{
list.DeleteAllItems();int flag=0;int nIndex;
CString course="",a="",b="",c="",d="",e="",f="",g="",h="",sSql="",sql="",number="",name="",sex="";

connection1.Initialize();
sSql.Format("select * from 课程 where 课程号='%s'",data);
connection1.Connect(sSql);
 if((connection1.m_pRecordset->adoEOF))
  {AfxMessageBox("没有课程记录");
   connection1.Unitialize();	
   return ;}	
   connection1.m_pRecordset->MoveFirst();
while(!connection1.m_pRecordset->adoEOF)//找存在的每个课程号课程
{      _variant_t TheValue; 
	    TheValue = connection1.m_pRecordset->Fields->GetItem("课程号")->Value;
		course=TheValue.bstrVal;//对每个找到的课程号进行处理


flag=0; 
connection2.Initialize(); 

 sql.Format("select * from 课程 where 课程号='%s' ",course);
 connection2.Connect(sql);
 connection2.m_pRecordset->MoveFirst();
while(!connection2.m_pRecordset->adoEOF)
{      _variant_t TheValue; 

	    TheValue = connection2.m_pRecordset->Fields->GetItem("课程号")->Value;
		a=TheValue.bstrVal;

	    TheValue = connection2.m_pRecordset->Fields->GetItem("课程名称")->Value;
		b=TheValue.bstrVal;
	
		float credit = connection2.m_pRecordset->Fields->GetItem("学分")->Value;
		c.Format("%g",credit);

	    TheValue = connection2.m_pRecordset->Fields->GetItem("学时")->Value;
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -