使用Layui表格实现后台分页的方法

<table class="layui-table" lay-data="{width: 892, height:332,url:'', page:true, id:'idTest'}" lay-filter="demo">

  <thead>

    <tr>

      <th lay-data="{type:'checkbox', fixed: 'left'}"></th>

      <th lay-data="{field:'id', width:80, sort: true, fixed: true}">id</th>

      <th lay-data="{field:'menubarid', width:80}">菜单id</th>

      <th lay-data="{field:'name', width:80, sort: true}">菜名</th>

      <th lay-data="{field:'price', width:80}">价格</th>

      <th lay-data="{field:'status', width:160}">状态</th>

      <th lay-data="{fixed: 'right', width:178, align:'center', toolbar: '#barDemo'}"></th>

    </tr>

  </thead>

</table>

int page = Integer.parseInt(request.getParameter("page"));

int limit = Integer.parseInt(request.getParameter("limit"));   

int count = menuDao.searchcount();             // 查找数据条数

int page_temp = page;

int limit_temp = limit;

if (count < page * limit) {

    limit = count - (page - 1) * limit;

}

page = (page_temp - 1) * limit_temp;

select  count(*) from menu

select * from menu limit ?,?

String layjson ="{\"code\":0,\"msg\":\"\",\"count\":"+getcount()+",\"data\":["+data+"]}";