📄 shilian_yuxi.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">
</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>位置：管理系统：<a href="shilian_yuxi.asp">实验预习</a></td>
  </tr>
   <form name="form2" method="post" action="shilian_yuxi.asp">
  <tr>
    <td> 实验名称：
      <label>
      <input name="skey" type="text" id="skey" />
      <input type="submit" name="Submit" value="查询" />
    </label></td>
  </tr>
  </form>
</table>
<br />
<table width="760" height="30"  border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#6fb86c">
  <tr bgcolor="#f2fcf1">
    <td width="206">实验名称;</td>
    <td width="206">最小预约时长;</td>
    <td width="206" height="30">最大预约时长;</td>
    <td width="206">实验拓朴图;</td>
    <td width="206">操作;</td>
  </tr>
  <%dim rs
  set rs=server.createobject("adodb.recordset") 
  
  dim strsql
    strsql="select * from shilian"
   if request.form("skey")<>"" then
  strsql="select * from shilian where shilian_name='"& request.form("skey") &"'" 
    rs.open strsql,conn,1,1
    
  if not rs.eof then%>
  <tr bgcolor="#fafafa">
    <td width="206"><%=rs("shilian_name")%></td>
    <td width="206"><%=rs("min_time")%>小时</td>
    <td width="206" height="20"><%=rs("max_time")%>小时</td>
    <td width="206"><a href="viewpic.asp?id=<%=rs("id")%>" target="_blank">查看拓朴图</a>;</td>
    <td width="206"><a href="shilian_yuxi_show.asp?id=<%=rs("id")%>" target="_blank">查看详细</a></td>
  </tr>
  <% 
  else
  Response.write"没有此记录！"
  end if
  rs.close
  else
  
  rs.open strsql,conn,1,1
      do while not rs.eof
	%>
  <tr bgcolor="#fafafa">
    <td width="206"><%=rs("shilian_name")%></td>
    <td width="206"><%=rs("min_time")%>小时</td>
    <td width="206" height="20"><%=rs("max_time")%>小时</td>
    <td width="206"><a href="viewpic.asp?id=<%=rs("id")%>" target="_blank">查看拓朴图</a>;</td>
    <td width="206"><a href="shilian_yuxi_show.asp?id=<%=rs("id")%>" target="_blank">查看详细</a></td>
  </tr>
  <%rs.movenext
  loop
  rs.close
  end if
  %>
  
  
  
  
</table>
<br /><br />


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

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -