⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 admin_search.asp

📁 ASPkaifa 11111111111111111111111
💻 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>&nbsp;</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>&nbsp;</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>&nbsp;</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 + -