問題描述

問題解答

圖片有點太模糊了，看不清楚，給你看看我之前寫的吧，先配置一個Mongoose.js

var mongoose = require(’mongoose’);var config = require(’./Config’);mongoose.connect(config.dbUrl, function (err) { if (err) {console.error(’[數據庫鏈接錯誤]connect to %s error’, err.message);process.exit(1); }});exports.mongoose = mongoose;

然后寫Dao層，用來保存數據庫表的操作

這是我之前寫的一個操作數據庫表的js

var dbo = require(’../bin/Mongoose’).mongoose , Schema = dbo.Schema;var u = require(’../bin/Util’);var c = require(’../bin/Config’);//產品所屬表var mySchema = Schema({ _id: String, _pid: {type: String, ref: ’product’}, //產品id _sid: {type: String, ref: ’sale’}, //銷售id _mid: {type: String, ref: ’merchant’}, //服務商id c_Scan: String, //打開次數 c_Sort: Number, //排序 c_Like: Number, //點贊次數 c_Datetime: String //創建時間});var Chain = dbo.model(’chain’, mySchema);//鏈接（二維碼）//默認添加exports.saveChain = function (u, callback) { var p = new Chain(u); p.save(callback);};//查詢 產品 和 銷售 對應exports.findPS = function (p, s, callback) { Chain.findOne({_pid: p, _sid: s}, callback);};//查詢 按照服務商exports.find = function (mid, callback) { Chain.find({_mid: mid}).populate(’_pid _sid’).sort({’c_Datetime’: -1}).exec(callback);};exports.findSid = function (sid, callback) { Chain.find({_sid: sid}).populate(’_pid _sid’).sort({’c_Datetime’: -1}).exec(callback);};exports.findOne = function (id, callback) { Chain.findOne({_id: id}).populate(’_pid _sid _mid’).exec(callback);};//修改 掃描次數exports.updateScan = function (id, num, options, callback) { Chain.update({_id: id}, {$set: {c_Scan: num}}, options, callback);};//修改 點贊次數exports.updateLike = function (id, num, options, callback) { Chain.update({_id: id}, {$set: {c_Like: num}}, options, callback);};//查詢 按照銷售exports.findSale = function (sid, skip, callback) { Chain.find({_sid: sid}).populate(’_pid’).sort({’c_Datetime’: -1}).limit(c.loadNum).skip(skip).exec(callback);};//查詢 按照銷售exports.findSaleWd = function (sid, callback) { Chain.find({_sid: sid}).populate(’_pid’).sort({’c_Datetime’: -1}).exec(callback);};//查詢 按照銷售exports.findSaleNum = function (sid, id, callback) { Chain.find({_sid: sid, _id: {’$ne’: id}}).populate(’_pid _mid’).sort({’c_Datetime’: -1}).limit(4).skip(0).exec(callback);};exports.updateData=function(pid,data,options,callback){ Chain.update({_pid: pid}, {$set: {c_Datetime: data}}, options, callback);};//查詢 按照銷售exports.count = function (sid, callback) { Chain.count({_sid: sid}, callback);};//按照銷售 全部清空排序exports.updateSortSid = function (id, options, callback) { Chain.update({_id: id}, {$set: {c_Like: 200}}, options, callback);};

希望可以幫助到你。

router.post(’/homepage’,function(req,res){ var query_doc = {userid:req.body.userid,password:req.body.password}; userModel.findOne(query_doc,function(err,data){if(err) { console.error(err);}if(!!data){ //有這個用戶 //todo }else{ //沒有這個用戶 //todo } })})

你上面打印的應該是這里的日志