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

📄 statics.cpp

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

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

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

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

		TheValue = connection2.m_pRecordset->Fields->GetItem("考试时间")->Value;
		h=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,"");

//找到教该课程的一个老师
flag=0;p9=0;p8=0;p7=0;p6=0;pf=0;  
connection3.Initialize();
sql.Format("select * from 选修 where 课程号='%s'and 教师号='%s'order by 学号 desc",course,e);
 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);

		

connection4.m_pRecordset->MoveNext();
}  
connection4.Unitialize(); 
}
connection4.Initialize();
sql.Format("select * from 成绩 where 学号='%s'and 课程号='%s' ",number,course);
connection4.Connect(sql);
connection4.m_pRecordset->MoveFirst();
while(!connection4.m_pRecordset->adoEOF)
{   _variant_t TheValue; ///////////////////////
       CString usual,text,final;
        TheValue = connection4.m_pRecordset->Fields->GetItem("平时成绩")->Value;
		usual=TheValue.bstrVal;
		
		TheValue = connection4.m_pRecordset->Fields->GetItem("考试成绩")->Value;
		text=TheValue.bstrVal;

		TheValue = connection4.m_pRecordset->Fields->GetItem("总评成绩")->Value;
		final=TheValue.bstrVal;

				float Final=atof(final);
        if(Final>=90)p9++;
		if(Final>=80&&Final<90)p8++;
		if(Final>=70&&Final<80)p7++;
		if(Final>=60&&Final<70)p6++;
		if(Final<60)pf++;
        
		list.SetItemText(nIndex,3,usual);
		list.SetItemText(nIndex,4,text );
		list.SetItemText(nIndex,5,final );
		

		list.SetItemText(nIndex,3,usual);
		list.SetItemText(nIndex,4,text );
		list.SetItemText(nIndex,5,final );
		connection4.m_pRecordset->MoveNext();
}
connection4.Unitialize(); 
//*************

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

CString s9,s8,s7,s6,sf;
s9.Format("%0.0f",p9);
s8.Format("%0.0f",p8);
s7.Format("%0.0f",p7);
s6.Format("%0.0f",p6);
sf.Format("%0.0f",pf);

float r9=0,r8=0,r7=0,r6=0,rf=0;
float sum=0;
sum=p9+p8+p7+p6+pf;
if(sum!=0)
{
r9=(p9/sum)*100;
r8=(p8/sum)*100;
r7=(p7/sum)*100;
r6=(p6/sum)*100;
rf=(pf/sum)*100;}

CString t9,t8,t7,t6,tf;
t9.Format("%0.2f",r9);
t8.Format("%0.2f",r8);
t7.Format("%0.2f",r7);
t6.Format("%0.2f",r6);
tf.Format("%0.2f",rf);

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,"比例："+t9+"% ");
 list.SetItemText(nIndex,1,"比例 ："+t8+"% ");
 list.SetItemText(nIndex,2,"比例 ："+t7+"% ");
 list.SetItemText(nIndex,3,"比例 ："+t6+"% ");
 list.SetItemText(nIndex,4,"比例："+tf+"% "); 

nIndex= list.InsertItem (0,"90-100：  "+s9+"人 ");
 list.SetItemText(nIndex,1,"80-90 ：  "+s8+"人 ");
 list.SetItemText(nIndex,2,"70-80 ：  "+s7+"人 ");
 list.SetItemText(nIndex,3,"60-70 ：  "+s6+"人 ");
 list.SetItemText(nIndex,4,"不及格：  "+sf+"人 "); 

 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);
      
connection2.m_pRecordset->MoveNext();
}  

connection2.Unitialize(); 

}

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


}

if(chose==2)//按课程名称输出
{UpdateData(true);
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;
		d=TheValue.bstrVal;

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

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

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

		TheValue = connection2.m_pRecordset->Fields->GetItem("考试时间")->Value;
		h=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,"");

//找到教该课程的一个老师
flag=0;p9=0;p8=0;p7=0;p6=0;pf=0;  
connection3.Initialize();
sql.Format("select * from 选修 where 课程号='%s'and 教师号='%s'order by 学号 desc",course,e);
 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(); 
}

connection4.Initialize();
sql.Format("select * from 成绩 where 学号='%s'and 课程号='%s' ",number,course);
connection4.Connect(sql);
connection4.m_pRecordset->MoveFirst();
while(!connection4.m_pRecordset->adoEOF)
{   _variant_t TheValue; ///////////////////////
       CString usual,text,final;
        TheValue = connection4.m_pRecordset->Fields->GetItem("平时成绩")->Value;
		usual=TheValue.bstrVal;
		
		TheValue = connection4.m_pRecordset->Fields->GetItem("考试成绩")->Value;
		text=TheValue.bstrVal;

		TheValue = connection4.m_pRecordset->Fields->GetItem("总评成绩")->Value;
		final=TheValue.bstrVal;
				float Final=atof(final);
        if(Final>=90)p9++;
		if(Final>=80&&Final<90)p8++;
		if(Final>=70&&Final<80)p7++;
		if(Final>=60&&Final<70)p6++;
		if(Final<60)pf++;
        
		list.SetItemText(nIndex,3,usual);
		list.SetItemText(nIndex,4,text );
		list.SetItemText(nIndex,5,final );

		list.SetItemText(nIndex,3,usual);
		list.SetItemText(nIndex,4,text );
		list.SetItemText(nIndex,5,final );
		connection4.m_pRecordset->MoveNext();
}
connection4.Unitialize(); 
connection3.m_pRecordset->MoveNext();
}
connection3.Unitialize(); 
}

CString s9,s8,s7,s6,sf;
s9.Format("%0.0f",p9);
s8.Format("%0.0f",p8);
s7.Format("%0.0f",p7);
s6.Format("%0.0f",p6);
sf.Format("%0.0f",pf);

float r9=0,r8=0,r7=0,r6=0,rf=0;
float sum=0;
sum=p9+p8+p7+p6+pf;
if(sum!=0)
{
r9=(p9/sum)*100;
r8=(p8/sum)*100;
r7=(p7/sum)*100;
r6=(p6/sum)*100;
rf=(pf/sum)*100;}

CString t9,t8,t7,t6,tf;
t9.Format("%0.2f",r9);
t8.Format("%0.2f",r8);
t7.Format("%0.2f",r7);
t6.Format("%0.2f",r6);
tf.Format("%0.2f",rf);

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,"比例："+t9+"% ");
 list.SetItemText(nIndex,1,"比例 ："+t8+"% ");
 list.SetItemText(nIndex,2,"比例 ："+t7+"% ");
 list.SetItemText(nIndex,3,"比例 ："+t6+"% ");
 list.SetItemText(nIndex,4,"比例："+tf+"% "); 

nIndex= list.InsertItem (0,"90-100：  "+s9+"人 ");
 list.SetItemText(nIndex,1,"80-90 ：  "+s8+"人 ");
 list.SetItemText(nIndex,2,"70-80 ：  "+s7+"人 ");
 list.SetItemText(nIndex,3,"60-70 ：  "+s6+"人 ");
 list.SetItemText(nIndex,4,"不及格：  "+sf+"人 "); 

 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);
      
connection2.m_pRecordset->MoveNext();
}  
connection2.Unitialize(); 

}
12345

⌨️ 快捷键说明

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