問題描述

url: 'userPersonServlet?method=findByPage',method: 'post',columns: [{ checkbox: true, field: '選擇'}, { field: ’Number’, title: ’ID’, formatter: function (value, row, index) {return index + 1; }, align: 'center'}, { field: 'username', title: '姓名', align: 'center'}, { field: 'email', title: '郵箱', align: 'center'}, { field: 'graduate', title: '畢業學校', align: 'center'}, { field: 'education', title: '學歷', align: 'center'}, { field: 'phone', title: '手機號', align: 'center'}, { field: 'computer', title: '技能', align: 'center'}, { field: 'computer', title: '技能', align: 'center'}, { field: '操作', title: '操作', formatter: function (value, row, index) {return ['<a class=’btn btn-default’ href=’userPersonServlet?method=findById&id[]=' + row.id + '&state=0’>查看</a>', '<a class=’btn btn-default’ href=’userPersonServlet?method=findById&id[]=' + row.id + '&state=1’>編輯</a>', '<a class=’btn btn-default’ href=’userPersonServlet?method=delete&row=' + row.id + '&state=2’>刪除</a>'].join(' '); }, align: 'center'}],pagination: true,pageNumber: 1,pageSize: 10,pageList: [10, 20, 30, 50],onlyInfoPagination: false,sidePagination: 'server',queryParamsType: '',queryParams: function (params) { console.log(params.pageSize); console.log(params.pageNumber); return {pageSize: params.pageSize, pageNumber: params.pageNumber};},uniqueId: 'username',dataType: 'json',idField: 'username',contentType: 'application/x-www-form-urlencoded',paginationPreText: '上一頁',paginationNextText: '下一頁',cache: false,toolbar: '#toolbar',maintainSelected: true,clickToSelect: true });java代碼： private void findByPage(HttpServletRequest req, HttpServletResponse resp) {String pageSize = req.getParameter('pageSize');String pageNumber = req.getParameter('pageNumber');System.out.println('pageSize = ' + pageSize);System.out.println('pageNumber = ' + pageNumber);UserPersonService userPersonService = new UserPersonServiceImpl();try { List<UserPerson> users = userPersonService.findByPage(Integer.parseInt(pageNumber), Integer.parseInt(pageSize)); System.out.println(users); String userPerson = '{'total': ' + users.size() + ', 'rows': ' + JSONArray.fromObject(users) + '}'; System.out.println(userPerson); resp.setContentType('text/html;charset=UTF-8'); resp.getWriter().write(userPerson);} catch (Exception e) { try {resp.setContentType('text/html;charset=utf-8');String json = '{'status':'error','message':'失敗'}';resp.getWriter().write(json); } catch (IOException e1) {e1.printStackTrace(); }}

}

問題解答

在服務端分頁時，必須配置 contentType: 'application/x-www-form-urlencoded'并且，一定要返回total，total代表數據庫中數據的總記錄數。