📄 display.asp

📁 购物系统(本版为正式商业版
💻 ASP
字号:
<!--#include file="conn.asp"-->
<!--#include file="adminset.asp"-->
<%if session("admin")="" then
response.Write "<script language='javascript'>alert('网络超时或您还没有登陆！');window.location.href='login.asp';</script>"
response.End
end if
if session("flag")>2 then
response.Write "<div align=center><font size=80 color=red><b>您没有此项目管理权限！</b></font></div>"
response.End
end if
if qx16<>1 then
response.Write "<div align=center><font size=80 color=red><b>您没有此项目管理权限！</b></font></div>"
response.End
end if
%><html>
<title>邮件列表</title>
<link href="../css.css" rel="stylesheet" type="text/css">


<style type="text/css">
<!--
.style1 {
	color: #000000;
	font-weight: bold;
}
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
-->
</style>
<body bgcolor="#FFFFFF">
<table width="100%" border="0" cellpadding="0" cellspacing="0" background="images/right_top2.gif">
  <tr>
    <td width="1%">&nbsp;</td>
    <td width="99%"><table width="100%" border="0" cellspacing="0" cellpadding="5">
        <tr>
          <td width="30%" style="font-size:14px;color:#ffffff">&nbsp;<span class="style1">邮件列表</span></td>
          <td width="70%" align="right">&nbsp;</td>
        </tr>
    </table></td>
  </tr>
</table><br>
<table width="90%" border="0" align="center" cellpadding="3" cellspacing="1" bordercolorlight="#CCCCCC" bordercolordark="#CCCCCC" bgcolor="#9DB2D4">
 <% 
            
set rs = server.createobject("adodb.recordset")
on error resume next
dim curpage, curtopic, strtopic
dim FIRSTNO, PERPAGE
PERPAGE = 20	'每页显示记录数

    
    if request("page")="" then
  	curpage = 1
else
	curpage = cint(request("page"))
end if
sql = "SELECT * FROM mail ORDER BY id DESC"
rs.open sql,conn,1,1

if err.number <> 0 then
	response.write "数据库连接发生了错误"
	else
	if rs.bof and rs.eof then
		rs.close
		response.write "<center>目前还没有任何用户的邮件"
	else
		dim i
		rs.pagesize = PERPAGE
		rs.absolutepage = curpage
	
		for i = 1 to rs.pagesize
		%>  <tr valign="top"> 
          
    <td width="524" bgcolor="#F0F3F8"> 邮件：<a href=mailto:<%=rs("mail")%>><%=rs("mail")%></a> 加入时间：<%=rs("date")%> IP地址：<%=rs("ip")%>
     </td>
  </tr><%
			rs.movenext
			if rs.eof then
				i = i + 1
				exit for
			end if
		next%>
        
  <tr align="left" bgcolor="#CCCCCC"> 
    <td width="524" height="23" bgcolor="#F0F3F8"><%
		response.write "第" + cstr(curpage) + "页/总" + cstr(rs.pagecount) + "页 "
		response.write "本页" + cstr(i-1) + "条/总" + cstr(rs.recordcount) + "条 "
		if curpage = 1 then 
			response.write "首页 前页 "
		else
			response.write "<a href='display.asp?page=1'>首页</a> <a href='display.asp?page=" + cstr(curpage-1) + "'>前页</a> "
		end if
		if  curpage = rs.pagecount then
			response.write "后页 末页"
		else
			response.write "<a href='display.asp?page=" + cstr(curpage+1) + "'>后页</a> <a href='display.asp?page=" + cstr(rs.pagecount) + "'>末页</a>"
		end if
		rs.close
 	'end if	
end if	
end if	
set rs = nothing
call endconnection()

 %> </td>
         
  </tr>
</table>
      <br>
<!--#include file="copyright.asp"-->
</body>
      </html>
⌨️ 快捷键说明

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