关于jquery遍历json的问题
请教一个问题json的
简单的json我能看得懂，
var json ='{"users":[{"username":"dashuji","nicheng":"dashuji001"},{"username":"xiaoju","nicheng":"xiaoju001"}]}';
var dataObj=eval("("+json2+")") ;
alert(dataObj.users[0].username);
输出结果我知道是 dashuji
但是想这样的json 我就凌乱得蛋疼了
var json2='{"code":"1", "datatype":"json", "dataset":{"f24":{"meta":["USERID", "LABEL", "PASSWD"],"rows":10,"pagerows":10,' +
' "pagesize":1, "pageindex":1,"rowset":[["dashuji", "lzg", "332313"], ["dengzy","邓振裕", "13"],["hurr", "胡如荣",' +
' "13"], ["liuy", "刘勇","13"], ["lizr", "李周仁", "13"], ["luj", "陆俊", "13"], ["yangww", "杨旺文", "13"],' +
'["yuyx", "于映喜", "13"], ["zhanggx","张观先", "13"],["zhangsy", "张水源", "13"]]}}}';
这个是从数据库访问出来的，我没看到因为感觉数据太不规整了，假设我想用jquery循环输出rowset 应该怎么办
循环rowset的时候我就往html里的表格添加<tr>,<td>然后把数据放进去。不知道怎么处理这样的json
],
"rows": 10,
"pagerows": 10,
"pagesize": 1,
"pageindex": 1,
"rowset": [
[
"dashuji",
"lzg",
"332313"
],
[
"dengzy",
"邓振裕",
"13"
],
[
"hurr",
"胡如荣",
"13"
],
[
"liuy",
"刘勇",
"13"
],
[
"lizr",
"李周仁",
"13"
],
[
"luj",
"陆俊",
"13"
],
[
"yangww",
"杨旺文",
"13"
],
[
"yuyx",
"于映喜",
"13"
],
[
"zhanggx",
"张观先",
"13"
],
[
"zhangsy",
"张水源",
"13"
]
]
}
}
};
var test = test1.dataset.f24.rowset;
$.each(test, function(idx,item) {
alert("第["+idx+"]列-- 帐号:"+item[0]+" 姓名:"+item[1]+" 号码:"+item[2]);
})
</script>
</head>
<body>
</body>
</html>
[解决办法]
<script type="text/javascript" charset="UTF-8">
var json2 = {
"code":"1",
"datatype":"json",
"dataset":{
"f24":{
"meta":["USERID", "LABEL", "PASSWD"],
"rows":10,
"pagerows":10,
"pagesize":1,
"pageindex":1,
"rowset":[
["dashuji", "lzg", "332313"],
["dengzy","邓振裕", "13"],
["hurr", "胡如荣", "13"],
["liuy", "刘勇","13"],
["lizr", "李周仁", "13"],
["luj", "陆俊", "13"],
["yangww", "杨旺文", "13"],
["yuyx", "于映喜", "13"],
["zhanggx","张观先", "13"],
["zhangsy", "张水源", "13"]
]
}
}
};
var rowData = json2.dataset.f24.rowset;
var str='', arr = new Array();
for(var j=0 ;j<rowData.length;j++){
arr.push(' <tr>');
for(var i=0; i<rowData[j].length; i++){
arr.push(' <td>'+rowData[j][i]+'</td>')
}
arr.push(' </tr>');
}
str = arr.join('');
console.log(str);
delete arr;
</script>
for (var i=0; i<json2.dataset.meta.rowset.length; i++) {
var rec = json2.dataset.meta.rowset[i];
var obj = {userId: rec[0], label: rec[1], passwd: rec[2]};
alert("userId = " + obj.userId + ", label = " + obj.label + ", passwd = " + obj.passwd);
}