程序設計方法學課程設計-寄宿管理系統(tǒng)

1、西安科技大學程序設計方法學課程設計報告題目： 寄宿管理系統(tǒng) 組號： 19 組 成員： 2014年7月9日目 錄 1 設計內(nèi)容及人員分工22 系統(tǒng)架構(gòu)設計及模塊設計63 實現(xiàn)效果及主要模塊代碼84 技術(shù)難點與解決方案365 總結(jié)37一、設計內(nèi)容與分工 1.設計內(nèi)容：設計內(nèi)容及需求描述：某寄宿學校需要開發(fā)一個信息管理系統(tǒng)，通過該管理系統(tǒng)可以對學生的日常事務進行管理：1. 系統(tǒng)在學生入學時，為其建立個人檔按，并由校長助理進行錄入。校長助理可對學生檔案進行管理，包括刪除，修改，查詢等操作。2. 每天由老師記錄考勤情況，然后由校長助理完成考勤錄入。3. 校長助理對班級進行管理，包括新增和刪除班級，進行學

2、生的編班和調(diào)班工作，查詢班級名冊等情況。4. 費用部分有收費和退費兩大模塊，由財務人員完成。每月的費用由財務人員根據(jù)規(guī)定錄入，所退費用由系統(tǒng)自動生成，5. 如果家長對收費、退費有疑問之處，可登陸系統(tǒng)進行查詢。該程序共有三個參與者：校長助理，財務人員，學生家長及七個用例圖：（1） 檔案管理：本用例提供了增加、刪除、查詢、修改學生檔按的功能。 圖11檔案管理用例 圖12學生表Student （2）管理班級:本用例提供了建立、刪除、修改班級,對學生進行編班和調(diào)班,查詢班級名冊的功能。 圖21班級管理用例 圖22班級表Class（3） 密碼修改：該用例提供了密碼修改功能 圖31密碼修改用例（4） 考勤

3、管理：該用例提供了各班考勤情況的錄入功能 圖41考勤管理用例 圖42考勤表Attendance（5） 財務管理：本用例提供了錄入費用、收費、退費以及查詢費用情況的功能。 圖51財務管理用例 圖52費用表Fee (6)疑問查詢：本用例提供了查詢費用情況以及考勤情況的功能。 圖31疑問查詢用例（7） 登陸：本用例提供了驗證用戶身份的功能。 圖71登陸用例 圖72角色表Role 人員分工如下：魏楠楠：班級管理(增，刪，改，查)，學生管理李 倩： 考勤錄入(錄入時默認當前日期)，密碼修改王青枝：登陸界面及相關(guān)菜單功能設計(選擇相應權(quán)限其他菜單顯灰)，家長疑問解答，數(shù)據(jù)庫備份 2 系統(tǒng)架構(gòu)設計及模塊設計

4、系統(tǒng)架構(gòu)設計圖：退費收費班級管理學生管理修改密碼修改密碼財務人員校長助理備份寄宿學校信息 管理登陸登陸學生家長登陸修改密碼疑問解答模塊設計實現(xiàn)如下： 寄宿學校信息系統(tǒng)財務人員校長助理學生家長班級管理學生管理數(shù)據(jù)庫備份修改密碼收退費修改密碼疑難解答修改密碼修改班級增加班級查詢費用查詢費用考勤刪除班級修改檔案增加檔案刪除檔案查詢信息錄入考勤查詢班級查詢3. 實現(xiàn)效果及主要模塊代碼1. 登陸界面的制作及確定控件的主要函數(shù)代碼void CLoginDlg1:OnOK() / TODO: Add extra validation hereCLoginSet2 recordset;CString strS

5、QL;CString m_type = ;UpdateData(TRUE);if(m_strUsername.IsEmpty()AfxMessageBox(請輸入用戶名！);return;if(m_strPassword.IsEmpty()AfxMessageBox(請輸入密碼！);return;switch(m_radio)case 0:m_type = 校長助理;break;case 1:m_type = 財務人員;break;case 2:m_type = 家長;break;if(!recordset.Open() MessageBox(數(shù)據(jù)加載失敗!,數(shù)據(jù)庫錯誤,MB_OK);retu

6、rn ;while(!recordset.IsEOF()if(recordset.m_Password = m_strPassword & recordset.m_Username = m_strUsername & recordset.m_Type = m_type)break;recordset.MoveNext();if(recordset.GetRecordCount()=0)recordset.Close();MessageBox(密碼錯誤或者無權(quán)限，請重新輸入！);m_strPassword=;/m_ctrUserPsw.SetFocus();/UpdateData(FALSE);

7、 elseCDialog:OnOK();2.登陸界面如下所示：3.主界面的調(diào)用4.校長助理負責學生，班級的管理和考勤的錄入情況。而它的管理功能包括增刪改查，以下以班級管理為例。4.1 查詢班級信息情況，與數(shù)據(jù)庫School中的表Class表相關(guān)聯(lián)，并將其顯示出來。m_ctrList.DeleteAllItems();m_ctrList.SetRedraw(FALSE);UpdateData(TRUE);CString strSQL;strSQL.Format( select * from Class );CClassSet m_recordset ;if(!m_recordset.Open(A

8、FX_DB_USE_DEFAULT_TYPE,strSQL)MessageBox(打開數(shù)據(jù)庫失敗!,數(shù)據(jù)庫錯誤,MB_OK);return ;char buffer20;int i=0;CString strTime;while(!m_recordset.IsEOF() ltoa(m_recordset.m_Cnumber,buffer,10);m_ctrList.InsertItem(i,m_recordset.m_Cno);m_ctrList.SetItemText(i,1,m_recordset.m_Cname);m_ctrList.SetItemText(i,2,buffer);i+;

9、m_recordset.MoveNext();m_recordset.Close();m_ctrList.SetRedraw(TRUE);4.2查詢單個班級情況void CClassDlg:OnQuery1() / TODO: Add your control notification handler code hereUpdateData();CString strSQL;strSQL.Format(select * from Class where Cno=%s,m_strCno);m_ctrList.DeleteAllItems();m_ctrList.SetRedraw(FALSE);

10、 CClassSet m_recordset ;if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL)MessageBox(打開數(shù)據(jù)庫失敗!,數(shù)據(jù)庫錯誤,MB_OK);return ;char buffer20;int i=0;CString strTime;while(!m_recordset.IsEOF()m_ctrList.InsertItem(i,m_recordset.m_Cno);m_ctrList.SetItemText(i,1,m_recordset.m_Cname);ltoa(m_recordset.m_Cnumber,buf

11、fer,10);m_ctrList.SetItemText(i,2,buffer);i+;m_recordset.MoveNext();m_recordset.Close();MessageBox(查詢班級成功！);m_ctrList.SetRedraw(TRUE);4.3增加班級信息，每添加一個班級數(shù)據(jù)庫中進行相應的數(shù)據(jù)增加。增加一組信息并刷新列表。void CClassDlg:OnZyes() / TODO: Add your control notification handler code hereUpdateData();if(m_strNCno.IsEmpty()AfxMessag

12、eBox(請輸入班級編號！);return;if(m_strNCname.IsEmpty()AfxMessageBox(請輸入班級姓名！);return; CString strSQL;strSQL.Format(select * from Class where Cno= %s,m_strNCno);CClassSet m_recordset ;if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL)MessageBox(打開數(shù)據(jù)庫失敗!,數(shù)據(jù)庫錯誤,MB_OK);return ;if(m_recordset.GetRecordCount()!

13、=0)m_recordset.Close();AfxMessageBox(該班級已經(jīng)存在，請重新輸入！);return;m_recordset.Close();if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE)MessageBox(打開數(shù)據(jù)庫失敗!,數(shù)據(jù)庫錯誤,MB_OK);return ;m_recordset.AddNew();m_recordset.m_Cno=m_strNCno; m_recordset.m_Cname = m_strNCname; m_recordset.m_Cnumber =0;m_recordset.Update();Mes

14、sageBox(增加班級成功！);m_recordset.Close();char buffer20;m_ctrList.InsertItem(0,m_recordset.m_Cno);/更新列表m_ctrList.SetItemText(0,1,m_recordset.m_Cname);m_ctrList.SetItemText(0,2,buffer);m_strNCno = _T(); /更新界面顯示m_strNCname = _T();UpdateData(FALSE);4.4修改班級信息void CClassDlg:OnXyes() / TODO: Add your control n

15、otification handler code hereUpdateData();if(m_strXCno.IsEmpty()AfxMessageBox(請輸入班級編號！);return; if(m_strXCname=)MessageBox(請輸入班級名稱！);return; if(m_strCnum=NULL)MessageBox(請輸入班級人數(shù)！);return; CString strSQL;strSQL.Format(select * from Class where Cno=%s,m_strXCno);CClassSet m_recordset ;if(!m_recordset.

16、Open(AFX_DB_USE_DEFAULT_TYPE,strSQL)MessageBox(打開數(shù)據(jù)庫失敗!,數(shù)據(jù)庫錯誤,MB_OK);return ;m_recordset.Edit();m_recordset.m_Cno=m_strXCno ; m_recordset.m_Cname = m_strXCname; m_recordset.m_Cnumber= m_strCnum ;m_recordset.Update();MessageBox(修改班級信息成功！);m_recordset.Close();char buffer20;m_ctrList.InsertItem(0,m_str

17、XCno); /更新列表 m_ctrList.SetItemText(0,1,m_strXCname); m_ctrList.SetItemText(0,2,buffer); m_strXCno = _T(); /更新界面顯示 m_strXCname = _T(); UpdateData(FALSE);4.5刪除班級void CClassDlg:OnDelete() / TODO: Add your control notification handler code hereint i = m_ctrList.GetSelectionMark();if(0i)AfxMessageBox(請選擇

18、一條記錄進行刪除！);return;CString strSQL;strSQL.Format(select * from Class where Cno = %s ,m_ctrList.GetItemText(i,0);CClassSet m_recordset ;if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL) MessageBox(打開數(shù)據(jù)庫失敗!,數(shù)據(jù)庫錯誤,MB_OK);return ;if(m_recordset.m_Cnumber!=0)MessageBox(表中含有數(shù)據(jù)不能刪除);elsem_recordset.Delete

19、();MessageBox(刪除班級成功！);m_recordset.Close(); UpdateData(FALSE);5. 密碼修改void Alterpassword:OnOK() / TODO: Add extra validation hereUpdateData();/增加新用戶的輸入檢查if(m_struser=)MessageBox(請?zhí)顚懹脩裘?;/m_ctrUser.SetFocus();return;if(m_strpass=) MessageBox(密碼不能為空，請輸入密碼！);/m_ctrPass.SetFocus();return;/驗證密碼與確認密碼是否一致i

20、f(m_strpass!=m_strppass) MessageBox(兩次輸入地密碼不一致，請重新輸入密碼！);/m_ctrPass.SetFocus();m_strpass = ;m_strppass = ;UpdateData(FALSE);return;/打開記錄集CString strSQL;strSQL.Format(select * from Role where Username=%s,m_struser);CLoginSet2 m_recordset;if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL)MessageBox(

21、打開數(shù)據(jù)庫失敗!,數(shù)據(jù)庫錯誤,MB_OK);return ;/判斷用戶是否已經(jīng)存在if(m_recordset.GetRecordCount()=0)m_recordset.Close();MessageBox(該用戶不存在！);return; m_recordset.Edit();m_recordset.m_Username =m_struser;m_recordset.m_Password = m_strpass;m_recordset.Update();MessageBox(密碼修改成功！請記住用戶名和密碼！);m_recordset.Close();CDialog:OnOK();6.

22、學生管理與班級管理大同小異，所以不做詳細介紹，下面是學生管理界面7備份void CCBEIFEN:OnChoice() / TODO: Add your control notification handler code here CFileDialog FileDlg(false, bak, .bak, OFN_OVERWRITEPROMPT | OFN_HIDEREADONLY, 數(shù)據(jù)庫文件(*.bak)|*.bak|); if(IDOK != FileDlg.DoModal()/打開打開文件對話框 return ;m_strpath = FileDlg.GetPathName();/獲取

23、選擇文件的路徑UpdateData(FALSE);/數(shù)據(jù)的更新void CCBEIFEN:OnOK() / TODO: Add extra validation hereUpdateData();/數(shù)據(jù)的更新CDatabase m_database;if(m_strpath = )/條件的判斷MessageBox(請選擇路徑!);/提示信息 m_database.Open(School);CString sql;/定義字符串變量sql.Format(Backup Database School to Disk = %s , m_strpath);m_database.ExecuteSQL(sq

24、l);MessageBox(備份數(shù)據(jù)庫成功！);m_database.Close();/關(guān)閉連接CDialog:OnOK();6.7.8. 考勤情況查詢與錄入如下，下面三錄入考勤代碼void CAttendDlg:OnEditlr() int i;UpdateData();if(m_Sno.IsEmpty()AfxMessageBox(請輸入學號！);return; CString strSQL;CTime current=CTime:GetCurrentTime();strSQL.Format(select * from Attendance where Sno= %s,m_Sno);CAt

25、tendSet1 m_recordset ;if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL)MessageBox(打開數(shù)據(jù)庫失敗!,數(shù)據(jù)庫錯誤,MB_OK);return ;/*if(m_recordset.GetRecordCount()!=0)m_recordset.Close();AfxMessageBox(該學號已經(jīng)存在，請重新輸入！);return;*/m_recordset.Close();if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE)MessageBox(打開數(shù)據(jù)庫失敗!,數(shù)據(jù)庫錯

26、誤,MB_OK);return ;m_recordset.AddNew();m_recordset.m_Sno=m_Sno; m_recordset.m_Date=m_Time; m_recordset.Update(); MessageBox(添加學生成功！);m_recordset.Close(); / temp.Format(%d,recordset.m_Sno);/m_ctrList.InsertItem(i,temp);m_ctrList.SetItemText(i,1,m_Sno);m_ctrList.SetItemText(i,2,m_Time);m_Sno = _T(); /更

27、新界面顯示m_Time = _T();UpdateData(FALSE);9. 費用表幾經(jīng)改動本來可以是實現(xiàn)功能的，但是現(xiàn)在由于數(shù)據(jù)庫表的改動，現(xiàn)在出現(xiàn)了問題，所以我只能將代碼拷下來。BOOL CChargeDlg:OnInitDialog()CDialog:OnInitDialog();/ TODO: Add extra initialization herem_ctrList1.InsertColumn(0,學號);m_ctrList1.SetColumnWidth(0,100);m_ctrList1.InsertColumn(1,月份);m_ctrList1.SetColumnWidth

28、(1,60);m_ctrList1.InsertColumn(2,伙食費);m_ctrList1.SetColumnWidth(2,80);m_ctrList1.InsertColumn(3,住宿費);m_ctrList1.SetColumnWidth(3,80);m_ctrList1.InsertColumn(4,空調(diào)費);m_ctrList1.SetColumnWidth(4,80);m_ctrList1.InsertColumn(5,取暖費);m_ctrList1.SetColumnWidth(5,80);m_ctrList1.InsertColumn(6,書本費);m_ctrList1

29、.SetColumnWidth(6,80);m_ctrList1.InsertColumn(7,應收費用);m_ctrList1.SetColumnWidth(7,80);m_ctrList1.InsertColumn(8,當月余額);m_ctrList1.SetColumnWidth(8,80); m_ctrList1.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES); CChargeSet1 m_recordset ;if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,select * fr

30、om Fee)MessageBox(打開數(shù)據(jù)庫失敗!,數(shù)據(jù)庫錯誤,MB_OK);return FALSE;m_recordset.Close();return TRUE;void CChargeDlg:OnUpdate() / TODO: Add your control notification handler code herem_ctrList1.DeleteAllItems();m_ctrList1.SetRedraw(FALSE);UpdateData(TRUE);CString strSQL; CChargeSet1 m_recordset ;strSQL.Format( sele

31、ct * from Fee );if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL)MessageBox(打開數(shù)據(jù)庫失敗!,數(shù)據(jù)庫錯誤,MB_OK);return ;int i=0;while(!m_recordset.IsEOF() char buffer20;m_ctrList1.InsertItem(i,m_recordset.m_FSno);itoa(m_recordset.m_Fmonth,buffer,10);m_ctrList1.SetItemText(i,1,buffer); itoa(m_recordset.m_Fhee,b

32、uffer,10);m_ctrList1.SetItemText(i,2,buffer); itoa(m_recordset.m_Fzee,buffer,10);m_ctrList1.SetItemText(i,3,buffer); itoa(m_recordset.m_Fkee,buffer,10); m_ctrList1.SetItemText(i,4,buffer); itoa(m_recordset.m_Fqee,buffer,10); m_ctrList1.SetItemText(i,5,buffer); itoa(m_recordset.m_Fsee,buffer,10); m_c

33、trList1.SetItemText(i,6,buffer);itoa(m_recordset.m_Fscharge ,buffer,10);m_ctrList1.SetItemText(i,7,buffer);itoa(m_recordset.m_Fcharge ,buffer,10);m_ctrList1.SetItemText(i,8,buffer);i+;m_recordset.MoveNext();m_recordset.Close();m_ctrList1.SetRedraw(TRUE);void CChargeDlg:OnQuery() / TODO: Add your con

34、trol notification handler code hereUpdateData();CString strSQL;strSQL.Format(select * from Fee where Sno=%s,m_strSno);m_ctrList1.DeleteAllItems();m_ctrList1.SetRedraw(FALSE); CChargeSet1 m_recordset ;if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL)MessageBox(打開數(shù)據(jù)庫失敗!,數(shù)據(jù)庫錯誤,MB_OK);return ;int i=0

35、;CString strTime;while(!m_recordset.IsEOF()char buffer20;/m_ctrList1.InsertItem(i,m_recordset.m_Fsno);itoa(m_recordset.m_Fmonth,buffer,10);m_ctrList1.SetItemText(i,1,buffer); itoa(m_recordset.m_Fhee,buffer,10);m_ctrList1.SetItemText(i,2,buffer); itoa(m_recordset.m_Fzee,buffer,10);m_ctrList1.SetItemT

36、ext(i,3,buffer); itoa(m_recordset.m_Fkee,buffer,10); m_ctrList1.SetItemText(i,4,buffer); itoa(m_recordset.m_Fqee,buffer,10); m_ctrList1.SetItemText(i,5,buffer); itoa(m_recordset.m_Fsee,buffer,10); m_ctrList1.SetItemText(i,6,buffer);itoa(m_recordset.m_Fscharge,buffer,10);m_ctrList1.SetItemText(i,7,bu

37、ffer); itoa(m_recordset.m_Fcharge,buffer,10); m_ctrList1.SetItemText(i,8,buffer);i+;m_recordset.MoveNext();m_recordset.Close();m_ctrList1.SetRedraw(TRUE);void CChargeDlg:OnTuifei() /退費/ TODO: Add your control notification handler code hereCChargeSet1 recordset;if(m_strcharge i)AfxMessageBox(請選擇一條記錄進

38、行計費！)return; CString strSQL; CChargeSet1 rs_yscharge; strSQL.Format(select * from Fee where Sno = %s,i); if(!rs_yscharge.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL) MessageBox(打開數(shù)據(jù)庫失敗!,數(shù)據(jù)庫錯誤,MB_OK); return ; if(rs_yscharge.GetRecordCount()=0) rs_yscharge.Close();return;m_strycharge=rs_yscharge.m_Fcharge ;

39、rs_yscharge.Close();UpdateData(FALSE);經(jīng)過同學的修改后填上了兩句代碼定義一個對象來獲取表格中的列函數(shù)： CString str = m_ctrList1.GetItemText(i,0);strSQL.Format(select * from Fee where Sno = %s,str);則總費用可以顯示。（4） 在家長進行疑問解答時，代碼如下： CparentSet m_recordset;m_ctrList.DeleteAllItems();m_ctrList.SetRedraw(FALSE);UpdateData(TRUE);CString str

40、SQL;char buffer20;if(m_strSno.IsEmpty()MessageBox(請輸入學生編號!);return;elsestrSQL.Format(select * from Fee where m_Fsno= %s ,m_strSno);if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL)MessageBox(打開數(shù)據(jù)庫失敗!,數(shù)據(jù)庫錯誤,MB_OK);return ;int i=0;CString strTime;while(!m_recordset.IsEOF()char buffer20;m_ctrList.In

41、sertItem(i,m_recordset.m_Sno);itoa(m_recordset.m_Fmonth,buffer,10);m_ctrList.SetItemText(i,1,buffer); itoa(m_recordset.m_Fhee,buffer,10);m_ctrList.SetItemText(i,2,buffer); itoa(m_recordset.m_Fzee,buffer,10);m_ctrList.SetItemText(i,3,buffer); itoa(m_recordset.m_Fkee,buffer,10); m_ctrList.SetItemText(

42、i,4,buffer); itoa(m_recordset.m_Fqee,buffer,10); m_ctrList.SetItemText(i,5,buffer); itoa(m_recordset.m_Fsee,buffer,10); m_ctrList.SetItemText(i,6,buffer);itoa(m_recordset.m_Fscharge ,buffer,10);m_ctrList.SetItemText(i,7,buffer);itoa(m_recordset.m_Fcharge ,buffer,10);m_ctrList.SetItemText(i,8,buffer)

43、;i+;m_recordset.MoveNext();i+;m_recordset.MoveNext();m_recordset.Close();m_ctrList.SetRedraw(TRUE);當代碼為上述時，根據(jù)學生學號則查詢不出該生費用情況。經(jīng)考慮到在學生表中用到了根據(jù)學號查詢學生檔案的函數(shù)，將該處代碼改為下面時則可以查詢出學生費用情況 UpdateData();CString strSQL;strSQL.Format(select * from Fee where Sno=%s,m_strName);m_ctrList.DeleteAllItems();m_ctrList.SetRe

44、draw(FALSE); CparentSet m_recordset ;if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL)MessageBox(打開數(shù)據(jù)庫失敗!,數(shù)據(jù)庫錯誤,MB_OK);return ;int i=0;CString strTime;while(!m_recordset.IsEOF() char buffer20;m_ctrList.InsertItem(i,m_recordset.m_Sno);itoa(m_recordset.m_Fmonth,buffer,10);m_ctrList.SetItemText(i,1,buffer);