📄 19.4.3 分页显示.html
字号:
<body>
<form>
<input type="button" value="第一页" onclick="list(1)"/>
<input type="button" value="上一页" onclick="list(2)" />
<input type="button" value="下一页" onclick="list(3)"/>
<input type="button" value="最后一页" onclick="list(4)" /><br />
<div id="lst"></div>
</form>
<script type="text/javascript" src="openCon.js"></script>
<script type="text/javascript" src="adojavas.inc"> </script>
<script language="javascript">
var rs=new ActiveXObject("ADODB.RecordSet");
var sql="select * from book";
var curpage=1;
rs.Locktype=3;
rs.cursortype=3;
rs.PageSize=2;
rs.open(sql,objconn);
//显示第一页
getPage(curpage);
function list(number)
{
switch(number)
{
case 1:
curpage=1;break;
case 2:
curpage-=1;break;
case 3:
curpage+=1;break;
case 4:
curpage=rs.PageCount;
}
if(curpage<1)
curpage=1;
if(curpage>rs.PageCount)
curpage=rs.PageCount;
getPage(curpage);
}
//显示指定的页面
function getPage()
{
rs.AbsolutePage=curpage;
var strRlt="<table style='border-collapse:collapse' border='1' bordercolor='#339900'>"
strRlt+=writeHead(rs,strRlt);
//循环显示当前页的记录
for(var i=1;i<=rs.PageSize;i++)
{
if(rs.EOF)
{
return;
}
strRlt+="<tr>";
var flds=new Enumerator(rs.Fields);
while(!flds.atEnd())
{
var fd=flds.item();
strRlt+="<td>"+fd.Value+"</td>";
flds.moveNext();
}
strRlt+="</tr>";
if(rs.EOF)
{
return;
}
else
if(i<rs.PageSize)
rs.moveNext();
}
strRlt+="</table>"
document.all("lst").innerHTML=strRlt;
}
function writeHead(rs,str)
{
var flds=new Enumerator(rs.Fields);
str+="<tr>";
while(!flds.atEnd())
{
var fd=flds.item();
str+="<td>"+fd.Name+"</td>";
flds.moveNext();
}
str+="</tr>";
return str;
}
</script>
</body>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -