📄 ajax实现分页查询 中国天易网.htm
字号:
href=\"<I>javascript</I>:TurnPage(1)\">首页</a>&nbsp;";<BR>
<BR> strInner += "<a
href=\"<I>javascript</I>:PreviousPage()\">前一页</a>&nbsp;";<BR>
<BR> strInner += "总共" + TotalPage +
"页&nbsp;";<BR> <BR> strInner += "<a
href=\"<I>javascript</I>:NextPage()\">下一页</a>&nbsp;";<BR>
<BR> strInner += "<a href=\"<I>javascript</I>:TurnPage(" +
TotalPage + ")\">尾页</a>&nbsp;";<BR>
<BR> tabinfo.innerHTML = strInner;<BR>
<BR> strInner = "";<BR>
<BR> if (CurTab > 1) strInner += "<a
href=\"<I>javascript</I>:TurnTab(-1)\">...</a>&nbsp;";<BR>
<BR> for ( ; nPage<=CurTab*PageTab; nPage++)
{<BR>
<BR> if (nPage <= TotalPage)
{<BR>
<BR> strInner
+= "<a href=\"<I>javascript</I>:TurnPage("+ nPage +
")\">"+nPage+"</a>&nbsp;"<BR>
<BR> }<BR>
}<BR> <BR> if (nPage < TotalPage)
strInner += "<a
href=\"<I>javascript</I>:TurnTab(1)\">...</a>&nbsp;";<BR>
<BR> carinfo.innerHTML = strInner;<BR>
<BR>}</P>
<P>
TurnPage函数用于切换分页，val表示要切换到的页数，根据要显示的页数生成查询范围，如查询前50条记录，从51到100的记录，从101到150的记录。。。<BR>
cscCustomAnalyst是一个异步调用函数，函数实现的代码将在下面贴出。"Method","SID", "TIME1", "TIME2",
"ROW1", "ROW2"都是执行查询所需的参数，Method是用来判断要执行什么查询，"ROW1",
"ROW2"表示要查询的记录范围，其他的参数就根据实际需要进行调整。ShowCarTrack(val)是一个对查询结果进行处理的函数，异步调用完成后得到的结果就将在这个函数中分析处理并且显示。这部分代码按照具体实现编写，我这里就不列出。</P>
<P>function TurnPage(val)<BR>{<BR> if (Number(val) != CurPage)
{<BR> <BR> CurPage =
Number(val);<BR>
<BR> var row1 = String((CurPage - 1) *
50 + 1);<BR> var row2 = String(CurPage
* 50);<BR>
<BR> var trackinfo =
document.getElementById("div_trackpoint");<BR>
trackinfo.innerHTML =
" 获取数据中，请稍等．．．";<BR>
<BR> _cscCustomAnalyst(["Method",
"SID", "TIME1", "TIME2", "ROW1", "ROW2"],
<BR>
["GetCarTrack",, "80100117", t1, t2, row1,
row2],<BR>
ShowCarTrack,onQueryError);<BR>
<BR> if (CurPage == 1)
TurnTab(0);<BR>
<BR> if (CurPage == TotalPage)
TurnTab(-2); <BR>
<BR> var statusinfo =
document.getElementById("div_trackpage_status");<BR>
<BR> statusinfo.innerHTML = "第" +
CurPage + "页";<BR> }</P>
<P>}</P>
<P> NextPage切换下一页，调用TurnPage实现，如果下一页超出当前分组则要切换到下一分组。</P>
<P>function NextPage()<BR>{<BR> if (CurPage < TotalPage)
{<BR> <BR>
TurnPage(CurPage+1);<BR>
<BR> if ((CurPage + 1) > (CurTab *
PageTab))
{<BR>
TurnTab(1);<BR>
}<BR> }<BR> <BR>}</P>
<P>
PreviousPage切换上一页，调用TurnPage实现，如果上一页超出当前分组则要切换到上一分组。<BR>function
PreviousPage()<BR>{<BR> if (CurPage > 1) {</P>
<P>
TurnPage(CurPage-1);<BR>
<BR> if ((CurPage - 1) <= ((CurTab
- 1) * PageTab))
{<BR>
TurnTab(-1);<BR>
}<BR> <BR>
}<BR>}</P>
<P> _cscCustomAnalyst是异步调用函数，xhr.open("post","MapQuery.ashx",
true);这段话是表示将请求提交到MapQuery.ashx这个页面。所有的服务器段数据库操作都在MapQuery.ashx里面执行。</P>
<P>function _cscCustomAnalyst(paramNames, paramValues, onComplete,
onError){<BR> <BR> var
xhr=_GetXmlHttpRequest();<BR> <BR>
xhr.open("post","MapQuery.ashx", true);</P>
<P> xhr.setRequestHeader("Content-Type",
"application/x-www-form-urlencoded");<BR>
<BR> xhr.onreadystatechange=function(){<BR>
<BR> var
readyState=xhr.readyState;<BR>
<BR> if
(readyState==4){<BR>
<BR> var
status=xhr.status;<BR>
<BR>
if(status==200){<BR>
<BR>
var resultset =
xhr.responseText;<BR>
<BR>
if(resultset ==
null){<BR>
onComplete(null);<BR>
return;<BR>
}</P>
<P>
if(onComplete){<BR>
onComplete(resultset);<BR>
resultset =
null;<BR>
}<BR>
}<BR>
else{<BR>
if(onError){<BR>
onError(xhr.responseText);<BR>
}<BR>
}<BR>
<BR>
xhr.onreadystatechange =
function(){};<BR>
<BR> xhr =
null;<BR> }<BR>
};<BR> <BR> var
paramString=null;<BR> <BR>
if(paramNames&&paramNames.length>0){<BR>
<BR> var params = new
Array();<BR>
<BR>
while(paramNames&&paramNames.length>0)<BR>
{<BR>
params.push(paramNames.shift()+"="+_ToJSON(paramValues.shift()));<BR>
}<BR>
<BR> paramString =
params.join("&");<BR>
<BR> }<BR> <BR>
xhr.send(paramString);<BR>};</P>
<P> 最后列出一个Oracle的按数量范围查询的SQL语句：(查询前50条记录)<BR>SELECT
*<BR> FROM (SELECT /*+ FULL(tablename)*/ fieldname,
ROWNUM rn FROM tablename WHERE condition AND ROWNUM <= 50 ORDER BY
field DESC) t2 where t2.rn >= 1;</P></DIV>
<DIV id=Gq_artHits>[
<SCRIPT language=JavaScript src="Ajax实现分页查询 中国天易网.files/Hits.htm"></SCRIPT>
] [<A href="javascript:history.go(-1)">返回上一页</A>] [<A
href="javascript:window.print()">打 印</A>] [<A
href="http://www.tee5.com/user/favorite.asp?action=add&topic=Ajax实现分页查询">收
藏</A>] </DIV>
<DIV id=Gq_artMore>上一篇文章：<A
href="http://www.tee5.com/News/1/6/2007/05/News_149.html">实例简析XPath串函数和XSLT</A><BR>下一篇文章：<A
href="http://www.tee5.com/News/1/7/2007/05/News_151.html">Ajax实现不刷屏的前提下实现页面定时刷新</A></DIV>
<DIV class=dot_bg>∷相关搜索∷</DIV>
<DIV id=Gq_artSo><IMG height=18 alt=百度搜索 src="Ajax实现分页查询 中国天易网.files/baidu.gif"
width=50 align=absMiddle border=0>中：<A
onclick='window.open("http://www1.baidu.com/baidu?word=Ajax实现分页查询 &cl=3&tn=qncxl3&ct=0&f=5&lm=0")'
href="javascript:">搜索“Ajax实现分页查询”相关内容</A><BR><IMG height=18 alt=Google搜索
src="Ajax实现分页查询 中国天易网.files/google.gif" width=50 align=absMiddle border=0>中：<A
onclick='window.open("http://www.google.com/search?hl=zh-CN&ie=gb&domains=www.tee5.com&q=Ajax实现分页查询 &sitesearch=")'
href="javascript:">搜索“Ajax实现分页查询”相关内容</A> </DIV>
<DIV class=dot_bg>∷相关文章评论∷ （评论内容只代表网友观点，与本站立场无关！） [<A
href="http://www.tee5.com/News/comment.asp?ArticleID=150"
target=_blank>更多评论</A>…]</DIV>
<DIV id=Gq_artComment></DIV>
<DIV class=Gq_artComment>
<FORM name=myform action=/News/comment.asp method=post><INPUT type=hidden
value=150 name=ArticleID> <INPUT type=hidden value=save name=action>
<DIV class=Dou_bg style="BORDER-TOP: #ccc 1px dashed">用户名：<INPUT maxLength=15
size=28 name=UserName> <FONT color=#ff0000>！</FONT></DIV>
<DIV class=Dou_bg>打分数：<INPUT type=radio value=100 name=Grade>100分 <INPUT
type=radio CHECKED value=85 name=Grade>85分 <INPUT type=radio value=70
name=Grade>70分 <INPUT type=radio value=55 name=Grade>55分 <INPUT type=radio
value=40 name=Grade>40分 <INPUT type=radio value=25 name=Grade>25分 <INPUT
type=radio value=10 name=Grade>10分 <INPUT type=radio value=0 name=Grade>0分</DIV>
<DIV class=Dou_bg>说 明：<TEXTAREA title=请注意用语文明且合法，不要发布带有攻击性的言论，谢谢合作！ name=content rows=5 cols=70></TEXTAREA></DIV>
<DIV id=Gq_artCommentadd>
<DIV class=Dou_bg style="PADDING-LEFT: 100px"><INPUT class=Button type=submit value=" 提 交 " name=Submit>
<INPUT class=Button type=reset value=" 重 设 " name=Submit2> (注“<FONT
color=#ff0000>！</FONT>”为必填内容。)
</DIV></DIV></FORM></DIV><!-- 文章内容 End --></DIV></DIV><!-- 内容 End --><!-- 尾部 Start -->
<DIV id=StyleBottom>
<DIV id=StyleBottomNav>
<DIV class=StyleBottomhr>
<HR align=center width="99%" color=#d0f2ff SIZE=2>
</DIV>
<DIV class=StyleBottomico><IMG src="Ajax实现分页查询 中国天易网.files/Ico.gif"
border=0></DIV>
<DIV class=StyleBottomby><A
href="http://www.tee5.com/About/Aboutus.html">关于我们</A> | <A
href="http://www.tee5.com/About/Contactus.html">联系方式</A> | <A
href="http://www.tee5.com/About/Pay.html">汇款方式</A> | <A
href="http://www.tee5.com/About/Case.html">成功案例</A> | <A
href="http://www.tee5.com/About/Services.html">售后服务</A> | <A
href="http://www.tee5.com/Link/" target=_blank>合作伙伴</A><BR>Copyright © 2004-2007
<A href="http://www.tee5.com/" target=_blank><FONT face=Verdana, Arial,
Helvetica, sans-serif><B>Tee5<FONT color=#cc0000>.Com</FONT></B></FONT></A>. All
Rights Reserved . 版权所有：<A href="http://www.tee5.com/"
target=_blank>天易网络</A><BR><FONT color=#cc0000>业务联系QQ：555140</FONT> 美化编写：天易鬼泣
程序策划：神泪(QQ:338545) <BR>Tee5 WebSite ManageSystem Version 2.0 Build 0518 </DIV>
<DIV class=StyleBottomgov><A
href="http://www.tee5.com/News/1/7/2007/05/News_150.html#"><IMG
src="Ajax实现分页查询 中国天易网.files/bottom_top.gif" border=0></A><BR><BR><A
href="http://www.miibeian.gov.cn/" target=_blank><FONT
color=#ff0000>苏ICP备06018988号</FONT></A><BR>
<SCRIPT language=JavaScript src="Ajax实现分页查询 中国天易网.files/stat.htm"
charset=gb2312></SCRIPT>
</DIV></DIV>
<DIV id=StyleBottomBg>
<DIV class=StyleBottomBg1><IMG src="Ajax实现分页查询 中国天易网.files/tee5_pic_05.jpg"
border=0></DIV>
<DIV class=StyleBottomBg2><IMG src="Ajax实现分页查询 中国天易网.files/tee5_pic_06.jpg"
border=0></DIV>
<DIV class=StyleBottomBg3><A href="http://www.tee5.com/admin/admin_login.asp"
target=_blank><IMG src="Ajax实现分页查询 中国天易网.files/tee5_pic_07.jpg"
border=0></A></DIV></DIV></DIV><!-- 尾部 End --></BODY></HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -