📄 admin_search.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<html>
<head>
<title>Untitled Documnt</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="all.css" rel=StyleSheet type=text/css>
</head>
<script language=JavaScript>
function winclose()
{
window.history.go(-1);
}
</script>
<body>
<p> </p>
<table border="0" align="center" cellspacing="0">
<form method="POST" action="admin_search.asp">
<tr>
<td width="157" align="center">关键字:</font>
<input name="keyword" type="text" value="" size="12"> </td>
<td width="157">按照
<select name="tj" style="font-family:幼圆">
<option value="hy_nch" selected>昵称
<option value="hy_name">姓名
<option value="hy_number">学号</option>
</select>
<input name="submit" type="submit" value="查 询"></td>
</tr>
</form>
</table>
</body>
</html>
<%if request("keyword")<>"" then
key=request("keyword")
term=request("tj")
%>
<!--#include file="conn.asp" -->
<%
sqltxt="select * from hydsh where "&term&"='"&key&"'"
set rs1 = conn.execute(sqltxt)
if rs1.eof then
response.write "sorry!没有找到你要的信息."
response.End()
end if%>
<table width="100%" height=183 border=1 cellpadding="0" cellspacing=0 bordercolor="#009900">
<tbody>
<tr bgcolor="#cbe6b9">
<td align=right height=18 width="21%">会员呢称:</td>
<td height=18 width="79%"> <%=rs1("hy_nch")%> </td>
</tr>
<tr bgcolor="#E7FDE3">
<td align=right height=18 width="21%">真实姓名:</td>
<td height=18 width="79%"> <%=rs1("hy_name")%> </td>
</tr>
<tr bgcolor="#cbe6b9">
<td align=right height=18 width="21%">学号:</td>
<td height=18 width="79%"> <%=rs1("hy_number")%> <font color=#ff0000> </font></td>
</tr>
<tr bgcolor="#E7FDE3">
<td align=right height=18 width="21%">院系专业班级:</td>
<td height=18 width="79%"> <%=rs1("hy_zy")%> </td>
</tr>
<tr bgcolor="#cbe6b9">
<td align=right height=18 width="21%">宿舍:</td>
<td height=18 width="79%"> <%=rs1("hy_address")%> </td>
</tr>
<tr bgcolor="#E7FDE3">
<td align=right height=18 width="21%">性别:</td>
<td height=18 width="79%"> <%=rs1("hy_sex")%> </td>
</tr>
<tr bgcolor="#cbe6b9">
<td align=right height=18 width="21%">联系电话:</td>
<td height=18 width="79%"> <%=rs1("hy_phone")%> </td>
</tr>
<tr bgcolor="#E7FDE3">
<td align=right height=18 width="21%">出生年月日:</td>
<td height=18 width="79%"> <%=rs1("hy_birthday")%> </td>
</tr>
<tr bgcolor="#cbe6b9">
<td align=right height=18 width="21%">电子邮箱:</td>
<td height=18 width="79%"> <%=rs1("hy_email")%> </td>
</tr>
<tr bgcolor="#E7FDE3">
<td width="21%" height=18 align=right valign="top">备注: </td>
<td height=18 width="79%"> <%=rs1("hy_jl")%> </td>
</tr>
<% set rs1=nothing
sqltxt="select * from hyinfor where "&term&"='"&key&"'"
set rs1 = conn.execute(sqltxt)
if not rs1.eof then
sht=rs1("hy_st")
else
sht="还未参加任何社团~"
end if
%>
<tr bgcolor="#cbe6b9">
<td align=right height=18 width="21%">所在社团:</td>
<td height=18 width="79%"><%=sht%> </td>
</tr>
<tr bgcolor="#CCCCCC">
<td width="21%" height=18 align=right> </td>
<td width="79%" height=18 align="center"> <a href="#" onClick="winclose()"><font color="#FF0000">后退</font></a>
</td>
</tr>
</tbody>
</table>
<%
set rs1=nothing
end if%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -