【正文】 elsesql=select top 1 * from bbs1end if學生成績查詢系統(tǒng)38 sql,conn,1,1totalput=if and then 當前沒有這個 id 的成績~~~~~~~~~~Else%/td /tr/tabletable width=768 border=0 align=center cellpadding=0 cellspacing=0 tr td height=25 table width=768 height=25 border=0 cellpadding=0 cellspacing=0 tr td bgcolor=EEEEEE span class=unnamed2_14班級：/span%=rs(bj)%/td /tr /table table width=768 border=0 cellpadding=0 cellspacing=0 height=25 tr td width=14% align=center height=25 學號/td td width=14% align=center height=25姓名/td td width=14% align=center height=25課程/td td width=14% align=center height=25成績/td td width=14% align=center height=25學期/td td width=14% align=center height=25類型/td td width=14% align=center height=25操作/td /tr /table table width=768 height=22 border=0 cellpadding=0 cellspacing=0 %do while not % tr td width=14% height=25 align=center%=rs(xh)%/td td width=14% align=center%=rs(user)%/td td width=14% align=center%=rs(kc)%/td td width=14% align=center%=rs(cj)%/td 。 id amp。if request(id) thensql=select * from bbs1 where id like39。DefaultDir=。}學生成績查詢系統(tǒng)37/style/headbodytable width=768 border=0 align=center cellpadding=5 cellspacing=0 trtd width=754 valign=top bgcolor=A0A4AC style=lineheight:140%。body {backgroundcolor: 3399FF。img src=image/ width=800 height=92/td /tr/tabletable width=768 border=0 align=center cellpadding=0 cellspacing=0 tr td height=30 bgcolor=A0A4ACdiv align=center class=unnamed3write學生成績管理系統(tǒng)/div/td /tr/table學生成績查詢系統(tǒng)34p /pp /ptable width=768 border=0 align=center cellpadding=0 cellspacing=0 tr td height=3 class=style2div align=center/div/td /tr/tabletable width=768 border=0 align=center cellpadding=0 cellspacing=0 class=unnamed_rld2tr td class=style2 /td td class=style2 /td/trtr td width=50% class=style2table width=380 border=0 align=center cellpadding=0 cellspacing=0 tr td form action= method=post name=form1 table width=250 border=0 align=center cellpadding=0 cellspacing=0 class=unnamed1_rld tr bgcolor=EAEAEA td height=25 colspan=2div align=center學生成績查詢/div/td /tr tr td width=100 height=30div align=center學號：/div/td td input name=xh type=text class=unnamed_rld2 value=980125 size=20 maxlength=20/td /tr tr td height=30div align=center密碼：/div/td td input name=mm type=password class=unnamed_rld2 value=980125 size=20 maxlength=20/td /tr tr td height=30 colspan=2 div align=center input name=submit type=submit value=查詢 /div/td /tr /table學生成績查詢系統(tǒng)35 /form/td /tr /table/td td width=50% class=style2table width=380 border=0 align=center cellpadding=0 cellspacing=0 tr td form action= method=post name=form2 id=form2 table width=250 border=0 align=center cellpadding=0 cellspacing=0 class=unnamed1_rld tr bgcolor=EAEAEA td height=25 colspan=2 div align=center %if mm=1 then 對不起，您輸入的密碼有誤！ elseif mm=2 then 您沒有登陸的權限！elseif mm=3 then 請輸入完整的用戶名和密碼！ end if% 管理員登陸 /div/td /tr tr td width=100 height=30div align=center管理員賬號：/div/td td width=154 input name=keys type=hidden value=submit input name=username type=text class=unnamed_rld2 id=username2 value=admin size=20 maxlength=20/td /tr tr td height=30div align=center管理員密碼：/div/td td input name=password type=password class=unnamed_rld2 value=admin size=20 maxlength=20 /td /tr tr align=center td height=30 colspan=2 input type=submit name=Reg2 value=登錄 class=bottom input type=reset name=Submit32 value=重填 class=bottom學生成績查詢系統(tǒng)36 /td /tr /table /form/td /tr /table/td /tr/table p /p p /p p /p p /p table width=768 border=0 align=center cellpadding=0 cellspacing=0 tr td height=3 class=style2div align=center/div/td /tr /table table width=768 border=0 align=center cellpadding=0 cellspacing=0 tr td height=30 bgcolor=FFCCFF class=style2div align=center class=unnamed3write a href= class=unnamed3writepowered by deng131 /a /div/td /tr /table/body/html