学生选课系统-软件工程课程设计报告

1、 （ 1图 2-1 学生选课系统用例图表 2-1 修改密码用例的正常事件流图和异常事件流图用例名称参与者管理员、教师、学生2管理员、教师、学生用户进行密码修改，新密码两次2.系统检查密码格式是否相符3.系统检查旧密码是否正确4.面异常流返回密码修改界面，提示旧密码不正确，新密码格式不符，两次不同等密码异常用户旧密码错误表 2-2 提交成绩用例的正常事件流图和异常事件流图提交成绩用例提交选自己开设课程的学生的成绩进入提交成绩界面用户成功登录3.填写学生成绩，单击提交成绩异常流异常流用户已经提交过该门课程成绩3提示该课程成绩已提交，不能再次提交 4 图 2-3 管理员修改课程信息顺序图 : 图 2

2、-4 学生用户退选课的顺序图 5: BaseUser: Teacher: Elect: 教师用户3: 进入老师界面4: 点击提交成绩”6: 验证是否已提交成绩图 2-5 教师提交成绩顺序图 ) : Student验证是否课程时间冲突: Elect:学生用户验证用户身份图 2-6 学生用户选课协作图 6: Teacher验证是否已提交: Elect验证用户身份: BaseUser图 2-7 教师提交成绩协作图 7图 3-1 学生选课系统总体设计图表 3-1 学生选课系统功能模块表包含子功能模块对教师的添加，修改，删除，查询操作管理员模块对课程的添加，添加时为其分配任课教师，上课时间和地点，实现对

3、课程的修改，删除，查看某个课程的详细信息等8图3-2 数据表之间的关系图表3-3 Student学生用户表字段类型123456stuNamestuDepartstuGradestuClassIntintint学生系院号学生年级学生班级表3-4 Teacher教师用户表字段名teaIDteaPwd12nvarchar(20)not nullnvarchar(20)not null教师编号教师密码934nvarchar(100)not nullInt(4)teaDepart教师系院号表3-5 Cource课程信息表字段类型23456teaID教师编号课程名称上课时间上课地点课程简介courseNa

4、mecourseTimecourseAddresscourseInfoText表3-6 Elect选课信息表字段类型nvarchar(20)not nullnvarchar(20)not nullnvarchar(20)not nullint学生学号课程编号教师编号课程成绩234courseIDteaIDScore表3-7 Users管理员表字段名adminNameadminPwd字段类型nvarchar(20)not nullnvarchar(20)12系统管理员用户名系统管理员密码表3-8 Depart系院表10字段类型Int not nullnvarchar(100)12系院号系院名称d

5、epartName图3-3 人机交互子系统结构图选课查看退课学生课程查看提交师 412结束图 4-1 系统用户登录流程图 13输入用户旧密码、新密码验证用户密码是否合法提示修改成功结束图 4-2 用户密码修改流程图提示已提交，不能再提交结束图 4-3 教师提交成绩流程图14提示添加成功退出图 4-4 管理员添加课程流程图提示时间冲突，不能选修是结束图 4-5 学生选修课程流程图 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:/身份为教师时selectStr = Select * from Teacher where

11、teaID = + uid + ;break;case1:/身份为学生时selectStr = Select * from Student where stuID = + uid + ;break;case2:/身份为管理员时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 :/身份为教师时/身份为学生时/身份为管理员时18return ;default:return null;else/密码错误，给出提示信息！return-1;else/用户不存在或用户名输入错误return-2;publicstring modifyPWD(String urole, String uid, String oldPwd,String newPwd)String updateStr = String.Empty;

13、switch (urole)case0:/身份为教师时updateStr =update Teacher set teaPwd=+ newPwd + where teaID=+ uid +;break;case1:/身份为学生时updateStr =update Student set stuPwd=+ newPwd + where stuID=+ uid +;break;case2:/身份为管理员时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);/根据修改后返回的结果给出提示if (t 0)return1;elsereturn0;elsereturn-1;19 title登录页面divtablealign=centerstyle=font-size:12px;font-family:Tahoma;border-collapse:collapsetrtd colspan=2style=tex

15、t-align: centerspan style=font-size: 24pt; font-family: 隶书学生选课系统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教师学生管理员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;您已经选修的课程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=上课时间 SortExpression=courceTime:ButtonField HeaderText=退选 CommandN

21、ame=shanchu TextaspSqlDataSource ID=SqlDataSource2 runat=serverSelectParametersaspSessionParameter Name=stuID SessionField=userID /修改密码退出系统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 教师用户提交成绩界面 t