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

📄 left_link.asp

📁 一个邮政 编码查询系统的代码
💻 ASP
字号:
<%
Dim rs_yb_link__MMColParam
rs_yb_link__MMColParam = "1"
If (Request.QueryString("nr") <> "") Then 
  rs_yb_link__MMColParam = Request.QueryString("nr")
End If
%>
<%
Dim rs_yb_link
Dim rs_yb_link_numRows

Set rs_yb_link = Server.CreateObject("ADODB.Recordset")
rs_yb_link.ActiveConnection = MM_ybqh_STRING
Select case Request.QueryString("type")
	Case "dm"
cmd_line=" dq ='"
	Case "qh"
cmd_line=" qh ='"
	Case "yb"
cmd_line=" yb='"
End Select

rs_yb_link.Source = "SELECT id, dq, lj1, lj1_name, lj2, lj2_name, lj3, lj3_name, lj4, lj4_name, lj5, lj5_name FROM ybqh WHERE "&cmd_line&Replace(rs_yb_link__MMColParam, "'", "''") + "'"
rs_yb_link.CursorType = 0
rs_yb_link.CursorLocation = 2
rs_yb_link.LockType = 1
rs_yb_link.Open()

rs_yb_link_numRows = 0
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="style.css" rel="stylesheet" type="text/css">
</head>

<body>

<table width="120" border="0" cellpadding="0" cellspacing="0" background="images/ybcx_20.gif" class="xiao">
  <!--DWLayoutTable-->
  <tr> 
    <td height="50" colspan="2" valign="top"><img src="images/ybcx_24.gif" width="160" height="36"></td>
  </tr>
<%
Session("not_found")="yes"
If Not rs_yb_link.Eof Then 
Session("not_found")="no"
%>  
  <tr> 
    <td width="11" height="13" rowspan="4"></td>
    <td width="149" valign="top"><div align="center"><a href="<%=(rs_yb_link.Fields.Item("lj1").Value)%>" target="_blank"><%=(rs_yb_link.Fields.Item("lj1_name").Value)%></a></div></td>
  </tr>
  <tr> 
    <td valign="top"><div align="center"><a href="<%=(rs_yb_link.Fields.Item("lj2").Value)%>" target="_blank"><%=(rs_yb_link.Fields.Item("lj2_name").Value)%></a></div></td>
  </tr>
  <tr> 
    <td valign="top"><div align="center"><a href="<%=(rs_yb_link.Fields.Item("lj3").Value)%>" target="_blank"><%=(rs_yb_link.Fields.Item("lj3_name").Value)%></a></div></td>
  </tr>
  <tr> 
    <td valign="top"><div align="center"><a href="<%=(rs_yb_link.Fields.Item("lj4").Value)%>" target="_blank"><%=(rs_yb_link.Fields.Item("lj4_name").Value)%></a></div></td>
  </tr>
  <tr> 
    <td height="14"></td>
    <td valign="top"><div align="center"><a href="<%=(rs_yb_link.Fields.Item("lj5").Value)%>" target="_blank"><%=(rs_yb_link.Fields.Item("lj5_name").Value)%></a></div></td>
  </tr>
  <%End If %>
  <tr> 
    <td height="16" colspan="2" valign="bottom"><img src="images/ybcx_22.gif" width="160" height="6"></td>
  </tr>
</table>
</body>
</html>
<%
rs_yb_link.Close()
Set rs_yb_link = Nothing
%>

⌨️ 快捷键说明

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