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

📄 s.asp

📁 功能强大的查询系统操作方便易懂好用不会繁琐数据库也强大
💻 ASP
字号:
<!-- #include file="Conn.asp" -->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title></title>
<link href="Images/default.css" rel="stylesheet" type="text/css" />
</head>

<body>
<form id="form1" name="form1" method="post" action="Search.asp">
  <table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#FFFFFF">
    <tr>
      <td height="24" colspan="2" class="AddGoods_Left"><div align="center">证书查询</div></td>
    </tr>
    <tr>
      <td height="5" colspan="2" background="Images/topnav.gif"></td>
    </tr>
    <tr>
      <td height="5" colspan="2"></td>
    </tr>
    <tr>
      <td width="15%" height="30" align="right" valign="middle" bgcolor="#efefef">学员姓名:</td>
      <td height="30" align="left" valign="middle">&nbsp;
          <input name="name" type="text" id="name" size="15" maxlength="5" />
      </td>
    </tr>
    <tr>
      <td height="30" align="right" valign="middle" bgcolor="#efefef">身份证号:</td>
      <td height="30" align="left" valign="middle">&nbsp;
          <input name="sid" type="text" id="sid" size="15" maxlength="18" style="ime-mode:disabled" />
  </td>
    </tr>
    <tr>
      <td height="30" align="right" valign="middle" bgcolor="#efefef">证书类别:</td>
      <td height="30" align="left" valign="middle">&nbsp;
          <select name="Cate" id="Cate">
<%
set fs=server.createobject("adodb.recordset")
fs.open "select * from Cate",conn,1,1
If fs.RecordCount=0 Then
Response.Write "<option value=''>暂无类别</option>"
Else
Do While Not fs.EOF
%>
            <option value="<%=Trim(fs("id"))%>"><%=Trim(fs("Catename"))%></option>
            <%
fs.MoveNext
Loop
End If
fs.Close
Set fs=nothing
%>
          </select></td>
    </tr>
    <tr>
      <td height="30" align="right" valign="middle" bgcolor="#efefef">&nbsp;</td>
      <td height="30" align="left" valign="middle">&nbsp;
        <span class="C_Title">
        <input type="submit" name="Submit2" value=" 查 询 " />
</span></td>
    </tr>
  </table>
</form>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -