java - 无法在数据表中设置iTotalRecords和iTotalDisplayRecords

数据表显示aaData值，但分页错误。

$("#tableData").DataTable({
    "bProcessing": true,
    "bServerSide": true,
    "bsort":true,
    "orderMulti":true,
    "sAjaxSource":"datalist",
    "sAjaxDataProp":  function ( json ) {
        var msgObj = JSON.parse(json);
        console.log(msgObj)
        return msgObj.aaData;
    },
    "aoColumns": [
        { "data": "scheduleId" },
        { "data": "startTime" },
        { "data": "endTime" },
        { "data": "selectFlag" }
    ]
});

这是json数据:

{"iTotalRecords":7,"iTotalDisplayRecords":7,"aaData":
  [
    {"scheduleId":1,"startTime":"02:00","endTime":"04:00","selectFlag":false},
    {"scheduleId":2,"startTime":"02:00","endTime":"04:00","selectFlag":false},
    {"scheduleId":3,"startTime":"02:00","endTime":"04:00","selectFlag":false},
    {"scheduleId":4,"startTime":"02:00","endTime":"04:00","selectFlag":false},
    {"scheduleId":5,"startTime":"02:00","endTime":"04:00","selectFlag":false},
    {"scheduleId":6,"startTime":"02:00","endTime":"04:00","selectFlag":false},
    {"scheduleId":7,"startTime":"03:00","endTime":"04:00","selectFlag":false}
]}

下面我附上了数据表的图像。



您能指出我犯的错误吗？

最佳答案

删除sAjaxDataProp选项，不需要。另外，您的JSON响应缺少sEcho参数，这是从客户端发送的sEcho的不变副本。

有关更多详细信息，请参见Example JSON return。

有关代码和演示，请参见this example。请注意，该示例将无法正确排序/过滤/分页，因为没有可用的服务器端脚本。