`
a137268431
  • 浏览: 145617 次
文章分类
社区版块
存档分类
最新评论

springMVC运用jqueryEasyUI实现分页

 
阅读更多
<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{

	@Resource
	private  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;
	}
	
	
	
	
}


分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics