对于查询单表的信息,用easyui里的datagrid展示,并且自带分页,java代码如下显示:
@ApiOperation(value = "查询所有日志信息", notes = "分页查询所有日志信息")
@RequestMapping("/findAll")
@ResponseBody
public EasyUiResult findAll(Integer page,Integer rows) {
PageHelper.startPage(page, rows);
List<SysLog> lists = sysLogService.selectPage(1, 10);
PageInfo<SysLog> pageInfo = new PageInfo<SysLog>(lists);
Integer total = (int) pageInfo.getTotal();
EasyUiResult result = new EasyUiResult(total, lists);
return result;
}
这里要说的就是分页查询用EasyUiResult,
对于前台的datagird展示如下:
$('#sysLogGrid').datagrid({
fit:true,
fitColumns:true,
collapsible:false,
nowrap: true,
striped: true,
url:'findAll',
rownumbers:true,
idField:'id',
frozenColumns:[
{field:'ck',checkbox:true}//复选框
],
columns:[[
{field:'title',title:'功能名称',width:80,align:'center'},
{field:'createBy',title:'操作员',width:80,align:'center'},
{field:'createDate',title:'操作时间',width:80,align:'center'},
{field:'params',title:'操作结果',width:80,align:'center'},
{field:'requestUri',title:'操作描述',width:80,align:'center'},
{field:'remoteAddr',title:'操作IP地址',width:100,align:'center'}
]],
pagination:true,
pageSize:10,
toolbar:'#tb',
onLoadSuccess:function(data){
/**
* 数据加载成功后渲染linkbutton
*/
$(".editSysLog").linkbutton({
text:'编辑',
title:'编辑',
plain:true
});
$(".detailSysLog").linkbutton({
text:'详细',
title:'详细',
plain:true
});
}
});
//分页
var p = $('#sysLogGrid').datagrid('getPager');
$(p).pagination({
pageSize: 10,//每页显示的记录条数,默认为20
beforePageText: '第',//页数文本框前显示的汉字
afterPageText: '页 共 {pages} 页',
pageList: [10,20,30],//可以设置每页记录条数的列表
displayMsg: '当前显示 {from} - {to} 条记录 共 {total} 条记录',
onBeforeRefresh:function(){
}
});