官方文檔: https://mongoosejs.com/docs/index.html

安裝

npm install mongoose --save

基本使用

// 1. 引入包
const mongoose = require("mongoose");

// 2. 連接數(shù)據(jù)庫
mongoose.connect('mongodb://127.0.0.1/test_db');

// 3. 獲取數(shù)據(jù)庫連接對象
const connection = mongoose.connection;

/**
 *  4. 監(jiān)聽數(shù)據(jù)庫狀態(tài)
**/

// 監(jiān)聽數(shù)據(jù)庫的連接的打開和關(guān)閉
connection.once("open", () => {
    console.log("數(shù)據(jù)庫連接成功");
});
connection.once("close", () => {
    console.log("數(shù)據(jù)庫已經(jīng)關(guān)閉連接");
});

// 監(jiān)聽數(shù)據(jù)庫錯(cuò)誤
connection.on("error", error => {
    console.log("數(shù)據(jù)庫錯(cuò)誤|Database error:" + error);
});

// 5. 創(chuàng)建Schema(模式對象) 類似于SQL中的設(shè)計(jì)表字段約束(此處的Schema注意大寫)
let userSchema = new mongoose.Schema({
    name : String,
    age: Number,
    sex: {
        type: String,
        default: "男"
    },
    height: Number
});

// 6. 創(chuàng)建model對象 model("collectionName", "documents")
// 注意: 此處的 collectionName會自動轉(zhuǎn)換為復(fù)數(shù)形式
let userModel = mongoose.model("users", catSchema);
 
// 7. 插入一條數(shù)據(jù)到 users 這個(gè)集合中
userModel.create({ name : "zs", age: 18, height: 172 }, error => {
    if (error) throw error;
    console.log("插入成功");
});

插入數(shù)據(jù)

// 插入一條數(shù)據(jù)
userModel.create([ { name : "zs", age: 18, height: 172 } ], error => {
    if (error) throw error;
    console.log("插入成功");
});

// 一次插入多個(gè)數(shù)據(jù)
userModel.create([
    { name : "zs", age: 18, height: 172 },
    { name : "ls", age: 20, height: 176 },
    { name : "wc", age: 28, height: 178 },
    { name : "ml", age: 32, height: 168 }
], error => {
    if (error) throw error;
    console.log("插入成功");
});

刪除數(shù)據(jù)

userModel.remove({name: 'ml'}, error => {
    if (error) throw error;
    console.log("刪除成功");
});

修改數(shù)據(jù)

userModel.update({'name' : 'zs'}, { $set: {height: 182} }, error => {
    if (error) throw error;
    console.log("修改成功");
});

查詢數(shù)據(jù)

• 簡單使用

// 帶條件條件的查詢
userModel.find({name: 'zs'}, (error, docs) => {
    if (error) throw error;
    console.log(docs);
});

• 查詢數(shù)據(jù),限制顯示字段并且跳過前兩個(gè)顯示一個(gè)

// db.users.find({}, {_id:0, __v:0}).skip(2).limit(1);
userModel.find( {}, {  _id: 0, __v:0 }, { skip:2, limit: 1 }, (error, docs) => {
    if (error) throw err;
    console.log(docs);
});