网上选课系统项目报告

网上选课系统项目报告目录第一章需求分析 (4)1.1概念分析 (4)1.2系统分析 (5)1.2.1学生选课子系统页面设计 (5)1.2.2 教师管理子系统界面设计 (5)1.2.3.管理员管理子系统界面设计 (5)1.3功能分析 (6)1.3.1功能模块图设计 (6)1.4用例图设计 (6)1.4.1学生用例图设计 (6)1.4.2教师用例图设计 (7)1.4.3管理员用例图设计 (7)第二章系统设计 (7)2.1总体设计 (8)2.2数据库设计 (8)2.2.1部门表设计 (8)2.2.2专业表设计 (9)2.2.3班级表设计 (9)2.2.4学期表设计 (9)2.2.6教师表设计 (10)2.2.7学生表设计 (10)2.2.9课程表设计 (11)2.2.10教师课程关系表设计 (11)2.3表间关系图 (12)2.3.1UV_Base_Major (12)2.3.2UV_Base_Class (12)2.3.4UV_Select_TeacheSubjectReleation (13)2.3.5UV_Select_StudenSubjectReleation (13)2.3.6UV_Select_SelectSubjectVerify (14)第三章程序设计 (14)3.1网上选课系统后台程序实现 (14)3.1.1母版页设计 (14)3.1.2基本信息管理页面设计 (15)3.2网上选课系统前台程序实现 (16)3.2.1系统注册页面设计 (16)3.2.2学生选课页面设计 (16)3.2.3教师任务查看页面设计 (17)第四章编码设计 (17)4.1班级管理的编码 (17)4.2专业管理的编码 (19)4.3课程管理的编码 (20)4.4学期管理的编码 (21)第五章编码测试 (23)5.1页面测试 (23)5.2数据表测试 (23)第六章部署维护 (24)1. (24)2. (24)3. (24)4. (24)5. (25)6. (25)7. (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.3班级表设计2.2.4学期表设计2.2.5职称表设计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_StudenSubjectReleation2.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.QueryString["operFlag"];if (operFlag == null)operFlag = "add";if ("modify".Equals(operFlag)) {String classID = Request.QueryString["ID"];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.Rows[0]["classNo"]);txtName.Text = Convert.ToString(dtClass.Rows[0]["className"]);ddlMajor.SelectedValue =Convert.ToString(dtClass.Rows[0]["majorID"]);txtRemark.Text = Convert.ToString(dtClass.Rows[0]["Remark"]);Session.Add(CommonUtils.Session_ClassID, dtClass.Rows[0]["ID"]); 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 FROMUV_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 FROMUV_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("<script language='javascript'>alert('班级添加成功！');</script>");elseResponse.Write("<script language='javascript'>alert('班级添加失败！');</script>");}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(Session[CommonUtils.Session_ClassID]);Session.Remove(CommonUtils.Session_ClassID);int result = CommonUtils.OperateData(sql);if (result == 1)Response.Write("<script language='javascript'>alert('班级信息修改成功！');</script>");elseResponse.Write("<script language='javascript'>alert('班级信息修改失败！');</script>");}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.Rows[i].FindControl("cbxDelOper");if (cbx.Checked == true){Label lblClassID =(Label)this.gdvClass.Rows[i].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("<script language='javascript'>alert('共删除" + count + "个班级');</script>");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 = "SELECTID,DepartmentID,MajorNo,MajorName,DepartNo,DepartName,ParentID,DepartRemark FROM UV_Base_Major";CommonUtils.ECGridView(this.gdvMajor, sql);sql = "SELECT ID,DepartNo,DepartName,ParentID,Remark FROMUT_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("<script language='javascript'>alert('专业添加成功！');</script>");elseResponse.Write("<script language='javascript'>alert('专业添加失败！');</script>");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 FROMUT_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.Rows[i];dr["StartYear"] = Convert.ToString(dr["StartYear"]) + "-" + Convert.ToString(dr["EndYear"]) + "学年第" + Convert.ToString(dr["TermOrder"]) + "学期";}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.Rows[i];dr["StartYear"] = Convert.ToString(dr["StartYear"]) + "-" + Convert.ToString(dr["EndYear"]) + "学年第" + Convert.ToString(dr["TermOrder"]) + "学期";}this.gdvSubject.DataSource = dt.DefaultView;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.Rows[i].FindControl("cbxDelOper");if (cbx.Checked == true){Label lblSubjectID =(Label)this.gdvSubject.Rows[i].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("<script language='javascript'>alert('共删除" + count + "门课程');</script>");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("<script language='javascript'>alert('学期添加成功！');</script>");elseResponse.Write("<script language='javascript'>alert('学期添加失败！');</script>");InitPageData();{string id = gdvTerm.DataKeys[e.RowIndex].Value.ToString();sql = "delete UT_Base_Term where ID='" + id + "'";int result = CommonUtils.OperateData(sql);if (result == 1)Response.Write("<script language='javascript'>alert('学期删除成功！');</script>");elseResponse.Write("<script language='javascript'>alert('学期删除失败！');</script>");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.Cells[5].Controls[0]).Attributes.Add("onclick", "javascript:return confirm('你确认要删除：\"" + e.Row.Cells[1].Text + "-->" + e.Row.Cells[2].Text + "\"学年吗?')");}}}protected void gdvTerm_RowEditing(object sender, GridViewEditEventArgs e) {gdvTerm.EditIndex = e.NewEditIndex;InitPageData();}protected void gdvTerm_RowUpdating(object sender, GridViewUpdateEventArgs e) {sql = "update UT_Base_Term set StartYear='"+ ((TextBox)gdvTerm.Rows[e.RowIndex].Cells[1].Controls[0]).Text+ "',EndYear='"+ ((TextBox)gdvTerm.Rows[e.RowIndex].Cells[2].Controls[0]).Text+ "',TermOrder='"+ ((TextBox)gdvTerm.Rows[e.RowIndex].Cells[3].Controls[0]).Text+ "' where ID='"+ gdvTerm.Rows[e.RowIndex].Cells[0].Text + "'";int result = CommonUtils.OperateData(sql);if (result == 1)Response.Write("<script language='javascript'>alert('学期修改成功！');</script>");elseResponse.Write("<script language='javascript'>alert('学期修改失败！');</script>");gdvTerm.EditIndex = -1;InitPageData(); }protected void gdvTerm_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e){gdvTerm.EditIndex = -1;InitPageData(); }}第五章编码测试5.1页面测试5.2数据表测试第六章部署维护1.在2005中打开网上选课系统的网站所在文件夹”C:\网上选课系统”。