bootstrap table 服务器端分页例子
1,前台引入所需的js 可以从官网上下载
function getTab(){
var url = contextPath+\'/fundRetreatVoucher/fundBatchRetreatVoucherQuery.htm\';
$(\'#tab\').bootstrapTable({
method: \'get\', //这里要设置为get,不知道为什么 设置post获取不了
url: url,
cache: false,
height: 400,
striped: true,
pagination: true,
pageList: [10,20],
// contentType: "application/x-www-form-urlencoded",
pageSize:10,
pageNumber:1,
search: true,
sidePagination:\'server\',//设置为服务器端分页
queryParams: queryParams,//参数
showColumns: true,
showRefresh: true,
minimumCountColumns: 2,
clickToSelect: true,
smartDisplay:true,
columns: [
{
field: \'interfaceInfoCode\',
title: \'资金通道编码\',
align: \'center\',
width: \'180\',
valign: \'bottom\',
sortable: true
}, {
field: \'retreatBatchCode\',
title: \'资金退回批次号\',
align: \'center\',
width: \'200\',
valign: \'middle\',
sortable: true
}, {
field: \'total\',
title: \'总笔数\',
align: \'center\',
width: \'10\',
valign: \'top\',
sortable: true
}, {
field: \'totalMoney\',
title: \'总金额\',
align: \'center\',
width: \'100\',
valign: \'middle\',
clickToSelect: false
}, {
title: \'操作\',
field: \'state\',
align: \'center\',
width: \'200\',
valign: \'middle\',
}]
});
}
//设置传入参数
function queryParams(params) {
return params
}
$(function(){
getTab();
})
2 后台
获取limit offset ,有些网站上 要格式化传入参数 获取pageSize,pageIndex 反正我是没有成功,如果知道 可以分享给我
int currentPage = request.getParameter("offset") == null ? 1 : Integer.parseInt(request.getParameter("offset"));
// 每页行数
int showCount = request.getParameter("limit") == null ? 10 : Integer.parseInt(request.getParameter("limit"));/
if (currentPage != 0) {// 获取页数
currentPage = currentPage / showCount;
}
currentPage += 1;
JSONObject json = new JSONObject();
json.put("rows", bfrv); //这里的 rows 和total 的key 是固定的
json.put("total", total);