|
![]() |
名片设计 CorelDRAW Illustrator AuotoCAD Painter 其他软件 Photoshop Fireworks Flash |
|
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%> <!--#include file="connect.asp"--> <!--#include file="news.asp"--> <% var DataSet,sql,DataList; var i=0; var j=0; DataList=new News(); DataSet=Server.CreateObject("Adodb.recordset"); sql="select * from News where ngroup=\\\'集团新闻\\\' order by id desc"; DataSet.Open(sql,DataConn,1,1); //是否有数据 if ((DataSet.eof)&&(DataSet.bof)) { Response.Write("<BR>" ); Response.Write("=== 暂无 ==="); Response.Write("<BR><BR>"); Response.End(); } //记录总数 NumRecords=DataSet.RecordCount; //设定每页最大记录数 PageSize=3; //总页数 NumPages=Math.ceil(NumRecords/PageSize); //当前页 i=Request.QueryString("CurrentPageID").Count; if (i==0) { CurrentPageID=1; } else { CurrentPageID=parseInt(Request.QueryString("CurrentPageID")); } //初始化 PreviousPageID=CurrentPageID-1; NextPageID=CurrentPageID+1; HomePage=1; EndPage=NumPages; //内容列表 DataSet.MoveFirst; DataSet.Move((CurrentPageID-1)*PageSize,1); while (!DataSet.eof && j<PageSize) { Response.Write("<a href=show.asp?id="+DataSet("id")+" target="_blank">"+DataSet("subject")+"</a><br>"); j=j+1; DataSet.MoveNext; } //设定URL if (CurrentPageID == HomePage) { Response.Write("<p class=\\\'Normal\\\'><a href=list.asp?CurrentPageID="+HomePage+">首页</a> "); Response.Write("上一页 "); Response.Write("<a href=list.asp?CurrentPageID="+NextPageID+">下一页</a> "); Response.Write("<a href=list.asp?CurrentPageID="+EndPage+">尾页</a> </p>"); } else if (CurrentPageID == EndPage) { Response.Write("<p class=\\\'Normal\\\'><a href=list.asp?CurrentPageID="+HomePage+">首页</a> "); Response.Write("<a href=list.asp?CurrentPageID="+PreviousPageID+">上一页</a> "); Response.Write("下一页 "); Response.Write("<a href=list.asp?CurrentPageID="+EndPage+">尾页</a> </p>"); } else { Response.Write("<p class=\\\'Normal\\\'><a href=list.asp?CurrentPageID="+HomePage+">首页</a> "); Response.Write("<a href=list.asp?CurrentPageID="+PreviousPageID+">上一页</a> "); Response.Write("<a href=list.asp?CurrentPageID="+NextPageID+">下一页</a> "); Response.Write("<a href=list.asp?CurrentPageID="+EndPage+">尾页</a> </p>"); } %> 返回类别: 教程 上一教程: ASP程序中使用断开的数据记录集 下一教程: 出现404页面错误的自动发送邮件的代码 您可以阅读与"在ASP中,用JSCRIPT脚本实现分页的另类办法"相关的教程: · 用ASP实现分页的源码 · 用ASP实现分页显示的具体讲解 · ASP+FSO+框架实现ASP生成HTM并分页的方式 · 在ASP中通过GETROWS实现数据库记录分页的一段代码 · 实现分页的例子-使用存储过程来实现分页 |
![]() ![]() |
快精灵印艺坊 版权所有 |
首页![]() ![]() ![]() ![]() ![]() ![]() ![]() |