node.js如何在mongodb中获取列值

debugcn 发表于 Dev

用户名

我一直在研究node.js和mongodb。我想带特定的db值。但是对我来说并不容易。我想获取Vidget中该数组的值。我不知道如何实现。

我的mongodb数据

  {
    "Seq": 1,
    "UID": "kingnight99",
    "DBID": "yyyymmddhhmmss",
    "NAME": "name",
    "DESC": "desc",
    "Forms": [
              {
               "Seq": 1,
               "Name": "aaa",
               "Desc": "aaa",
               "Vidget": [
                           {
                             "Seq": 1,
                             "Vid": "ID",
                             "X": "x",
                             "Y": "y",
                             "W": "w",
                             "H": "h"
                            },
                          {
                            "Seq": 2,
                            "Vid": "ID",
                            "X": "x",
                            "Y": "y",
                            "W": "w",
                            "H": "h"
                          },
                          {
                           "Seq": 3,
                           "Vid": "ID",
                           "X": "x",
                           "Y": "y",
                           "W": "w",
                           "H": "h"
                          }
                       ]
               }
             ]     
   }

我的node.js

var db = require('mongojs').connect('vizboard', [ 'member', 'count','Dashboard' ]);
exports.checkData=function(req,res){
  console.log('check Dats json in');
  console.log('Forms Seq:'+req.param('seq'));
  db.Dashboard.find({
     "Forms":{"Seq":Number(req.param('seq'))}
 },function(error,result){
    if(error){
        console.log('error:'+error);
    }
    console.log('data':'+JSON.stringify(result));
}).Vidget;
}

结果为空...我请教一些建议！

男生

您必须访问返回给您的结果：

var db = require('mongojs').connect('vizboard', [ 'member', 'count', 'Dashboard' ]);
exports.checkData = function (req, res) {
    console.log('check Dats json in');
    console.log('Forms Seq:' + req.param('seq'));
    db.Dashboard.find({
        "Forms.Seq": Number(req.param('seq'))
    }, function (error, result) {
        if (error) {
            console.log('error:' + error);
        }
        console.log('data:' + JSON.stringify(result));

        // here is your result, it's not accessible outside this function!

        result[0].Forms.forEach(function (form) {
            console.log('form Name=' + form.Name, form.Vidget);
        });
    });
};

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。