所以我想做一个库存管理器，只要点击一个按钮，它就可以从数据库的表中选择行。我当前有一个原始记录集，它是

[{"id":1,"first_name":"Tyler","last_name":"Marlow","hooks_id":1,"sp_id":1,"rods_id":1,"num_hooks":10,"num_sp":30},{"id":2,"first_name":"Jon","last_name":"Marlow","hooks_id":2,"sp_id":1,"rods_id":1,"num_hooks":50,"num_sp":200}]

但是，我只想打印冒号后面的值。例如:1泰勒马洛1 1 1 10 30

下面是打印记录集的代码

server.js

app.get('/addPerson', function (req, res) {
    var conn = new sql.Connection(config);
    var requ = new sql.Request(conn);

    conn.connect(function (err) {
        if (err) {
            console.log(err);
            return;
        }

        var sql = "SELECT * FROM person";

        requ.query(sql, function (err, recordset) {
            if (err) {
                console.log(err)
            } else {
                res.send(recordset);
            }
        });
        conn.close();
    });
});

下面是使用记录集的xmlhttp请求

index.html

<script>
        function displayPerson() {
           // console.log('test');
            var xhttp = new XMLHttpRequest();
            xhttp.onreadystatechange = function () {
                if (this.readyState == 4 && this.status == 200) {
                    var person = xhttp.responseText;
                    var element = document.getElementById("PersonContainer");
                    element.innerHTML = person;
                }
            };
            xhttp.open("GET", "/AddPerson", true);
            xhttp.send();
        }
    </script>

如果有任何帮助，我将不胜感激，谢谢！