學(xué)生選課系統(tǒng)-軟件工程課程設(shè)計(jì)報(bào)告

1、 （ 1圖 2-1 學(xué)生選課系統(tǒng)用例圖表 2-1 修改密碼用例的正常事件流圖和異常事件流圖用例名稱參與者管理員、教師、學(xué)生2管理員、教師、學(xué)生用戶進(jìn)行密碼修改，新密碼兩次2.系統(tǒng)檢查密碼格式是否相符3.系統(tǒng)檢查舊密碼是否正確4.面異常流返回密碼修改界面，提示舊密碼不正確，新密碼格式不符，兩次不同等密碼異常用戶舊密碼錯(cuò)誤表 2-2 提交成績(jī)用例的正常事件流圖和異常事件流圖提交成績(jī)用例提交選自己開(kāi)設(shè)課程的學(xué)生的成績(jī)進(jìn)入提交成績(jī)界面用戶成功登錄3.填寫學(xué)生成績(jī)，單擊提交成績(jī)異常流異常流用戶已經(jīng)提交過(guò)該門課程成績(jī)3提示該課程成績(jī)已提交，不能再次提交 4 圖 2-3 管理員修改課程信息順序圖 : 圖 2

2、-4 學(xué)生用戶退選課的順序圖 5: BaseUser: Teacher: Elect: 教師用戶3: 進(jìn)入老師界面4: 點(diǎn)擊提交成績(jī)”6: 驗(yàn)證是否已提交成績(jī)圖 2-5 教師提交成績(jī)順序圖 ) : Student驗(yàn)證是否課程時(shí)間沖突: Elect:學(xué)生用戶驗(yàn)證用戶身份圖 2-6 學(xué)生用戶選課協(xié)作圖 6: Teacher驗(yàn)證是否已提交: Elect驗(yàn)證用戶身份: BaseUser圖 2-7 教師提交成績(jī)協(xié)作圖 7圖 3-1 學(xué)生選課系統(tǒng)總體設(shè)計(jì)圖表 3-1 學(xué)生選課系統(tǒng)功能模塊表包含子功能模塊對(duì)教師的添加，修改，刪除，查詢操作管理員模塊對(duì)課程的添加，添加時(shí)為其分配任課教師，上課時(shí)間和地點(diǎn)，實(shí)現(xiàn)對(duì)

3、課程的修改，刪除，查看某個(gè)課程的詳細(xì)信息等8圖3-2 數(shù)據(jù)表之間的關(guān)系圖表3-3 Student學(xué)生用戶表字段類型123456stuNamestuDepartstuGradestuClassIntintint學(xué)生系院號(hào)學(xué)生年級(jí)學(xué)生班級(jí)表3-4 Teacher教師用戶表字段名teaIDteaPwd12nvarchar(20)not nullnvarchar(20)not null教師編號(hào)教師密碼934nvarchar(100)not nullInt(4)teaDepart教師系院號(hào)表3-5 Cource課程信息表字段類型23456teaID教師編號(hào)課程名稱上課時(shí)間上課地點(diǎn)課程簡(jiǎn)介courseNa

4、mecourseTimecourseAddresscourseInfoText表3-6 Elect選課信息表字段類型nvarchar(20)not nullnvarchar(20)not nullnvarchar(20)not nullint學(xué)生學(xué)號(hào)課程編號(hào)教師編號(hào)課程成績(jī)234courseIDteaIDScore表3-7 Users管理員表字段名adminNameadminPwd字段類型nvarchar(20)not nullnvarchar(20)12系統(tǒng)管理員用戶名系統(tǒng)管理員密碼表3-8 Depart系院表10字段類型Int not nullnvarchar(100)12系院號(hào)系院名稱d

5、epartName圖3-3 人機(jī)交互子系統(tǒng)結(jié)構(gòu)圖選課查看退課學(xué)生課程查看提交師 412結(jié)束圖 4-1 系統(tǒng)用戶登錄流程圖 13輸入用戶舊密碼、新密碼驗(yàn)證用戶密碼是否合法提示修改成功結(jié)束圖 4-2 用戶密碼修改流程圖提示已提交，不能再提交結(jié)束圖 4-3 教師提交成績(jī)流程圖14提示添加成功退出圖 4-4 管理員添加課程流程圖提示時(shí)間沖突，不能選修是結(jié)束圖 4-5 學(xué)生選修課程流程圖 15namespace MyElectCourse.DALpublicclass Databaseprotected string connectionString;protected SqlConnection co

6、nnection = null;public Database()connectionString =ConfigurationManager.ConnectionStringsConnectionString.ConnectionString.ToString();Database()if (connection != null)connection = null;protected void Open()if (connection = null)connection = new SqlConnection(connectionString);if (connection.State.Eq

7、uals(ConnectionState.Closed)connection.Open();protected void Close()if (connection != null)connection.Close();publicint ExecuteSQL(string sqlstr)16intcount = -1;this.Open();SqlCommand cmd = new SqlCommand(sqlstr, connection);count = cmd.ExecuteNonQuery();this.Close();return count;publicDataSet GetDa

8、taSet(string sqlstr)this.Open();DataSetds = new DataSet();SqlDataAdapter adapter = new SqlDataAdapter(sqlstr,connection);adapter.Fill(ds);this.Close();return ds;publicDataTable GetDataTable(string sqlstr)DataSetds = this.GetDataSet(sqlstr);DataTabledt = new DataTable();if (ds.Tables.Count 0)dt = ds.

9、Tables0;return dt;public SqlDataReaderGetDataReader(string sqlstr)this.Open();SqlCommand cmd = new SqlCommand(sqlstr, connection);SqlDataReadersdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);/this.Close();return sdr;namespace MyElectCourse.BLLpublicclass UserBase17private string userID;publ

10、icstring UserIDget return userID; set userID = value; private string userPSW;publicstring UserPSWget return userPSW; set userPSW = value; public string loginCheck(string uid, string upwd, string urole)String selectStr = String.Empty;switch (urole)case0:/身份為教師時(shí)selectStr = Select * from Teacher where

11、teaID = + uid + ;break;case1:/身份為學(xué)生時(shí)selectStr = Select * from Student where stuID = + uid + ;break;case2:/身份為管理員時(shí)selectStr = Select * from Users where adminName = + uid + ;break;default:returnnull;Database db = new Database();DataTabledt = db.GetDataTable(selectStr);if (dt.Rows.Count 0)/如果該用戶存在if (d

12、t.Rows01.ToString().Equals(upwd) /密碼正確switch (urole)case :return ;case :return ;case :/身份為教師時(shí)/身份為學(xué)生時(shí)/身份為管理員時(shí)18return ;default:return null;else/密碼錯(cuò)誤，給出提示信息！return-1;else/用戶不存在或用戶名輸入錯(cuò)誤return-2;publicstring modifyPWD(String urole, String uid, String oldPwd,String newPwd)String updateStr = String.Empty;

13、switch (urole)case0:/身份為教師時(shí)updateStr =update Teacher set teaPwd=+ newPwd + where teaID=+ uid +;break;case1:/身份為學(xué)生時(shí)updateStr =update Student set stuPwd=+ newPwd + where stuID=+ uid +;break;case2:/身份為管理員時(shí)updateStr =update Users set adminPwd=+ newPwd + where adminName=break;string ucheck = this.loginCh

14、eck(uid, oldPwd, urole);if (ucheck.Equals(0) | ucheck.Equals(1) | ucheck.Equals()intt = new Database().ExecuteSQL(updateStr);/根據(jù)修改后返回的結(jié)果給出提示if (t 0)return1;elsereturn0;elsereturn-1;19 title登錄頁(yè)面divtablealign=centerstyle=font-size:12px;font-family:Tahoma;border-collapse:collapsetrtd colspan=2style=tex

15、t-align: centerspan style=font-size: 24pt; font-family: 隸書(shū)學(xué)生選課系統(tǒng)trtddiv align=right用戶名/span：td style=width: 242pxasp:TextBox ID=txtUserNamerunat=server Width=150pxasp:RequiredFieldValidatorID=RequiredFieldValidator1 runat=serverErrorMessage=不能為空！trtd style=height: 32pxdiv align=right密碼：td style=heig

16、ht: 32px; width: 242px;asp:TextBox ID=txtPwd runat=server TextMode=Passwordtrtd colspan=2align=center style=height: 46pxasp:RadioButtonListID=rblClassrunat=serverRepeatDirection=Horizontal教師學(xué)生管理員20table id=table1 width=80% border=0 align=centertrspan style=font-size: 16pt;可選修課程trtdasp:GridViewID=Gri

17、dView1 runat=server AutoGenerateColumns=FalseWidth=100% BorderColor=#999999 BorderStyle=None BorderWidth=1pxDataSourceID=SqlDataSource1 GridLines=VerticalBackColor=WhiteCellPadding=3OnRowCommand=GridView1_RowCommandFont-Size=10pt DataKeyNames=courceID,teaIDasp:SqlDataSource ID=SqlDataSource1 runat=s

18、erver22ConnectionString=SelectCommand=SELECT Cource.courceID, Cource.teaID, Cource.courceName,Teacher.teaName, Cource.courceTime, Cource.courceAddress FROM Cource INNER JOIN Teacher ON Cource.teaID=Teacher.teaIDWHERENOTEXISTS(SELECT*FROMElectWHERE(courceID=Cource.courceIDandteaID=Cource.teaIDand stu

19、ID = stuID)trtdasp:Label runat=server ID=errormess ForeColor=RedFont-Size=Smallertd style=height: 24px; text-align: centerspan style=font-size: 16pt;您已經(jīng)選修的課程trtdasp:GridViewID=GridView2 runat=server AutoGenerateColumns=FalseBackColor=WhiteWidth=100% BorderColor=#999999 BorderStyle=None BorderWidth=1

20、pxCellPadding=3DataSourceID=SqlDataSource2 GridLines=VerticalOnRowCommand=GridView2_RowCommandDataKeyNames=stuID,courceID,teaIDaspBoundField DataField=teaID HeaderText=teaID ReadOnly=True23aspBoundField DataField=courceTime HeaderText=上課時(shí)間 SortExpression=courceTime:ButtonField HeaderText=退選 CommandN

21、ame=shanchu TextaspSqlDataSource ID=SqlDataSource2 runat=serverSelectParametersaspSessionParameter Name=stuID SessionField=userID /修改密碼退出系統(tǒng)form id=form1 runat=serverdivtable width=100% bgcolor=#ccccfftrtduc1:top ID=Top1 runat=server /table id=table1 width=400 border=0 runat=server align=centertr val

22、ign=toptd align=leftasp:Label ID=lblmessage Font-Size=10pt runat=server課程名稱：asp:TextBox runat=server ID=cnametrtd align=centerasp:GridView ID=GridView1 runat=server AutoGenerateColumns=FalseBackColor=WhiteBorderColor=#999999 BorderStyle=None BorderWidth=1px CellPadding=3Font-Size=10ptGridLines=Vertical Width=100%25trImageUrl=/Images/SubmitScore.GIFOnClick=imgBtnSubmitScore_Click /tdasp:HyperLink ID=HyperLink2 runat=server Font-Size=10ptNavigateUrl=/ModifyPwd.aspx修改密碼圖 5-3 教師用戶提交成績(jī)界面 t