温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

bootstrapTable sidePagination server出现No matching

发布时间:2020-07-26 14:20:04 来源:网络 阅读:710 作者:ninnycalf 栏目:web开发

bootstrapTable sidePagination server pagination true 出现No matching records found
对此纠结了一上午,首先百度、google,其实作者已经给出例子了,不仔细查看api和wiki怪不得别人哇!!!
作者例子:
http://issues.wenzhixin.net.cn/bootstrap-table/#options/server-side-pagination.html
从里面可以看到数据格式应该是:

{
  "total": 800,
  "rows": [
    {
      "id": 0,
      "name": "Item 0",
      "price": "$0"
    },
    {
      "id": 1,
      "name": "Item 1",
      "price": "$1"
    },
    {
      "id": 2,
      "name": "Item 2",
      "price": "$2"
    },
    {
      "id": 3,
      "name": "Item 3",
      "price": "$3"
    },
    {
      "id": 4,
      "name": "Item 4",
      "price": "$4"
    },
    {
      "id": 5,
      "name": "Item 5",
      "price": "$5"
    },
    {
      "id": 6,
      "name": "Item 6",
      "price": "$6"
    },
    {
      "id": 7,
      "name": "Item 7",
      "price": "$7"
    },
    {
      "id": 8,
      "name": "Item 8",
      "price": "$8"
    },
    {
      "id": 9,
      "name": "Item 9",
      "price": "$9"
    }
  ]
}

这种json格式,就可以了,前端就会有数据了!!!
client的不需要前面的total和rows

[
    {
        "id": 0,
        "name": "Item 0",
        "price": "$0",
        "amount": 3
    },
    {
        "id": 1,
        "name": "Item 1",
        "price": "$1",
        "amount": 4
    },
    {
        "id": 2,
        "name": "Item 2",
        "price": "$2",
        "amount": 8
    },
    {
        "id": 3,
        "name": "Item 3",
        "price": "$3",
        "amount": 2
    },
    {
        "id": 4,
        "name": "Item 4",
        "price": "$4",
        "amount": 90
    },
    {
        "id": 5,
        "name": "Item 5",
        "price": "$5",
        "amount": 2
    },
    {
        "id": 6,
        "name": "Item 6",
        "price": "$6",
        "amount": 3
    },
    {
        "id": 7,
        "name": "Item 7",
        "price": "$7",
        "amount": 7
    },
    {
        "id": 8,
        "name": "Item 8",
        "price": "$8",
        "amount": 39
    },
    {
        "id": 9,
        "name": "Item 9",
        "price": "$9",
        "amount": 78
    },
    {
        "id": 10,
        "name": "Item 10",
        "price": "$10",
        "amount": 30
    },
    {
        "id": 11,
        "name": "Item 11",
        "price": "$11",
        "amount": 32
    },
    {
        "id": 12,
        "name": "Item 12",
        "price": "$12",
        "amount": 12
    },
    {
        "id": 13,
        "name": "Item 13",
        "price": "$13",
        "amount": 76
    },
    {
        "id": 14,
        "name": "Item 14",
        "price": "$14",
        "amount": 10
    },
    {
        "id": 15,
        "name": "Item 15",
        "price": "$15",
        "amount": 9
    },
    {
        "id": 16,
        "name": "Item 16",
        "price": "$16",
        "amount": 8
    },
    {
        "id": 17,
        "name": "Item 17",
        "price": "$17",
        "amount": 1
    },
    {
        "id": 18,
        "name": "Item 18",
        "price": "$18",
        "amount": 99
    },
    {
        "id": 19,
        "name": "Item 19",
        "price": "$19",
        "amount": 100
    },
    {
        "id": 20,
        "name": "Item 20",
        "price": "$20",
        "amount": 109
    }
]

后端nodejs

var total = 300;//这一条要根据sql得到的count数才可以
db.sql(sql, function(err, results) {
                                if (err) {
                                    console.log("出现错误:", err);
                                    res.write("出现错误,请刷新后重试!");
                                    res.end();
                                } else {
                                    var send_arr = {};
                                    send_arr["total"] = total;
                                    send_arr["rows"] = results;
                                    res.json(send_arr);
                                }
                            })
向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI