Extjs Ajax 分页详解编程语言

var storeCpye = new Ext.data.GroupingStore({ 
    proxy : new Ext.data.HttpProxy({ 
        url : 'cxgl_cpye.app?dateTime=' + new Date().getTime() + '&subTranCode=list' 
    }), 
    reader : new Ext.data.JsonReader({ 
        root : 'hstamcx', 
        totalProperty : "results", 
        fields : ["zfe_hz","khbh","bankacc","fundacc","xxsdm","dxjgdm", 
                  "cpdm","tazh","tajyzh","tadm","hybh","zfe","lsdjfe", 
                  "cqdjfe","zhtzfe","bddjfe","fhfs","yfhfs","fhbl", 
                  "zrzfe","fejg","khlb","zjtzbz","bqsy","sybl","mrcb", 
                  "ljsr","wfsy","wfsydj","dtsy","glfzkl","glfje", 
                  "dqglf","glfrq","gxrq","apex1","apex2","apex3"] 
    })//,  
    //sortInfo : { 
    //    field : 'cpdm', 
    //    direction : 'DESC' 
    //}, 
    //groupField : 'cpdm' 
}); 
 
var colMArray = new Array(); 
colMArray = [{header : "产品代码",    dataIndex : "cpdm",    width : 100}, 
            {header : "代销机构代码",    dataIndex : "dxjgdm",    width : 100}, 
            //{header : "总份额汇总",    dataIndex : "zfe_hz",    width : 100}, 
            {header : "总份额",    dataIndex : "zfe",    width : 100, align:"right"},  
           {header : "客户编号",    dataIndex : "khbh",    width : 100}, 
           {header : "理财账号",    dataIndex : "bankacc",    width : 100},  
           {header : "客户资金账号",    dataIndex : "fundacc",    width : 100},  
           {header : "本行销售商代码",    dataIndex : "xxsdm",    width : 100},  
           {header : "TA账号",    dataIndex : "tazh",    width : 100},  
           {header : "TA交易账号",    dataIndex : "tajyzh",    width : 100},  
           {header : "TA代码",    dataIndex : "tadm",    width : 100},  
           {header : "合约编号",    dataIndex : "hybh",    width : 100},  
           {header : "临时冻结份额",    dataIndex : "lsdjfe",    width : 100, align:"right"},  
           {header : "长期冻结份额",    dataIndex : "cqdjfe",    width : 100, align:"right"},  
           {header : "组合投资份额",    dataIndex : "zhtzfe",    width : 100, align:"right"},  
           {header : "本地冻结份额",    dataIndex : "bddjfe",    width : 100, align:"right"},  
           {header : "当前分红方式",    dataIndex : "fhfs",    width : 100},  
           {header : "原分红方式",    dataIndex : "yfhfs",    width : 100},  
           {header : "红利比例(%)",    dataIndex : "fhbl",    width : 100},  
           {header : "昨日总份额",    dataIndex : "zrzfe",    width : 100, align:"right"},  
           {header : "份额所属机构",    dataIndex : "fejg",    width : 100}, 
           {header : "客户类别",    dataIndex : "khlb",    width : 100}, 
           {header : "追加投资标志",    dataIndex : "zjtzbz",    width : 100}, 
           {header : "本期收益",    dataIndex : "bqsy",    width : 100, align:"right"}, 
           {header : "收益客户比例(%)",    dataIndex : "sybl",    width : 100}, 
           {header : "买入成本",    dataIndex : "mrcb",    width : 100, align:"right"}, 
           {header : "累计收入",    dataIndex : "ljsr",    width : 100, align:"right"}, 
           {header : "未付收益",    dataIndex : "wfsy",    width : 100, align:"right"}, 
           {header : "冻结的未付收益",    dataIndex : "wfsydj",    width : 100, align:"right"}, 
           {header : "当天新分配收益",    dataIndex : "dtsy",    width : 100, align:"right"}, 
           {header : "管理费折扣率(%)",    dataIndex : "glfzkl",    width : 100}, 
           {header : "管理费总额",    dataIndex : "glfje",    width : 100, align:"right"}, 
           {header : "当前管理费",    dataIndex : "dqglf",    width : 100, align:"right"}, 
           {header : "管理费计算日期",    dataIndex : "glfrq",    width : 100}, 
           {header : "更新日期",    dataIndex : "gxrq",    width : 100}]; 
 
var colQd = new Ext.grid.ColumnModel(colMArray); 
     
// GRID定义 
var gridCpye = new Ext.grid.GridPanel({ 
    id : 'cpye_grid', 
    title:'[产品余额]查询', 
    height : 800, 
    stripeRows : true, 
    bodyStyle : 'width:100%', 
    disableSelection : true, 
    cm : colQd, 
    viewConfig : { 
        forceFit : false 
    }, 
    store : storeCpye, 
    iconCls : 'details', 
    animCollapse : true, 
    trackMouseOver : false, 
    loadMask : { 
        msg : '正在加载[产品余额]信息，请稍侯……' 
    }, 
    //selModel : smQd, 
    selModel : new Ext.grid.RowSelectionModel({singleSelect:true}), 
    tbar : ['-',new Ext.form.Label({ 
        text : '产品代码:' 
    }),new Ext.form.TextField({ 
        id : 'cpdm', 
        name : 'cpdm', 
        width : 130 
    }),'-',new Ext.form.Label({ 
        text : '代销机构代码:' 
    }), new Ext.form.TextField({ 
        id : 'dxjgdm', 
        name : 'dxjgdm', 
        width : 130 
    }), '-', { 
        pressed : true, 
        text : '  查    询    ', 
        iconCls : 'yes', 
        handler : selinfo 
    },'-',new Ext.Toolbar.Fill(),'-',new Ext.form.Label({ 
        text : ' 查询方式:  ' 
    }),new Ext.form.Radio({ 
                            id:"cpdm_radio",   
                            name : "select_method",   
                            inputValue : "cpdm desc,dxjgdm desc", 
                            checked : true,     
                            boxLabel : " 产 品  "//,   
                            //listeners : {   
                                //check : radiochange   
                            //}   
                            
                        }),   
                new Ext.form.Radio({ 
                            id:"dxjgdm_radio",   
                            name : "select_method",   
                            inputValue : "dxjgdm desc,cpdm desc", 
                            boxLabel : "代销机构  "//,   
                            //listeners : {   
                                //check : radiochange   
                            //}   
                        }),'-' 
     ], 
    bbar : new Ext.PagingToolbar({ 
        pageSize : 20, 
        store : storeCpye, 
        displayInfo : true, 
        emptyMsg : '没有记录' 
    }) 
});

    private void list() throws HsException { 
        String cpdm = $("cpdm_sel"); 
        String dxjgdm = $("dxjgdm_sel"); 
        String order_by = $("select_method_sel"); 
        String start = $("start"); 
        String limit = $("limit"); 
        int b=0,m=20; 
        if(start!=null && !start.equals("")){ 
            b = new Integer(start); 
        } 
        if(limit!=null && !limit.equals("")){ 
            m = new Integer(limit); 
        } 
        //查询 
        CpyeDao cpyeDao = new CpyeDao(request, response); 
        String sql = cpyeDao.select(cpdm,dxjgdm,order_by); 
        List<HashMap> list1 = null; 
        try { 
            list1 = this.findSql(new String(sql.getBytes("iso8859-1"),"UTF-8")); 
        } catch (UnsupportedEncodingException e) { 
            e.printStackTrace(); 
        } 
         
         
        List<HashMap> list = new ArrayList(); 
        for(int i = b; i < b + m && i<list1.size(); i++ ){ 
            list.add(list1.get(i)); 
        } 
         
        //把list转化成Json 
//        StringBuffer s = new StringBuffer("{results:"+list1.size()+",result:["); 
//        for( int i=0;i< list.size();i++){ 
//            HashMap hm = list.get(i); 
//             
//            for(int j=0;j < columns.length; j++){ 
//                if(j==0) s.append("{"); 
//                s.append(columns[j]+":/""+hm.get(columns[j].toUpperCase().toString()).toString()+"/""); 
//                if(j>0 && j<(columns.length-1) ) s.append(","); 
//                if(j==(columns.length-1)) s.append("}"); 
//            } 
//        } 
//        s.append("]}"); 
         
//        AjaxTools.exAjax("{results:"+list1.size()+",hstamcx:"+JsonTools.agentJdbcLstToJson(list,lpDict,gbismDict)+",/""+paramName+"/":/""+paramValue+"/"}",response); 
        AjaxTools.exAjax("{results:"+list1.size()+",hstamcx:"+JsonTools.agentJdbcLstToJson(list,lpDict,gbismDict)+"}",response); 
    }

public class AjaxTools { 
    public static  void exAjax(String ajaxString,HttpServletResponse response)throws HsException{ 
        PrintWriter out = null; 
        try{ 
            response.setContentType("text/html;charset=utf-8"); 
            response.setHeader("Cache-Control", "no-cache"); 
                out=response.getWriter(); 
                out.write(ajaxString); 
                out.flush(); 
        }catch(Exception e){ 
            throw new HsException(HsErrorMsg.ERR_DEFAULT, "AJAX通讯出错!"+e.getMessage()); 
        } 
        finally{ 
            out.close(); 
        } 
    } 
 
}