有用代码.txt

是自己做的一个小的学生管理系统.希望对大家有用

void CStudentView::OnSelchangedTreeList(NMHDR* pNMHDR, LRESULT* pResult)
{
	
	NM_TREEVIEW* pNMTreeView = (NM_TREEVIEW*)pNMHDR;
	
	HTREEITEM hItem = m_tree_list.GetSelectedItem();
	m_list.DeleteAllItems();
	CClass Class;
	CDatabase db4;
	CStudent student(&db4);
	CString strStudentQuery;
	while(m_tree_list.GetItemData(hItem)>100)
	{
		strStudentQuery.Format("SELECT * FROM student WHERE class_id = %d",m_tree_list.GetItemData(hItem)); 



		if(student.Open(AFX_DB_USE_DEFAULT_TYPE,strStudentQuery))
		{
			CString nID , nAge;
			int i=0, j=1;
			CString strName, StrSex, strTemp,stremail,strtel,strqq,strpost,straddr;
			
			while(!student.IsEOF())
			{
				//学号
				student.GetFieldValue("stu_id", nID);
				m_list.InsertItem(i,nID);
				
				
				//姓名
				student.GetFieldValue("stu_name", strName);
				m_list.SetItemText(i, j++, strName);
				
				//性别
				student.GetFieldValue("stu_sex", StrSex);
				if(StrSex == '0')
				//char	m_wan[] = "女";
				m_list.SetItemText(i, j++, "女");
				else 
					m_list.SetItemText(i, j++, "男");
	
				
				//年龄
				student.GetFieldValue("stu_birth", nAge);
				m_list.SetItemText(i, j++, nAge);
				
				//家庭住址
				student.GetFieldValue("stu_address", straddr);
				m_list.SetItemText(i, j++, straddr);


				//电话
					student.GetFieldValue("stu_tel", strtel);
				m_list.SetItemText(i, j++, strtel);


				//邮编
				student.GetFieldValue("stu_post", strpost);
				m_list.SetItemText(i, j++, strpost);

				//E-mail
				student.GetFieldValue("stu_e_mail", stremail);
				m_list.SetItemText(i, j++, stremail);

				//QQ
				student.GetFieldValue("stu_qq", strqq);
				m_list.SetItemText(i, j++, strqq);
				
				j=1;
				i++;		
				student.MoveNext();
			}	
			//	SwitchData(student,true);
		}
		else
		{
			//	AfxMessageBox(CAdoTestApp::m_adoDB.GetLastErrorString());
		}
		break;
	}
}








(stuno,stuname,ssex,score,scorno,xueyuan,nianji,classname,birthday,political,address,tel)




void CStudentView::InitTreeList()
{
	m_tree_list.DeleteAllItems();
	
	CString strCollageQuery;
	strCollageQuery = "SELECT * FROM collage ORDER BY collage_id ASC";
	CDatabase db1;
	CCollage gi(&db1);
	gi.Open(AFX_DB_USE_DEFAULT_TYPE,strCollageQuery);
	
	while(!gi.IsEOF())
	{
		HTREEITEM collage = m_tree_list.InsertItem(gi.m_collage_name,0,0); 
		
		
		m_tree_list.SetItemData(collage,gi.m_collage_id);
		
		CString strSpecialityQuery;
		strSpecialityQuery.Format("SELECT * FROM speciality WHERE collage_id = %d",gi.m_collage_id);
		CDatabase db2;
		CSpeciality spec(&db2);
		spec.Open(AFX_DB_USE_DEFAULT_TYPE,strSpecialityQuery);
		
		HTREEITEM hSpeciality;
		while(!spec.IsEOF())
		{
			hSpeciality = m_tree_list.InsertItem(spec.m_spec_name,collage);
			
			m_tree_list.SetItemData(hSpeciality,spec.m_spec_id);
			
			
			CString strClassQuery;
			strClassQuery.Format("SELECT * FROM class WHERE spec_id = %d",spec.m_spec_id);
			CDatabase db3;
			CClass Class(&db3);
			Class.Open(AFX_DB_USE_DEFAULT_TYPE,strClassQuery);
			
			
			HTREEITEM hclass;
			while(!Class.IsEOF())
			{
				hclass = m_tree_list.InsertItem(Class.m_class_name,hSpeciality);
				
				m_tree_list.SetItemData(hclass,Class.m_class_id);	
				Class.MoveNext();
			}
			db3.Close();
			spec.MoveNext();  
		}
		
		db2.Close();
		gi.MoveNext();
		
	}
	db1.Close();
}



		HTREEITEM root=m_tcTest.InsertItem("西安工程大学",0,0);
	HTREEITEM subroot1=m_tcTest.InsertItem("纺织与材料学院",1,1,root);
	HTREEITEM subroot2=m_tcTest.InsertItem("人文社会科学学院",1,1,root);
	HTREEITEM subroot3=m_tcTest.InsertItem("环境与化学学院",1,1,root);
	HTREEITEM subroot4=m_tcTest.InsertItem("计算机科学学院",1,1,root);
	HTREEITEM subroot5=m_tcTest.InsertItem("机电工程学院",1,1,root);

	HTREEITEM subroot6=m_tcTest.InsertItem("体育部",1,1,root);

	m_tcTest.InsertItem("纺织工程",1,1,subroot1);
	m_tcTest.InsertItem("轻化工程",1,1,subroot1);
	m_tcTest.InsertItem("高分子材料与工程",1,1,subroot1);

	m_tcTest.InsertItem("法学系",1,1,subroot2);
	m_tcTest.InsertItem("文学系",1,1,subroot2);
	m_tcTest.InsertItem("英语系",1,1,subroot2);
	m_tcTest.InsertItem("马克思主义理论部",1,1,subroot2);

	m_tcTest.InsertItem("环境科学与工程系",1,1,subroot3);
	m_tcTest.InsertItem("建筑环境与设备工程系",1,1,subroot3);
	m_tcTest.InsertItem("化学工程系",1,1,subroot3);
	m_tcTest.InsertItem("生物工程系和市政工程系",1,1,subroot3);

	m_tcTest.InsertItem("计算机科学与技术",1,1,subroot4);
	m_tcTest.InsertItem("教育技术学",1,1,subroot4);
	m_tcTest.InsertItem("电子信息与科学",1,1,subroot4);


	m_tcTest.InsertItem("机械工程及自动化",1,1,subroot5);
	m_tcTest.InsertItem("工业设计",1,1,subroot5);






void CScoreDlg::OnSelchangeComboNo() 
{
	// TODO: Add your control notification handler code here
	int nIndex = m_comboNO.GetCurSel();	
	if(nIndex == CB_ERR)
		return;
	CString str;
	m_comboNO.GetLBText(nIndex,str);
	//根据课程号查找course表中的记录
	CCourseSet cSet;
	cSet.m_strFilter.Format("courseno = '%s' ", str);
	cSet.Open();
	if(!cSet.IsEOF())    ///如果打开记录集有记录
	{
		m_strNO = m_strCourseNO = str;
		m_strName = cSet.m_cname;
		m_strHours = cSet.m_hours;
		m_strOpen = cSet.m_copen;
		m_strHours.Format("%d", cSet.m_hours);
		m_strOpen.Format("%d", cSet.m_copen);
		m_fCredit = cSet.m_credit;
		UpdateData(FALSE);

	}

	if(cSet.IsOpen())
		cSet.Close();
}





void CXiugai::OnEditchangeComboCollageXiugai() 
{

	m_combo_spec_xiugai.ResetContent();
	// TODO: Add your control notification handler code here
	//CADDXINXI addxx;	
	CString strTemp; 
	m_combo_collage_xiugai.GetWindowText(strTemp);
	CString strCollageQuery;
	CString strSpecQuery;

	strCollageQuery.Format("SELECT * FROM collage WHERE collage_name ='%s'",strTemp);
	CDatabase db1;
	CCollage col(&db1);
    col.Open(AFX_DB_USE_DEFAULT_TYPE,strCollageQuery);
	strSpecQuery.Format("SELECT * FROM speciality WHERE collage_id = %d",col.m_collage_id);
	CDatabase db2;
	CSpeciality gi(&db2);
	gi.Open(AFX_DB_USE_DEFAULT_TYPE,strSpecQuery);
	
	int count = gi.GetRecordCount();

	if(count>0)
	{
		gi.MoveFirst();
		CString value;
		while(!gi.IsEOF())
		{
			
			gi.GetFieldValue("spec_name",gi.m_spec_name);
			 strTemp.Format("%s",gi.m_spec_name);
			 m_combo_spec_xiugai.AddString(strTemp);  
	
			gi.MoveNext();
			
		}
	}
	UpdateData(false);
 
 
 七彩雨 17:05:16

	m_combo_class_xiugai.ResetContent();

	CString strTemp; 
	m_combo_spec_xiugai.GetWindowText(strTemp);
	
	CString strClassQuery;
	CString strSpecQuery;

	strSpecQuery.Format("SELECT * FROM speciality WHERE spec_name ='%s'",strTemp);
	CDatabase db1;
	CSpeciality spec(&db1);
    spec.Open(AFX_DB_USE_DEFAULT_TYPE,strSpecQuery);

	strClassQuery.Format("SELECT * FROM class WHERE spec_id = %d",spec.m_spec_id);
	CDatabase db2;
	CClass gi(&db2);
	gi.Open(AFX_DB_USE_DEFAULT_TYPE,strClassQuery);
	
	int count = gi.GetRecordCount();

	if(count>0)
	{
		gi.MoveFirst();
		CString value;
		while(!gi.IsEOF())
		{
			
			gi.GetFieldValue("class_name",gi.m_class_name);
			 strTemp.Format("%s",gi.m_class_name);
			 m_combo_class_xiugai.AddString(strTemp);  
	
			gi.MoveNext();
			
		}
	}
	UpdateData(false); 
 




student2\n\nStuden\n\n\nStudent2.Document\nStuden Document






学号=dlg2.m_addstuno,姓名=dlg2.m_addstuname,数学=dlg2.m_addmaths,物理=dlg2.m_addphycical,化学=dlg2.m_addchmistry,英语=dlg2.m_addenglish,政治=dlg2.m_addpolitic


	  m_Set.m_column8=dlg.m_fmaths+dlg.m_fphysical+dlg.m_fchemistry+dlg.m_fenglish+dlg.m_fpolitic;
	  m_Set.m_column9=(float)(m_Set.m_column8/5);