关于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

解决方案 »

  1.   

    你这json有问题啊，格式化都不好用那些个'+'号是干嘛的
      

  2.   


    <!DOCTYPE html>
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>Editable TreeGrid - jQuery EasyUI Demo</title>
    <script type="text/javascript" src="scripts/jquery-1.9.1.js"></script>
    <script type="text/javascript">
    var test1={
        "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 test = test1.dataset.f24.rowset;
                                                $.each(test, function(idx,item) {
                                                alert("第["+idx+"]列-- 帐号:"+item[0]+"   姓名:"+item[1]+"   号码:"+item[2]); 
                                                }) </script>
    </head>
    <body>

    </body>
    </html>
      

  3.   


            <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>大概这样的..
      

  4.   

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