koa2练手demo，node

const router = require('koa-router')() const packet = require("../utils/db"); router.get('/', async (ctx, next) => { await ctx.render('index', { title: 'Hello Koa 2!' }) }) router.get('/string', async (ctx, next) => { let body = `<p style="color:red">koa2 这是一个路由测试页面</p><img style="width:300px" src="./images/dsBuffer.png" alt="">` let title = '你好模板引擎，我是一个标题' // 需要给模板引擎传递变量参数，指定第二个参数是一个对象 await ctx.render('test', { title, body }) }) router.get('/json', async (ctx, next) => { console.log(ctx) let query=JSON.stringify(ctx.request.query) console.log(query) ctx.body = query }) router.post('/testQueryById', async (ctx, next) => { // ctx.request.body const body = ctx.request.body let id=body.id let slect = `select * from user where id='${id}'`; let res=await packet.packet(slect); console.log('ctx:', res) ctx.body = res }) router.post('/testAdd', async (ctx, next) => { const body = ctx.request.body const {v4: v4} = require('uuid'); let uuid = v4().replace(/\-/g, ''); let selects=`insert into user(id,name,age,sex) values('${uuid}','${body.name}','${body.age}','${body.sex}')`; let res=await packet.packet(selects); ctx.body = res }) router.post('/testEdit', async (ctx, next) => { const body = ctx.request.body let sql='' if(body.name){ sql+=`name='${body.name}'` } if(body.age!=undefined){ sql+=`age='${body.age}'` } if(body.sex!=undefined){ sql+=`sex='${body.sex}'` } console.log(body) let selects=`update user set ${sql} where id='${body.id}'`; let res=await packet.packet(selects); ctx.body = res }) router.post('/testDelete', async (ctx, next) => { const body = ctx.request.body let selects=`delete from user where id='${body.id}'`; let res=await packet.packet(selects); ctx.body = res }) router.get('/testList', async (ctx, next) => { const body = ctx.request.body let selects=`select * from user`; let res=await packet.packet(selects); console.log("s->"+res) ctx.body = res }) module.exports = router