📄 booksearch.asp

📁 === === === === === === === === === 项目：图书管理系统V2.0 作者：覃武权主页：http://cpucool.512j.com 邮箱：cooltoend

💻 ASP

字号:

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="Connections/conn.asp" -->
<!--#include file="global.asp" -->
<% checkUser("user") %>
<%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_conn_STRING
Recordset1.Source = "SELECT * FROM BookClass ORDER BY id ASC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

Recordset1_numRows = 0
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>图书查询</title>
<link href="images/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<p align="center">&nbsp;</p>
<table width="97%" border="0" align="center" cellpadding="4" cellspacing="1" bgcolor="#FFFFFF">
  <tr> 
    <td><br> <form name="form1" method="get" action="Bookslist.asp">
        <table width="95%" border="0" align="center" cellpadding="4" cellspacing="1" bgcolor="#000000">
          <tr class="header"> 
            <td colspan="2" nowrap><strong>图书查询</strong></td>
          </tr>
          <tr> 
            <td width="130" height="26" nowrap bgcolor="#F8F8F8">图书编号</td>
            <td width="781" bgcolor="#FFFFFF"> <input name="bookno" type="text" id="bookno">
              <font color="#FF0000">(不填写代表该选项查询条件为任意) </font></td>
          </tr>
          <tr> 
            <td height="26" bgcolor="#F8F8F8">分类</td>
            <td bgcolor="#FFFFFF"> <select name="sortno" id="sortno">
                <option value="0" selected>所有分类</option>
                <%
While (NOT Recordset1.EOF)
%>
                <option value="<%=(Recordset1.Fields.Item("id").Value)%>"><%=(Recordset1.Fields.Item("classname").Value)%></option>
                <%
  Recordset1.MoveNext()
Wend
If (Recordset1.CursorType > 0) Then
  Recordset1.MoveFirst
Else
  Recordset1.Requery
End If
%>
              </select></td>
          </tr>
          <tr> 
            <td height="26" bgcolor="#F8F8F8">书名</td>
            <td bgcolor="#FFFFFF"> <input name="title" type="text" id="title"></td>
          </tr>
          <tr> 
            <td height="26" bgcolor="#F8F8F8">著者</td>
            <td bgcolor="#FFFFFF"> <input name="author" type="text" id="author"></td>
          </tr>
          <tr> 
            <td height="26" bgcolor="#F8F8F8">价格</td>
            <td bgcolor="#FFFFFF"> <input name="price" type="text" id="price"></td>
          </tr>
        </table>
        <p align="center"> 
          <input type="submit" name="Submit" value="提 交 查 询">
          &nbsp; 
          <input type="reset" name="Submit2" value="重 置 条 件">
          <input name="action" type="hidden" id="action" value="search">
        </p>
      </form> <p align="center">&nbsp;</p> </td>
  </tr>
</table>
</body>
</html>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -