高校學(xué)生就業(yè)標(biāo)準(zhǔn)管理系統(tǒng)

目錄一、題目概述（內(nèi)容及規(guī)定） 1二、需求分析 12.1高校就業(yè)管理系統(tǒng) 12.2高校就業(yè)管理系統(tǒng)數(shù)據(jù)流圖 12.3高校就業(yè)系統(tǒng)管理系統(tǒng)功能框圖 1三、概要設(shè)計 23.1數(shù)據(jù)模型（E-R圖） 23.2數(shù)據(jù)庫表格構(gòu)造設(shè)計 2四、詳細(xì)設(shè)計 34.1登錄界面 34.2修改界面 54.3查詢界面 10五、軟件測試 155.1劃分等價類并編號 155.2有效測試用例 155.3無效測試用例 16六、總結(jié) 16參照文獻(xiàn) 16一、題目概述（內(nèi)容及規(guī)定）實現(xiàn)院系、專業(yè)、畢業(yè)生信息管理（設(shè)有就業(yè)標(biāo)志，初值為‘待業(yè)’）；實現(xiàn)職業(yè)類型、職業(yè)信息（職業(yè)號、類型號、需求數(shù)量、聘任數(shù)量、用人單位）登記；實現(xiàn)畢業(yè)生就業(yè)登記（學(xué)號、職業(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)系。二、需求分析2.1高校就業(yè)管理系統(tǒng) 高校就業(yè)管理系統(tǒng)化可以完畢對學(xué)生信息修改、查詢（就業(yè)率，已就業(yè)信息，未就業(yè)信息，公司信息）、添加（學(xué)生基本信息，院系信息，公司信息）、退出功能。初步完畢了對高校就業(yè)信息管理，界面設(shè)計簡潔，使用簡樸。2.2高校就業(yè)管理系統(tǒng)數(shù)據(jù)流圖圖2.1高校就業(yè)管理系統(tǒng)數(shù)據(jù)流圖2.3高校就業(yè)系統(tǒng)管理系統(tǒng)功能框圖圖2.2高校就業(yè)系統(tǒng)管理系統(tǒng)功能框圖三、概要設(shè)計3.1數(shù)據(jù)模型（E-R圖）圖3高校學(xué)生就業(yè)管理E_R圖3.2數(shù)據(jù)庫表格構(gòu)造設(shè)計表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ù)類型與否為空闡明學(xué)號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è)計4.1登錄界面登陸界面設(shè)計如圖4.1所示：圖4.1登陸界面設(shè)計代碼如下：privatevoidbutton1_Click(objectsender，EventArgse){if(textBox1.Text!=""){if(textBox2.Text!=""){DataConnection.getConn();stringid=textBox1.Text.Trim();stringpwd=textBox2.Text.Trim();stringsql="selectcount(*)from[login]where顧客名='"+id+"'and密碼='"+pwd+"'";intstate=DataConnection.GetCountInfoBySql(sql);if(state==0||state>1){MessageBox.Show("顧客名或密碼錯誤?。?！");}else{Form1f2=newForm1();f2.Show();this.Hide();}DataConnection.CloseConn();}else{MessageBox.Show("密碼為空?。?！請輸入");}}else{MessageBox.Show("顧客名為空?。?！請輸入");}}privatevoidbutton2_Click(objectsender，EventArgse){textBox1.Text="";textBox2.Text="";}4.2修改界面修改界面設(shè)計如圖4.2所示：圖4.2修改界面設(shè)計代碼如下：privatevoidbutton7_Click(objectsender，EventArgse){if(textBox1.Text!=""){stringid=textBox1.Text.Trim();if(radioButton3.Checked==true){if(comboBox1.Text!=""){if(comboBox4.Text!=""){stringa="selectsum(需求數(shù)量)fromprofesion_student,typewhereprofesion_student.類型號=type.類型號andprofesion_student.用人單位='"+comboBox1.Text.Trim()+"'and類型名稱='"+comboBox4.Text.Trim()+"'";intb=DataConnection.GetCountInfoBySql(a);a="selectsum(聘任數(shù)量)fromprofesion_student,typewhereprofesion_student.類型號=type.類型號andprofesion_student.用人單位='"+comboBox1.Text.Trim()+"'and類型名稱='"+comboBox4.Text.Trim()+"'";intc=DataConnection.GetCountInfoBySql(a);if(c<b){stringsql="updatestudent_infoset就業(yè)標(biāo)志='已就業(yè)'where學(xué)號='"+id+"'";DataConnection.UpdateDate(sql);sql="select學(xué)號fromemploymentwhere學(xué)號='"+id+"'";if(DataConnection.GetCountInfoBySql(sql)==0){sql="insertintoemployment(學(xué)號)values('"+id+"')";DataConnection.UpdateDate(sql);}strings="select職業(yè)號fromprofesion_student,typewhereprofesion_student.類型號=type.類型號andprofesion_student.用人單位='"+comboBox1.Text.Trim()+"'and類型名稱='"+comboBox4.Text.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學(xué)號='"+id+"'";DataConnection.UpdateDate(sql);}elseMessageBox.Show("公司聘任數(shù)量已達(dá)上線！?。?);}elseMessageBox.Show("類型號為空?。。≌堖x取");}else{MessageBox.Show("用人單位為空?。。≌堖x取\n否則，將就業(yè)狀況修改為待就業(yè)?。。?);radioButton2.Checked=true;strings="updatestudent_infoset就業(yè)標(biāo)志='待就業(yè)'where學(xué)號='"+id+"'";DataConnection.UpdateDate(s);stringsql="select學(xué)號fromemploymentwhere學(xué)號='"+id+"'";inth=DataConnection.GetCountInfoBySql(sql);s="select職業(yè)號fromemploymentwhere學(xué)號='"+id+"'";s=DataConnection.GetDataString(s).Trim();if(DataConnection.GetCountInfoBySql(sql)>0){sql="deletefromemploymentwhere學(xué)號='"+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);}}elseMessageBox.Show("學(xué)號為空?。?！請輸入");}}privatevoidtabPage2_Click(objectsender，EventArgse){comboBox2.Items.Clear();comboBox1.Items.Clear();comboBox4.Items.Clear();comboBox6.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()){comboBox2.Items.Add(dr["專業(yè)名稱"]);}sql="selectdistinct用人單位fromprofesion_student";dr=DataConnection.GetSqlDataReader(sql);while(dr.Read()){comboBox1.Items.Add(dr["用人單位"]);}sql="select類型名稱fromdbo.type";dr=DataConnection.GetSqlDataReader(sql);while(dr.Read()){comboBox4.Items.Add(dr["類型名稱"]);}sql="select院系名稱fromacademyorderby院系編號asc";dr=DataConnection.GetSqlDataReader(sql);while(dr.Read()){comboBox6.Items.Add(dr["院系名稱"]);}if(textBox1.Text!=""){stringid=textBox1.Text.Trim();stringsql1="select姓名fromstudent_infowhere學(xué)號='"+id+"'";textBox2.Text=DataConnection.GetDataString(sql1);sql1="select性別fromstudent_infowhere學(xué)號='"+id+"'";strings=DataConnection.GetDataString(sql1);if(s=="男")radioButton4.Checked=true;if(s=="女")radioButton1.Checked=true;sql1="select出生年月fromstudent_infowhere學(xué)號='"+id+"'";textBox3.Text=DataConnection.GetDataString(sql1);sql1="select籍貫fromstudent_infowhere學(xué)號='"+id+"'";textBox4.Text=DataConnection.GetDataString(sql1);sql1="select專業(yè)名稱fromstudent_info,departmentwherestudent_info.專業(yè)編號=department.專業(yè)編號and學(xué)號='"+id+"'";comboBox2.Text=DataConnection.GetDataString(sql1);sql1="select院系名稱fromstudent_info,academywherestudent_info.院系編號=academy.院系編號and學(xué)號='"+id+"'";comboBox6.Text=DataConnection.GetDataString(sql1);sql1="select就業(yè)標(biāo)志fromstudent_infowhere學(xué)號='"+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.學(xué)號='"+id+"'";comboBox1.Text=DataConnection.GetDataString(sql1);sql1="select類型名稱fromtype,profesion_student,employmentwheretype.類型號=profesion_student.類型號andprofesion_student.職業(yè)號=employment.職業(yè)號andemployment.學(xué)號='"+id+"'";comboBox4.Text=DataConnection.GetDataString(sql1);}elseMessageBox.Show("學(xué)號為空！！！請輸入");}privatevoidbutton1_Click(objectsender，EventArgse){if(textBox1.Text!=""){stringsql="select院系編號fromacademywhere院系名稱='"+comboBox6.Text.Trim()+"'";stringa=DataConnection.GetDataString(sql).Trim();sql="select專業(yè)編號fromdepartmentwhere專業(yè)名稱='"+comboBox2.Text.Trim()+"'";stringb=DataConnection.GetDataString(sql).Trim();if(radioButton1.Checked==true){sql="updatestudent_infoset性別='"+radioButton1.Text+"'where學(xué)號='"+textBox1.Text.Trim()+"'";intg=DataConnection.UpdateDate(sql);}if(radioButton4.Checked==true){sql="updatestudent_infoset性別='"+radioButton4.Text+"'where學(xué)號='"+textBox1.Text.Trim()+"'";intf=DataConnection.UpdateDate(sql);}sql="updatestudent_infoset姓名='"+textBox2.Text.Trim()+"',出生年月='"+textBox3.Text.Trim()+"',籍貫='"+textBox4.Text.Trim()+"',專業(yè)編號='"+b+"',院系編號='"+a+"'where學(xué)號='"+textBox1.Text.Trim()+"'";intd=DataConnection.UpdateDate(sql);}elseMessageBox.Show("學(xué)號為空?。。≌堓斎?);}4.3查詢界面查詢就業(yè)率界面設(shè)計如圖4.3所示：圖4.3查詢就業(yè)率界面設(shè)計代碼如下：privatevoidtabPage3_Click(objectsender，EventArgse){stringsql="selectcount(*)fromstudent_info";inta=DataConnection.GetCountInfoBySql(sql);label3.Text=a.ToString();sql="selectcount(*)fromstudent_infowhere就業(yè)標(biāo)志='已就業(yè)'";intb=DataConnection.GetCountInfoBySql(sql);label5.Text=b.ToString();sql="selectcount(*)fromstudent_infowhere就業(yè)標(biāo)志='待就業(yè)'";label4.Text=DataConnection.GetCountInfoBySql(sql).ToString();floatc=(float)b/a;label6.Text=c.ToString();comboBox3.Items.Clear();sql="select專業(yè)名稱fromdepartmentorderby專業(yè)編號asc";SqlDataReaderdr=DataConnection.GetSqlDataReader(sql);while(dr.Read()){comboBox3.Items.Add(dr["專業(yè)名稱"]);}comboBox3.Text="";label10.Text="";}privatevoidbutton2_Click(objectsender，EventArgse){//comboBox3.Text="";label10.Text="";if(comboBox3.Text!=""){stringsql="selectcount(*)fromstudent_info,departmentwherestudent_info.專業(yè)編號=department.專業(yè)編號and專業(yè)名稱='"+comboBox3.Text+"'";inta=DataConnection.GetCountInfoBySql(sql);sql="selectcount(*)fromstudent_info,departmentwherestudent_info.專業(yè)編號=department.專業(yè)編號and就業(yè)標(biāo)志='已就業(yè)'and專業(yè)名稱='"+comboBox3.Text+"'";intb=DataConnection.GetCountInfoBySql(sql);if(a==0){label10.Text="該專業(yè)學(xué)生人數(shù)為0";}else{floatc=(float)b/a;label10.Text=c.ToString();}}elseMessageBox.Show(“專業(yè)為空?。。≌堖x取….”);}查詢已就業(yè)信息界面設(shè)計如圖4.4所示：圖4.4查詢已就業(yè)信息界面設(shè)計代碼如下：privatevoidtabPage4_Click(objectsender，EventArgse){comboBox5.Items.Clear();comboBox7.Items.Clear();comboBox5.Text="";comboBox7.Text="";stringsql="select專業(yè)名稱fromdepartmentorderby專業(yè)編號asc";SqlDataReaderdr=DataConnection.GetSqlDataReader(sql);while(dr.Read()){comboBox7.Items.Add(dr["專業(yè)名稱"]);}sql="select院系名稱fromacademyorderby院系編號asc";dr=DataConnection.GetSqlDataReader(sql);while(dr.Read()){comboBox5.Items.Add(dr["院系名稱"]);}}privatevoidbutton3_Click(objectsender，EventArgse){if(comboBox5.Text!=""){strings="selectc5.學(xué)號,姓名,出生年月,籍貫,院系名稱,專業(yè)名稱,就業(yè)標(biāo)志,用人單位,類型名稱fromtyperightjoin(selectc4.學(xué)號,姓名,出生年月,就業(yè)標(biāo)志,籍貫,院系名稱,專業(yè)名稱,c4.職業(yè)號,類型號,用人單位fromprofesion_studentrightjoin(selectc3.學(xué)號,姓名,出生年月,就業(yè)標(biāo)志,籍貫,院系名稱,專業(yè)名稱,職業(yè)號fromdbo.employmentrightjoin(select學(xué)號,姓名,出生年月,就業(yè)標(biāo)志,籍貫,院系名稱,專業(yè)名稱fromdepartmentjoin(select學(xué)號,姓名,出生年月,就業(yè)標(biāo)志,籍貫,院系名稱,專業(yè)編號fromacademyjoin(select學(xué)號,姓名,出生年月,院系編號,籍貫,就業(yè)標(biāo)志,專業(yè)編號fromstudent_infowhere就業(yè)標(biāo)志='已就業(yè)')c1onacademy.院系編號=c1.院系編號)c2ondepartment.專業(yè)編號=c2.專業(yè)編號)c3onemployment.學(xué)號=c3.學(xué)號)c4onprofesion_student.職業(yè)號=c4.職業(yè)號)c5ontype.類型號=c5.類型號where院系名稱='"+comboBox5.Text.Trim()+"'orderbyc5.學(xué)號";dataGridView1.DataSource=DataConnection.GetDataSuoce(s).Tables[0];}elseMessageBox.Show("院系名稱為空?。?！請選取");}privatevoidbutton4_Click(objectsender，EventArgse){if(comboBox7.Text!=""){strings="selectc5.學(xué)號,姓名,出生年月,籍貫,院系名稱,專業(yè)名稱,就業(yè)標(biāo)志,用人單位,類型名稱fromtyperightjoin(selectc4.學(xué)號,姓名,出生年月,就業(yè)標(biāo)志,籍貫,院系名稱,專業(yè)名稱,c4.職業(yè)號,類型號,用人單位fromprofesion_studentrightjoin(selectc3.學(xué)號,姓名,出生年月,就業(yè)標(biāo)志,籍貫,院系名稱,專業(yè)名稱,職業(yè)號fromdbo.employmentrightjoin(select學(xué)號,姓名,出生年月,就業(yè)標(biāo)志,籍貫,院系名稱,專業(yè)名稱fromdepartmentjoin(select學(xué)號,姓名,出生年月,就業(yè)標(biāo)志,籍貫,院系名稱,專業(yè)編號fromacademyjoin(select學(xué)號,姓名,出生年月,院系編號,籍貫,就業(yè)標(biāo)志,專業(yè)編號fromstudent_infowhere就業(yè)標(biāo)志='已就業(yè)')c1onacademy.院系編號=c1.院系編號)c2ondepartment.專業(yè)編號=c2.專業(yè)編號)c3onemployment.學(xué)號=c3.學(xué)號)c4onprofesion_student.職業(yè)號=c4.職業(yè)號)c5ontype.類型號=c5.類型號where專業(yè)名稱='"+comboBox7.Text.Trim()+"'orderbyc5.學(xué)號";dataGridView1.DataSource=DataConnection.GetDataSuoce(s).Tables[0];}elseMessageBox.Show("專業(yè)名稱為空?。?！請選取");}查詢未就業(yè)信息界面設(shè)計如圖4.5所示：圖4.5查詢未就業(yè)信息界面設(shè)計代碼如下：privatevoidtabPage5_Click(objectsender，EventArgse){comboBox8.Items.Clear();comboBox9.Items.Clear();comboBox8.Text="";comboBox9.Text="";stringsql="select專業(yè)名稱fromdepartmentorderby專業(yè)編號asc";SqlDataReaderdr=DataConnection.GetSqlDataReader(sql);while(dr.Read()){comboBox9.Items.Add(dr["專業(yè)名稱"]);}sql="select院系名稱fromacademyorderby院系編號asc";dr=DataConnection.GetSqlDataReader(sql);while(dr.Read()){comboBox8.Items.Add(dr["院系名稱"]);}}privatevoidbutton5_Click(objectsender，EventArgse){if(comboBox8.Text!=""){stringsql="selectstudent_info.學(xué)號,姓名,出生年月,籍貫,院系名稱,專業(yè)名稱,就業(yè)標(biāo)志fromstudent_info,academy,departmentwherestudent_info.院系編號=academy.院系編號andstudent_info.專業(yè)編號=department.專業(yè)編號and就業(yè)標(biāo)志='待就業(yè)'and院系名稱='"+comboBox8.Text.Trim()+"'orderbystudent_info.學(xué)號";dataGridView2.DataSource=DataConnection.GetDataSuoce(sql).Tables[0];}elseMessageBox.Show("院系名稱為空?。?！請選取");}privatevoidbutton6_Click(objectsender，EventArgse){if(comboBox9.Text!=""){stringsql="selectstude