连接mysql
先看连接部分
const koa = require('koa')
const Router = require('koa-router')
let router = new Router()
let server = new koa()
server.listen(8080)
server.context.db = require('./libs/databases')
router.get('/a', async ctx => {
try {
let data = await ctx.db.query('SELECT * FROM user')
ctx.body = data
} catch (e) {
ctx.body = '数据库出错'
}
});
server.use(router.routes())
再看数据库信息配置
const co = require('co-mysql')
const mysql = require('mysql')
let conn = mysql.createPool({
host: 'localhost',
user: 'root',
password: '*** ***',
database: 'koademo'
})
module.exports = co(conn)