1、html 部分:table用于加载数据的,div是显示分页条用的
<table class="layui-table" id="list" lay-filter="list" class="layui-table" lay-even="" lay-skin="row">
</table>
<div id="page1"></div>
2、JS 部分
layui.use(['laydate','form', 'table','element','laypage'], function () {
var laydate = layui.laydate;
var form = layui.form;
var table = layui.table;
var element = layui.element;
form.render();
element.init();
// 分页功能
var laypage = layui.laypage;
var url = "${ctxPath}/moneyDetail/selectMoneyDetailALL";
var config = {page:1,limit:10};
$.getJSON(url,config,function(res){
laypage.render({
elem: 'page1',
count: res.count, //总条数
limit:config.limit, //每页条数
layout: ['count', 'prev', 'page', 'next', 'skip'],
theme: '#FFB800', //自定义颜色
jump: function(obj, first){
if(!first){ //首次则不进入
config.page = obj.curr;
getUserListByPage(url,config);
}
}
});
parseUserList(res.data.list,config.page);
});
//点击页数从后台获取数据
function getUserListByPage(url,config){
$.getJSON(url,config,function(res){
parseUserList(res.data.list,config.page);
});
}
//解析数据,currPage参数为预留参数,当删除一行刷新列表时,可以记住当前页而不至于显示到首页去
function parseUserList(res,currPage){
table.render({
elem: '#list',
data: res,//数据接口,
page: false,
cols: [[ //表头
{field: 'detailId', title: 'ID', width:'8%', sort: true, fixed: 'left',style:'height:50px;',align:'center'},
{field: 'title', title: '标题', width:'15%',style:'vertical-align: middle',align:'center'},
{field: 'type', title: '类型(进账/出账)', width:'15%',templet: '#type',align:'center'},
{field: 'userName', title: '用户名称', width: '15%',align:'center'},
{field: 'amount', title: '金额', width: '10%',align:'center',templet:'#amount'},
{field: '', title: '是否分红', width: '10%',align:'center'},
{field: 'addTime', title: '添加时间', width: '15%',align:'center',templet: '#addTime'},
{field: 'couredit', title: '操作',width: '10%',templet: '#couredit',toolbar: '#barDemo',align:'center'}
]]
});
}
});
3、 java 部分
3.1、Controller
@ResponseBody
@RequestMapping("/selectMoneyDetailALL")
public Object selectMoneyDetailALL(@RequestParam("page") Integer pageNum,@RequestParam("limit") Integer pageSize) {
PageInfo<MrtMoneyDetail> list = mrtMoneyDetailService.selectMoneyDetailALL(pageNum,pageSize);
int count = (int) list.getTotal();
//TODO isCommition字段数据库不存在,后期报错再改
LayUIResult result = LayUIResult.build(0, "", list); // 这个是我返回的数据格式,可以可以自己定义
result.setCount(count); // 尾部以把该封装类贴出来
return result;
}
3.2、serive
PageInfo<MrtMoneyDetail> selectMoneyDetailALL(Integer pageNum, Integer pageSize);
3.3、serviceImpl
public