Ajax实现分页查询

if ((CurPage - 1) <= ((CurTab - 1) * PageTab)) {
TurnTab(-1);
}

}
} 字串3

_cscCustomAnalyst是异步调用函数，xhr.open("post","MapQuery.ashx", true);这段话是表示将请求提交到MapQuery.ashx这个页面。所有的服务器段数据库操作都在MapQuery.ashx里面执行。

字串3

function _cscCustomAnalyst(paramNames, paramValues, onComplete, onError){

var xhr=_GetXmlHttpRequest();

xhr.open("post","MapQuery.ashx", true);

字串1

xhr.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");

xhr.onreadystatechange=function(){

var readyState=xhr.readyState;

if (readyState==4){

var status=xhr.status;

if(status==200){

var resultset = xhr.responseText;

if(resultset == null){
onComplete(null);
return;
} 字串9

if(onComplete){
onComplete(resultset);
resultset = null;
}
}
else{
if(onError){
onError(xhr.responseText);
}
}

xhr.onreadystatechange = function(){};

xhr = null;
}
};

var paramString=null;

if(paramNames&&paramNames.length>0){

var params = new Array();

while(paramNames&&paramNames.length>0)
{
params.push(paramNames.shift() "=" _ToJSON(paramValues.shift()));
}

paramString = params.join("&");

}

xhr.send(paramString);
}; 字串3

最后列出一个Oracle的按数量范围查询的SQL语句：(查询前50条记录)
SELECT *
FROM (SELECT /* FULL(tablename)*/ fieldname, ROWNUM rn FROM tablename WHERE condition AND ROWNUM <= 50 ORDER BY field DESC) t2 where t2.rn >= 1;

字串5