koa使用mysql的简单dome

const mysql = require("mysql");
const co = require("co-mysql");
let conn = mysql.createPool({
    host: "localhost",
    user: "root",
    password: "root",
    database: "20200329",
})
let dp = co(conn);
//全局添加到app里面 
app.context.dp = dp;
app.use(async ctx => {
    let data = await ctx.dp.query(`select * from user_table where id<5`);
    console.log(data)
})