当前位置:Gxlcms > 数据库问题 > mongoose查询数据库步骤

mongoose查询数据库步骤

时间:2021-07-01 10:21:17 帮助过:51人阅读

API文档: http://mongoosejs.com/docs/guide.html

  1. cnpm install mongoose --save

二、创建一个model模型

  1. <span style="color: #008000">//</span><span style="color: #008000"> goods.js</span>
  2. <span style="color: #0000ff">var</span> mongoose = require(‘mongoose‘<span style="color: #000000">);
  3. </span><span style="color: #0000ff">var</span> Schema =<span style="color: #000000"> mongoose.Schema;
  4. </span><span style="color: #008000">//</span><span style="color: #008000"> 定义一个Schema</span>
  5. <span style="color: #0000ff">var</span> produtSchema = <span style="color: #0000ff">new</span><span style="color: #000000"> Schema({
  6. </span>‘productId‘:String, <span style="color: #008000">//</span><span style="color: #008000"> 或者 ‘productId‘:{type:String}</span>
  7. ‘productName‘<span style="color: #000000">:String,
  8. </span>‘salePrice‘<span style="color: #000000">:Number,
  9. </span>‘productImage‘<span style="color: #000000">:String
  10. })
  11. </span><span style="color: #008000">//</span><span style="color: #008000"> 输出(导出)</span>
  12. module.exports = mongoose.model(‘good‘,produtSchema); <span style="color: #008000">//</span><span style="color: #008000"> 定义一个good商品模型,可以根据这个商品模型调用其API方法。</span><span style="color: #008000">
  13. //</span><span style="color: #008000"> 这个模型定义的是数据库dumall的goods集合数据,所以这个model取名good是对应这个集合,连接数据库之后,这个模型会根据名字的复数形式"goods"来查找数据集合。</span><span style="color: #008000">
  14. //</span><span style="color: #008000"> module.exports = mongoose.model(‘good‘,produtSchema,‘goods‘); 也可以后面注明链接的是数据库的goods集合</span>

三、连接数据库

  1. <span style="color: #008000">//</span><span style="color: #008000"> db.js</span>
  2. <span style="color: #0000ff">var</span> mongoose = require(‘mongoose‘<span style="color: #000000">);
  3. </span><span style="color: #0000ff">var</span> Goods = require(‘./goods.js‘<span style="color: #000000">);
  4. </span><span style="color: #008000">//</span><span style="color: #008000"> 链接MongoDB数据库,数据库的名称叫dumall</span>
  5. mongoose.connect(‘mongodb://127.0.0.1:27017/dumall‘); <span style="color: #008000">//</span><span style="color: #008000"> 若是带账号密码的:‘mongodb://root:123456@127.0.0.1:27017/dumall‘</span>
  6. <span style="color: #008000">//</span><span style="color: #008000"> 连接成功操作</span>
  7. mongoose.connection.on("connected",<span style="color: #0000ff">function</span><span style="color: #000000">(){
  8. console.log(</span>"MongoDB connected success."<span style="color: #000000">)
  9. })
  10. </span><span style="color: #008000">//</span><span style="color: #008000"> 连接失败操作</span>
  11. mongoose.connection.on("error",<span style="color: #0000ff">function</span><span style="color: #000000">(){
  12. console.log(</span>"MongoDB connected fail."<span style="color: #000000">)
  13. })
  14. </span><span style="color: #008000">//</span><span style="color: #008000"> 连接断开操作</span>
  15. mongoose.connection.on("disconnected",<span style="color: #0000ff">function</span><span style="color: #000000">(){
  16. console.log(</span>"MongoDB connected disconnected."<span style="color: #000000">)
  17. })
  18. </span><span style="color: #008000">//</span><span style="color: #008000"> 连接成功之后,用model的good商品模型查询到数据库的goods集合。</span>
  19. Goods.find({},<span style="color: #0000ff">function</span><span style="color: #000000">(err, doc){
  20. </span><span style="color: #0000ff">if</span><span style="color: #000000">(err) {
  21. console.log(err.message)
  22. }</span><span style="color: #0000ff">else</span><span style="color: #000000">{
  23. console.log(doc)
  24. }
  25. })</span>

doc的内容:

技术分享图片

 

mongoose查询数据库步骤

标签:uid   src   str   导入数据   success   number   cte   文档   vue   

人气教程排行