87,910
社区成员
发帖
与我相关
我的任务
分享
jQuery(document).ready(function(){
jQuery("#list48").jqGrid({
autowidth: true,
url:'data.jsp',
mtype:"GET",
datatype: "json",
height: 'auto',
width:'100%',
rowNum: 10,
rowList: [10,20,30],
colNames:['ID','日期', '用户', '余额','手续费','总额','标记','电话','QQ'],
colModel:[
{name:'id',index:'id', width:55,editable:false,editoptions:{readonly:true,size:10}},
{name:'date',index:'date', width:80,editable:true},
{name:'name',index:'name', width:90,editable:true,editoptions:{size:25}},
{name:'amount',index:'amount', width:60, align:"right",editable:true,editoptions:{size:10}},
{name:'tax',index:'tax', width:60, align:"right",editable:true,editoptions:{size:10}},
{name:'total',index:'total', width:60,align:"right",editable:true,editoptions:{size:10}},
{name:'closed',index:'closed',width:55,align:'center'},
{name:'phone',index:'phone',width:70,editable: true},
{name:'QQ',index:'QQ', width:100}
],
pager: "#list49",
viewrecords: true,
sortname: 'id'
grouping:true,
bgbutton:true,
multiselect: true,
jsonReader: {
root:"gridModel",
records: "record",
repeatitems : false
}
caption: "我的列表 "
});
});
int pageNow = new Integer(request.getParameter("page").toString());
int pageSize = new Integer(request.getParameter("rows").toString());
//int totalPage =
String sql = "select * from t_people";
ResultSet rs = PageInfo.getRs(sql,pageNow-1,10);
int totalPage = PageInfo.totalPage;
int totalRecord = PageInfo.totalRecord;
String json = "{\"cell\":[";
int i =0;
while(rs.next()){
i++;
json+="{\"id\":\""+rs.getString(1)+"\",\"date\":\""+rs.getString(2)+"\",\"name\":"+rs.getString(3)+",\"amount\":\""+rs.getString(4)+"\",\"tax\":\""+rs.getString(5)+"\",\"total\":\""+rs.getString(6)+"\",\"closed\":\""+rs.getString(7)+"\",\"phone\":\""+rs.getString(8)+"\"}";
if(i!=(pageSize)){
json+=",";
}
}
json +="],";
json+="\"page\":"+pageNow+",\"record\":"+totalRecord+",\"rows\":"+pageSize+",\"total\":"+totalPage+"}";
System.out.print(json);
response.getWriter().write(json);
每页最后一条。你返回的数据有多少条json
还有页面有没有设置没有显示多少条的
colNames:['ID','date', '用户', '余额','手续费','总额','标记','电话','QQ'],
colModel:[
{name:'id',index:'ID'}, {name: "日期", index: "date"}
是不是colModel的index和colNames是映射的关系