LigerUI真假分页以及过滤查询功能

{"Rows":[{"RN":1,"UUID":50095,"LOGIN_NAME":"admin","USER_NAME":"admin","CDATE":{"date":12,"day":1,"hours":13,"minutes":43,"month":10,"nanos":0,"seconds":36,"time":1352699016000,"timezoneOffset":-480,"year":112}},{"RN":2,"UUID":50391,"LOGIN_NAME":"ccc","USER_NAME":"ccc","PASSWORD":"E0323A9039ADD2978BF5B49550572C7C","CDATE":{"date":22,"day":5,"hours":17,"minutes":56,"month":10,"nanos":0,"seconds":27,"time":1385114187000,"timezoneOffset":-480,"year":113}}],"Total":2}

  var grid=null;
  var griddata=null;
  $(function(){
    $.ajax({
    url: path+‘/rcp/rml/tesgligerui.do‘,
    dataType: ‘json‘,
    type: ‘POST‘,
    success: function (result) {
      griddata=result;
      setgrid(griddata);
    }
    });
  });
  function setgrid(griddata){
    grid = $("#maingrid").ligerGrid({
    columns: [
    { name: ‘UUID‘, display: ‘序号‘, width: 85 },
    { name: ‘LOGIN_NAME‘, display: ‘登录名‘, width: 120 },
    { name: ‘USER_NAME‘, display: ‘用户名‘, width: 80 }
    ],
    data:griddata,
    pageSize: 10, 
    rownumbers: true
    });
     }

  var grid=null;
  var griddata=null;
  $(function(){
    $.ajax({
    url: path+‘/rcp/rml/tesgligerui.do‘,
    dataType: ‘json‘,
    type: ‘POST‘,
    success: function (result) {
      griddata=result;
      setgrid(griddata);
    }
    });
  });
  function setgrid(griddata){
    grid = $("#maingrid").ligerGrid({
    columns: [
    { name: ‘UUID‘, display: ‘序号‘, width: 85 },
    { name: ‘LOGIN_NAME‘, display: ‘登录名‘, width: 120 },
    { name: ‘USER_NAME‘, display: ‘用户名‘, width: 80 }
    ],
    data:griddata,
    pageSize: 10, 
    rownumbers: true,
    where:f_getWhere()
    });
     }
   function f_getWhere() {
    if (!grid) {return null};
    var clause = function (rowdata, rowindex) {
    var username = $(‘#txtKey‘).val();
    return ((rowdata.USER_NAME.indexOf(username) > -1));
    };
    return clause;
    }
     //查询按钮，根据文本框中用户输入的用户名查询
     function fsearch() {
       grid.options.data = $.extend(true, {}, griddata);//必须这么写
       grid.loadData(f_getWhere());
    } 

  url分页问题：

  grid = $("#maingrid").ligerGrid({
    columns: [
    { name: ‘UUID‘, display: ‘序号‘, width: 85 },
    { name: ‘LOGIN_NAME‘, display: ‘登录名‘, width: 120 },
    { name: ‘USER_NAME‘, display: ‘用户名‘, width: 80 }
    ],
    url: path+‘/rcp/rml/tesgligerui.do‘,
    pageSize: 10, 
    rownumbers: true
    });

   SELECT T.*
   FROM (SELECT ROWNUM RN, T.* FROM (SELECT * FROM LEAP_USER) T) T
  WHERE 1=1 {?and T.RN BETWEEN  #start# AND #end#} 

Map map = new HashMap();
map.put("Rows", list);
map.put("Total", records);
JSONObject jsonObject = JSONObject.fromObject(map);
response.setCharacterEncoding("utf-8");
response.getWriter().write(jsonObject.toString());
System.out.println(jsonObject);