使用分页引入的js,然后复制jq代码
$("#mytable1").bootstrapTable('destroy'); $("#mytable1").bootstrapTable({url: baseUrl + '/bankBusinessVolumeStatistics/getAll', //请求地址 striped: true, //是否显示行间隔色 pageNumber: 1, //初始化加载第一页 pagination: true,//是否分页 sidePagination: 'server',//server:服务器端分页|client:前端分页 pageSize: 5,//单页记录数 pageList: [5,10,20],//可选择单页记录数 showRefresh: false,//刷新按钮 cache:false, queryParams: function (params) {//上传服务器的参数 var temp = {offset: $("#mytable1").bootstrapTable("getOptions").pageNumber,// SQL语句起始索引 pageNumber: params.limit, // 每页显示数量' branchCode: branchCode, CustCode: custCode, operationStatus: operationStatus, Start: s1, end: s2
}; return temp; }, columns: [{title: '申请编号', field: 'recNo', sortable: true, align: 'center', clickToSelect: true, formatter: function (value, row, index) {//formatter可以自定义列显示的内容 return ['view(\'' + value + '\',\'' + row.branchCode + '\',\'' + row.custCode + '\',\'' + row.operationStatus + '\',\'' + row.createDate + '\');" >' + row.recNo + '' ]
}
}, {title: '银行代码', field: 'branchCode', sortable: true, align: 'center', clickToSelect: true }, {title: '企业代码', field: 'custCode', sortable: true, align: 'center', clickToSelect: true }, {title: '处理代码', field: 'operationStatus', sortable: true, align: 'center' }, {title: '调用方法', field: 'operationStatus', sortable: true, align: 'center', formatter: function (value, row, index) {//formatter可以自定义列显示的内容 if (value == "1") {return "预扣成功"; } else if (value == "2") {return "预扣失败"; } else if (value == "3") {return "实扣成功"; } else if (value == "4") {return "实扣失败"; } else if (value == "5") {return "手动撤销成功"; } else if (value == "6") {return "手动撤销失败"; } else if (value == "7") {return "自动撤销成功"; } else if (value == "8") {return "自动撤销失败"; } else if (value == "9") {return "新增成功"; } else if (value == "10") {return "新增失败"; }
}
},{title: '实扣金额', field: 'shikou', sortable: true, align: 'center' },{title: '创建人', field: 'creator', sortable: true, align: 'center' },{title: '处理时间', field: 'createDate', sortable: true, align: 'center' }]
});}
后台创建一个page类来存储查询条件及总页数
* @date :Created in 2020/6/4 13:11 */@Setter@Getterpublic class Page {private int total; private int pageNumber; //每页的条数 private int offset; //数据库查询索引 private String Start; private String end; private String branchCode; private String CustCode; private String operationStatus;
后台分页算法:
select * from table limit 0(起始页),5(结束页);
起始页/结束页 =当前页码*现实页数,(就是显示几条数据,这个前台传过来)
根据实际情况加减