📄 list_user.asp
字号:
<%
if request.cookies("flag")="" then
response.write "<script>top.location.href=""login.asp"";</script>"
response.end
end if
%>
<!--#include file="dbconn.asp"-->
<html>
<head>
<title>Untitled Document</title>
<LINK href="css/style.css" type=text/css rel=stylesheet>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p align="center"> </p><form name="form1" method="post" action="search_user.asp">
<div align="center"><font color="#808080" style="font-size: 9pt"><font color="#000000">搜索：</font>
<input name="search" size="30" style="border: 1 solid #808080"> </font> <FONT COLOR="#808080" STYLE="font-size: 9pt"><SELECT NAME="dq"><OPTION VALUE="">全部</OPTION><OPTION VALUE="梅州城区">梅州城区</OPTION><OPTION VALUE="梅江区">梅江区</OPTION><OPTION VALUE="平远县">平远县</OPTION><OPTION VALUE="蕉岭县">蕉岭县</OPTION><OPTION VALUE="大埔县">大埔县</OPTION><OPTION VALUE="丰顺县">丰顺县</OPTION><OPTION VALUE="兴宁市">兴宁市</OPTION><OPTION VALUE="五华县">五华县</OPTION><OPTION VALUE="广东地区">广东地区</OPTION><OPTION VALUE="全国各地">全国各地</OPTION></SELECT></FONT><input type="submit" name="Submit" value="搜索">
</div></form><p align="center"> </p><p> <%
i=1
set rs=server.createobject("ADODB.recordset")
sql="select * from contacts order by id desc"
rs.open sql,conn,1,1
%> </p>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
<tr bgcolor="#CCCCCC">
<td width="46" height="28"> <div align="center"><b>编号</b></div></td>
<td width="71" height="28"> <div align="center"><b>地区</b></div></td>
<td width="257" height="28"> <div align="center"><b>企业名称</b></div></td>
<td width="108" height="28"> <div align="center"><b><font color="#000000">电话</font></b></div></td>
<td width="248" height="28"> <div align="center"><b>网址</b></div></td>
<td width="95" height="28"> <div align="center"><b>经办人</b></div></td>
<td width="131" height="28"> <div align="center"><b>操作</b></div></td>
</tr>
<%do while not rs.eof%>
<tr>
<td width="46" height="32"> <div align="center"><font color="#0000FF"><b><font face="Arial, Helvetica, sans-serif"><%=i%>
<%'=rs("id")%>
</font></b></font></div></td>
<td width="71" height="32"> <div align="center"><%=rs("地区")%></div></td>
<td width="257" height="32"> <div align="left"> <a href="list.asp?company=<%=rs("企业名称")%>"><%=rs("企业名称")%></a></div></td>
<td width="108" height="32"> <div align="center"><%=rs("电话")%></div></td>
<td width="248" height="32"> <div align="left"> <%=rs("网址")%></div></td>
<td width="95" height="32"> <div align="center"><%=rs("经办人1")%>、<%=rs("经办人2")%></div></td>
<td width="131" height="32"> <div align="center"><a href="edit_user.asp?id=<%=rs("id")%>">修改</a></div></td>
</tr>
<%
i=i+1
rs.movenext
loop
%>
<%rs.close
set rs=nothing
%>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -