📄 news_list.asp
字号:
<%
'****************************************************
' 多多校园 Power by ddtaobao.com
' Email:ddmaster@126.com OICQ:136465584
' Web: http://www.ddtaobao.com 作者:多多
' 校园、企业、医院、公司程序定做，系统开发，网站制作!
' Copyright (C) 2007 ddtaobao.com All Rights Reserved
'****************************************************
%><!--#include file="top.asp"-->
<BODY>
<BODY>
<div align="center">
<TABLE width=778 border=0 cellpadding="0" cellspacing="0">
<TBODY>
<TR align="center"> <TD vAlign=top width=182>
<TABLE cellSpacing=0 cellPadding=0 width="182" border=0>
<TBODY>
<TR>
<TD class=right_title_bs06 align=center>会 员 登 陆</TD>
</TR>
<TR>
<TD> <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD >
<% call ShowUserLogin() %>
</TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
<TR>
<TD class=right_title_bs06 align=center>店 铺 分 类</TD>
</TR>
<TR>
<TD>
<% call showshoptype %>
</TD>
</TR>
<TR>
<TD class=right_title_bs06 align=center>搜 索 宝 贝</TD>
</TR>
<TR>
<TD> <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD > <TABLE width="100%" align=center border=0>
<TBODY>
<TR>
<TD> <form action="search.asp" method="post" name="form" id="form">
<table width="100%" border="0" cellpadding="2">
<tr>
<td>
商品名称:<INPUT size=15 name=keyword></td>
</tr>
<tr>
<td align="center">
<input type="submit" name="Submit" value="搜索看看" class=input2></td>
</tr>
</table>
</form>
</TD>
</TR>
</TABLE><TABLE width="100%" align=center border=0>
<TBODY>
<TR>
<TD> <form action="shopsearch.asp" method="post" name="form1" id="form1">
<table width="100%" border="0" cellpadding="2">
<tr>
<td>
店铺名称:<INPUT size=15 name=keyword></td>
</tr>
<tr>
<td align="center">
<input type="submit" name="Submit" value="搜索看看" class=input2></td>
</tr>
</table>
</form>
</TD>
</TR>
</TABLE></TD>
</TR>
</TABLE></TD>
</TR>
</TABLE>
</TD><td class=line></td>
<TD vAlign=top>
<%
dim strsql,rs
set rs=server.CreateObject("adodb.recordset")
strsql="Select * From dd_news Order By id Desc"
rs.open strsql,conn,1,1
%>
<SCRIPT LANGUAGE="JavaScript">
<!--
function GoPage() {
window.location.href="?page_no="+ page.value;
}
//-->
</SCRIPT>
<div align="center">
<TABLE cellpadding="3" cellspacing="1" align="center" class="tableborder1">
<TR>
<TD class=main_title_bsf colspan="3">
新闻列表</TD>
</TR>
<tr>
<td class="tablebody1" align="center">标题</td>
<td class="tablebody1" align="center">人气</td>
<td class="tablebody1" width="67" align="center">时间</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 height=18 class="tablebody1" > ·<a href="news_info.asp?id=<%=rs("id")%>" target="_blank"><%=rs("newsname")%></a></td>
<td align="center" class="tablebody1" >浏览<font class=font>(<%=rs("newstimes")%>)</font>次</td>
<td align="right" class="tablebody1" width="67" ><font color="#999999">(<%=rs("newsdate")%>)</font></td>
</tr>
<%
Rs.MoveNext
Loop
End IF
%>
</table>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" class=page>
<tr>
<td><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>
</div> </div>
</tr>
</TBODY>
</TABLE>
<!--#include file="bottom.asp"-->
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -