在ASP中,用JScript脚本实现分页的另类办法

王朝asp·作者佚名  2006-01-09
宽屏版  字体: |||超大  

<%@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>&nbsp;&nbsp;");

Response.Write("上一页&nbsp;&nbsp;");

Response.Write("<a href=list.asp?CurrentPageID="+NextPageID+">下一页</a>&nbsp;&nbsp;");

Response.Write("<a href=list.asp?CurrentPageID="+EndPage+">尾页</a>&nbsp;&nbsp;</p>");

}

else if (CurrentPageID == EndPage)

{

Response.Write("<p class='Normal'><a href=list.asp?CurrentPageID="+HomePage+">首页</a>&nbsp;&nbsp;");

Response.Write("<a href=list.asp?CurrentPageID="+PreviousPageID+">上一页</a>&nbsp;&nbsp;");

Response.Write("下一页&nbsp;&nbsp;");

Response.Write("<a href=list.asp?CurrentPageID="+EndPage+">尾页</a>&nbsp;&nbsp;</p>");

}

else

{

Response.Write("<p class='Normal'><a href=list.asp?CurrentPageID="+HomePage+">首页</a>&nbsp;&nbsp;");

Response.Write("<a href=list.asp?CurrentPageID="+PreviousPageID+">上一页</a>&nbsp;&nbsp;");

Response.Write("<a href=list.asp?CurrentPageID="+NextPageID+">下一页</a>&nbsp;&nbsp;");

Response.Write("<a href=list.asp?CurrentPageID="+EndPage+">尾页</a>&nbsp;&nbsp;</p>");

}

%>

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
© 2005- 王朝网络 版权所有