NodeJs操作Mongodb

• 创建数据库

var mongoClient = require('mongoDB').MongoClient;
var url = 'mongodb://localhost:27017/test';

mongoClient.connect(url,function (err,db) {
    if(err){
        console.log(err);
    }
    console.log('连接数据库成功');
    db.close();
});

• 创建集合

var mongoClient = require('mongoDB').MongoClient;
var url = 'mongodb://localhost:27017/test';

mongoClient.connect(url,function (err,db) {
    if(err){
        console.log(err);
    }
    console.log('连接数据库成功');
    var dbbase = db.db('test');
    dbbase.createCollection('node',function (err,res) {
        if (err) throw err;
        console.log("创建集合!");
        db.close();
    });
});

• 删除集合

var mongoClient = require('mongoDB').MongoClient;
var url = 'mongodb://localhost:27017/test';

mongoClient.connect(url, function(err, db) {
    if (err) throw err;
    var dbo = db.db("test");
    // 删除 test 集合
    dbo.collection("node").drop(function(err, res) {  // 执行成功 res 返回 true，否则返回 false
        if (err) throw err;
        if (res) console.log("集合已删除");
        db.close();
    });
});

• 插入数据

var mongoClient = require('mongoDB').MongoClient;
var url = 'mongodb://localhost:27017/test';

mongoClient.connect(url,function (err,db) {
    if(err){
        console.log(err);
    }
    console.log('连接数据库成功');
    var dbbase = db.db('test');
    var data2 = [{'name':'王红','age':21},{'name':'李明','age':26}];
    /* var data1 = {'name':'abc','age':22};
     dbbase.collection('node').insertOne(data1,function () {
         if (err) throw err;
         console.log("单条文档插入成功");
         db.close();
     });*/
    dbbase.collection('node').insertMany(data2,function () {
        if (err) throw err;
        console.log("多条文档插入成功");
        db.close();
    });
});

•  查询数据

var mongoClient = require('mongoDB').MongoClient;
var url = 'mongodb://localhost:27017/test';

mongoClient.connect(url,function (err,db) {
    if(err){
        console.log(err);
    }
    console.log('连接数据库成功');
    var dbbase = db.db('test');

    var queryParams = {'name':'abc'};
    dbbase.collection('node').find(queryParams).toArray(function (err,result) {
        if (err) throw err;
        console.log(result);
        db.close();
    });
});

• 排序查询数据

var mongoClient = require('mongoDB').MongoClient;
var url = 'mongodb://localhost:27017/test';

mongoClient.connect(url,function (err,db) {
    if(err){
        console.log(err);
    }
    console.log('连接数据库成功');
    var dbbase = db.db('test');

    var sortParams = {'age':1};//按年龄升序查询排列 {'age':0}为降序排列
    dbbase.collection('node').find().sort(sortParams).toArray(function (err,result) {
        if (err) throw err;
        console.log(result);
        db.close();
    });
});

• 分页查询数据

var mongoClient = require('mongoDB').MongoClient;
var url = 'mongodb://localhost:27017/test';

mongoClient.connect(url,function (err,db) {
    if(err){
        console.log(err);
    }
    console.log('连接数据库成功');
    var dbbase = db.db('test');

    //查询分页                      find().skip(1).limit(2)跳过第一条数据 查询后两条数据
    dbbase.collection('node').find().limit(2).toArray(function (err,result) {
        if (err) throw err;
        console.log(result);
        db.close();
    });
});

•  更新数据

var mongoClient = require('mongoDB').MongoClient;
var url = 'mongodb://localhost:27017/test';

mongoClient.connect(url,function (err,db) {
    if(err){
        console.log(err);
    }
    console.log('连接数据库成功');
    var dbbase = db.db('test');

    var queryParams = {'name':'abc'};
    var updateParams = {$set:{'age':100}};
    dbbase.collection('node').updateOne(queryParams,updateParams,function (err,res) {
        if (err) throw err;
        console.log('文档更新成功');
        //updateMany();   //多条修改
        //console.log(res.result.nModified + " 条文档被更新");
        db.close();
    });
});

• 删除数据

var mongoClient = require('mongoDB').MongoClient;
var url = 'mongodb://localhost:27017/test';

mongoClient.connect(url,function (err,db) {
    if(err){
        console.log(err);
    }
    console.log('连接数据库成功');
    var dbbase = db.db('test');

    var queryParams = {'name':'abc'};

    dbbase.collection('node').deleteOne(queryParams,function (err,res) {
        if (err) throw err;
        console.log('文档删除成功');
        //updateMany();   //多条修改
        //console.log(res.result.nModified + " 条文档被更新");
        db.close();
    });
});