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

📄 course_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="38">&nbsp;</td>
    <td width="722" 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 shilian where shilian_name like '%"&Request.form("username2")&"%'"
rs.open strsql,conn,1,1
if not rs.eof then


	%>
	
	<table width="691" border="0" cellpadding="0" cellspacing="1" bgcolor="#6fb86c">
      <tr bgcolor="#f2fcf1">
        <td height="30" colspan="6" align="center">查询结果</td>
        </tr>
      <tr bgcolor="#fafafa">
        <td width="42"><div align="center">编号
          </div></td>
        <td width="260" height="20"> <div align="center"> 实验名称</div></td>
        <td width="95"> <div align="center">最小预约时长 </div></td>
        <td width="84"> <div align="center">最大预约时长 </div></td>
        <td width="115" height="20"><div align="center"> 是否允许查看答案 </div></td>
        <td width="88"><div align="center">操作</div></td>
      </tr>
	  <%do while not rs.eof%>
	  <tr bgcolor="#fafafa">
        <td width="42"><div align="center"><%=rs("id")%></div></td>
        <td width="260" height="20"><div align="center"><%=rs("shilian_name")%></div></td>
        <td width="95"><div align="center"><%=rs("min_time")%></div></td>
        <td width="84"><div align="center"><%=rs("max_time")%></div></td>
        <td width="115" height="20"><div align="center"><%=rs("isviewanswer")%></div></td>
        <td width="88" height="20"><div align="center"><a href="course_detail.asp?id=<%=rs("id")%>" target="_blank">详细信息</a></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 + -