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

来源:互联网 发布:学生管理系统数据库 编辑:程序博客网 时间:2024/05/16 11:27

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


<