Ajaxによるページングクエリの実装--他のユーザ

            ，  10w   ，               。         DataGrid   ，          。
              DIV:
    
    <div id="div_trackpoint" style=" border:solid 1px gray; height:230px; width:99%; overflow-y:auto;">          </div>
    <div id="div_trackpages" style=" height:15px; width:99%; font-size:8pt; word-break:break-all; word-wrap: break-word;">         </div><br />
    <div id="div_trackpagetab" style=" height:15px; width:99%; font-size:8pt; text-align:center;">       、   、...、  、       </div>
    <div id="div_trackpage_status" style=" height:20px; width:99%; font-size:8pt; text-align:center;">          </div>

             ：
    var CurPage=0;                          //   
    var TotalPage=0;                        //   
    var PageTab=7;                          //      
    var CurTab=0;                           //    
    
               50   ，    7 ，         。

    TurnTab        ，     val          。val=1        ，val=-1        ，0        ，-2         。            ...         。

function TurnTab(val)
{
    var nPage = 0;
    
    if (val == 1) {
        CurTab++;
        nPage = (CurTab - 1) * PageTab + 1;  
    }
    else if (val == -1) {
        CurTab--;
        nPage = (CurTab - 1) * PageTab + 1;
    }
    else if (val == 0) {
        CurTab = 1;
        nPage = 1;
    }
    else if (val == -2) {
        CurTab = Math.floor(TotalPage / PageTab) + 1;
        nPage = (CurTab - 1) * PageTab + 1;
    }
        
    var carinfo = document.getElementById("div_trackpages");
    var tabinfo = document.getElementById("div_trackpagetab");

    var strInner = "";
    
    strInner += "<a href=\"javascript:TurnPage(1)\">  </a>&nbsp;";
    
    strInner += "<a href=\"javascript:PreviousPage()\">   </a>&nbsp;";
    
    strInner += "  " + TotalPage + " &nbsp;";
    
    strInner += "<a href=\"javascript:NextPage()\">   </a>&nbsp;";
    
    strInner += "<a href=\"javascript:TurnPage(" + TotalPage + ")\">  </a>&nbsp;";
    
    tabinfo.innerHTML = strInner;
    
    strInner = "";
    
    if (CurTab > 1) strInner += "<a href=\"javascript:TurnTab(-1)\">...</a>&nbsp;";
    
    for ( ; nPage<=CurTab*PageTab; nPage++) {
        
        if (nPage <= TotalPage) {
            
            strInner += "<a href=\"javascript:TurnPage("+ nPage + ")\">"+nPage+"</a>&nbsp;"
            
        }
    }
    
    if (nPage < TotalPage) strInner += "<a href=\"javascript:TurnTab(1)\">...</a>&nbsp;";
    
    carinfo.innerHTML = strInner;
    
}

    TurnPage        ，val         ，              ，    50   ， 51 100   ， 101 150   。。。
    cscCustomAnalyst         ，             。"Method","SID", "TIME1", "TIME2", "ROW1", "ROW2"           ，Method            ，"ROW1", "ROW2"          ，                。ShowCarTrack(val)               ，                            。             ，       。

function TurnPage(val)
{
    if (Number(val) != CurPage) {
    
        CurPage = Number(val);
        
        var row1 = String((CurPage - 1) * 50 + 1);
        var row2 = String(CurPage * 50);
        
        var trackinfo = document.getElementById("div_trackpoint");
        trackinfo.innerHTML = "　　     ，   ．．．";
        
        _cscCustomAnalyst(["Method", "SID", "TIME1", "TIME2", "ROW1", "ROW2"], 
                            ["GetCarTrack",, "80100117", t1, t2, row1, row2],
                    ShowCarTrack,onQueryError);
                    
        if (CurPage == 1) TurnTab(0);
        
        if (CurPage == TotalPage) TurnTab(-2);    
        
        var statusinfo = document.getElementById("div_trackpage_status");
        
        statusinfo.innerHTML = " " + CurPage  + " ";
    }

}

    NextPage     ，  TurnPage  ，                    。

function NextPage()
{
    if (CurPage < TotalPage) {
    
        TurnPage(CurPage+1);
        
        if ((CurPage + 1) > (CurTab * PageTab)) {
            TurnTab(1);
        }
    }
    
}

    PreviousPage     ，  TurnPage  ，                    。
function PreviousPage()
{
    if (CurPage > 1) {

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

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

function _cscCustomAnalyst(paramNames, paramValues, onComplete, onError){
    
    var xhr=_GetXmlHttpRequest();
    
    xhr.open("post","MapQuery.ashx", true);

    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;
                }

                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);
};

          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;