📄 search_st.asp
字号:
<!--#include file="conn.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>按姓名和学院查询</title>
<link rel="stylesheet" href="style.css">
</head>
<body topmargin="0" background="../2s/images/bj.jpg" style="background-attachment: fixed">
<div align="center">
<table border="0" width="400" cellspacing="0" cellpadding="0">
<tr>
<td width="100%">
<form method="POST" action="search_user.asp">
<table border="1" width="100%" bordercolorlight="#000000" cellspacing="0" cellpadding="5" bordercolordark="#FFFFFF">
<tr>
<td width="33%">
<p align="right">按姓名查询：</td>
<center>
<td width="33%"><input type="text" name="user_name" size="20"></td>
<td width="34%"><input type="submit" value="提交" name="B1"></td>
</tr>
</table>
</form>
</center>
</td>
</tr>
<tr>
<td width="100%">
<form method="POST" action="search_number.asp">
<table border="1" width="100%" bordercolorlight="#000000" cellspacing="0" cellpadding="5" bordercolordark="#FFFFFF">
<tr>
<td width="33%">
<p align="right">按学院查询：</td>
<td width="33%"><select size="1" name="user_number">
<option value="机电学院">机电学院</option>
<option value="工学院">工学院</option>
<option value="商学院">商学院</option>
<option value="外语学院">外语学院</option>
<option selected value="基础学院">基础学院</option>
</select></td>
<td width="34%"><input type="submit" value="提交" name="B1"></td>
</tr>
</table>
</form>
</td>
</tr>
<tr>
<td width="100%">
</td>
</tr>
<tr>
<td width="100%">注意：搜索系统支持<font color="#FF0000">模糊查询</font>，即输入“应”，更可找到所有姓名为“应”的学生<br>
</td>
</tr>
</table>
</div>
<div align="center">
<center>
<table border="0" width="400" cellspacing="0" cellpadding="0">
<tr>
<td width="100%">最新登记记录列表(20条)</td>
<%set rs=server.createobject("adodb.recordset")%>
<%sql="select top 20 * from st_info order by id desc"%>
<%rs.open sql,conn,1,1%>
</tr>
<tr>
<td width="100%">
<table border="1" width="100%" cellspacing="0" cellpadding="5" bordercolorlight="#000000" bordercolordark="#FFFFFF">
<tr>
<td width="18%" align="center" bgcolor="#C0C0C0">ID</td>
<td width="22%" align="center" bgcolor="#C0C0C0">日期</td>
<td width="20%" align="center" bgcolor="#C0C0C0">姓名</td>
<td width="20%" align="center" bgcolor="#C0C0C0">类别</td>
<td width="20%" align="center" bgcolor="#C0C0C0">班级</td>
</tr>
<%
do while not rs.eof
%>
<tr>
<td width="18%" align="center"><%=rs("id")%></td>
<td width="22%" align="center"><%=(year(rs("user_number")))%>-<%=(month(rs("user_number")))%>-<%=(day(rs("user_number")))%></td>
<td width="20%" align="center"><A
onclick="window.showModelessDialog('viewuser.asp?id=<%=rs("id")%>',0,'dialogHeight:300px;dialogWidth:550px;center:yes;help:no;resizable:no;status:no')"
href="###"><%=rs("user_name")%></A></td>
<td width="20%" align="center"><%=rs("user_sex")%></td>
<td width="20%" align="center"><%=rs("user_class")%></td>
</tr>
<%rs.movenext%>
<%loop%>
<%rs.close%>
</table>
</td>
</tr>
</table>
</center>
</div>
<!--#include file="down.asp"-->
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -