[TOC] [mongoose 官網](https://mongoosejs.com/docs/validation.html) [簡書參考](https://www.jianshu.com/p/9b20c1e2f373) ## 安裝 `npm i -S mongoose` ## demo使用 在`model/base.js `中 連接數據庫 ``` const mongoose = require("mongoose"); // 若是帶賬號密碼的：'mongodb://root:123456@127.0.0.1:27017/dumall' const connStr= "mongodb://127.0.0.1:27017/imoocsell"; mongoose.connect(connStr,{ useNewUrlParser: true }); mongoose.connection.on("connected",()=>{ console.log("MongoDB connected success.") }); mongoose.connection.on("error",()=>{ console.log("MongoDB connected fail.") }); mongoose.connection.on("disconnected",()=>{ console.log("MongoDB connected disconnected.") }); ``` 在`model/goods.js`中 創建 映射關系 ``` const mongoose = require("mongoose"); let Schema = mongoose.Schema; //定義一個shcema var productSchema = new Schema({ 'productId':String, // 或者 'productId':{type:String} 'productName':String, 'salePrice':Number, 'productImage':String, }); // 輸出(導出) module.exports = mongoose.model('good',productSchema,"goods");//第三參數對應表名 ``` 在 `routers/goods.js` 中 ``` const goods = require("../models/goods"); //復雜條件查詢 params.salePrice={ $gt: priceGt, $lte: priceLte, } goodsModel = goods.find(params); goodsModel.sort({salePrice:param.sort}).skip(skip).limit(param.pageSize); goodsModel.exec((err,doc)=>{} //單條查詢 User.findOne({userName:userName},(err1,userDoc)=>{ //保存 userDoc.userName="ccc"; userDoc.save((err4,doc3)=>{}) } //刪除用戶下購物車中的某個物品 userModel.update({userId: userId}, {$pull: {cartList: {productId: productId} } }, (err, doc) => {}) //更新 購物車下的某個物品數量 userModel.update({ userId:userId,"cartList.productId":productId}, {"cartList.$.productNum":productNum},(err,doc)=>{}); //類更改默認值 userModel.findOne({userId:userId},(err,doc)=>{ doc.addressList.forEach(item=>{}) //進行循環 doc.save((err,doc)=>{}) }); ``` ##