📄 reault.asp
字号:
<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>新建网页 1</title>
<!--#include file="conn1.asp"-->
<% itype=request("type")
set ort=server.createobject("adodb.recordset")
select case itype
case 1
if request("txtuser")<>"" then
sql="select * from teacher where name like '"&trim(request("txtuser"))&"' "
end if
case 2
if request("txtsex")<>"" then
sql="select * from teacher where sex='"&trim(request("txtsex"))&"' "
end if
case 3
if request("txtclass")<>"" then
sql="select * from teacher where classid='"&trim(request("txtclass"))&"' "
end if
end select %>
</head>
<body bgcolor="#E2F5E2">
<table border="1" align="center" width="80%" height="29" >
<tr >
<td width="7%" height="27" bgcolor="#66ccff"><font color="#80000">代码</font></td>
<td width="20%" height="27" bgcolor="#66ccff" ><font color="#80000">教师姓名</font></td>
<td width="20%" height="27" bgcolor="#66ccff"><font color="#80000">性别</font></td>
<td width="19%" height="27" bgcolor="#66ccff"><font color="#80000">授课班级</font></td>
<td width="19%" height="27" bgcolor="#66ccff"><font color="#800000">查询</font></td >
</tr>
<%ort.open sql ,conn
if not ort.bof and not ort.eof then
do while not ort.eof
i=i+1%>
<tr>
<td width="7%" height="1"><font color="#338800"><%=i%></font></td>
<td width="20%" height="1"><font color="#338800"><%=ort("name")%></font></td>
<td width="20%" height="1"><font color="#338800"><%=ort("sex")%></font></td>
<td width="19%" height="1"><font color="#338800"><%=ort("classid")%></font></td>
<td width="19%" height="1"><font color="#338800"><%response.write "<a href=tlist1.asp?teachername="&ort("name")&"&class="&ort("classid")&">"&"进入"&"</a>"%>
</tr>
<%ort.movenext
loop
%>
<%else%>
<%response.clear%>
<body bgcolor="e2f5e2">
<br>
<table cellpadding=0 cellspacing=0 border=0 width=656 bgcolor=#777777 align=center>
<tr>
<td width="656">
<table cellpadding=3 cellspacing=1 border=0 width="104%" height="77">
<tr align="center">
<td width="100%" bgcolor=#EEEEEE height="16">网页信息</td>
</tr>
<tr>
<td width="100%" bgcolor=#FFFFFF height="28"><br><br>
<br>
<ul>
<li>查无此人。
</ul>
</td>
</tr>
<tr align="center">
<td width="100%" bgcolor=#EEEEEE height="12">
<a href="javascript:history.go(-2)"> << 返回上一页</a>
</td>
</tr>
</table>
<%end if%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -