📄 hardware_search.asp

📁 实验室资源管理系统实验室人事资料管理、实验室设备管理、实验课程管理及实验室软件资料管理及相关分析统计功能

💻 ASP

字号:

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="include/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="css/css.css" type="text/css" rel="stylesheet">
<script language="JavaScript">
function CheckForm()
{
	if(document.form.username2.value=="")
	{
		alert("请输入资料名称！");
		document.form.username2.focus();
		return false;
	}

}
</script>
</head>



<body>

   <!--#include file="include/header.asp"-->
<table width="760" height="77" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>位置：管理系统：硬件资料查询</td>
  </tr>
  <tr>
  <form name="form" action="" method="post" target="_parent" onSubmit="return CheckForm();">
    <td><div align="center">硬件资料名称：
      <input type="text" name="username2" />
      <label>
      <input type="submit" name="Submit3" value="查询" />
	  <input type="hidden" name="action" value="search_name" />
      </label>
    </div></td>
	</form>
  </tr>
</table>
<table width="760" height="166" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="206">&nbsp;</td>
    <td width="574" valign="top">
	<%if Request("action")="search_name" then
	
if request("page")<>"" then
    currentPage=cint(request("page"))
else
	currentPage=1
end if	
	
	dim rs,strsql
set rs=server.createobject("adodb.recordset")
strsql="select * from hardware where h_name like '%"&Request.form("username2")&"%'"
rs.open strsql,conn,1,1
if not rs.eof then


	%>
	
	<table width="450" border="0" cellpadding="0" cellspacing="1" bgcolor="#6fb86c">
      <tr bgcolor="#f2fcf1">
        <td height="30" colspan="3" align="center">查询结果</td>
        </tr>
      <tr bgcolor="#fafafa">
        <td width="61"><div align="center">编号
          </div></td>
        <td width="130" height="20"> <div align="center">硬件名称 </div></td><td width="255" height="20"><div align="center">描述</div></td>
      </tr>
	  <%do while not rs.eof%>
	  <tr bgcolor="#fafafa">
        <td width="61"><div align="center"><%=rs("h_id")%></div></td>
        <td width="130" height="20"><div align="center"><%=rs("h_name")%></div></td>
        <td width="255" height="20"><div align="center"><%=left(rs("h_discription"),30)%></div></td>
      </tr>
     <%
	   rs.movenext
	   loop
	 %>
    </table>
	<p>&nbsp;	  </p>
	<p>
	  <%else
	Response.write"<script>alert('没有你要找的记录！');</script>"
	end if
	end if
	%>
	  
    </p></td>
  </tr>
</table>

   <!--#include file="include/bottom.asp"-->
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -