📄 new_list.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="../Inc/AdminChk.asp"-->
<!--#include file="Conn.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>店铺新闻管理</title>
<LINK href="../style.css" type=text/css rel=stylesheet>
</head>
<body><!--#include file="top.asp"-->
<table width="100%" border="0">
<tr>
<td align="center">
<%
set rs=server.createobject("adodb.recordset")
sql="select * from new"
rs.open sql,conn,1,3
%>
<SCRIPT LANGUAGE="JavaScript">
<!--
function GoPage() {
window.location.href="?page_no="+ page.value;
}
//-->
</SCRIPT>
<table width="100%" border="0" cellspacing="1" bgcolor="#0099FF">
<tr align="center">
<td bgcolor="#FFFFFF"><font color="#0099FF">ID</font></td>
<td bgcolor="#FFFFFF"><font color="#0099FF">标题</font></td>
<td bgcolor="#FFFFFF"><font color="#0099FF">日期</font></td>
<td bgcolor="#FFFFFF"><font color="#0099FF">删除</font></td>
</tr>
<%
IF not rs.eof and not rs.bof then
dim page_size
dim page_no
dim page_total
page_size=15
if request.QueryString("page_no")="" then
page_no=1
else
page_no=cint(request.QueryString("page_no"))
end if
rs.pagesize=page_size
page_total=rs.pagecount
rs.absolutepage=page_no
dim I,J
I=0
J=page_size
do while not rs.eof and J>0
J=J-1
I=I+1
%>
<tr>
<td bgcolor="#FFFFFF"><%=rs("id")%></td>
<td bgcolor="#FFFFFF"><a href="../shopnewsinfor.asp?id=<%=rs("id")%>" target=_blank><%=rs("name")%></a></td>
<td bgcolor="#FFFFFF"><%=rs("date")%></td>
<td bgcolor="#FFFFFF"><a href="new_del.asp?id=<%=rs("id")%>">删除</a></td>
<%
Rs.MoveNext
Loop
End IF
%>
</table>
</td>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" class="page" >
<tr>
<td bgcolor="#D9F2FF"><div align="center">[本页是<%=int(page_no)%>/<%=int(page_total)%>] [<a href="?page_no=1">第一页</a>]
<%if int(page_no)>1 then%>
[<a href="?page_no=<%=cstr(int(page_no-1))%>">前一页</a>]
<%elseif int(page_no)<=1 then%>
[<a href="?page_no=1">前一页</a>]
<%end if%>
<%if int(page_no)<int(page_total) then%>
[<a href="?page_no=<%=cstr(int(page_no+1))%>">后一页</a>]
<%elseif int(page_no)>=int(page_total) then%>
[<a href="?page_no=<%=cstr(int(page_total))%>">后一页</a>]
<%end if%>
[<a href="?page_no=<%=page_total%>">最后一页</a>] 转到
<input name="page" type="text" value="<%=page_no%>" size="5">页
<input type="button" class=input name="Submit" value="转到" onclick="GoPage()"></div></td>
</tr>
</table><!--#include file="copy.asp"-->
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -