摘要：轉載先用安裝安裝成功后，繼續在上面操作創建的庫和表中操作插入連接到表插入數據連接成功查詢連接到表查詢數據連接成功修改連接到表更新數據連接成功刪除連接到表刪除數據連接成功調用存儲過程存儲過程調用連接成功

轉載：http://forum.foxera.com/mongo...

先用npm安裝mongodb

npm install mongodb

安裝成功后，繼續在上面操作創建的庫和表中操作

插入

var MongoClient = require("mongodb").MongoClient;
var DB_CONN_STR = "mongodb://localhost:27017/wilsondb1";    
var insertData = function(db, callback) {  
    //連接到表  
    var collection = db.collection("tb2");
    //插入數據
    var data = [{"name":"wilson001","age":21},{"name":"wilson002","age":22}];
    collection.insert(data, function(err, result) { 
        if(err)
        {
            console.log("Error:"+ err);
            return;
        }     
        callback(result);
    });
}
MongoClient.connect(DB_CONN_STR, function(err, db) {
    console.log("連接成功！");
    insertData(db, function(result) {
        console.log(result);
        db.close();
    });
});

查詢

var MongoClient = require("mongodb").MongoClient;
var DB_CONN_STR = "mongodb://localhost:27017/wilsondb1";  
var selectData = function(db, callback) {  
  //連接到表  
  var collection = db.collection("tb2");
  //查詢數據
  var whereStr = {"name":"wilson001"};
  collection.find(whereStr).toArray(function(err, result) {
    if(err)
    {
      console.log("Error:"+ err);
      return;
    }     
    callback(result);
  });
}
MongoClient.connect(DB_CONN_STR, function(err, db) {
  console.log("連接成功！");
  selectData(db, function(result) {
    console.log(result);
    db.close();
  });
});

修改

var MongoClient = require("mongodb").MongoClient;
var DB_CONN_STR = "mongodb://localhost:27017/wilsondb1";    
var updateData = function(db, callback) {  
    //連接到表  
    var collection = db.collection("tb2");
    //更新數據
    var whereStr = {"name":"wilson001"};
    var updateStr = {$set: { "age" : 100 }};
    collection.update(whereStr,updateStr, function(err, result) {
        if(err)
        {
            console.log("Error:"+ err);
            return;
        }     
        callback(result);
    });
}
MongoClient.connect(DB_CONN_STR, function(err, db) {
    console.log("連接成功！");
    updateData(db, function(result) {
        console.log(result);
        db.close();
    });
});

刪除

var MongoClient = require("mongodb").MongoClient;
var DB_CONN_STR = "mongodb://localhost:27017/wilsondb1";  
var delData = function(db, callback) {  
  //連接到表  
  var collection = db.collection("tb2");
  //刪除數據
  var whereStr = {"name":"wilson001"};
  collection.remove(whereStr, function(err, result) {
    if(err)
    {
      console.log("Error:"+ err);
      return;
    }     
    callback(result);
  });
}
MongoClient.connect(DB_CONN_STR, function(err, db) {
  console.log("連接成功！");
  delData(db, function(result) {
    console.log(result);
    db.close();
  });
});

調用存儲過程

var MongoClient = require("mongodb").MongoClient;
var DB_CONN_STR = "mongodb://localhost:27017/wilsondb1";    
var invokeProcData = function(db, callback) {  
    //存儲過程調用
    db.eval("get_tb2_count()", function(err, result) { 
        if(err)
        {
            console.log("Error:"+ err);
            return;
        }             
        callback(result);
    });
}
MongoClient.connect(DB_CONN_STR, function(err, db) {
    console.log("連接成功！");
    invokeProcData(db, function(result) {
        console.log(result);
        db.close();
    });
});