node 实现mongodb数据库简单的增删改查
首先需要下载驱动包,使用命令npm install mongodb
//增加数据
var MongoClient = require('mongodb').MongoClient;
var DB_CONN_STR = 'mongodb://localhost:27017/runoob';//数据库为runoob
var insertData = function(db,callback){
//连接到表site
var collection = db.collection('site');
//插入数据
var data = [{"name":"菜鸟教程","url":"wwww.runoob.com"},{"name":"菜鸟工具","url":"c.runoob.com"}];
collection.insert(data,function(err,result){
if(err){
console.log('Error:'+err);
return;
}
callback(result);
});
}
//查询数据
var MongoClient = require('mongodb').MongoClient;
var DB_CONN_STR = 'mongodb://localhost:27017/runoob';
var selectData = function(db,callback){
//连接到表
var collection = db.collection('site');
//查询数据
var whereStr = {"name":"菜鸟教程"};
collection.find(whereStr).toArray(function(err,result){
if(err){
console.log("Error:"+err);
return;
}
callback(result);
});
}
//跟新数据
var MongoClient = require('mongodb').MongoClient;
var DB_CONN_STR = 'mongodb://localhost:27017/runoob';
var updateData = function(db,callback){
//连接到表
var collection = db.collection('site');
//跟新数据
var whereStr = {"name":"菜鸟教程"};
var updateStr = {$set:{"url":"https://www.runoob.com"}};
collection.update(whereStr,updateStr,function(err,result){
if(err){
console.log("error:"+err);
return;
}
callback(result);
});
}
//删除数据
var MongoClient = require('mongodb').MongoClient;
var DB_CONN_STR = 'mongodb://localhost:27017/runoob';
var delData = function(db, callback) {
//连接到表
var collection = db.collection('site');
//删除数据
var whereStr = {"name":'菜鸟工具'};
collection.remove(whereStr, function(err, result) {
if(err)
{
console.log('Error:'+ err);
return;
}
callback(result);
});
}
MongoClient.connect(DB_CONN_STR, function(err, db) {
console.log("连接成功!");
delData(db, function(result) {
console.log(result);
db.close();
});
});