java中pageInfo分页带条件查询+查询条件的回显

z940136637 2019-04-22 09:34:19
急着做项目,要用pageInfo的异步分页条件查询,有没有大佬可以给个页面和Controller的代码看看
...全文
1091 1 打赏 收藏 转发到动态 举报
写回复
用AI写文章
1 条回复
切换为时间正序
请发表友善的回复…
发表回复
usecf 2019-04-22
  • 打赏
  • 举报
回复
$("#deviceinfo_start").datagrid({
title: '设备管理',
checkOnSelect: false,
remoteSort:false,
pagination:true,
pageSize:20,
pageNumber:1,
toolbar: '#deviceinfo_toolbar',
url: 'requeryDeviceData',
loadMsg:'加载中...',
height: "300px",
striped: true, //交替行换色
fit: true,
columns: [[
{title: '',field: 'IndexId', width: 80, checkbox: true,},
{field:'deviceNo',title:'设备编号',width:100,sortable:true,sorter:sortItem},
{field:'deviceMac',title:'设备MAC',width:100},
{field:'deviceImei',title:'设备IMEI',width:100},
{field:'deviceSn',title:'设备SN',width:100},
{field:'deviceModel',title:'设备型号',width:100},
{field:'deviceVender',title:'设备制造商',width:100},
{field:'deviceHardVer',title:'设备硬件版本',width:100},
{field:'deviceSoftVer',title:'设备软件版本',width:100},
{field:'deviceUpdateTime',title:'更新时间',width:100,sortable:true,sorter:sortItem},
{field:'deviceState',title:'设备状态',width:100,sortable:true,sorter:sortItem},
{field:'deviceReMark1',title:'预留字段1',width:100},
{field:'deviceReMark2',title:'预留字段2',width:100}
]]
});

采用的是layui框架


controller

@RequestMapping(value = "/requeryDeviceData")
@ResponseBody
public String requeryDeviceData(HttpServletRequest request, HttpServletResponse response, HttpSession httpSession){
System.out.print("enter requeryDeviceData");

String json = "";
int page = Integer.parseInt(request.getParameter("page"));
int rows = Integer.parseInt(request.getParameter("rows"));
String searchFlag = request.getParameter("searchFlag");
String searchKey = request.getParameter("searchKey");

if(null != searchFlag && 0 == searchFlag.compareTo("1"))
{
List<DeviceManagerTable> dmList = null;

HttpRequestUtil http = new HttpRequestUtil();
try
{
dmList = deviceManagerService.queryUserByName(searchKey);
JSONArray dmArray = JSONArray.fromObject(dmList);
json = String.format("{\"result\":\"success\",\"total\":%d,\"rows\":%s}", dmList.size(),dmArray.toString());
}
catch(Exception e)
{
json = "{\"result\":\"fail\",\"message\":\"01\"}";
e.printStackTrace();
}
finally
{

http.httpResponse(response, json);

}
}
else if((0 != page && 0 != rows) && (null ==searchFlag))
{
List<DeviceManagerTable> dmList = new ArrayList<DeviceManagerTable>();
List<DeviceManagerTable> dmListTotal = new ArrayList<DeviceManagerTable>();
HttpRequestUtil http = new HttpRequestUtil();
try
{
dmListTotal = deviceManagerService.requeryDeviceData();
dmList = deviceManagerService.getPageList(page,rows);
JSONArray dmArray = JSONArray.fromObject(dmList);
json = String.format("{\"result\":\"success\",\"total\":%d,\"rows\":%s}", dmListTotal.size(),dmArray.toString());
}
catch(Exception e)
{
json = "{\"result\":\"fail\",\"message\":\"01\"}";
e.printStackTrace();
}
finally
{

http.httpResponse(response, json);

}
}
return json;

}

52,797

社区成员

发帖
与我相关
我的任务
社区描述
Web 开发 Ajax
社区管理员
  • Ajax
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧