XX大學(xué)XXXX學(xué)院課程設(shè)計 課題題目：教務(wù)管理系統(tǒng) 學(xué)部：XX學(xué)部專業(yè)：XXXX班級：X班 學(xué)號： 姓名XXX 指導(dǎo)老師：XXX2011年6月23日

成績： 一系統(tǒng)功能分析與設(shè)計1.需求分析

制作教務(wù)管理信息系統(tǒng)的目的是為學(xué)校學(xué)生提供一個方便創(chuàng)立教師、學(xué)生信息的工具，實現(xiàn)能夠方便、快捷的查詢信息。管理信息系統(tǒng)是進行信息的采集,存儲,修改,維護,備份和使用的系統(tǒng),它是隨著管理科學(xué)和技術(shù)科學(xué)的開展而形成的.教務(wù)管理信息系統(tǒng)是一個教育單位不可缺少的局部,它的內(nèi)容對于學(xué)校的決策者和管理者來說都至關(guān)重要,所以教務(wù)管理信息系統(tǒng)應(yīng)該能夠為用戶提供充足的信息和快捷的查詢手段,對學(xué)生來說可以輕松的查閱自己在校的信息以及選課等。

2.功能模塊圖分析說明2.1總體功能模塊圖教務(wù)信息系統(tǒng)教務(wù)信息系統(tǒng)學(xué)生學(xué)籍管理教學(xué)信息管理教師信息管理教材信息管理查詢學(xué)生信息添加學(xué)生信息刪除學(xué)生信息更新學(xué)生信息查詢教學(xué)信息添加教學(xué)信息刪除教學(xué)信息更新教師信息查詢教師信息添加教師信息刪除教師信息更新教師信息更新教材信息刪除教材信息添加教材信息查詢教材信息2.2各個模塊分析說明學(xué)生學(xué)籍管理該模塊主要實現(xiàn)學(xué)生信息的根本管理，便于管理員添加學(xué)生、刪除學(xué)生、查詢學(xué)生等管理學(xué)生學(xué)籍的功能。教學(xué)管理該模塊實現(xiàn)對課程的根本管理。課程管理主要實現(xiàn)對課程信息的查詢，添加課程，替學(xué)生選課等功能。教師管理該模塊實現(xiàn)教師情況的管理，如：對教師的信息查詢，添加，刪除，修改。教材管理該模塊主要實現(xiàn)對教材的查詢，添加，修改管理。二、數(shù)據(jù)庫設(shè)計1.全局E-R圖選課選課nppm選用教材教材發(fā)行碼頁碼教材編號教材名稱出版社主編l單價專業(yè)編碼姓名性別出生年月入學(xué)時間籍貫學(xué)生學(xué)號教師教師名性別出生年月部門編號職稱籍貫m教師編號課程學(xué)時學(xué)分課程名考試／考查課程號2.關(guān)系模式student(studentnum,studentname,ssecret,sex,stuyear,stumon,studay,inyear,inmon,inday,specialnum,phone,city);teacher(teachernum,teachername,ssecret,sex,teayear,teamon,teaday,classnum,position,phone,city);book(booknum,bookname,edition,number,editor,rate,pagenum,);class(classnum,classname,exam,knowledge,credits);stc(classnum,studentnum,teachernum);boocla(classnum,booknum);3.數(shù)據(jù)字典

3.1student〔學(xué)生表〕：學(xué)號studentnumvarchar(10)notnullprimarykey姓名studentnamevarchar(10)notnull密碼ssecretvarchar(10)notnull性別sexvarchar(10)nullcheck(sexin(‘男’,’女’))出生年stuyearvarchar(10)null出生月stumonvarchar(10)null出生日studayvarchar(10)null入學(xué)年inyearvarchar(10)null入學(xué)月inmonvarchar(10)null入學(xué)日indayvarchar(10)null專業(yè)編碼specialnumvarchar(10)notnullphonevarchar(10)null籍貫cityvarchar(10)null3.2 teacher〔教師表〕：教師編號teachernumvarchar(10)notnullprimarykey教師名teachernamevarchar(10)notnull密碼ssecretvarchar(10)notnull性別sexvarchar(10)nullcheck(sexin('男','女'))出生年teayearvarchar(10)null出生月teamonvarchar(4)null出生日teadayvarchar(4)null部門編號classnumvarchar(10)notnull職稱positionvarchar(10)notnullphonevarchar(10)null籍貫cityvarchar(10)null3.3book〔教材表〕：

教材編號booknumvarchar(10)notnullprimarykey教材名稱booknamevarchar(10)notnull出版社editionvarchar(10)null發(fā)行碼numbervarchar(10)notnull主編editorvarchar(10)null單價ratevarchar(10)notnull頁碼pagenumvarchar(10)null3.4class〔課程表〕：學(xué)時knowledgevarchar(10)null學(xué)分creditsvarchar(10)null課程號classnumvarchar(10)notnullprimarykey課程名classnamevarchar(10)notnull考試方式examvarchar(10)nullcheck(examin('考試','考查'))3.5stc〔選課表〕：課序號coursenumvarchar(10)notnullprimarykey課程號classnumvarchar(10)notnullforeignkey(classnum)referencesclass(classnum)學(xué)號studentnumvarchar(10)notnullforeignkey(studentnum)referencesstudent(studentnum)教師編號teachernumvarchar(10)notnullforeignkey(teachernum)referencesteacher(teachernum)3.6ookcla〔選教材表〕：課程號classnumvarchar(10)notnullprimarykey教材編號booknumvarchar(10)notnullforeignkey(booknum)referencesbook(booknum)foreignkey(coursenum)referencescourse(coursenum)三系統(tǒng)實現(xiàn)管理員登陸如圖1所示，可對學(xué)生學(xué)籍、教師、教學(xué)、教材進行管理圖1管理員登陸后的界面如圖2所示，初始頁面為“學(xué)生學(xué)籍管理”頁面，點擊“教學(xué)管理”、“教學(xué)管理”、“教材管理”鏈接進入相應(yīng)的頁面圖2在“學(xué)生學(xué)籍管理”頁面，輸入需要查找的相應(yīng)信息，點擊查找按鈕即可對此進行搜索，并列出符合條件的學(xué)生列表，如圖3所示，性別選擇女，點擊查找按鈕，列出性別為女的學(xué)生圖3點擊查找按鈕后面的“添加”鏈接，跳轉(zhuǎn)到“添加學(xué)生”頁面，界面如圖4所示圖4填好需要添加的學(xué)生的相應(yīng)信息后，點擊提交按鈕，彈出“添加成功！”，說明該學(xué)生信息已成功添加，如圖5所示圖5在返回的“學(xué)生學(xué)籍管理”主頁面，輸入該學(xué)生的學(xué)號0838010301進行查找，結(jié)果列出該生的全部信息，如圖6所示圖6點擊該學(xué)生信息后的“修改”鏈接，跳轉(zhuǎn)到“學(xué)生信息修改”頁面，可對除學(xué)號外所有信息進行修改，如圖7所示圖7修改好相應(yīng)信息后，點擊“修改”按鈕，彈出“修改成功！”提示框，說明修改已成功，如圖8所示圖8在“學(xué)生學(xué)籍管理”主頁面，輸入該學(xué)生的學(xué)號0838010301進行查找，結(jié)果列出該生的全部信息，如圖9所示，發(fā)現(xiàn)已有修改圖9點擊“修改”鏈接后的刪除鏈接，可對學(xué)生的信息進行刪除處理，彈出“刪除成功！”提示框，說明已刪除成功，如圖10所示圖10輸入學(xué)生的學(xué)號和密碼后可登陸到“學(xué)生信息查詢”頁面，如圖11所示圖11如果學(xué)號和密碼正確，那么再彈出“登陸成功！”提示框，如圖12所示圖12然后跳轉(zhuǎn)到“學(xué)生資料查詢”頁面，如圖13所示圖13點擊“查詢課程”鏈接后，跳轉(zhuǎn)到“學(xué)生個人課表查詢”頁面，如圖14所示圖14點擊“修改”按鈕跳轉(zhuǎn)到學(xué)生資料修改頁面，可對密碼、、籍貫進行修改，如圖15所示圖15點擊“修改”，彈出“修改成功！”提示框，說明修改資料成功，如圖16所示圖16四小結(jié)全組組員在設(shè)計數(shù)據(jù)庫前期規(guī)劃和設(shè)計上都有很突出的奉獻，畫E-R圖，轉(zhuǎn)邏輯關(guān)系，設(shè)計數(shù)據(jù)字典，幾乎是一氣呵成。五開發(fā)工具和參考文獻1.開發(fā)工具AdobeDreamweaverCS3AdobePhotoshopCS5ExtendedMicrosoftSQLServer2000PersonalSP42.參考文獻2.1劉濤.動態(tài)網(wǎng)站開發(fā)：ASPSQLServerDreamweaver.北京：高等教育出版社，20082.2王珊，薩師煊.數(shù)據(jù)庫系統(tǒng)概論〔第4版〕.北京：高等教育出版社，2006〔2010重印〕2.32.42.5劉浩增，張坤，宋強等.ASP動態(tài)網(wǎng)站開發(fā)教程.北京：清華大學(xué)出版社，20092.6李曉黎，張巍.ASP+SQLServer網(wǎng)絡(luò)應(yīng)用系統(tǒng)開發(fā)與實例.北京：人民郵電出版社，2004〔2005重印〕六源程序清單1.建表代碼createtableteacher(teachernum varchar(10) notnull primarykey ,teachername varchar(10) notnull ,ssecret varchar(10) notnull ,sex varchar(10) null check(sexin('男','女')) ,teayear varchar(10) null ,teamon varchar(4) null ,teaday varchar(4) null ,classnum varchar(10) notnull ,position varchar(10) notnull ,phone varchar(11) null ,city varchar(20) null ,);createtablebook(booknum varchar(10) notnull primarykey ,bookname varchar(20) notnull ,edition varchar(20) null ,number varchar(10) notnull ,editor varchar(10) null ,rate varchar(10) notnull ,pagenum varchar(10) null ,);createtableclass(knowledge varchar(10) null ,credits varchar(10) null ,classnum varchar(10) notnull primarykey ,classname varchar(10) notnull ,exam varchar(10) null check(examin('考試','考查')) ,);createtablestudent(studentnum varchar(10) notnull primarykey ,studentname varchar(10) notnull ,ssecret varchar(10) notnull ,sex varchar(10) null check(sexin('男','女')) ,stuyear varchar(10) null ,stumon varchar(10) null ,studay varchar(10) null ,inyear varchar(10) null ,inmon varchar(10) null ,inday varchar(10) null ,specialnum varchar(10) notnull ,phone varchar(11) null ,city varchar(20) null ,);createtablestc(classnum varchar(10) notnull ,studentnum varchar(10) notnull ,teachernum varchar(10) notnull , primarykey(studentnum,teachernum,classnum), foreignkey(studentnum)referencesstudent(studentnum) , foreignkey(teachernum)referencesteacher(teachernum) , foreignkey(classnum)referencesclass(classnum) ,);createtableboocla(classnum varchar(10) notnull ,booknum varchar(10) notnull , primarykey(classnum,booknum) , foreignkey(booknum)referencesbook(booknum) , foreignkey(classnum)referencesclass(classnum) ,);2.網(wǎng)頁關(guān)鍵代碼2.1鏈接數(shù)據(jù)庫核心代碼〔Connections/conn.asp〕<%DimMM_conn_STRINGMM_conn_STRING="Provider=SQLOLEDB;datasource=(local);initialcatalog=teachers;uid=sa;pwd=;"%>2.2網(wǎng)頁通用調(diào)用方法<!--#includefile="/Connections/conn.asp"-->2.3管理員查詢和刪除頁面關(guān)鍵代碼〔index_stu.asp〕<%Setconn=Server.Createobject("ADODB.Connection")conn.openMM_conn_STRING%><% del=request.QueryString("studentnum")if(del<>"")then conn.execute("deletefromstudentwherestudentnum='"&del&"'") Response.Write("<script>alert('刪除成功！');window.location.href='index_stu.asp';</script>") endif studentnum=request.form("studentnum") studentname=request.form("studentname") ssecret=request.form("ssecret") sex=request.form("sex") stuyear=request.form("stuyear") stumon=request.form("stumon") studay=request.form("studay") inyear=request.form("inyear") inmon=request.form("inmon") inday=request.form("inday") specialnum=request.form("specialnum") phone=request.form("phone")dimrssetrs=server.CreateObject("adodb.recordset")sql="select*fromstudentwherestudentnumlike('"&studentnum&"%')andstudentnamelike('"&studentname&"%')andstudentnumlike('"&studentnum&"%')andssecretlike('"&ssecret&"%')andsexlike('"&sex&"%')andstuyearlike('"&stuyear&"%')andstumonlike('"&stumon&"%')andstudaylike('"&studay&"%')andinyearlike('"&inyear&"%')andinmonlike('"&inmon&"%')andindaylike('"&inday&"%')andspecialnumlike('"&specialnum&"%')andphonelike('"&phone&"%')"rs.opensql,conn,1,3 ifnotrs.eofthen constmaxperpage=10'定義每一頁顯示的數(shù)據(jù)記錄的常量 dimcurrentpage'定義當前頁的變量 rs.pagesize=maxperpage currentpage=request("page") ifcurrentpage=""ornotIsnumeric(currentpage)then currentpage=1 elseifcurrentpage<1then c1urrentpage=1 else currentpage=clng(currentpage) ifcurrentpage>rs.pagecountthen currentpage=rs.pagecount endif endif '如果變量currentpage的數(shù)據(jù)類型不是數(shù)值型 '就1賦給變量currentpage ifnotisnumeric(currentpage)then currentpage=1 endif dimtotalput,n'定義變量 totalput=rs.recordcount iftotalputmodmaxperpage=0then n=totalput\maxperpage else n=totalput\maxperpage+1 endif ifn=0then n=1 endif rs.move(current1)*maxperpage i=0 dowhilei<maxperpageandnotrs.eof i=i+1 %><% rs.movenext loop endif rs.close setrs=nothing%>2.4添加頁面關(guān)鍵代碼(student_add.asp)<%DimMM_editActionMM_editAction=CStr(Request.ServerVariables("SCRIPT_NAME"))If(Request.QueryString<>"")ThenMM_editAction=MM_editAction&"?"&Server.HTMLEncode(Request.QueryString)EndIf'booleantoabortrecordeditDimMM_abortEditMM_abortEdit=false%><%If(CStr(Request("MM_insert"))="form1")ThenIf(NotMM_abortEdit)Then'executetheinsertDimMM_editCmdSetMM_editCmd=Server.CreateObject("ADODB.Command")MM_editCmd.ActiveConnection=MM_conn_STRINGMM_editCmd.CommandText="INSERTINTOdbo.student(studentnum,studentname,ssecret,sex,stuyear,stumon,studay,inyear,inmon,inday,specialnum,phone,city)VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?)"MM_editCmd.Prepared=trueMM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param1",201,1,10,Request.Form("studentnum"))'adLongVarCharMM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param2",201,1,10,Request.Form("studentname"))'adLongVarCharMM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param3",201,1,10,Request.Form("ssecret"))'adLongVarCharMM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param4",201,1,10,Request.Form("sex"))'adLongVarCharMM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param5",201,1,10,Request.Form("stuyear"))'adLongVarCharMM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param6",201,1,10,Request.Form("stumon"))'adLongVarCharMM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param7",201,1,10,Request.Form("studay"))'adLongVarCharMM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param8",201,1,10,Request.Form("inyear"))'adLongVarCharMM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param9",201,1,10,Request.Form("inmon"))'adLongVarCharMM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param10",201,1,10,Request.Form("inday"))'adLongVarCharMM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param11",201,1,10,Request.Form("specialnum"))'adLongVarCharMM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param12",201,1,10,Request.Form("phone"))'adLongVarCharMM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param13",201,1,10,Request.Form("city"))'adLongVarCharMM_editCmd.Execute Response.Write("<script>alert('添加成功！');window.location.href='index_stu.asp';</script>") Response.endEndIfEndIf%><%DimrcDimrc_cmdDimrc_numRowsSetrc_cmd=Server.CreateObject("ADODB.Command")rc_cmd.ActiveConnection=MM_conn_STRINGrc_cmd.CommandText="SELECT*FROMdbo.student"rc_cmd.Prepared=trueSetrc=rc_cmd.Executerc_numRows=0%>2.5管理員修改頁面關(guān)鍵代碼(modify_stu.asp)<%DimMM_editActionMM_editAction=CStr(Request.ServerVariables("SCRIPT_NAME"))If(Request.QueryString<>"")ThenMM_editAction=MM_editAction&"?"&Server.HTMLEncode(Request.QueryString)EndIf'booleantoabortrecordeditDimMM_abortEditMM_abortEdit=false%><%If(CStr(Request("MM_update"))="form1")ThenIf(NotMM_abortEdit)Then'executetheupdateDimMM_editCmdSetMM_editCmd=Server.CreateObject("ADODB.Command")MM_editCmd.ActiveConnection=MM_conn_STRINGMM_editCmd.CommandText="UPDATEdbo.studentSETstudentname=?,ssecret=?,sex=?,stuyear=?,stumon=?,studay=?,inyear=?,inmon=?,inday=?,specialnum=?,phone=?,city=?WHEREstudentnum=?"MM_editCmd.Prepared=trueMM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param1",201,1,10,Request.Form("studentname"))'adLongVarCharMM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param2",201,1,10,Request.Form("ssecret"))'adLongVarCharMM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param3",201,1,10,Request.Form("sex"))'adLongVarCharMM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param4",201,1,10,Request.Form("stuyear"))'adLongVarCharMM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param5",201,1,10,Request.Form("stumon"))'adLongVarCharMM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param6",201,1,10,Request.Form("studay"))'adLongVarCharMM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param7",201,1,10,Request.Form("inyear"))'adLongVarCharMM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param8",201,1,10,Request.Form("inmon"))'adLongVarCharMM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param9",201,1,10,Request.Form("inday"))'adLongVarCharMM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param10",201,1,10,Request.Form("specialnum"))'adLongVarCharMM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param11",201,1,10,Request.Form("phone"))'adLongVarCharMM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param12",201,1,10,Request.Form("city"))'adLongVarCharMM_editCmd.Parameters.AppendMM_editCmd.CreateParameter("param13",200,1,10,Request.Form("MM_recordId"))'adVarCharMM_editCmd.Execute Response.Write("<script>alert('修改成功！');window.location.href='index_stu.asp';</script>") Response.endEndIfEndIf%><%DimRecordset1__MMColParamRecordset1__MMColParam="1"If(Request.QueryString("studentnum")<>"")ThenRecordset1__MMColParam=Request.QueryString("studentnum")EndIf%><%DimRecordset1DimRecordset1_cmdDimRecordset1_numRowsSetRecordset1_cmd=Server.CreateObject("ADODB.Command")Recordset1_cmd.ActiveConnection=MM_conn_STRINGRecordset1_cmd.CommandText="SELECT*FROMdbo.studentWHEREstudentnum=?"Recordset1_cmd.Prepared=trueRecordset1_cmd.Parameters.AppendRecordset1_cmd.CreateParameter("param1",200,1,10,Recordset1__MMColParam)'adVarCharSetRecordset1=Recordset1_cmd.ExecuteRecordset1_numRows=0%>2.6學(xué)生查詢信息頁面關(guān)鍵代碼〔student_index.asp〕<%'***Logoutthecurrentuser.MM_Logout=CStr(Request.ServerVariables("URL"))&"?MM_Logoutnow=1"If(CStr(Request("MM_Logoutnow"))="1")ThenSession.Contents.Remove("MM_Username")Session.Contents.Remove("MM_UserAuthorization")MM_logoutRedirectPage="index.asp"'redirectwithURLparameters(removethe"MM_Logoutnow"queryparam).if(MM_logoutRedirectPage="")ThenMM_logoutRedirectPage=CStr(Request.ServerVariables("URL"))If(InStr(1,UC_redirectPage,"?",vbTextCompare)=0AndRequest.QueryString<>"")ThenMM_newQS="?"ForEachItemInRequest.QueryStringIf(Item<>"MM_Logoutnow")ThenIf(Len(MM_newQS)>1)ThenMM_newQS=MM_newQS&"&"MM_newQS=MM_newQS&Item&"="&Server.URLencode(Request.QueryString(Item))EndIfNextif(Len(MM_newQS)>1)ThenMM_logoutRedirectPage=MM_logoutRedirectPage&MM_newQSEndIfResponse.Redirect(MM_logoutRedirectPage)EndIf%><!--#includefile="Connections/conn.asp"--><%DimRecordset1__MMColParamRecordset1__MMColParam="1"If(session("username")<>"")ThenRecordset1__MMColParam=session("username")EndIf%><%DimRecordset1DimRecordset1_cmdDimRecordset1_numRowsSetRecordset1_cmd=Server.CreateObject("ADODB.Command")Recordset1_cmd.ActiveConnection=MM_conn_STRINGRecordset1_cmd.CommandText="SELECT*FROMdbo.studentWHEREstudentnum=?"Recordset1_cmd.Prepared=trueRecordset1_cmd.Parameters.AppendRecordset1_cmd.CreateParameter("param1",200,1,10,Recordset1__MMColParam)'adVarCharSetRecordset1=Recordset1_cmd.ExecuteRecordset1_numRows=0%><%DimMM_paramName%><%'***GoToRecordandMoveToRecord:createstringsformaintainingURLandFormparametersDimMM_keepNoneDimMM_keepURLDimMM_keepFormDimMM_keepBothDimMM_removeListDimMM_itemDimMM_nextItem'createthelistofparameterswhichshouldnotbemaintainedMM_removeList="&index="If(MM_paramName<>"")ThenMM_removeList=MM_removeList&"&"&MM_paramName&"="EndIfMM_keepURL=""MM_keepForm=""MM_keepBoth=""MM_keepNone=""'addtheURLparameterstotheMM_keepURLstringForEachMM_itemInRequest.QueryStringMM_nextItem="&"&MM_item&"="If(InStr(1,MM_removeList,MM_nextItem,1)=0)ThenMM_keepURL=MM_keepURL&MM_nextItem&Server.URLencode(Request.QueryString(MM_item))EndIfNext'addtheFormvariablestotheMM_keepFormstringForEachMM_itemInRequest.FormMM_nextItem="&"&MM_item&"="If(InStr(1,MM_removeList,MM_nextItem,1)=0)ThenMM_keepForm=MM_keepForm&MM_nextItem&Server.URLencode(Request.Form(MM_item))EndIfNext'createtheForm+URLstringandremovetheintial'&'fromeachofthestringsMM_keepBoth=MM_keepURL&MM_keepFormIf(MM_keepBoth<>"")ThenMM_keepBoth=Right(MM_keepBoth,Len(MM_keepBoth)-1)EndIfIf(MM_keepURL<>"")ThenMM_keepURL=Right(MM_keepURL,Len(MM_keepURL)-1)EndIfIf(MM_keepForm<>"")ThenMM_keepForm=Right(MM_keepForm,Len(MM_keepForm)-1)EndIf'autilityfunctionusedforaddingadditionalparameterstothesestringsFunctionMM_joinChar(firstItem)If(firstItem<>"")ThenMM_joinChar="&"ElseMM_joinChar=""EndIfEndFunction%>2.7學(xué)生查詢課表頁面關(guān)鍵代碼〔student_class.asp〕<%Setrs=conn.execute("Select*fromclasswhereclassnum=(Selectclassnumfromstcwherestudentnum='"&session("username")&"')") constmaxperpage=20'定義每一頁顯示的數(shù)據(jù)記錄的常量 dimcurrentpage'定義當前頁的變量 currentpage=1 rs.pagesize=maxperpage rs.move(current1)*maxperpage dowhilei<maxperpag