mongoose数据库连接和操作
! mongodb注意点:数据表名称一定要用复数,比如users,在使用model引用时也必须复数
var mongoose = require('mongoose')
mongoose.connect('mongodb://localhost:27017/hometown',{useMongoClient: true}); var db = mongoose.connection;
db.on('error', console.error.bind(console, 'connection error:')); db.once('open', function (callback) { console.log('db service connected.') });
//set schema var blogSchema = new mongoose.Schema({ article_id: {type:Number,default:0}, title: String, detail: String, img: String, view: {type:Number,default:0} }); //pub model var blogModel = db.model('towntrip',blogSchema);
blogModel.find(function(err,articles){ //find({},fn) res.render('index', {title:'Home Town',articles:articles}) })
//add data //var data = new blogModel({title:'Guanyin Mountain',detail:'With history culture,Guanyin Mountain is known for so many years.',img:'upload/img/a2.jpg',view:0}) //data.save() //update data //blogModel.update({_id:'5850c66834d5c51918f04d4c'},{$set:{view:1}},function(err){});