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

isiqi

浏览: 16593413 次
性别:
来自: 济南

最近访客更多访客>>

yuxiatongzhi

nison

hellohank

wangyy

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

2012-07 ( 335)
2012-06 ( 252)
2012-05 ( 362)
更多存档...

ASP 脚本 SQL SQL Server JavaScript

<%@LANGUAGE="JAVASCRIPT"CODEPAGE="936"%>


<%
varDataSet,sql,DataList;
vari=0;
varj=0;
DataList=newNews();
DataSet=Server.CreateObject("Adodb.recordset");
sql="select*fromNewswherengroup='集团新闻'orderbyiddesc";
DataSet.Open(sql,DataConn,1,1);

//是否有数据
if((DataSet.eof)&&(DataSet.bof))
{
Response.Write(" ");
Response.Write("===暂无===");
Response.Write(" ");
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("<ahref=show.asp?id="+DataSet("id")+"target=\"_blank\">"+DataSet("subject")+"</a> ");
j=j+1;
DataSet.MoveNext;
}

//设定URL
if(CurrentPageID==HomePage)
{
Response.Write("<pclass='Normal'><ahref=list.asp?CurrentPageID="+HomePage+">首页</a>  ");
Response.Write("上一页  ");
Response.Write("<ahref=list.asp?CurrentPageID="+NextPageID+">下一页</a>  ");
Response.Write("<ahref=list.asp?CurrentPageID="+EndPage+">尾页</a>  ");
}
elseif(CurrentPageID==EndPage)
{
Response.Write("<pclass='Normal'><ahref=list.asp?CurrentPageID="+HomePage+">首页</a>  ");
Response.Write("<ahref=list.asp?CurrentPageID="+PreviousPageID+">上一页</a>  ");
Response.Write("下一页  ");
Response.Write("<ahref=list.asp?CurrentPageID="+EndPage+">尾页</a>  ");
}
else
{
Response.Write("<pclass='Normal'><ahref=list.asp?CurrentPageID="+HomePage+">首页</a>  ");
Response.Write("<ahref=list.asp?CurrentPageID="+PreviousPageID+">上一页</a>  ");
Response.Write("<ahref=list.asp?CurrentPageID="+NextPageID+">下一页</a>  ");
Response.Write("<ahref=list.asp?CurrentPageID="+EndPage+">尾页</a>  ");
}
%>

分享到：