..>--考試資料."高校學(xué)生就業(yè)管理系統(tǒng)"課程設(shè)計報告目錄12739一、題目概述〔內(nèi)容及要求〕114452二、需求分析11571911892312431612527三、概要設(shè)計2156493.1數(shù)據(jù)模型〔E-R圖〕228938328663四、詳細(xì)設(shè)計422567445795271931431557五、軟件測試23148192310482236778242933六、總結(jié)248896參考文獻(xiàn)25..>--考試資料.一、題目概述〔內(nèi)容及要求〕實(shí)現(xiàn)院系、專業(yè)、畢業(yè)生信息管理〔設(shè)有就業(yè)標(biāo)志，初值為‘待業(yè)’〕；實(shí)現(xiàn)職業(yè)類型、職業(yè)信息〔職業(yè)號、類型號、需求數(shù)量、聘用數(shù)量、用人單位〕登記；實(shí)現(xiàn)畢業(yè)生就業(yè)登記〔**、職業(yè)號〕，自動修改相應(yīng)學(xué)生的就業(yè)標(biāo)志和職業(yè)的聘用數(shù)量，并保證聘用數(shù)量不大于需求數(shù)量；創(chuàng)立存儲過程查詢畢業(yè)生的人數(shù)、待業(yè)人數(shù)、就業(yè)人數(shù)和就業(yè)率；創(chuàng)立存儲過程查詢各專業(yè)的畢業(yè)生就業(yè)率；創(chuàng)立check約束限制畢業(yè)生性別必須為‘男’或‘女’；建立表間關(guān)系。二、需求分析高校就業(yè)管理系統(tǒng)化可以完成對學(xué)生信息的修改、查詢〔就業(yè)率，已就業(yè)信息，未就業(yè)信息，公司信息〕、添加〔學(xué)生根本信息，院系信息，公司信息〕、退出功能。初步完成了對高校就業(yè)信息的管理，界面設(shè)計簡潔，使用簡單。圖2.1高校就業(yè)管理系統(tǒng)數(shù)據(jù)流圖圖2.2高校就業(yè)系統(tǒng)管理系統(tǒng)功能框圖三、概要設(shè)計模型〔E-R圖〕圖3高校學(xué)生就業(yè)管理E_R圖表3.1學(xué)院信息表列名數(shù)據(jù)類型是否為空說明院系char(4)NOTNULL主鍵院系名稱char(20)NULL表3.2專業(yè)信息表列名數(shù)據(jù)類型是否為空說明專業(yè)char(6)NOTNULL主鍵專業(yè)名稱char(20)NULL表3.3員工信息表列名數(shù)據(jù)類型是否為空說明**char(10)NULL職業(yè)號char(10)NULL表3.4用戶信息表列名數(shù)據(jù)類型是否為空說明用戶名char(10)NULL密碼char(10)NULL權(quán)限char(10)NULL表3.5用人單位信息表列名數(shù)據(jù)類型是否為空說明職業(yè)號char(10)NOTNULL主鍵類型號char(10)NULL需求數(shù)量intNULL聘用數(shù)量intNULL用人單位char(20)NULL表3.6學(xué)生信息表列名數(shù)據(jù)類型是否為空說明char(20)NULL性別char(2)NOTNULLCheck〔男，女〕出生年月char(10)NULL籍貫char(20)NULL專業(yè)char(6)NULL院系char(4)NULL就業(yè)標(biāo)志char(20)NULL初值為"待就業(yè)〞表3.7職業(yè)信息表列名數(shù)據(jù)類型是否為空說明類型號char(10)NULL主鍵類型名稱char(20)NULL四、詳細(xì)設(shè)計登陸界面的設(shè)計如圖4.1所示：圖4.1登陸界面設(shè)計代碼如下：privatevoidbutton1_Click(objectsender,EventArgse){if(te*tBo*1.Te*t!=""){if(te*tBo*2.Te*t!=""){DataConnection.getConn();stringid=te*tBo*1.Te*t.Trim();stringpwd=te*tBo*2.Te*t.Trim();stringsql="selectcount(*)from[login]where用戶名='"+id+"'and密碼='"+pwd+"'";intstate=DataConnection.GetCountInfoBySql(sql);if(state==0||state>1){MessageBo*.Show("用戶名或密碼錯誤！?。?);}else{Form1f2=newForm1();f2.Show();this.Hide();}DataConnection.CloseConn();}else{MessageBo*.Show("密碼為空?。。≌堓斎?);}}else{MessageBo*.Show("用戶名為空?。?！請輸入");}}privatevoidbutton2_Click(objectsender,EventArgse){te*tBo*1.Te*t="";te*tBo*2.Te*t="";}修改界面的設(shè)計如圖4.2所示：圖4.2修改界面設(shè)計代碼如下：privatevoidbutton7_Click(objectsender,EventArgse){if(te*tBo*1.Te*t!=""){stringid=te*tBo*1.Te*t.Trim();if(radioButton3.Checked==true){if(comboBo*1.Te*t!=""){if(comboBo*4.Te*t!=""){stringa="selectsum(需求數(shù)量)fromprofesion_student,typewhereprofesion_student.類型號=type.類型號andprofesion_student.用人單位='"+comboBo*1.Te*t.Trim()+"'and類型名稱='"+comboBo*4.Te*t.Trim()+"'";intb=DataConnection.GetCountInfoBySql(a);a="selectsum(聘用數(shù)量)fromprofesion_student,typewhereprofesion_student.類型號=type.類型號andprofesion_student.用人單位='"+comboBo*1.Te*t.Trim()+"'and類型名稱='"+comboBo*4.Te*t.Trim()+"'";intc=DataConnection.GetCountInfoBySql(a);if(c<b){stringsql="updatestudent_infoset就業(yè)標(biāo)志='已就業(yè)'where**='"+id+"'";DataConnection.UpdateDate(sql);sql="select**fromemploymentwhere**='"+id+"'";if(DataConnection.GetCountInfoBySql(sql)==0){sql="insertintoemployment(**)values('"+id+"')";DataConnection.UpdateDate(sql);}strings="select職業(yè)號fromprofesion_student,typewhereprofesion_student.類型號=type.類型號andprofesion_student.用人單位='"+comboBo*1.Te*t.Trim()+"'and類型名稱='"+comboBo*4.Te*t.Trim()+"'";s=DataConnection.GetDataString(s).Trim();sql="selectcount(*)fromemploymentwhere職業(yè)號='"+s+"'";intd=DataConnection.GetCountInfoBySql(sql);sql="updateprofesion_studentset聘用數(shù)量="+d+"where職業(yè)號='"+s+"'";DataConnection.UpdateDate(sql);sql="updateemploymentset職業(yè)號='"+s+"'where**='"+id+"'";DataConnection.UpdateDate(sql);}elseMessageBo*.Show("公司聘用數(shù)量已達(dá)上線?。。?);}elseMessageBo*.Show("類型號為空?。?！請選擇");}else{MessageBo*.Show("用人單位為空！?。≌堖x擇\n否則，將就業(yè)情況修改為待就業(yè)！??！");radioButton2.Checked=true;strings="updatestudent_infoset就業(yè)標(biāo)志='待就業(yè)'where**='"+id+"'";DataConnection.UpdateDate(s);stringsql="select**fromemploymentwhere**='"+id+"'";inth=DataConnection.GetCountInfoBySql(sql);s="select職業(yè)號fromemploymentwhere**='"+id+"'";s=DataConnection.GetDataString(s).Trim();if(DataConnection.GetCountInfoBySql(sql)>0){sql="deletefromemploymentwhere**='"+id+"'";intf=DataConnection.UpdateDate(sql);}sql="selectcount(*)fromemploymentwhere職業(yè)號='"+s+"'";intd=DataConnection.GetCountInfoBySql(sql);sql="updateprofesion_studentset聘用數(shù)量="+d+"where職業(yè)號='"+s+"'";DataConnection.UpdateDate(sql);}}elseMessageBo*.Show("**為空?。?！請輸入");}}privatevoidtabPage2_Click(objectsender,EventArgse){comboBo*2.Items.Clear();comboBo*1.Items.Clear();comboBo*4.Items.Clear();comboBo*6.Items.Clear();radioButton3.Checked=false;radioButton1.Checked=false;radioButton2.Checked=false;radioButton4.Checked=false;stringsql="select專業(yè)名稱fromdepartmentorderby專業(yè)asc";SqlDataReaderdr=DataConnection.GetSqlDataReader(sql);while(dr.Read()){comboBo*2.Items.Add(dr["專業(yè)名稱"]);}sql="selectdistinct用人單位fromprofesion_student";dr=DataConnection.GetSqlDataReader(sql);while(dr.Read()){comboBo*1.Items.Add(dr["用人單位"]);}sql="select類型名稱fromdbo.type";dr=DataConnection.GetSqlDataReader(sql);while(dr.Read()){comboBo*4.Items.Add(dr["類型名稱"]);}sql="select院系名稱fromacademyorderby院系asc";dr=DataConnection.GetSqlDataReader(sql);while(dr.Read()){comboBo*6.Items.Add(dr["院系名稱"]);}if(te*tBo*1.Te*t!=""){stringid=te*tBo*1.Te*t.Trim();stringsql1="selectfromstudent_infowhere**='"+id+"'";te*tBo*2.Te*t=DataConnection.GetDataString(sql1);sql1="select性別fromstudent_infowhere**='"+id+"'";strings=DataConnection.GetDataString(sql1);if(s=="男")radioButton4.Checked=true;if(s=="女")radioButton1.Checked=true;sql1="select出生年月fromstudent_infowhere**='"+id+"'";te*tBo*3.Te*t=DataConnection.GetDataString(sql1);sql1="select籍貫fromstudent_infowhere**='"+id+"'";te*tBo*4.Te*t=DataConnection.GetDataString(sql1);sql1="select專業(yè)名稱fromstudent_info,departmentwherestudent_info.專業(yè)=department.專業(yè)and**='"+id+"'";comboBo*2.Te*t=DataConnection.GetDataString(sql1);sql1="select院系名稱fromstudent_info,academywherestudent_info.院系=academy.院系and**='"+id+"'";comboBo*6.Te*t=DataConnection.GetDataString(sql1);sql1="select就業(yè)標(biāo)志fromstudent_infowhere**='"+id+"'";strings1=DataConnection.GetDataString(sql1).Trim();if(s1=="待就業(yè)"){radioButton2.Checked=true;}if(s1=="已就業(yè)"){radioButton3.Checked=true;}sql1="select用人單位fromprofesion_student,employmentwhereprofesion_student.職業(yè)號=employment.職業(yè)號andemployment.**='"+id+"'";comboBo*1.Te*t=DataConnection.GetDataString(sql1);sql1="select類型名稱fromtype,profesion_student,employmentwheretype.類型號=profesion_student.類型號andprofesion_student.職業(yè)號=employment.職業(yè)號andemployment.**='"+id+"'";comboBo*4.Te*t=DataConnection.GetDataString(sql1);}elseMessageBo*.Show("**為空?。?！請輸入");}privatevoidbutton1_Click(objectsender,EventArgse){if(te*tBo*1.Te*t!=""){stringsql="select院系fromacademywhere院系名稱='"+comboBo*6.Te*t.Trim()+"'";stringa=DataConnection.GetDataString(sql).Trim();sql="select專業(yè)fromdepartmentwhere專業(yè)名稱='"+comboBo*2.Te*t.Trim()+"'";stringb=DataConnection.GetDataString(sql).Trim();if(radioButton1.Checked==true){sql="updatestudent_infoset性別='"+radioButton1.Te*t+"'where**='"+te*tBo*1.Te*t.Trim()+"'";intg=DataConnection.UpdateDate(sql);}if(radioButton4.Checked==true){sql="updatestudent_infoset性別='"+radioButton4.Te*t+"'where**='"+te*tBo*1.Te*t.Trim()+"'";intf=DataConnection.UpdateDate(sql);}sql="updatestudent_infoset='"+te*tBo*2.Te*t.Trim()+"',出生年月='"+te*tBo*3.Te*t.Trim()+"',籍貫='"+te*tBo*4.Te*t.Trim()+"',專業(yè)='"+b+"',院系='"+a+"'where**='"+te*tBo*1.Te*t.Trim()+"'";intd=DataConnection.UpdateDate(sql);}elseMessageBo*.Show("**為空?。?！請輸入");}查詢就業(yè)率界面的設(shè)計如圖4.3所示：圖4.3查詢就業(yè)率界面設(shè)計代碼如下：privatevoidtabPage3_Click(objectsender,EventArgse){stringsql="selectcount(*)fromstudent_info";inta=DataConnection.GetCountInfoBySql(sql);label3.Te*t=a.ToString();sql="selectcount(*)fromstudent_infowhere就業(yè)標(biāo)志='已就業(yè)'";intb=DataConnection.GetCountInfoBySql(sql);label5.Te*t=b.ToString();sql="selectcount(*)fromstudent_infowhere就業(yè)標(biāo)志='待就業(yè)'";label4.Te*t=DataConnection.GetCountInfoBySql(sql).ToString();floatc=(float)b/a;label6.Te*t=c.ToString();comboBo*3.Items.Clear();sql="select專業(yè)名稱fromdepartmentorderby專業(yè)asc";SqlDataReaderdr=DataConnection.GetSqlDataReader(sql);while(dr.Read()){comboBo*3.Items.Add(dr["專業(yè)名稱"]);}comboBo*3.Te*t="";label10.Te*t="";}privatevoidbutton2_Click(objectsender,EventArgse){//comboBo*3.Te*t="";label10.Te*t="";if(comboBo*3.Te*t!=""){stringsql="selectcount(*)fromstudent_info,departmentwherestudent_info.專業(yè)=department.專業(yè)and專業(yè)名稱='"+comboBo*3.Te*t+"'";inta=DataConnection.GetCountInfoBySql(sql);sql="selectcount(*)fromstudent_info,departmentwherestudent_info.專業(yè)=department.專業(yè)and就業(yè)標(biāo)志='已就業(yè)'and專業(yè)名稱='"+comboBo*3.Te*t+"'";intb=DataConnection.GetCountInfoBySql(sql);if(a==0){label10.Te*t="該專業(yè)學(xué)生人數(shù)為0";}else{floatc=(float)b/a;label10.Te*t=c.ToString();}}elseMessageBo*.Show("專業(yè)為空?。?！請選擇….〞);}查詢已就業(yè)信息界面的設(shè)計如圖4.4所示：圖4.4查詢已就業(yè)信息界面設(shè)計代碼如下：privatevoidtabPage4_Click(objectsender,EventArgse){comboBo*5.Items.Clear();comboBo*7.Items.Clear();comboBo*5.Te*t="";comboBo*7.Te*t="";stringsql="select專業(yè)名稱fromdepartmentorderby專業(yè)asc";SqlDataReaderdr=DataConnection.GetSqlDataReader(sql);while(dr.Read()){comboBo*7.Items.Add(dr["專業(yè)名稱"]);}sql="select院系名稱fromacademyorderby院系asc";dr=DataConnection.GetSqlDataReader(sql);while(dr.Read()){comboBo*5.Items.Add(dr["院系名稱"]);}}privatevoidbutton3_Click(objectsender,EventArgse){if(comboBo*5.Te*t!=""){strings="selectc5.**,,出生年月,籍貫,院系名稱,專業(yè)名稱,就業(yè)標(biāo)志,用人單位,類型名稱fromtyperightjoin(selectc4.**,,出生年月,就業(yè)標(biāo)志,籍貫,院系名稱,專業(yè)名稱,c4.職業(yè)號,類型號,用人單位fromprofesion_studentrightjoin(selectc3.**,,出生年月,就業(yè)標(biāo)志,籍貫,院系名稱,專業(yè)名稱,職業(yè)號fromdbo.employmentrightjoin(select**,,出生年月,就業(yè)標(biāo)志,籍貫,院系名稱,專業(yè)名稱fromdepartmentjoin(select**,,出生年月,就業(yè)標(biāo)志,籍貫,院系名稱,專業(yè)fromacademyjoin(select**,,出生年月,院系,籍貫,就業(yè)標(biāo)志,專業(yè)fromstudent_infowhere就業(yè)標(biāo)志='已就業(yè)')c1onacademy.院系=c1.院系)c2ondepartment.專業(yè)=c2.專業(yè))c3onemployment.**=c3.**)c4onprofesion_student.職業(yè)號=c4.職業(yè)號)c5ontype.類型號=c5.類型號where院系名稱='"+comboBo*5.Te*t.Trim()+"'orderbyc5.**";dataGridView1.DataSource=DataConnection.GetDataSuoce(s).Tables[0];}elseMessageBo*.Show("院系名稱為空?。。≌堖x擇");}privatevoidbutton4_Click(objectsender,EventArgse){if(comboBo*7.Te*t!=""){strings="selectc5.**,,出生年月,籍貫,院系名稱,專業(yè)名稱,就業(yè)標(biāo)志,用人單位,類型名稱fromtyperightjoin(selectc4.**,,出生年月,就業(yè)標(biāo)志,籍貫,院系名稱,專業(yè)名稱,c4.職業(yè)號,類型號,用人單位fromprofesion_studentrightjoin(selectc3.**,,出生年月,就業(yè)標(biāo)志,籍貫,院系名稱,專業(yè)名稱,職業(yè)號fromdbo.employmentrightjoin(select**,,出生年月,就業(yè)標(biāo)志,籍貫,院系名稱,專業(yè)名稱fromdepartmentjoin(select**,,出生年月,就業(yè)標(biāo)志,籍貫,院系名稱,專業(yè)fromacademyjoin(select**,,出生年月,院系,籍貫,就業(yè)標(biāo)志,專業(yè)fromstudent_infowhere就業(yè)標(biāo)志='已就業(yè)')c1onacademy.院系=c1.院系)c2ondepartment.專業(yè)=c2.專業(yè))c3onemployment.**=c3.**)c4onprofesion_student.職業(yè)號=c4.職業(yè)號)c5ontype.類型號=c5.類型號where專業(yè)名稱='"+comboBo*7.Te*t.Trim()+"'orderbyc5.**";dataGridView1.DataSource=DataConnection.GetDataSuoce(s).Tables[0];}elseMessageBo*.Show("專業(yè)名稱為空?。?！請選擇");}查詢未就業(yè)信息界面的設(shè)計如圖4.5所示：圖4.5查詢未就業(yè)信息界面設(shè)計代碼如下：privatevoidtabPage5_Click(objectsender,EventArgse){comboBo*8.Items.Clear();comboBo*9.Items.Clear();comboBo*8.Te*t="";comboBo*9.Te*t="";stringsql="select專業(yè)名稱fromdepartmentorderby專業(yè)asc";SqlDataReaderdr=DataConnection.GetSqlDataReader(sql);while(dr.Read()){comboBo*9.Items.Add(dr["專業(yè)名稱"]);}sql="select院系名稱fromacademyorderby院系asc";dr=DataConnection.GetSqlDataReader(sql);while(dr.Read()){comboBo*8.Items.Add(dr["院系名稱"]);}}privatevoidbutton5_Click(objectsender,EventArgse){if(comboBo*8.Te*t!=""){stringsql="selectstudent_info.**,,出生年月,籍貫,院系名稱,專業(yè)名稱,就業(yè)標(biāo)志fromstudent_info,academy,departmentwherestudent_info.院系=academy.院系andstudent_info.專業(yè)=department.專業(yè)and就業(yè)標(biāo)志='待就業(yè)'and院系名稱='"+comboBo*8.Te*t.Trim()+"'orderbystudent_info.**";dataGridView2.DataSource=DataConnection.GetDataSuoce(sql).Tables[0];}elseMessageBo*.Show("院系名稱為空！??！請選擇");}privatevoidbutton6_Cl