各位好:目前使用jqGrid插件做数据展示,遇到问题
json返回的数据格式是正确的,但是前台界面却显示,服务器端我使用的struts2,为了方便调试,目前json串的拼接先直接接到txt文件中,action直接读取文件内容返回。方便修改测试,等这个问题解决后,改为
动态拼写,上代码:
返回的json:
{
"page": "1",
"total": 2,
"records": "13",
"rows": [
{
"id": "13",
"cell": [
"13",
"2007-10-06",
"1000.00",
"0.00",
"1000.00"
]
}
]
}
jsp文件:
<%@ page language="java" pageEncoding="UTF-8"
contentType="text/html; charset=UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/";
%>
<!DOCTYPE html>
<html>
<head>
<style>
</style>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<base href="<%=basePath%>">
<title>管理员用户信息查询</title>
<link rel="stylesheet" type="text/css" href="css/admin/jquery-ui.theme.css" />
<link rel="stylesheet" type="text/css" href="css/admin/ui.jqgrid.css" />
<style>
html, body {
margin: 0;
padding: 0;
font-size: 75%;
}
</style>
<script src="js/jquery-2.2.3.min.js" type="text/javascript"></script>
<script src="http://code.jquery.com/jquery-migrate-1.2.1.js"></script>
<script src="js/admin/jquery.jqGrid.min.js" type="text/javascript"></script>
<script src="js/admin/grid.locale-en.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(
function() {
jQuery("#list4").jqGrid({
url: 'menuMgr/adminUserMgr!query.action'
datatype: "JSON",
width: 1200,
height: 600,
colNames:['用户名','邮箱', '权限级别', '标志位','入库时间'],
colModel:[
{name:'userName',index:'userName', width:60, sorttype:"int"},
{name:'email',index:'email', width:90, sorttype:"date"},
{name:'perm_level',index:'perm_level', width:80, align:"right",sorttype:"float"},
{name:'flag',index:'flag', width:80, align:"right",sorttype:"float"},
{name:'intime',index:'intime', width:80,align:"right",sorttype:"float"}
],
rowNum : 10,
pager : '#pager2',
multiselect: true,
caption: ""
});
jQuery("#list4").jqGrid('navGrid', '#pager2', {edit : false,add : false,del : false});
/* var mydata = [
{id:"1",invdate:"2007-10-01",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"},
{id:"2",invdate:"2007-10-02",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"},
{id:"3",invdate:"2007-09-01",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"},
{id:"4",invdate:"2007-10-04",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"},
{id:"5",invdate:"2007-10-05",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"},
{id:"6",invdate:"2007-09-06",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"},
{id:"7",invdate:"2007-10-04",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"},
{id:"8",invdate:"2007-10-03",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"},
{id:"9",invdate:"2007-09-01",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"}
];
for(var i=0;i<=mydata.length;i++)
jQuery("#list4").jqGrid('addRowData',i+1,mydata[i]); */
});
</script>
</head>
<body>
<br><span style="font-weight:bold;">
管理菜单 >> 管理员用户管理 >> 管理员用户信息查询
</span>
<br>
<br>
<table id="list4"></table>
<div id="pager2"></div>
</body>
</html>
静态数据是没问题的(local),动态的就是死活不展示
界面现状:
不过没C币了,希望大家帮帮我 谢谢大家!