分页显示求助 - ASP技术论坛

hxfly

等　级：贵宾
威　望：17
帖　子：5810
专家分：118
注　册：2005-4-7

第 2 楼

得分:0

<%
sql="select * from a order by id desc"
set rs=Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,3,1,1
rs.pagesize=2
if Request.QueryString("pageNum")="" or Request.QueryString("pageNum")<0 then
page=1
else
page=Request.QueryString("pageNum")
end if
rs.Absolutepage=page

if not (rs.eof and rs.bof) then
do while not rs.eof and i<rs.pagesize
%>
显示相应的信息
<%
i=i+1
rs.movenext
loop

end if
%>

<%
ppage=page-1
if ppage>0 then
Response.Write("<a href=showlist.asp?list="&list&"&pagenum="&ppage&">上一页</a>  ")
end if
do while j<=rs.pagecount
Response.Write("<a href=showlist.asp?list="&list&"&pagenum="&j&">"&j&"</a>  ")
j=j+1
loop
npage=page+1
if npage<=rs.pagecount then
Response.Write("<a href=showlist.asp?list="&list&"&pagenum="&npage&">下一页</a>  ")
end if

Response.Write("您现在的位置是第"&page&"页  ")

%>

2005-12-06 14:45

dreame

等　级：新手上路
威　望：8
帖　子：521
专家分：0
注　册：2005-10-23

第 4 楼

得分:0

简洁！

有时候真的想放弃寂寞的等待，但她是那么的可爱！I love u forever！

2005-12-06 15:02

酷酷的鱼

等　级：新手上路
威　望：1
帖　子：472
专家分：0
注　册：2005-8-9

第 6 楼

得分:0

不行阿

我想实现< 1 2 3 4 5 6 下一页 >
这种分页显示的效果

不是上一页下一页的那种

2005-12-06 16:17

griefforyou

等　级：贵宾
威　望：27
帖　子：3336
专家分：0
注　册：2004-4-15

第 8 楼

得分:0

这个如何?
[CODE]<!doctype html public "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title> JavaScript: showPages v1.0 [by Lapuasi.com]</title>
<script language="JavaScript">
<!--
/*
showPages v1.1
=================================
Infomation
----------------------
Author : Lapuasi
E-Mail : lapuasi@gmail.com
Web : http://www.lapuasi.com
Date : 2005-11-17

Example
----------------------
var pg = new showPages('pg');
pg.pageCount = 12; //定义总页数(必要)
pg.argName = 'p'; //定义参数名(可选,缺省为page)
pg.printHtml(); //显示页数

Supported in Internet Explorer, Mozilla Firefox
*/
function showPages(name) { //初始化属性
this.name = name; //对象名称
this.page = 1; //当前页数
this.pageCount = 1; //总页数
this.argName = 'page'; //参数名
this.showTimes = 1; //打印次数
}
showPages.prototype.getPage = function(){ //丛url获得当前页数,如果变量重复只获取最后一个
var args = location.search;
var reg = new RegExp('[\?&]?' + this.argName + '=([^&]*)[&$]?', 'gi');
var chk = args.match(reg);
this.page = RegExp.$1;
}
showPages.prototype.checkPages = function(){ //进行当前页数和总页数的验证
if (isNaN(parseInt(this.page))) this.page = 1;
if (isNaN(parseInt(this.pageCount))) this.pageCount = 1;
if (this.page < 1) this.page = 1;
if (this.pageCount < 1) this.pageCount = 1;
if (this.page > this.pageCount) this.page = this.pageCount;
this.page = parseInt(this.page);
this.pageCount = parseInt(this.pageCount);
}
showPages.prototype.createHtml = function(mode){ //生成html代码
var strHtml = '', prevPage = this.page - 1, nextPage = this.page + 1;
if (mode == '' || typeof(mode) == 'undefined') mode = 0;
switch (mode) {
case 0 : //模式1 (页数,首页,前页,后页,尾页)
strHtml += 'Pages: ' + this.page + ' / ' + this.pageCount + '';
strHtml += '';
if (prevPage < 1) {
strHtml += '«';
strHtml += '';
} else {
strHtml += '<a href="javascript:' + this.name + '.toPage(1);">«</a>';
strHtml += '<a href="javascript:' + this.name + '.toPage(' + prevPage + ');"></a>';
}
for (var i = 1; i <= this.pageCount; i++) {
if (i > 0) {
if (i == this.page) {
strHtml += '[' + i + ']';
} else {
strHtml += '<a href="javascript:' + this.name + '.toPage(' + i + ');">[' + i + ']</a>';
}
}
}
if (nextPage > this.pageCount) {
strHtml += '';
strHtml += '»';
} else {
strHtml += '<a href="javascript:' + this.name + '.toPage(' + nextPage + ');"></a>';
strHtml += '<a href="javascript:' + this.name + '.toPage(' + this.pageCount + ');">»</a>';
}
strHtml += ' ';
break;
case 1 : //模式1 (10页缩略,首页,前页,后页,尾页)
strHtml += 'Pages: ' + this.page + ' / ' + this.pageCount + '';
strHtml += '';
if (prevPage < 1) {
strHtml += '«';
strHtml += '';
} else {
strHtml += '<a href="javascript:' + this.name + '.toPage(1);">«</a>';
strHtml += '<a href="javascript:' + this.name + '.toPage(' + prevPage + ');"></a>';
}
if (this.page % 10 ==0) {
var startPage = this.page - 9;
} else {
var startPage = this.page - this.page % 10 + 1;
}
if (startPage > 10) strHtml += '<a href="javascript:' + this.name + '.toPage(' + (startPage - 1) + ');">...</a>';
for (var i = startPage; i < startPage + 10; i++) {
if (i > this.pageCount) break;
if (i == this.page) {
strHtml += '[' + i + ']';
} else {
strHtml += '<a href="javascript:' + this.name + '.toPage(' + i + ');">[' + i + ']</a>';
}
}
if (this.pageCount >= startPage + 10) strHtml += '<a href="javascript:' + this.name + '.toPage(' + (startPage + 10) + ');">...</a>';
if (nextPage > this.pageCount) {
strHtml += '';
strHtml += '»';
} else {
strHtml += '<a href="javascript:' + this.name + '.toPage(' + nextPage + ');"></a>';
strHtml += '<a href="javascript:' + this.name + '.toPage(' + this.pageCount + ');">»</a>';
}
strHtml += ' ';
break;
case 2 : //模式2 (前后缩略,页数,首页,前页,后页,尾页)
strHtml += 'Pages: ' + this.page + ' / ' + this.pageCount + '';
strHtml += '';
if (prevPage < 1) {
strHtml += '«';
strHtml += '';
} else {
strHtml += '<a href="javascript:' + this.name + '.toPage(1);">«</a>';
strHtml += '<a href="javascript:' + this.name + '.toPage(' + prevPage + ');"></a>';
}
if (this.page != 1) strHtml += '<a href="javascript:' + this.name + '.toPage(1);">[1]</a>';
if (this.page >= 5) strHtml += '...';
if (this.pageCount > this.page + 2) {
var endPage = this.page + 2;
} else {
var endPage = this.pageCount;
}
for (var i = this.page - 2; i <= endPage; i++) {
if (i > 0) {
if (i == this.page) {
strHtml += '[' + i + ']';
} else {
if (i != 1 && i != this.pageCount) {
strHtml += '<a href="javascript:' + this.name + '.toPage(' + i + ');">[' + i + ']</a>';
}
}
}
}
if (this.page + 3 < this.pageCount) strHtml += '...';
if (this.page != this.pageCount) strHtml += '<a href="javascript:' + this.name + '.toPage(' + this.pageCount + ');">[' + this.pageCount + ']</a>';
if (nextPage > this.pageCount) {
strHtml += '';
strHtml += '»';
} else {
strHtml += '<a href="javascript:' + this.name + '.toPage(' + nextPage + ');"></a>';
strHtml += '<a href="javascript:' + this.name + '.toPage(' + this.pageCount + ');">»</a>';
}
strHtml += ' ';
break;
case 3 : //模式3 (箭头样式,首页,前页,后页,尾页) (only IE)
strHtml += 'Pages: ' + this.page + ' / ' + this.pageCount + '';
strHtml += '';
if (prevPage < 1) {
strHtml += '9';
strHtml += '7';
} else {
strHtml += '<a href="javascript:' + this.name + '.toPage(1);">9</a>';
strHtml += '<a href="javascript:' + this.name + '.toPage(' + prevPage + ');">7</a>';
}
if (nextPage > this.pageCount) {
strHtml += '8';
strHtml += ':';
} else {
strHtml += '<a href="javascript:' + this.name + '.toPage(' + nextPage + ');">8</a>';
strHtml += '<a href="javascript:' + this.name + '.toPage(' + this.pageCount + ');">:</a>';
}
strHtml += ' ';
break;
case 4 : //模式4 (下拉框)
if (this.pageCount < 1) {
strHtml += '<select name="toPage" disabled>';
strHtml += '<option value="0">No Pages</option>';
} else {
var chkSelect;
strHtml += '<select name="toPage" onchange="' + this.name + '.toPage(this);">';
for (var i = 1; i <= this.pageCount; i++) {
if (this.page == i) chkSelect=' selected="selected"';
else chkSelect='';
strHtml += '<option value="' + i + '"' + chkSelect + '>Pages: ' + i + ' / ' + this.pageCount + '</option>';
}
}
strHtml += '</select>';
break;
case 5 : //模式5 (输入框)
strHtml += '';
if (this.pageCount < 1) {
strHtml += '<input type="text" name="toPage" value="No Pages" class="itext" disabled="disabled">';
strHtml += '<input type="button" name="go" value="GO" class="ibutton" disabled="disabled"></option>';
} else {
strHtml += '<input type="text" value="Input Page:" class="ititle" readonly="readonly">';
strHtml += '<input type="text" id="pageInput' + this.showTimes + '" value="' + this.page + '" class="itext" title="Input page" onkeypress="return ' + this.name + '.formatInputPage(event);" onfocus="this.select()">';
strHtml += '<input type="text" value=" / ' + this.pageCount + '" class="icount" readonly="readonly">';
strHtml += '<input type="button" name="go" value="GO" class="ibutton" onclick="' + this.name + '.toPage(document.getElementById(\'pageInput' + this.showTimes + '\').value);"></option>';
}
strHtml += '';
break;
default :
strHtml = 'Javascript showPage Error: not find mode ' + mode;
break;
}
return strHtml;
}
showPages.prototype.createUrl = function (page) { //生成页面跳转url
if (isNaN(parseInt(page))) page = 1;
if (page < 1) page = 1;
if (page > this.pageCount) page = this.pageCount;
var url = location.protocol + '//' + location.host + location.pathname;
var args = location.search;
var reg = new RegExp('([\?&]?)' + this.argName + '=[^&]*[&$]?', 'gi');
args = args.replace(reg,'$1');
if (args == '' || args == null) {
args += '?' + this.argName + '=' + page;
} else if (args.substr(args.length - 1,1) == '?' || args.substr(args.length - 1,1) == '&') {
args += this.argName + '=' + page;
} else {
args += '&' + this.argName + '=' + page;
}
return url + args;
}
showPages.prototype.toPage = function(page){ //页面跳转
var turnTo = 1;
if (typeof(page) == 'object') {
turnTo = page.options[page.selectedIndex].value;
} else {
turnTo = page;
}
self.location.href = this.createUrl(turnTo);
}
showPages.prototype.printHtml = function(mode){ //显示html代码
this.getPage();
this.checkPages();
this.showTimes += 1;
document.write('<div id="pages_' + this.name + '_' + this.showTimes + '" class="pages"></div>');
document.getElementById('pages_' + this.name + '_' + this.showTimes).innerHTML = this.createHtml(mode);

}
showPages.prototype.formatInputPage = function(e){ //限定输入页数格式
var ie = navigator.appName=="Microsoft Internet Explorer"?true:false;
if(!ie) var key = e.which;
else var key = event.keyCode;
if (key == 8 || key == 46 || (key >= 48 && key <= 57)) return true;
return false;
}
//-->
</script>
<style>
/* Pages Main Tyle */
.pages {
color: #000000;
cursor: default;
font-size: 10px;
font-family: Tahoma, Verdana;
padding: 3px 0px 3px 0px;
}
.pages .count, .pages .number, .pages .arrow {
color: #000000;
font-size: 10px;
background-color: #F7F7F7;
border: 1px solid #CCCCCC;
}
/* Page and PageCount Style */
.pages .count {
font-weight: bold;
border-right: none;
padding: 2px 10px 1px 10px;
}
/* Mode 0,1,2 Style (Number) */
.pages .number {
font-weight: normal;
padding: 2px 10px 1px 10px;
}
.pages .number a, .pages .number span {
font-size: 10px;
}
.pages .number span {
color: #999999;
margin: 0px 3px 0px 3px;
}
.pages .number a {
color: #000000;
text-decoration: none;
}
.pages .number a:hover {
color: #0000ff;
}
/* Mode 3 Style (Arrow) */
.pages .arrow {
font-weight: normal;
padding: 0px 5px 0px 5px;
}
.pages .arrow a, .pages .arrow span {
font-size: 10px;
font-family: Webdings;
}
.pages .arrow span {
color: #999999;
margin: 0px 5px 0px 5px;
}
.pages .arrow a {
color: #000000;
text-decoration: none;
}
.pages .arrow a:hover {
color: #0000ff;
}
/* Mode 4 Style (Select) */
.pages select, .pages input {
color: #000000;
font-size: 10px;
font-family: Tahoma, Verdana;
}
/* Mode 5 Style (Input) */
.pages .input input.ititle, .pages .input input.itext, .pages .input input.icount {
color: #666666;
font-weight: bold;
background-color: #F7F7F7;
border: 1px solid #CCCCCC;
}
.pages .input input.ititle {
width: 70px;
text-align: right;
border-right: none;
}
.pages .input input.itext {
width: 25px;
color: #000000;
text-align: right;
border-left: none;
border-right: none;
}
.pages .input input.icount {
width: 35px;
text-align: left;
border-left: none;
}
.pages .input input.ibutton {
height: 17px;
color: #FFFFFF;
font-weight: bold;
font-family: Verdana;
background-color: #999999;
border: 1px solid #666666;
padding: 0px 0px 2px 1px;
margin-left: 2px;
cursor: hand;
}
/* body */
body {
font-size: 12px;
}
</style>
</head>
<body>
<script language="JavaScript">

</script>
</body>
</html>[/CODE]

天津网站建设 http://www./

2005-12-06 17:01

酷酷的鱼

等　级：新手上路
威　望：1
帖　子：472
专家分：0
注　册：2005-8-9

第 10 楼

得分:0

谢谢大家

2005-12-08 10:46