-
封装装服务
mongod --dbpath "C:/D/data/db" --logpath "C:/D/data/log.log" --serviceName "Mongodb" --install
-
查看全部集合(数据库)
show dbs
-
切换集合(数据库)
use 集合名
-
查看单个集合
show collections
-
查看列
db.集合名.find(列名)
不传列名代表全部 -
查看当前所在集合
db
-
插入 更新
db.集合名.save({})
-
插入
db.集合名.insert({})
db.test_start.save({contry: "中国", name: "张三", score: 77});
db.test_start.save({contry: "中国", name: "王是", score: 44});
db.test_start.save({contry: "中国", name: "订单", score: 21});
db.test_start.save({contry: "中国", name: "李四", score: 92});
db.test_start.save({contry: "美国", name: "张二麻子", score: 66});
db.test_start.save({contry: "美国", name: "aaa", score: 66});
db.test_start.save({contry: "美国", name: "bbb", score: 29});
db.test_start.save({contry: "美国", name: "ccc", score: 56});
db.test_start.save({contry: "美国", name: "ddd", score: 80});
db.test_start.save({contry: "美国", name: "eee", score: 23});
// score 大于80
db.test_start.find({score: {$gt: 80}})
// score 小于80
db.test_start.find({score: {$lt: 80}})
// score 大于等于80
db.test_start.find({score: {$gte: 80}})
// score 小于等于80
db.test_start.find({score: {$lte: 80}})
// score 不等于80
db.test_start.find({score: {$nt: 80}})
- 跳过前面n条数据 (从0开始)
db.test_start.find().skip(n)
- 取前面n条数据
db.test_start.find().limit(n)
- 排序 1 升序
db.test_start.find().sort({key:1|-1})
- 模糊匹配
db.test_start.find({key: {$regex: "str"}})
或
db.test_start.find({key: /str/})
- 集合查询(分组查询)
db.test_start.aggregate({$group:{_id: '$contry', sumaa: {$sum: '$score'}}})
KOA
基础写法
/* ----------- KOA ----------- */
/* ----------- KOA ----------- */
const Koa = require('koa');
let server2 = new Koa();
server2.use((context, next) => {
context.body = 'koa ok'
// context.request.url
// context.request.method
// context.response.set()
// context.response.status = 200
// context.response.body = ""
})
server2.listen(9999, () => {
console.log('服务器启动在9999端口');
}
9集 73分