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

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

 1   
 2var DataSet,sql,DataList;   
 3var i=0;   
 4var j=0;   
 5DataList=new News();   
 6DataSet=Server.CreateObject("Adodb.recordset");   
 7sql="select * from News where ngroup='集团新闻' order by id desc";   
 8DataSet.Open(sql,DataConn,1,1); 
 9
10//是否有数据   
11if ((DataSet.eof)&&(DataSet.bof))   
12{   
13Response.Write("

<br/>

1" );   
2Response.Write("=== 暂无 ===");   
3Response.Write("

<br/>

<br/>

 1");   
 2Response.End();   
 3} 
 4
 5//记录总数   
 6NumRecords=DataSet.RecordCount; 
 7
 8//设定每页最大记录数   
 9PageSize=3; 
10
11//总页数   
12NumPages=Math.ceil(NumRecords/PageSize); 
13
14  
15//当前页   
16i=Request.QueryString("CurrentPageID").Count;   
17if (i==0)   
18{   
19CurrentPageID=1;   
20}   
21else   
22{   
23CurrentPageID=parseInt(Request.QueryString("CurrentPageID"));   
24} 
25
26//初始化   
27PreviousPageID=CurrentPageID-1;   
28NextPageID=CurrentPageID+1;   
29HomePage=1;   
30EndPage=NumPages; 
31
32//内容列表   
33DataSet.MoveFirst;   
34DataSet.Move((CurrentPageID-1)*PageSize,1);   
35while (!DataSet.eof && j

<pagesize) href='show.asp?id="+DataSet("id")+"' response.write("<a="" target='"_blank"' {="">"+DataSet("subject")+"<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>");
}

Published At
Categories with Web编程
Tagged with
comments powered by Disqus