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