问题描述
我目前正在使用Node-webkit开发一个桌面应用程序.在此过程中,我需要从本地MySQL数据库中获取一些数据.
I'm currently developing a desktop application with Node-webkit. During that process I need to get some data from a local MySQL-database.
查询工作正常,但我不知道如何访问结果.我将它们全部存储在一个数组中,然后将其传递给函数.在控制台中,它们如下所示:
The querying works fine, but I can't figure out how to access the results. I store all of them in an array that is then passed to a function. In the console they look like this:
RowDataPacket {user_id: 101, ActionsPerformed: 20}
RowDataPacket {user_id: 102, ActionsPerformed: 110}
RowDataPacket {user_id: 104, ActionsPerformed: 3}
这是查询结构:
var ret = [];
conn.query(SQLquery, function(err, rows, fields) {
if (err)
alert("...");
else {
for (var i of rows)
ret.push(i);
}
doStuffwithTheResult(ret);
}
如何在doStuffwithTheResult
函数中检索此内容?值更重要,但是如果我也能得到键,那将是很棒的.
How do I retrieve this in the doStuffwithTheResult
function? The values are more important, but if I could get the keys as well that would be great.
推荐答案
原来它们是普通对象,您可以通过user_id
访问它们.
Turns out they are normal objects and you can access them through user_id
.
RowDataPacket实际上是创建对象的构造函数的名称,它看起来像这样new RowDataPacket(user_id, ...)
.您可以通过访问其名称[0].constructor.name
RowDataPacket is actually the name of the constructor function that creates an object, it would look like this new RowDataPacket(user_id, ...)
. You can check by accessing its name [0].constructor.name
如果结果是数组,则必须使用[0].user_id
.
If the result is an array, you would have to use [0].user_id
.
这篇关于如何访问RowDataPacket对象的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!