一、创建数据库
先安装mongodb:cnpm install mongodb --save
var MongodbClient=require("mongodb").MongoClient;
var url="mongodb://127.0.0.1:27017";
var dbname="chat";
//创建数据库
MongodbClient.connect(url,{useUnifiedTopology:true},function(err,client){
if(err) throw err;
console.log("chat数据库创建成功!");
var dbbase=client.db(dbname); //获取当前数据库对象
dbbase.createCollection("user",function(error,result){
if(error){
console.log("表已经存在!");
return;
}
console.log("user表创建成功!");
client.close(); //数据库关闭
});
});
二、增加数据
- 单条数据
var data={
name:"易安",
age:21,
sex:"女",
address:"西安市"
}
dbbase.collection("user").insertOne(data,function(err,res){
if(err) throw err;
if(res.result.ok==1){
console.log("增加数据成功!");
}
client.close();
});
- 多条数据
var data=[
{
name:"易安",
age:21,
sex:"女",
address:"西安市"
},
{
name:"kun",
age:20,
sex:"男",
address:"杭州市"
},
{
name:"ikun",
age:18,
sex:"女",
address:"上海市"
}
]
dbbase.collection("user").insertMany(data,function(error,res){
if(error) throw error;
if(res.result.ok!=0){
console.log("增加数据成功!");
}
client.close();
});
三、删除数据
- 单条数据(重复数据中删除第一条)
var data={
name:"ikun"
}
dbbase.collection("user").deleteOne(data,function(error,res){
if(error) throw error;
console.log("删除数据成功!");
client.close();
});
- 多条数据(重复数据全部删除)
var data={name:"yan"}
dbbase.collection("user").deleteMany(data,function(error,res){
if(error) throw error;
console.log("删除数据成功!");
client.close();
});
四、查找数据
- 查找返回整张表
dbbase.collection("user").find().toArray(function(error,res){
if(error) throw error;
console.log(res);
client.close();
});
- 条件查询
dbbase.collection("user").find({name:"kun"}).toArray(function(error,res){
if(error) throw error;
console.log(res);
client.close();
});
- 数据分页查找
dbbase.collection("user").find().skip(0).limit(2).toArray(function(error,res){
if(error) throw error;
console.log(res);
client.close();
});
- 模糊查找
dbbase.collection("user").find({name:/易/}).toArray(function(error,res){
if(error) throw error;
console.log(res);
client.close();
});
- 大于等于查找
dbbase.collection("user").find({age:{$gte:20}}).toArray(function(error,res){
if(error) throw error;
console.log(res);
client.close();
});
五、修改数据
- 单条数据
var data={
name:"易安"
}
var set={
$set:{name:"莲安"}
}
dbbase.collection("user").updateOne(data,set,function(error){
if(error) throw error;
console.log("修改数据成功!");
client.close();
});
- 多条数据
var data={
name:"kun"
}
var set={
$set:{name:"小花"}
}
dbbase.collection("user").updateMany(data,set,function(error){
if(error) throw error;
console.log("修改数据成功!");
client.close();
});