springMVC运用jqueryEasyUI实现分页

来源：互联网发布：linux opencv contrib 编辑：程序博客网时间：2024/06/05 15:04

<table id="dg" class="DataGrid - VirtualScrollView with Detail Rows"  > </table><script type="text/javascript">$(function(){   $('#dg').datagrid({       title: '信息列表',       width: 800,       height: 500,       nowrap: true,       striped: true,       collapsible:false,       border: true,        showFooter:true,       pagination:true,       rownumbers:true,       fitColumns:true,       singleSelect:true,       sortName:'flightCode',             columns:[[           {field:'name',title:'视频名称',width:150,align:'center'},             {field:'TThumbnail1',title:'视频',width:250,align:'center'},           {field:'uploadDate',title:'上传时间',width:150,align:'center'           ,sortable:true},           {field:'feedback',title:'反馈信息',width:180,align:'center'},         ]]   });      var p = $('#dg').datagrid('getPager');        $(p).pagination({           pageSize: 2,//每页显示的记录条数，默认为10           pageList: [2,4,8],//可以设置每页记录条数的列表           showPageList: true,              showRefresh: true,          beforePageText: '第',//页数文本框前显示的汉字           afterPageText: '页    共 {pages} 页',           displayMsg: '当前显示 {from} - {to} 条记录   共 {total} 条记录',       });       $(p).pagination({           onSelectPage: function (pageNumber, pageSize) { //每一个按钮选择是都会默认执行这个         // alert("onSelectPage");          var startTime2 = $('#start2').datetimebox('getValue');//获得开始时间和结束时间      var endTime2 = $('#end2').datetimebox('getValue');                getData(pageNumber, pageSize,startTime2,endTime2);           },    //   onChangePageSize:function (pageNumber, pageSize) {     //   alert("onChangePageSize");      //          getData(pageNumber, pageSize);      //     },          // onRefresh:function (pageNumber, pageSize) {         //  alert("onRefresh");         //       getData(pageNumber, pageSize);         //  }        });  });   var getData = function (pageNumber,pageSize,startTime2,endTime2) {       $.ajax({           type: 'POST',           url: 'dataGrid.do', //用户请求数据的URL        data : {      pageNumber:pageNumber,      pageSize:pageSize,      start:startTime2,      end:endTime2     },          error: function (XMLHttpRequest, textStatus, errorThrown) {               alert(textStatus);           },           success: function (data) {          // alert(data);          test = eval("(" + data + ")");  ////转换为json对象         // alert(test);              $('#dg').datagrid('loadData',test);                        }       });   };//页面初始化时调用函数加载数据  $(function(){  var startTime2 = $('#start2').datetimebox('getValue');//获得开始时间和结束时间      var endTime2 = $('#end2').datetimebox('getValue');      getData(1,2,startTime2,endTime2);  });//  function refreshPage(){//      getData(1, 2);  //  };     </script>

后台：

import java.sql.Timestamp;import java.util.List;import javax.annotation.Resource;import org.springframework.stereotype.Controller;import org.springframework.ui.ModelMap;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RequestParam;import org.springframework.web.bind.annotation.ResponseBody;import com.japdplat.common.utils.DateUtils;import com.japdplat.modules.sites.entity.TVideo;import com.japdplat.modules.sites.service.video.TVideoService;import com.japdplat.modules.sites.share.StaticVariable;/** * @author LzwGlory * @version 2013-12-19 * */@Controller("VideoController")@RequestMapping(value = "${adminPath}/sites/videoLzw")public class VideoController{@Resourceprivate  TVideoService tVideoService;@RequestMapping()public String list(ModelMap modelMap) {return "modules/sites/video";}@RequestMapping(value="/dataGrid.do")public @ResponseBody String dataGrid(ModelMap modelMap,@RequestParam int pageNumber,@RequestParam int pageSize,@RequestParam String start,@RequestParam String end) {Timestamp startTime = new Timestamp(System.currentTimeMillis());  Timestamp endTime = new Timestamp(System.currentTimeMillis());    try {          if(!start.isEmpty()){        startTime = Timestamp.valueOf(start);          }else{        startTime=null;        }        if(!end.isEmpty()){        endTime = Timestamp.valueOf(end);          }else{        endTime=null;        }        } catch (Exception e) {          //            e.printStackTrace();          }  List<TVideo> listTVideos=tVideoService.getVideoPaging(pageNumber,pageSize, startTime, endTime);long size=tVideoService.count(startTime,endTime); //start 拼json字符串 StringBuffer sb = new StringBuffer();   sb.append("{\"total\":"+size+",\"rows\":[");           for(TVideo tVideo:listTVideos){          sb.append("{\"name\":").append("\"")          .append(tVideo.getName()).append("\"").append(",")          .append("\"TThumbnail1\":").append("\"")          .append("<img src=").append("\'")          .append(StaticVariable.imgCcwz)          .append(DateUtils.formatDate(tVideo.getUploadDate(), "yyyy-MM-dd"))          .append("/")          .append(tVideo.getTThumbnail1())          .append("\'")          .append(">")          .append("\"").append(",")          .append("\"uploadDate\":").append("\"")          .append(tVideo.getUploadDate()).append("\"").append(",")          .append("\"feedback\":").append("\"")          .append(tVideo.getFeedback()).append("\"").append("},");           }         String jsonStr=null;         if(startTime==null||endTime==null){         jsonStr=sb.substring(0,sb.length()-1)+"]}" ;                 }else{         jsonStr=sb.substring(0,sb.length())+"]}" ;         }           //end 拼json字符串return jsonStr;}}

0 0