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); } })