如何解析数据库json表单中的数据

Question

我想在HTML页面中显示json的内容 我在数据库中读取表中的行，将它们放在一个列表中，然后我尝试解析json格式，但是当我尝试从json中检索一些数据时，我无法举例说明是否要显示名称或类似的内容

@APP.route('/scan',methods=['GET'])
def scan():
    listscan = []
    con = mdb.connect('localhost','testuser', 'test623', 'bd')
    cur = con.cursor()
    cur.execute("SELECT * FROM tablesd")
    rows = cur.fetchall()
    for row in rows:
        chaine = "Id:" + str(row[0]) + ',' + "HOST_NAME:" + str(row[1]) + "," + "ADDRESS:" + str(row[2]) + "," + "IP:" + str(row[3]) + "," + "TIME:" + str(row[4]) + "," + "DATE:" + str(row[5]) + "," + "CONN:" + str(row[6]) + "," + "ETAT:" + str(row[7]) + "," + "NEWgh:" + str(row[8])
    listscan.append(chaine)

    print json.dumps(listscan)
    return json.dumps(listscan)

function scan (){ 
    $.ajax({
        type: 'GET',
        url: '/scan',
        dataType: 'json',
        success: function(json) {
            alert('ok');
            var lang = '';
            $.each(json, function() {
                lang += this['Id'] + "<br/>";
            });
            $("#donnees").html(lang);
        },
        error: function() {
            alert('La requête n\'a pas abouti');
        }
    });    
}

打印结果json.dumps文件（列表扫描）：

["Id:1,HOST_NAME:,ADDRESS:x:x:x:x:x:x,IP:172.x.x.x,TIME:17:25,DATE:04/04/15,CONN:0,ETAT:null,NEWgh:1", "Id:2,HOST_NAME:,ADDRESS:Y:Y:Y:Y:Y:Y,IP:192.x.x.x,TIME:17:25,DATE:04/04/15,CONN:0,ETAT:null,NEWgh:1"]

我喜欢显示未定义我没有收到id

Answer 1

您应该更新您的响应（listscan），如：

var json = [
 {'Id':1, HOST_NAME:'', ADDRESS:'x:x:x:x:x:x', IP:'172.x.x.x', TIME:'17:25', DATE:'04/04/15', CONN:0, ETAT:null, NEWgh:1},
 {'Id':1, HOST_NAME:'', ADDRESS:'x:x:x:x:x:x', IP:'172.x.x.x', TIME:'17:25', DATE:'04/04/15', CONN:0, ETAT:null, NEWgh:1},
];

$.each(json, function() {
    $('body').append(this['Id'] + '<br\>');
});

在这里你可以找到一个例子：http://jsfiddle.net/guilhermeaferreira/jm86qr0v/