📄 dwlist.asp
字号:
<!--#include file="filetou.asp"-->
<%
sql="SELECT * FROM BMLIST WHERE 网点名<>'' "
set rs=server.createobject("ADODB.Recordset")
rs.Open sql,conn, 1, 1
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<Link Rel="STYLESHEET" Href="index.CSS" Type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>联盟网点</title>
</head>
<body bgcolor="#99CCFF">
<table border="1" cellspacing="0" width="100%" id="AutoNumber1" bordercolorlight="#000000" bordercolordark="#FFFFFF" bgcolor="#D4D0C8" cellpadding="0">
<tr>
<td width="100%">
<table border="0" cellspacing="1" width="100%" id="AutoNumber2" bgcolor="#000080">
<tr>
<td width="50%"> <font color="#FFFF00"> 联盟网点</font></td>
<td width="50%">
<p align="right">
<a href="javascript:history.back()"><font color="#FFFF00">返回</font></a>
</td>
</tr>
</table>
<table border="1" cellspacing="0" width="100%" id="AutoNumber3" bgcolor="#E8F9FF" style="border-collapse: collapse" bordercolor="#111111" cellpadding="2">
<tr>
<td bgcolor="#C5EBF5">名称</td>
<td bgcolor="#C5EBF5">地址</td>
<td bgcolor="#C5EBF5">电话</td>
<td bgcolor="#C5EBF5">联系人</td>
<td bgcolor="#C5EBF5">EMAIL</td>
</tr>
<% do while not rs.eof
Response.Write " <tr>"
Response.Write " <td><a href='dwxxlr.asp?name="&rs("网点名")&"'>"&rs("网点名")&"</a></td>"
Response.Write " <td>"&rs("地址")&"</td>"
Response.Write " <td>"&rs("电话")&"</td>"
Response.Write " <td><A HREF='userxxlr.asp?name="&rs("联系人")&"'>"&rs("联系人")&"</A></td>"
Response.Write " <td><a href='mailto:"&rs("email")&"'>"&rs("EMAIL")&"</a></td>"
Response.Write " </tr>"
rs.movenext
loop
rs.close
set conn=nothing%> </table>
</td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -