mysql2 rows js,如何从“行”解析数据？ node.js，express.js，mysql2中的对象

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

[{"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 .

解决方案

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;

});