datatables 带查询条件java服务端分页处理实例

2024-02-20 21:05:03 49

vartable; $(document).ready(function(){ table=$('#example').DataTable({ "pagingType":"simple_numbers",//设置分页控件的模式 searching:false,//屏蔽datatales的查询框 aLengthMenu:[10],//设置一页展示10条记录 "bLengthChange":false,//屏蔽tables的一页展示多少条记录的下拉列表 "oLanguage":{//对表格国际化 "sLengthMenu":"每页显示_MENU_条", "sZeroRecords":"没有找到符合条件的数据", //"sProcessing":"<imgsrc='./loading.gif'/>", "sInfo":"当前第_START_-_END_条共计_TOTAL_条", "sInfoEmpty":"木有记录", "sInfoFiltered":"(从_MAX_条记录中过滤)", "sSearch":"搜索：", "oPaginate":{ "sFirst":"首页", "sPrevious":"前一页", "sNext":"后一页", "sLast":"尾页" } }, "processing":true,//打开数据加载时的等待效果 "serverSide":true,//打开后台分页 "ajax":{ "url":"../../alarms/datatablesTest", "dataSrc":"aaData", "data":function(d){ varlevel1=$('#level1').val(); //添加额外的参数传给服务器 d.extra_search=level1; } }, "columns":[ {"data":"total"}, {"data":"level"} ] }); }); functionsearch1() { table.ajax.reload(); }

Name Position

@RequestMapping(value="/datatablesTest",method=RequestMethod.GET) @ResponseBody publicDatatablesViewPagedatatablesTest(HttpServletRequestrequest){ //获取分页控件的信息 Stringstart=request.getParameter("start"); System.out.println(start); Stringlength=request.getParameter("length"); System.out.println(length); //获取前台额外传递过来的查询条件 Stringextra_search=request.getParameter("extra_search"); System.out.println(extra_search); //随便组织的查询结果 Listlist=newArrayList(); Alarmalarm=newAlarm(); alarm.setLevel(1); alarm.setTotal(100L); list.add(alarm); alarm=newAlarm(); alarm.setLevel(2); alarm.setTotal(100L); list.add(alarm); DatatablesViewPageview=newDatatablesViewPage(); view.setiTotalDisplayRecords(100); view.setiTotalRecords(100); view.setAaData(list); returnview; }

publicclassDatatablesViewPage{ privateListaaData;//aaData与datatales加载的“dataSrc"对应 privateintiTotalDisplayRecords; privateintiTotalRecords; publicDatatablesViewPage(){ } //getset方法此处省略 }

@ResponseBody @RequestMapping("/datatable2") publicJSONgetTable2(StringaoData){ StringsEcho="";//记录操作的次数每次加1 StringiDisplayStart="";//起始 StringiDisplayLength="";//size StringsSearch="";//搜索的关键字 intcount=1;//查询出来的数量 JSONArrayalldata=JSON.parseArray(aoData); for(inti=0;ilistMap=newHashMap(); Listlist=newArrayList(); list.add(u1); listMap.put("iTotalRecords",count); listMap.put("sEcho",Integer.parseInt(sEcho)+1); listMap.put("iTotalDisplayRecords",count); listMap.put("aaData",list); return(JSON)JSON.toJSON(listMap); }

datatables 带查询条件java服务端分页处理实例

热门推荐

随机推荐