node.js查询mongo数据库

var MongoClient = require('mongodb').MongoClient;
var dburl = 'mongodb://localhost:27017/xuesheng';
MongoClient.connect(dburl, function(err, db) {
	if(err){
		console.log("错误！数据库没有链接成功！");
		console.log("你mongod了么？请使用mongod --dbpath 先开机！");
		return;
	}
	console.log("数据库连接成功");
	db.collection("product").insertMany(
		[
			{
				"id": 1,
				"brand": "苹果",
				"price" : 5000,
				"category_id":"c001"
			},
			{
				"id": 2,
				"brand": "'vivo', ",
				"price" : 3000,
				"category_id":"c001"
			},
			{
				"id": 3,
				"brand": "华为",
				"price" : 5000,
				"category_id":"c001"
			},
			{
				"id": 4,
				"brand": "oppo",
				"price" : 1000,
				"category_id":"c001"
			},
			{
				"id": 5,
				"brand": "真维斯",
				"price" : 200,
				"category_id":"c002"
			},
			{
				"id": 6,
				"brand": "only",
				"price" : 440,
				"category_id":"c002"
			},
			{
				"id": 7,
				"brand": "圣迪奥",
				"price" : 800,
				"category_id":"c002"
			},
			{
				"id": 8,
				"brand": "vero moda",
				"price" : 800,
				"category_id":"c003"
			},
			{
				"id": 9,
				"brand": "相宜本草",
				"price" : 200,
				"category_id":"c003"
			},
			{
				"id": 10,
				"brand": "卫龙辣条",
				"price" : 5,
				"category_id":"NULL"
			},
			{
				"id": 11,
				"brand": "好想你枣",
				"price" : 56,
				"category_id":"NULL"
			},
			{
				"id": 12,
				"brand": "香飘飘",
				"price" : 3,
				"category_id":"NULL"
			},
			{
				"id": 13,
				"brand": "小涴熊干脆面",
				"price" : 1,
				"category_id":"NULL"
			}
			
		],

		function(err,r){
			//回调函数
			if(err){
				console.log("插入数据失败！");
				return;
			}
			console.log("成功插入了" + r.insertedCount + "条数据");
		}
	);
	db.collection("product").find({}).toArray(function(err,results){
		if(err){
			console.log("查询数据失败！");
			return;
		}
		console.log(results);
		db.close();
	});
});

上面数插入数据，现在开始查

var MongoClient = require('mongodb').MongoClient;
var dburl = 'mongodb://localhost:27017/xuesheng';
MongoClient.connect(dburl, function(err, db) {
	if(err){
		console.log("错误！数据库没有链接成功！");
		console.log("你mongod了么？请使用mongod --dbpath 先开机！");
		return;
	}
	console.log("数据库连接成功");
	
	db.collection("product").find({"brand":"花花公子"}).toArray(function(err,results){
		if(err){
			console.log("查询数据失败！");
			return;
		}
		console.log(results);
		db.close();
	});
	db.collection("product").find({"price":800}).toArray(function(err,results){
		if(err){
			console.log("查询数据失败！");
			return;
		}
		console.log(results);
		db.close();
	});
	db.collection("product").find({"price":{$ne:5}}).toArray(function(err,results){
		if(err){
			console.log("查询数据失败！");
			return;
		}
		console.log(results);
		db.close();
	});
	db.collection("product").find({"price":{$gt:200,$lt:1000}}).toArray(function(err,results){
		if(err){
			console.log("查询数据失败！");
			return;
		}
		console.log(results);
		db.close();
	});
});

现在是查询

var MongoClient = require('mongodb').MongoClient;
var dburl = 'mongodb://localhost:27017/xuesheng';
MongoClient.connect(dburl, function(err, db) {
	if(err) {
		console.log("错误！数据库没有链接成功！");
		console.log("你mongod了么？请使用mongod --dbpath 先开机！");
		return;
	}
	console.log("数据库连接成功");
	db.collection("product").updateMany({}, function(err, r) {
		if(err) {
			console.log("查询数据失败！");
			return;
		}
		console.log("成功");
		db.close();
	});
});

改数据

var MongoClient = require('mongodb').MongoClient;
var dburl = 'mongodb://localhost:27017/xuesheng';
MongoClient.connect(dburl, function(err, db) {
	if(err) {
		console.log("错误！数据库没有链接成功！");
		console.log("你mongod了么？请使用mongod --dbpath 先开机！");
		return;
	}
	console.log("数据库连接成功");
	db.collection("banji1120").updateOne({"xingming": "刘备"},{$set : {"nianling":45}}, function(err, r) {
		if(err) {
			console.log("查询数据失败！");
			return;
		}
		console.log("成功");
		db.close();
	});
});