网上选课系统项目报告.doc

网上选课系统项目报告目录第一章 需求分析41.1概念分析41.2系统分析51.2.1学生选课子系统页面设计51.2.2 教师管理子系统界面设计51.2.3.管理员管理子系统界面设计51.3功能分析61.3.1功能模块图设计61.4用例图设计61.4.1学生用例图设计61.4.2教师用例图设计71.4.3管理员用例图设计7第二章 系统设计72.1总体设计82.2数据库设计82.2.1部门表设计82.2.2专业表设计92.2.3班级表设计92.2.4学期表设计92.2.6教师表设计102.2.7学生表设计102.2.9课程表设计112.2.10教师课程关系表设计112.3表间关系图122.3.1UV_Base_Major122.3.2UV_Base_Class122.3.4UV_Select_TeacheSubjectReleation132.3.5UV_Select_StudenSubjectReleation132.3.6UV_Select_SelectSubjectVerify14第三章 程序设计143.1网上选课系统后台程序实现143.1.1母版页设计143.1.2基本信息管理页面设计153.2网上选课系统前台程序实现163.2.1系统注册页面设计163.2.2学生选课页面设计163.2.3教师任务查看页面设计17第四章 编码设计174.1班级管理的编码174.2专业管理的编码194.3课程管理的编码204.4学期管理的编码21第五章 编码测试235.1页面测试235.2数据表测试23第六章 部署维护241.242.243.244.245.256.257.26第一章 需求分析1.1概念分析学生网上选课系统用于根据教学计划、教师资源等，制定每学期的课程表及相关信息，面对的用户包括系统管理员、教师和学生。因此该系统的功能模块应分为系统姑那里远需求、教师需求、学生需求三个部分。管理员可以通过超级用户身份登录，对系统进行全面的管理维护，老师、学生以不同用户的身份进入不同的界面，执行不同的操作。该系统为学生主要提供选课服务，因此学生可以直接查看选课情况，学生可以根据本人学号和密码登陆系统，进行相关操作。此外还应附带其他服务，如实核对个人信息，查看教师信息、课程信息以便选课，查看自己选课结果，查询考试成绩等。查询的功能需求：（1）说明：此功能是学生可以查询本学期的开课计划，包括课程的详细信息，专业课查询，选修课查询，已选课查询等。（2）录入：通过友好的交互界面，使学生通过点击鼠标就可以实现各种查询功能。（3）加工：系统通过点击鼠标所提交的查询请求，利用数据系统的查询功能查询出符合要求的记录。（4）输出：在屏幕上显示查询后的结果，通常以 报表的形式显示。1.2系统分析1.2.1学生选课子系统页面设计客户端可以为学生提供网上选课的过程，学生通过选择身份登录，进入选课系统，然后进行选课，提交的选课结果传到服务器端，便于接下来的教师打分。教师打完分数后，学生登录后可以查询个人或其他人的成绩。首先进入选择登录身份界面，点击“登录”之后进入选择操作界面，包括“选修”“查看选课结果”、“查询成绩”。1.2.2 教师管理子系统界面设计客户端可以为教师提供网上查看学生选课信息、打分、统计的过程，教师通过选择身份登录，进入选课系统，然后进行学生选课信息，为学生打分，提交的分数传到服务器端，便于接下来的学生查询分数。首先进入选择登录身份界面，点击“登录”之后进入选择操作界面，包括“学生选课信息”、“打分”、“统计”。1.2.3.管理员管理子系统界面设计 客户端有为教师提供网上管理学生、管理教师、管理课程的过程，管理员通过选择身份登录，进入选课系统，然后可以选择学生管理，管理教师或管理课程，管理员的请求被提交到服务器端，满足用户的要求。首先进入选择登录身份界面，点击“登录”之后进入选择操作界面，包括“管理学生”“管理教师”、“管理课程”。1.3功能分析1.3.1功能模块图设计1.4用例图设计1.4.1学生用例图设计1.4.2教师用例图设计1.4.3管理员用例图设计第二章 系统设计2.1总体设计2.2数据库设计2.2.1部门表设计2.2.2专业表设计2.2.3班级表设计2.2.4学期表设计2.2.5职称表设计2.2.6教师表设计2.2.7学生表设计2.2.8课程类型表设计2.2.9课程表设计2.2.10教师课程关系表设计2.2.11学生课程关系表设计2.3表间关系图2.3.1UV_Base_Major2.3.2UV_Base_Class2.3.3UV_Base_ Subject2.3.4UV_Select_TeacheSubjectReleation2.3.5UV_Select_StudenSubjectReleation 2.3.6UV_Select_SelectSubjectVerify第三章 程序设计3.1网上选课系统后台程序实现3.1.1母版页设计3.1.2基本信息管理页面设计 3.1.3教学任务分配设计3.2网上选课系统前台程序实现3.2.1系统注册页面设计3.2.2学生选课页面设计3.2.3教师任务查看页面设计第四章 编码设计4.1班级管理的编码public partial class Admin_SelectSubject_ClassManage : System.Web.UI.Page private string sql = ; protected void Page_Load(object sender, EventArgs e) if (!Page.IsPostBack) InitPageData(); private void InitPageData() String operFlag = Request.QueryStringoperFlag; if (operFlag = null) operFlag = add; if (modify.Equals(operFlag) String classID = Request.QueryStringID; sql = SELECT ID,MajorID,ClassNo,ClassName,Remark FROM UT_Base_Class where ID= + classID; DataTable dtClass = CommonUtils.GetTableBySql(sql).Copy(); txtNo.Text = Convert.ToString(dtClass.Rows0classNo); txtName.Text = Convert.ToString(dtClass.Rows0className); ddlMajor.SelectedValue = Convert.ToString(dtClass.Rows0majorID); txtRemark.Text = Convert.ToString(dtClass.Rows0Remark); Session.Add(CommonUtils.Session_ClassID, dtClass.Rows0ID); btnAdd.Visible = false; btnModify.Visible = true; btnQuery.Visible = false; else btnAdd.Visible = true; btnModify.Visible = false; btnQuery.Visible = true; sql = SELECT ID,ClassNo,ClassName,MajorName,DepartName FROM UV_Base_Class where 1=1 ; CommonUtils.ECGridView(gdvClass, sql); sql = select ID,majorName from ut_base_major; CommonUtils.ECDropDownList(ddlMajor, sql, majorName, ID, true); protected void btnQuery_Click(object sender, EventArgs e) sql = SELECT ID,ClassNo,ClassName,MajorName,DepartName FROM UV_Base_Class where 1=1 ; String tmp = ; tmp = txtNo.Text.Trim(); if (!.Equals(tmp) sql += and classNo= + tmp + ; tmp = txtName.Text.Trim(); if (!.Equals(tmp) sql += and className like % + tmp + %; tmp = txtRemark.Text.Trim(); if (!.Equals(tmp) sql += and classRemark like % + tmp + %; tmp = ddlMajor.SelectedValue; if (!tmp.Equals(CommonUtils.DDL_First_Item_Value) sql += and MajorID= + tmp + ; CommonUtils.ECGridView(gdvClass, sql); protected void btnAdd_Click(object sender, EventArgs e) sql = insert into UT_Base_Class (MajorID,ClassNo,ClassName,Remark ) values(; sql += ddlMajor.SelectedValue + ,; sql += txtNo.Text.Trim() + ,; sql += txtName.Text.Trim() + ,; sql += txtRemark.Text.Trim() + ); int result = CommonUtils.OperateData(sql); if (result = 1) Response.Write(alert(班级添加成功！);); else Response.Write(alert(班级添加失败！);); protected void btnModify_Click(object sender, EventArgs e) sql = update UT_Base_Class set ; sql += MajorID= + ddlMajor.SelectedValue + ,; sql += ClassNo= + txtNo.Text.Trim() + ,; sql += ClassName= + txtName.Text.Trim() + ,; sql += Remark= + txtRemark.Text.Trim() + ; sql += where ID= + Convert.ToString(SessionCommonUtils.Session_ClassID); Session.Remove(CommonUtils.Session_ClassID); int result = CommonUtils.OperateData(sql); if (result = 1) Response.Write(alert(班级信息修改成功！);); else Response.Write(alert(班级信息修改失败！);); protected void btnDel_Click(object sender, EventArgs e) int count = 0; for (int i = 0; i gdvClass.Rows.Count; i+) CheckBox cbx = (CheckBox)this.gdvClass.Rowsi.FindControl(cbxDelOper); if (cbx.Checked = true) Label lblClassID = (Label)this.gdvClass.Rowsi.FindControl(lblClassID); string classID = lblClassID.Text; sql = delete from UT_Base_Class where ID= + classID; int count1 = CommonUtils.OperateData(sql); if (count1 != 0) count+; Response.Write(alert(共删除 + count + 个班级);); InitPageData(); protected void gdvClass_PageIndexChanging(object sender, GridViewPageEventArgs e) gdvClass.PageIndex = e.NewPageIndex; InitPageData(); protected void txtNo_TextChanged(object sender, EventArgs e) string classNo = txtNo.Text.Trim(); sql = select count(*) from UT_Base_Class where ClassNo= + classNo + ; bool isExist = false; int result = Convert.ToInt32(CommonUtils.GetScalarBySql(sql); if (result 0) isExist = true; if (isExist) this.lblClassExist.Visible = true; this.txtNo.Focus();/ else this.lblClassExist.Visible = false; this.txtName.Focus(); 4.2专业管理的编码public partial class Admin_SelectSubject_MajorManage : System.Web.UI.Page String sql = ; protected void Page_Load(object sender, EventArgs e) if (!Page.IsPostBack) InitPageData(); private void InitPageData() sql = SELECT ID,DepartmentID,MajorNo,MajorName,DepartNo,DepartName,ParentID,DepartRemark FROM UV_Base_Major; CommonUtils.ECGridView(this.gdvMajor, sql); sql = SELECT ID,DepartNo,DepartName,ParentID,Remark FROM UT_Base_Department; CommonUtils.ECDropDownList(this.ddlDepartment, sql, DepartName, ID, true); protected void gdvMajor_PageIndexChanging(object sender, GridViewPageEventArgs e) this.gdvMajor.PageIndex = e.NewPageIndex; InitPageData(); protected void btnAdd_Click(object sender, EventArgs e) string majorNo = this.txtMajorNo.Text.Trim(); string majorName = this.txtMajorName.Text.Trim(); string remark = this.txtMajorRemark.Text.Trim(); string departmentID = this.ddlDepartment.SelectedValue; sql = insert into UT_Base_Major(DepartmentID,MajorNo,MajorName,Remark) values( + departmentID + , + majorNo + , + majorName + , + remark + ); int result = CommonUtils.OperateData(sql); if (result = 1) Response.Write(alert(专业添加成功！);); else Response.Write(alert(专业添加失败！);); InitPageData(); 4.3课程管理的编码public partial class Admin_SelectSubject_SubjectManage : System.Web.UI.Page private string sql = ; protected void Page_Load(object sender, EventArgs e) if (!Page.IsPostBack) InitPageData(); private void InitPageData() sql = SELECT ID,DepartNo,DepartName,ParentID,Remark FROM UT_Base_Department; CommonUtils.ECDropDownList(ddlDepartment, sql, DepartName, ID, true); sql = SELECT ID,StartYear,EndYear,TermOrder FROM UT_Base_Term; DataTable dt = CommonUtils.GetTableBySql(sql).Copy(); for (int i = 0; i dt.Rows.Count; i+) DataRow dr = dt.Rowsi; drStartYear = Convert.ToString(drStartYear) + - + Convert.ToString(drEndYear) + 学年 第 + Convert.ToString(drTermOrder) + 学期; CommonUtils.Dt2DropDownList(ddlTerm, dt, StartYear, ID, true); protected void btnQuery_Click(object sender, EventArgs e) sql = SELECT * ; sql += FROM UV_Base_Subject ; sql += where 1=1 ; string tmp = ; tmp = this.txtSubjectNo.Text.Trim(); if (!.Equals(tmp) sql += and SubjectNo= + tmp + ; tmp = this.txtSubjectName.Text.Trim(); if (!.Equals(tmp) sql += and SubjectName like % + tmp + %; tmp = this.ddlTerm.SelectedValue; if (!0.Equals(tmp) sql += and TermID= + tmp; tmp = this.ddlDepartment.SelectedValue; if (!0.Equals(tmp) sql += and DepartmentID= + tmp; DataTable dt = CommonUtils.GetTableBySql(sql).Copy(); for (int i = 0; i dt.Rows.Count; i+) DataRow dr = dt.Rowsi; drStartYear = Convert.ToString(drStartYear) + - + Convert.ToString(drEndYear) + 学年 第 + Convert.ToString(drTermOrder) + 学期; this.gdvSubject.DataSource = dt.DefaultView; this.gdvSubject.DataBind(); protected void gdvSubject_PageIndexChanging(object sender, GridViewPageEventArgs e) this.gdvSubject.PageIndex = e.NewPageIndex; InitPageData(); protected void btnDel_Click(object sender, EventArgs e) int count = 0; for (int i = 0; i this.gdvSubject.Rows.Count; i+) CheckBox cbx = (CheckBox)this.gdvSubject.Rowsi.FindControl(cbxDelOper); if (cbx.Checked = true) Label lblSubjectID = (Label)this.gdvSubject.Rowsi.FindControl(lblSubjectID); string subjectId = lblSubjectID.Text; sql = delete from UT_Base_Subject where ID= + subjectId; int count1 = CommonUtils.OperateData(sql); if (count1 != 0) count+; Response.Write(alert(共删除 + count + 门课程);); InitPageData(); 4.4学期管理的编码public partial class Admin_SelectSubject_TermManage : System.Web.UI.Page String sql = ; protected void Page_Load(object sender, EventArgs e) if (!Page.IsPostBack) InitPageData(); private void InitPageData() sql = SELECT ID,StartYear,EndYear,termOrder FROM UT_Base_Term; CommonUtils.ECGridView(this.gdvTerm, sql); Lb_PageInfo.Text = 第 + (gdvTerm.PageIndex + 1).ToString() + 页 / 共 + gdvTerm.PageCount + 页; protected void gdvTerm_PageIndexChanging(object sender, GridViewPageEventArgs e) this.gdvTerm.PageIndex = e.NewPageIndex; int x = Convert.ToInt32(e.NewPageIndex) + 1; InitPageData(); protected void btnAdd_Click(object sender, EventArgs e) string startYear = this.ddlYear.SelectedValue.Substring(0, 4); string endYear = this.ddlYear.SelectedValue.Substring(this.ddlYear.SelectedValue.IndexOf(-) + 1); string termOrder = this.ddlTerm.SelectedValue; sql = insert into UT_Base_Term(StartYear,EndYear,TermOrder) values( + startYear + , + endYear + , + termOrder + ); int result = CommonUtils.OperateData(sql); if (result = 1) Response.Write(alert(学期添加成功！);); else Response.Write(alert(学期添加失败！);); InitPageData(); protected void gdvTerm_RowDeleting(object sender, GridViewDeleteEventArgs e) string id = gdvTerm.DataKeyse.RowIndex.Value.ToString(); sql = delete UT_Base_Term where ID= + id + ; int result = CommonUtils.OperateData(sql); if (result = 1) Response.Write(alert(学期删除成功！);); else Response.Write(alert(学期删除失败！);); InitPageData(); protected void gdvTerm_RowDataBound(object sender, GridViewRowEventArgs e) if (e.Row.RowType = DataControlRowType.DataRow) if (e.Row.RowState = DataControlRowState.Normal | e.Row.RowState = DataControlRowState.Alternate) (LinkButton)e.Row.Cells5.Controls0).Attributes.Add(