<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;
}
}