mysql2 rows js,如何解析node.js，express.js，mysql2中“rows”對象的數據

I m using the node,express,mysql2 packages .When i m using console.log(rows) ,it is giving me following output:

我正在使用node,express,mysql2包。當我使用console.log(行)時,它給了我以下輸出:

[{"userid": "test","password": "test"}]

And here is my Code :

這是我的代碼:

var application_root = __dirname,

express = require("express"),

mysql = require('mysql2');

path = require("path");

var app = express();

var connection = mysql.createConnection({

host : 'localhost',

user : 'root',

password : '123',

database: "bbsbec"

});

app.configure(function () {

app.use(express.bodyParser());

app.use(express.methodOverride());

app.use(app.router);

app.use(express.static(path.join(application_root, "public")));

app.use(express.errorHandler({ dumpExceptions: true, showStack: true }));

});

connection.query('SELECT * from pass', function(err, rows) {

res.json(rows);

console.log(rows);

});

I just want to know that how can i parse this "rows" object so that i can retrive both userid and password .

我只想知道如何解析這個“行”對象,以便我可以檢索用戶ID和密碼。

2 个解决方案

#1

6

Try this (this is really basic):

試試這個(這是非常基本的):

connection.query('SELECT * from pass', function(err, rows) {

res.json(rows);

var user = rows[0].userid;

var password= rows[0].password;

});

#2

14

[{"userid": "test","password": "test"}]

This is an Array of Objects. So: First loop over the array to get a single object and then extract it's properties:

這是一個對象數組。所以:首先遍歷數組以獲取單個對象,然后提取它的屬性:

for (var i = 0; i < rows.length; i++) {

var row = rows[i];

console.log(row.userid);

}