【正文】 0% border=0 align=center cellpadding=0 cellspacing=0 tr td colspan=4amp。nbsp。/td /tr tr td width=15% height=30 align=rightamp。nbsp。/td td width=15% align=rightimg src=images/ alt=25175 width=30 height=27：/td td height=40 colspan=2管理員登陸/td /tr tr td height=30 colspan=2 align=right登錄ID：/td td colspan=2input name=username type=text class=bginput id=username2 size=20 maxlength=20 /td /tr tr td height=30 colspan=2 align=right登錄密碼：/td td colspan=2input name=password type=password class=bginput id=password2 size=20 maxlength=20 /td /tr tr td height=30 colspan=2 align=right附加碼：/td td colspan=2font color=FFFFFF input name=reg type=text class=bginput id=password size=10 maxlength=4 /font % FOR i=1 to 4 suiji=suijishu() suiji1=suiji1amp。suiji img src=39。images/suiji/amp。cstr(suiji)amp。.gif39。 next % input name=reg1 type=hidden id=reg1 value=%=suiji1% /td /tr tr td height=40 colspan=2amp。nbsp。/td td colspan=2input type=submit name=Submit value=提 交 　 input type=reset name=Submit2 value=重 置/td /tr /table /form課程管理在這里，管理員可以對(duì)已有課程進(jìn)行刪除，也可以添加新的課程。根據(jù)不同的操作，數(shù)據(jù)將提交到不同的頁面處理。最后提交到admin\。 后臺(tái)課程管理主要代碼如下：table width=970 border=0 align=center cellpadding=0 cellspacing=0 bgcolor=FFFFFF tr td width=188 rowspan=3 valign=top!include file=/td /tr trtd align=center valign=toptable width=100% border=0 cellpadding=0 cellspacing=1 bgcolor=ADD7FF tr align=center bgcolor=ADD7FF td height=25 colspan=8span style=fontsize: 24px課 程 管 理/span/td /tr tr align=center bgcolor=FFFFFF td width=7%序號(hào)/td td width=12% height=25教師名稱：/td td width=10% height=25學(xué)期：/td td width=16% height=25課程名稱：/td td width=14% height=25院系名稱：/td td width=17% height=25上課班級(jí)：/td td width=17% height=25備注：/td td width=7%操作/td /tr % strsql=select * from teachercourse order by id set rs=(strsql) j=1 do while not teachername=rs(teachername) term=rs(term) course=rs(course) department=rs(department) classes=rs(class) % tr align=center bgcolor=FFFFFF td%=j%/td td height=25%=teachername%/td td height=25%=term%/td td height=25%=course%/td td%=department%/td td%=classes%/td td%=rs(beizhu)%/td tda href=?ID=%=rs(ID)% target=_self刪除/a/td /tr % j=j+1 loop % /table/td td width=9 rowspan=2 background=/td /tr tr td width=589 align=center valign=middleform name=form1 method=post action= div align=center table width=97% height=195 border=0 align=center cellpadding=0 cellspacing=0 tr td height=65 colspan=4 align=centerp align=left教師課程添加/p p align=left第一步：添加院系名稱和教師：/p/td /tr tr bgcolor=ADD7FF td width=21% height=25 align=right bgcolor=ADD7FF院系名稱：/td td width=40% height=25 select name=addone_id id=addone_id sid=addone_id option selected請(qǐng)選擇教師院系/option % strsql=select * from department order by id set rs=(strsql) do while not department=rs(department) depid=rs(id) % option value=%=depid%%=department%/option % loop % /select/td /tr tr td height=25div align=right教師名稱：/div/td td colspan=3select name=addtwo_id id=addtwo_id option selected請(qǐng)選擇教師/option % strsql=select * from teacher order by id set rs=(strsql) do while not teachername=rs(teachername) teacherid=rs(id) % option value=%=teacherid%%=teachername%/option % loop % /select/td /tr tr td height=26amp。nbsp。/td td colspan=3amp。nbsp。/td /tr tr tdamp。nbsp。/td td colspan=3input type=submit name=Submit value=提交/td /tr /table /div /form/td /tr/table查看教師成績此頁面直接從tescherscore數(shù)據(jù)表調(diào)取數(shù)據(jù)，經(jīng)計(jì)算處理后顯示于頁面上。 后臺(tái)查看成績主要代碼如下：tr align=center valign=bottom bgcolor=FFFFFF td width=19% height=25 align=right valign=middle 請(qǐng)選擇教師院系：/td td width=81% height=25 align=left valign=middle % if Depart and Depart請(qǐng)選擇教師院系 then Depart input name=39。Depart39。 type=39。hidden39。 value=39。amp。Depart1amp。39。 else % select name=depart id=select7 onChange=changelocation1([].value) option value=請(qǐng)選擇教師院系 selected請(qǐng)選擇教師院系/option %sql=select * from DEPARTMENT order by ID descset rs=() sql,db,1,1while not % option value=%=rs(id)%%=rs(DEPARTMENT)%/option %wend()% /select * % end if% /td /t