网上选课系统项目报告Word格式.docx
《网上选课系统项目报告Word格式.docx》由会员分享,可在线阅读,更多相关《网上选课系统项目报告Word格式.docx(34页珍藏版)》请在冰点文库上搜索。
首先进入选择登录身份界面,点击“登录”之后进入选择操作界面,包括“管理学生”“管理教师”、“管理课程”。
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_Major
2.3.2UV_Base_Class
2.3.3UV_Base_Subject
2.3.4UV_Select_TeacheSubjectReleation
2.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班级管理的编码
publicpartialclassAdmin_SelectSubject_ClassManage:
System.Web.UI.Page
{
privatestringsql="
"
;
protectedvoidPage_Load(objectsender,EventArgse)
{
if(!
Page.IsPostBack)
InitPageData();
}
privatevoidInitPageData()
{
StringoperFlag=Request.QueryString["
operFlag"
];
if(operFlag==null)
operFlag="
add"
if("
modify"
.Equals(operFlag)){
StringclassID=Request.QueryString["
ID"
sql="
SELECTID,MajorID,ClassNo,ClassName,RemarkFROMUT_Base_ClasswhereID="
+classID;
DataTabledtClass=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]["
btnAdd.Visible=false;
btnModify.Visible=true;
btnQuery.Visible=false;
else
btnAdd.Visible=true;
btnModify.Visible=false;
btnQuery.Visible=true;
SELECTID,ClassNo,ClassName,MajorName,DepartNameFROMUV_Base_Classwhere1=1"
CommonUtils.ECGridView(gdvClass,sql);
selectID,majorNamefromut_base_major"
CommonUtils.ECDropDownList(ddlMajor,sql,"
majorName"
"
true);
protectedvoidbtnQuery_Click(objectsender,EventArgse)
Stringtmp="
tmp=txtNo.Text.Trim();
.Equals(tmp))
sql+="
andclassNo='
+tmp+"
'
tmp=txtName.Text.Trim();
andclassNamelike'
%"
%'
tmp=txtRemark.Text.Trim();
andclassRemarklike'
tmp=ddlMajor.SelectedValue;
tmp.Equals(CommonUtils.DDL_First_Item_Value))
andMajorID='
protectedvoidbtnAdd_Click(objectsender,EventArgse)
insertintoUT_Base_Class(MajorID,ClassNo,ClassName,Remark)values("
sql+=ddlMajor.SelectedValue+"
'
sql+=txtNo.Text.Trim()+"
sql+=txtName.Text.Trim()+"
sql+=txtRemark.Text.Trim()+"
)"
intresult=CommonUtils.OperateData(sql);
if(result==1)
Response.Write("
<
scriptlanguage='
javascript'
>
alert('
班级添加成功!
);
/script>
else
班级添加失败!
protectedvoidbtnModify_Click(objectsender,EventArgse)
updateUT_Base_Classset"
MajorID="
+ddlMajor.SelectedValue+"
"
ClassNo='
+txtNo.Text.Trim()+"
ClassName='
+txtName.Text.Trim()+"
Remark='
+txtRemark.Text.Trim()+"
whereID="
+Convert.ToString(Session[CommonUtils.Session_ClassID]);
Session.Remove(CommonUtils.Session_ClassID);
intresult=CommonUtils.OperateData(sql);
班级信息修改成功!
班级信息修改失败!
protectedvoidbtnDel_Click(objectsender,EventArgse)
intcount=0;
for(inti=0;
i<
gdvClass.Rows.Count;
i++)
CheckBoxcbx=(CheckBox)this.gdvClass.Rows[i].FindControl("
cbxDelOper"
if(cbx.Checked==true)
LabellblClassID=(Label)this.gdvClass.Rows[i].FindControl("
lblClassID"
stringclassID=lblClassID.Text;
deletefromUT_Base_ClasswhereID="
intcount1=CommonUtils.OperateData(sql);
if(count1!
=0)
count++;
共删除"
+count+"
个班级'
protectedvoidgdvClass_PageIndexChanging(objectsender,GridViewPageEventArgse)
gdvClass.PageIndex=e.NewPageIndex;
protectedvoidtxtNo_TextChanged(objectsender,EventArgse)
stringclassNo=txtNo.Text.Trim();
selectcount(*)fromUT_Base_ClasswhereClassNo='
+classNo+"
boolisExist=false;
intresult=Convert.ToInt32(CommonUtils.GetScalarBySql(sql));
if(result>
0)
isExist=true;
if(isExist)
this.lblClassExist.Visible=true;
this.txtNo.Focus();
//
this.lblClassExist.Visible=false;
this.txtName.Focus();
}
4.2专业管理的编码
publicpartialclassAdmin_SelectSubject_MajorManage:
Stringsql="
SELECTID,DepartmentID,MajorNo,MajorName,DepartNo,DepartName,ParentID,DepartRemarkFROMUV_Base_Major"
CommonUtils.ECGridView(this.gdvMajor,sql);
SELECTID,DepartNo,DepartName,ParentID,RemarkFROMUT_Base_Department"
CommonUtils.ECDropDownList(this.ddlDepartment,sql,"
DepartName"
protectedvoidgdvMajor_PageIndexChanging(objectsender,GridViewPageEventArgse)
this.gdvMajor.PageIndex=e.NewPageIndex;
stringmajorNo=this.txtMajorNo.Text.Trim();
stringmajorName=this.txtMajorName.Text.Trim();
stringremark=this.txtMajorRemark.Text.Trim();
stringdepartmentID=this.ddlDepartment.SelectedValue;
insertintoUT_Base_Major(DepartmentID,MajorNo,MajorName,Remark)values("
+departmentID+"
+majorNo+"
+majorName+"
+remark+"
专业添加成功!
专业添加失败!
4.3课程管理的编码
publicpartialclassAdmin_SelectSubject_SubjectManage:
CommonUtils.ECDropDownList(ddlDepartment,sql,"
SELECTID,StartYear,EndYear,TermOrderFROMUT_Base_Term"
DataTabledt=CommonUtils.GetTableBySql(sql).Copy();
dt.Rows.Count;
DataRowdr=dt.Rows[i];
dr["
StartYear"
]=Convert.ToString(dr["
])+"
-"
+Convert.ToString(dr["
EndYear"
学年第"
TermOrder"
学期"
CommonUtils.Dt2DropDownList(ddlTerm,dt,"
SELECT*"
FROMUV_Base_Subject"
where1=1"
stringtmp="
tmp=this.txtSubjectNo.Text.Trim();
andSubjectNo='
tmp=this.txtSubjectName.Text.Trim();
andSubjectNamelike'
tmp=this.ddlTerm.SelectedValue;
0"
andTermID="
+tmp;
tmp=this.ddlDepartment.SelectedValue;
andDepartmentID="
this.gdvSubject.DataSource=dt.DefaultView;
this.gdvSubject.DataBind();
protectedvoidgdvSubject_PageIndexChanging(objectsender,GridViewPageEventArgse)
this.gdvSubject.PageIndex=e.NewPageIndex;
this.gdvSubject.Rows.Count;
CheckBoxcbx=(CheckBox)this.gdvSubject.Rows[i].FindControl("
LabellblSubjectID=(Label)this.gdvSubject.Rows[i].FindControl("
lblSubjectID"
stringsubjectId=lblSubjectID.Text;
deletefromUT_Base_SubjectwhereID="
+subjectId;
共删除