高校學(xué)生就業(yè)管理系統(tǒng)方案

..目錄一、題目概述〔內(nèi)容及要求1二、需求分析12.1高校就業(yè)管理系統(tǒng)12.2高校就業(yè)管理系統(tǒng)數(shù)據(jù)流圖12.3高校就業(yè)系統(tǒng)管理系統(tǒng)功能框圖1三、概要設(shè)計(jì)23.1數(shù)據(jù)模型〔E-R圖23.2數(shù)據(jù)庫(kù)表格結(jié)構(gòu)設(shè)計(jì)2四、詳細(xì)設(shè)計(jì)34.1登錄界面34.2修改界面54.3查詢界面10五、軟件測(cè)試155.1劃分等價(jià)類并編號(hào)155.2有效測(cè)試用例155.3無效測(cè)試用例16六、總結(jié)16參考文獻(xiàn)16..一、題目概述〔內(nèi)容及要求實(shí)現(xiàn)院系、專業(yè)、畢業(yè)生信息管理〔設(shè)有就業(yè)標(biāo)志,初值為‘待業(yè)’；實(shí)現(xiàn)職業(yè)類型、職業(yè)信息〔職業(yè)號(hào)、類型號(hào)、需求數(shù)量、聘用數(shù)量、用人單位登記；實(shí)現(xiàn)畢業(yè)生就業(yè)登記〔學(xué)號(hào)、職業(yè)號(hào),自動(dòng)修改相應(yīng)學(xué)生的就業(yè)標(biāo)志和職業(yè)的聘用數(shù)量,并保證聘用數(shù)量不大于需求數(shù)量；創(chuàng)建存儲(chǔ)過程查詢畢業(yè)生的人數(shù)、待業(yè)人數(shù)、就業(yè)人數(shù)和就業(yè)率；創(chuàng)建存儲(chǔ)過程查詢各專業(yè)的畢業(yè)生就業(yè)率；創(chuàng)建check約束限制畢業(yè)生性別必須為‘男’或‘女’；建立表間關(guān)系。二、需求分析2.1高校就業(yè)管理系統(tǒng) 高校就業(yè)管理系統(tǒng)化可以完成對(duì)學(xué)生信息的修改、查詢〔就業(yè)率,已就業(yè)信息,未就業(yè)信息,公司信息、添加〔學(xué)生基本信息,院系信息,公司信息、退出功能。初步完成了對(duì)高校就業(yè)信息的管理,界面設(shè)計(jì)簡(jiǎn)潔,使用簡(jiǎn)單。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è)計(jì)3.1數(shù)據(jù)模型〔E-R圖圖3高校學(xué)生就業(yè)管理E_R圖3.2數(shù)據(jù)庫(kù)表格結(jié)構(gòu)設(shè)計(jì)表3.1學(xué)院信息表列名數(shù)據(jù)類型是否為空說明院系編號(hào)char<4>NOTNULL主鍵院系名稱char<20>NULL表3.2專業(yè)信息表列名數(shù)據(jù)類型是否為空說明專業(yè)編號(hào)char<6>NOTNULL主鍵專業(yè)名稱char<20>NULL表3.3員工信息表列名數(shù)據(jù)類型是否為空說明學(xué)號(hào)char<10>NULL職業(yè)號(hào)char<10>NULL表3.4用戶信息表列名數(shù)據(jù)類型是否為空說明用戶名char<10>NULL密碼char<10>NULL權(quán)限char<10>NULL表3.5用人單位信息表列名數(shù)據(jù)類型是否為空說明職業(yè)號(hào)char<10>NOTNULL主鍵類型號(hào)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è)編號(hào)char<6>NULL院系編號(hào)char<4>NULL就業(yè)標(biāo)志char<20>NULL初值為"待就業(yè)"表3.7職業(yè)信息表列名數(shù)據(jù)類型是否為空說明類型號(hào)char<10>NULL主鍵類型名稱char<20>NULL四、詳細(xì)設(shè)計(jì)4.1登錄界面登陸界面的設(shè)計(jì)如圖4.1所示：圖4.1登陸界面設(shè)計(jì)代碼如下：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<"用戶名或密碼錯(cuò)誤?。?！">;}else{Form1f2=newForm1<>;f2.Show<>;this.Hide<>;}DataConnection.CloseConn<>;}else{MessageBox.Show<"密碼為空?。。≌?qǐng)輸入">;}}else{MessageBox.Show<"用戶名為空?。?！請(qǐng)輸入">;}}privatevoidbutton2_Click<objectsender,EventArgse>{textBox1.Text="";textBox2.Text="";}4.2修改界面修改界面的設(shè)計(jì)如圖4.2所示：圖4.2修改界面設(shè)計(jì)代碼如下：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.類型號(hào)=type.類型號(hào)andprofesion_student.用人單位='"+comboBox1.Text.Trim<>+"'and類型名稱='"+comboBox4.Text.Trim<>+"'";intb=DataConnection.GetCountInfoBySql<a>;a="selectsum<聘用數(shù)量>fromprofesion_student,typewhereprofesion_student.類型號(hào)=type.類型號(hào)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é)號(hào)='"+id+"'";DataConnection.UpdateDate<sql>;sql="select學(xué)號(hào)fromemploymentwhere學(xué)號(hào)='"+id+"'";if<DataConnection.GetCountInfoBySql<sql>==0>{sql="insertintoemployment<學(xué)號(hào)>values<'"+id+"'>";DataConnection.UpdateDate<sql>;}strings="select職業(yè)號(hào)fromprofesion_student,typewhereprofesion_student.類型號(hào)=type.類型號(hào)andprofesion_student.用人單位='"+comboBox1.Text.Trim<>+"'and類型名稱='"+comboBox4.Text.Trim<>+"'";s=DataConnection.GetDataString<s>.Trim<>;sql="selectcount<*>fromemploymentwhere職業(yè)號(hào)='"+s+"'";intd=DataConnection.GetCountInfoBySql<sql>;sql="updateprofesion_studentset聘用數(shù)量="+d+"where職業(yè)號(hào)='"+s+"'";DataConnection.UpdateDate<sql>;sql="updateemploymentset職業(yè)號(hào)='"+s+"'where學(xué)號(hào)='"+id+"'";DataConnection.UpdateDate<sql>;}elseMessageBox.Show<"公司聘用數(shù)量已達(dá)上線?。?！">;}elseMessageBox.Show<"類型號(hào)為空?。?！請(qǐng)選擇">;}else{MessageBox.Show<"用人單位為空?。?！請(qǐng)選擇\n否則,將就業(yè)情況修改為待就業(yè)?。?！">;radioButton2.Checked=true;strings="updatestudent_infoset就業(yè)標(biāo)志='待就業(yè)'where學(xué)號(hào)='"+id+"'";DataConnection.UpdateDate<s>;stringsql="select學(xué)號(hào)fromemploymentwhere學(xué)號(hào)='"+id+"'";inth=DataConnection.GetCountInfoBySql<sql>;s="select職業(yè)號(hào)fromemploymentwhere學(xué)號(hào)='"+id+"'";s=DataConnection.GetDataString<s>.Trim<>;if<DataConnection.GetCountInfoBySql<sql>>0>{sql="deletefromemploymentwhere學(xué)號(hào)='"+id+"'";intf=DataConnection.UpdateDate<sql>;}sql="selectcount<*>fromemploymentwhere職業(yè)號(hào)='"+s+"'";intd=DataConnection.GetCountInfoBySql<sql>;sql="updateprofesion_studentset聘用數(shù)量="+d+"where職業(yè)號(hào)='"+s+"'";DataConnection.UpdateDate<sql>;}}elseMessageBox.Show<"學(xué)號(hào)為空?。?！請(qǐng)輸入">;}}privatevoidtabPage2_Click<objectsender,EventArgse>{comboBox2.Items.Clear<>;comboBox1.Items.Clear<>;<>;comboBox6.Items.Clear<>;radioButton3.Checked=false;radioButton1.Checked=false;radioButton2.Checked=false;radioButton4.Checked=false;stringsql="select專業(yè)名稱fromdepartmentorderby專業(yè)編號(hào)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院系編號(hào)asc";dr=DataConnection.GetSqlDataReader<sql>;while<dr.Read<>>{comboBox6.Items.Add<dr["院系名稱"]>;}if<textBox1.Text!="">{stringid=textBox1.Text.Trim<>;stringsql1="select姓名fromstudent_infowhere學(xué)號(hào)='"+id+"'";textBox2.Text=DataConnection.GetDataString<sql1>;sql1="select性別fromstudent_infowhere學(xué)號(hào)='"+id+"'";strings=DataConnection.GetDataString<sql1>;if<s=="男">radioButton4.Checked=true;if<s=="女">radioButton1.Checked=true;sql1="select出生年月fromstudent_infowhere學(xué)號(hào)='"+id+"'";textBox3.Text=DataConnection.GetDataString<sql1>;sql1="select籍貫fromstudent_infowhere學(xué)號(hào)='"+id+"'";textBox4.Text=DataConnection.GetDataString<sql1>;sql1="select專業(yè)名稱fromstudent_info,departmentwherestudent_info.專業(yè)編號(hào)=department.專業(yè)編號(hào)and學(xué)號(hào)='"+id+"'";comboBox2.Text=DataConnection.GetDataString<sql1>;sql1="select院系名稱fromstudent_info,academywherestudent_info.院系編號(hào)=academy.院系編號(hào)and學(xué)號(hào)='"+id+"'";comboBox6.Text=DataConnection.GetDataString<sql1>;sql1="select就業(yè)標(biāo)志fromstudent_infowhere學(xué)號(hào)='"+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è)號(hào)=employment.職業(yè)號(hào)andemployment.學(xué)號(hào)='"+id+"'";comboBox1.Text=DataConnection.GetDataString<sql1>;sql1="select類型名稱fromtype,profesion_student,employmentwheretype.類型號(hào)=profesion_student.類型號(hào)andprofesion_student.職業(yè)號(hào)=employment.職業(yè)號(hào)andemployment.學(xué)號(hào)='"+id+"'";comboBox4.Text=DataConnection.GetDataString<sql1>;}elseMessageBox.Show<"學(xué)號(hào)為空?。?！請(qǐng)輸入">;}privatevoidbutton1_Click<objectsender,EventArgse>{if<textBox1.Text!="">{stringsql="select院系編號(hào)fromacademywhere院系名稱='"+comboBox6.Text.Trim<>+"'";stringa=DataConnection.GetDataString<sql>.Trim<>;sql="select專業(yè)編號(hào)fromdepartmentwhere專業(yè)名稱='"+comboBox2.Text.Trim<>+"'";stringb=DataConnection.GetDataString<sql>.Trim<>;if<radioButton1.Checked==true>{sql="updatestudent_infoset性別='"+radioButton1.Text+"'where學(xué)號(hào)='"+textBox1.Text.Trim<>+"'";intg=DataConnection.UpdateDate<sql>;}if<radioButton4.Checked==true>{sql="updatestudent_infoset性別='"+radioButton4.Text+"'where學(xué)號(hào)='"+textBox1.Text.Trim<>+"'";intf=DataConnection.UpdateDate<sql>;}sql="updatestudent_infoset姓名='"+textBox2.Text.Trim<>+"',出生年月='"+textBox3.Text.Trim<>+"',籍貫='"+textBox4.Text.Trim<>+"',專業(yè)編號(hào)='"+b+"',院系編號(hào)='"+a+"'where學(xué)號(hào)='"+textBox1.Text.Trim<>+"'";intd=DataConnection.UpdateDate<sql>;}elseMessageBox.Show<"學(xué)號(hào)為空?。?！請(qǐng)輸入">;}4.3查詢界面查詢就業(yè)率界面的設(shè)計(jì)如圖4.3所示：圖4.3查詢就業(yè)率界面設(shè)計(jì)代碼如下：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è)編號(hào)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è)編號(hào)=department.專業(yè)編號(hào)and專業(yè)名稱='"+comboBox3.Text+"'";inta=DataConnection.GetCountInfoBySql<sql>;sql="selectcount<*>fromstudent_info,departmentwherestudent_info.專業(yè)編號(hào)=department.專業(yè)編號(hào)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è)為空?。。≌?qǐng)選擇….">;}查詢已就業(yè)信息界面的設(shè)計(jì)如圖4.4所示：圖4.4查詢已就業(yè)信息界面設(shè)計(jì)代碼如下：privatevoidtabPage4_Click<objectsender,EventArgse>{comboBox5.Items.Clear<>;comboBox7.Items.Clear<>;comboBox5.Text="";comboBox7.Text="";stringsql="select專業(yè)名稱fromdepartmentorderby專業(yè)編號(hào)asc";SqlDataReaderdr=DataConnection.GetSqlDataReader<sql>;while<dr.Read<>>{comboBox7.Items.Add<dr["專業(yè)名稱"]>;}sql="select院系名稱fromacademyorderby院系編號(hào)asc";dr=DataConnection.GetSqlDataReader<sql>;while<dr.Read<>>{comboBox5.Items.Add<dr["院系名稱"]>;}}privatevoidbutton3_Click<objectsender,EventArgse>{if<comboBox5.Text!="">{strings="selectc5.學(xué)號(hào),姓名,出生年月,籍貫,院系名稱,專業(yè)名稱,就業(yè)標(biāo)志,用人單位,類型名稱fromtyperightjoin<selectc4.學(xué)號(hào),姓名,出生年月,就業(yè)標(biāo)志,籍貫,院系名稱,專業(yè)名稱,c4.職業(yè)號(hào),類型號(hào),用人單位fromprofesion_studentrightjoin<selectc3.學(xué)號(hào),姓名,出生年月,就業(yè)標(biāo)志,籍貫,院系名稱,專業(yè)名稱,職業(yè)號(hào)fromdbo.employmentrightjoin<select學(xué)號(hào),姓名,出生年月,就業(yè)標(biāo)志,籍貫,院系名稱,專業(yè)名稱fromdepartmentjoin<select學(xué)號(hào),姓名,出生年月,就業(yè)標(biāo)志,籍貫,院系名稱,專業(yè)編號(hào)fromacademyjoin<select學(xué)號(hào),姓名,出生年月,院系編號(hào),籍貫,就業(yè)標(biāo)志,專業(yè)編號(hào)fromstudent_infowhere就業(yè)標(biāo)志='已就業(yè)'>c1onacademy.院系編號(hào)=c1.院系編號(hào)>c2ondepartment.專業(yè)編號(hào)=c2.專業(yè)編號(hào)>c3onemployment.學(xué)號(hào)=c3.學(xué)號(hào)>c4onprofesion_student.職業(yè)號(hào)=c4.職業(yè)號(hào)>c5ontype.類型號(hào)=c5.類型號(hào)where院系名稱='"+comboBox5.Text.Trim<>+"'orderbyc5.學(xué)號(hào)";dataGridView1.DataSource=DataConnection.GetDataSuoce<s>.Tables[0];}elseMessageBox.Show<"院系名稱為空?。?！請(qǐng)選擇">;}privatevoidbutton4_Click<objectsender,EventArgse>{if<comboBox7.Text!="">{strings="selectc5.學(xué)號(hào),姓名,出生年月,籍貫,院系名稱,專業(yè)名稱,就業(yè)標(biāo)志,用人單位,類型名稱fromtyperightjoin<selectc4.學(xué)號(hào),姓名,出生年月,就業(yè)標(biāo)志,籍貫,院系名稱,專業(yè)名稱,c4.職業(yè)號(hào),類型號(hào),用人單位fromprofesion_studentrightjoin<selectc3.學(xué)號(hào),姓名,出生年月,就業(yè)標(biāo)志,籍貫,院系名稱,專業(yè)名稱,職業(yè)號(hào)fromdbo.employmentrightjoin<select學(xué)號(hào),姓名,出生年月,就業(yè)標(biāo)志,籍貫,院系名稱,專業(yè)名稱fromdepartmentjoin<select學(xué)號(hào),姓名,出生年月,就業(yè)標(biāo)志,籍貫,院系名稱,專業(yè)編號(hào)fromacademyjoin<select學(xué)號(hào),姓名,出生年月,院系編號(hào),籍貫,就業(yè)標(biāo)志,專業(yè)編號(hào)fromstudent_infowhere就業(yè)標(biāo)志='已就業(yè)'>c1onacademy.院系編號(hào)=c1.院系編號(hào)>c2ondepartment.專業(yè)編號(hào)=c2.專業(yè)編號(hào)>c3onemployment.學(xué)號(hào)=c3.學(xué)號(hào)>c4onprofesion_student.職業(yè)號(hào)=c4.職業(yè)號(hào)>c5ontype.類型號(hào)=c5.類型號(hào)where專業(yè)名稱='"+comboBox7.Text.Trim<>+"'orderbyc5.學(xué)號(hào)";dataGridView1.DataSource=DataConnection.GetDataSuoce<s>.Tables[0];}elseMessageBox.Show<"專業(yè)名稱為空?。?！請(qǐng)選擇">;}查詢未就業(yè)信息界面的設(shè)計(jì)如圖4.5所示：圖4.5查詢未就業(yè)信息界面設(shè)計(jì)代碼如下：privatevoidtabPage5_Click<objectsender,EventArgse>{comboBox8.Items.Clear<>;comboBox9.Items.Clear<>;comboBox8.Text="";comboBox9.Text="";stringsql="select專業(yè)名稱fromdepartmentorderby專業(yè)編號(hào)asc";SqlDataReaderdr=DataConnection.GetSqlDataReader<sql>;while<dr.Read<>>{comboBox9.Items.Add<dr["專業(yè)名稱"]>;}sql="select院系名稱fromacademyorderby院系編號(hào)asc";dr=DataConnection.GetSqlDataReader<sql>;while<dr.Read<>>{comboBox8.Items.Add<dr["院系名稱"]>;}}privatevoidbutton5_Click<objectsender,EventArgse>{if<comboBox8.Text!="">{stringsql="selectstudent_info.學(xué)號(hào),姓名,出生年月,籍貫,院系名稱,專業(yè)名稱,就業(yè)標(biāo)志fromstudent_info,academy,departmentwherestudent_info.院系編號(hào)=academy.院系編號(hào)andstudent_info.專業(yè)編號(hào)=department.專業(yè)編號(hào)and就業(yè)標(biāo)志='待就業(yè)'and院系名稱='"+comboBox8.Text.Trim<>+"'orderbystudent_info.學(xué)號(hào)";dataGridView2.DataSource=DataConnection.GetDataSuoce<sql>.Tables[0];}elseMessageBox.Show<"院系名稱為空?。?！請(qǐng)選擇">;}privatevoidbutton6_Click<objectsender,EventArgse>{if<comboBox9.Text