JQuery DataTable 1.10服务端分页实现

现在JQuery DataTable最新版的是1.10版，然而已经网上最多是的1.9版或者之前的，最新版的内容比较少，由于英文不好，前端的经验也不是很多，经过一段的摸索，大体上实现了查询，分页等功能；

基本情况时，前端用metronic，后台用是Java+SpringMVC
前后台交互使用Json。
根据实际的业务情况，我需要在Table中展显海运货代的运价
所以有一个Java类

public class EPrice {
    private Integer id;
    private String polEn;
    private String polCn;
    private String portarea;
    private String potEn;
    private String potCn;    
    private String podEn;
    private String podCn;
    private Double price20Gp;
    private Double price40Gp;
    private Double price40Hq;
    ....
}

定义了一个返回类

public class HtResponse {
    //返回给前台的代码
    private String code;
    //返回给前台的信息
    private String msg;
    //访问成功标志
    private Boolean success;
    private String rowCount;
    //这是datatable分页是总记录数的关键字
    //这个很重要
    private String recordsTotal;
    private String recordsFiltered;
    private String draw;
    private List<Object> data = new ArrayList<Object>();

    public List<Object> getData() {
        return data;
    }

    public String getCode() {
        return code;
    }

    public void setCode(String code) {
        this.code = code;
    }

    public Boolean getSuccess() {
        return success;
    }

    public void setSuccess(Boolean success) {
        this.success = success;
    }

    public String getMsg() {
        return msg;
    }

    public void setMsg(String msg) {
        this.msg = msg;
    }

    public String getRowCount() {
        return rowCount;
    }

    public void setRowCount(String rowCount) {
        this.rowCount = rowCount;
    }

    public String getRecordsTotal() {
        return recordsTotal;
    }

    public void setRecordsTotal(String recordsTotal) {
        this.recordsTotal = recordsTotal;
    }

    public String getRecordsFiltered() {
        return recordsFiltered;
    }

    public void setRecordsFiltered(String recordsFiltered) {
        this.recordsFiltered = recordsFiltered;
    }

    public String getDraw() {
        return draw;
    }

    public void setDraw(String draw) {
        this.draw = draw;
    }

}

后台的Controller通过SpringMVC的ModelAndView作为对像返回

这里贴一下前端的代码

var oTable = table.dataTable({
            // Internationalisation. For more info refer to http://datatables.net/manual/i18n
            "language": {
                "aria": {
                    "sortAscending": ": activate to sort column ascending",
                    "sortDescending": ": activate to sort column descending"
                },
                "emptyTable": "没有数据",
                "info": "显示   _START_ -  _END_  共  _TOTAL_ 行",
                "infoEmpty": "没有找对应的记录",
                "infoFiltered": "(filtered1 from _MAX_ total entries)",
                "lengthMenu": "每页显示   _MENU_ 行",
                "search": "查询:",
                "zeroRecords": "没有相应的行"
            },
            'bFilter': false,
            //开启服务端分页
            "serverSide": true,
            //进度条
            "processing": true,
            "ajax": {
                'url':'/fob/app/price/getPrice?_mt=json',//请求路径
                'type':'POST',
                /**
                 * DataTable 默认关键字 是data
                 * 我这里后台返回是price
                 * 但是由于如果后台只返回一条记录是不是数组[]
                 * 所以需要重新判断一下，所以可以用function
                 */     
                'dataSrc':function(jsonData){
                    if(jsonData.code=="SUCCESS"){
                        var prices=jsonData.price;
                        var rel=[];
                        var data=[];
                        if(prices!=null ){
                            if(prices.length>1){
                                for(var i=0;i<prices.length;i++){
                                    data[data.length]=prices[i];
                                }
                                return data;
                            }
                            else{
                                data[data.length]=prices;
                                return data;
                            }
                        }
                        else {
                            return {"data":[]};
                        }
                    }
                    else{
                        return {"data":[]};
                    }
                },
                error:function(){
                     var data = {
                         "data" : []
                         };
                     return data;
                }
            },            
            "columns": [
               /* {
                    "className":      '',
                    "orderable":      false,
                    "data":           null,
                    "defaultContent": '<span class="row-details row-details-close"></span>'
                },*/
                { "data": null},
                { "data": "custName" },
                { "data": "mdporten" },
                { "data": "qyporten", "visible": false },
                { "data": "shipen" },
                { "data": "lineName" },
                { "data": "shipdate" },
                { "data": "price20"},
                { "data": "price40" },
                { "data": "price40hq" },
                { "data": "price45" },
                { "data": null}
            ],


            "columnDefs": [{
                "orderable": false,
                "targets": [0]
            },
            {
                "targets":[0],
                "render":function(data,type,full){
                    return "<span class=\"row-details row-details-close\"></span>";
                }
            },
            {
                "targets":[7],
                "render":function(data,type,full){
                    return Number(full.price20)+Number(full.addprice20);
                }
            },
            {
                "targets":[8],
                "render":function(data,type,full){
                    return Number(full.price40)+Number(full.addprice40);
                }
            },
            {
                "targets":[9],
                "render":function(data,type,full){
                    return Number(full.price40hq)+Number(full.addprice40hq);
                }
            },
            { "targets": [11], // 目标列位置，下标从0开始 "data": "salary", 
                // 数据列名 
                "render": function(data, type, full) { // 返回自定义内容 
                    return "<a class=\"edit\" href=\"javascript:TableAdvanced.edit('"+full.QYPortEN+"');\">Edit</a>"; } 
            },
            { "targets": [12], // 目标列位置，下标从0开始 "data": "salary", 
            // 数据列名 
            "render": function(data, type, full) { // 返回自定义内容                       
                return "<a id=\"tableDelBtn_"+full.pol+"\"class=\"delete\" href=\"javascript:TableAdvanced.show('"+full.QYPortEN+"');\">Delete</a>"; } 
            }],
            "order": [
                [1, 'asc']
            ],
            "lengthMenu": [
                [5, 15, 20, -1],
                [5, 15, 20, "All"] // change per page values here
            ],
            // set the initial value
            "pageLength": 20
        });

特别要注意
根据以往的经验，一般前端往后端，传送pageIndex和pageSize用于分页。在DataTable是传start与length,start是起始行，length是分页长度；