1. 分页
- per_page:一页多少条数据
- page:第几页
// index.js
const Koa = require('koa')
const app = new Koa()
const Router = require('koa-router')
const usersRouter = new Router({ prefix: '/users'})
// MongoDB数据库User模型
const User = require('/models/users.js')
const bodyparser = require('koa-bodyparser')
app.use(bodyparser())
// 用户列表
usersRouter.get('/', (ctx) => {
// 分页 http://localhost:3000/users?page=2&per_page=3
const { per_page = 10 } = ctx.query
const page = Math.max(ctx.query.page * 1, 1) - 1
const perPage = Math.max(per_page * 1, 1)
ctx.body = await User.find().limit(perPage).skip(page * perPage)
})
app.use(usersRouter.routes())
app.use(usersRouter.allowedMethods())
app.listen(3000)
2. 模糊查询
MongoDB中实现模糊查询要使用正则表达式
// index.js
const Koa = require('koa')
const app = new Koa()
const Router = require('koa-router')
const users