express操作数据库

const express = require('express')
const app = express()
const mysql2 = require('mysql2')
app.get('/', async(req, res) => {
    const config = mysqlConfig()
    const promisePool = mysql2.createPool(config).promise()
    var users = await promisePool.query(`select * from student`)
    console.log(users[0]);
    res.send({
        ok: 1,
        data: users[0]
    })
})
app.listen(3001)
function mysqlConfig() {
    return {
        host: '127.0.0.1',
        port: 3306,
        user: 'root',
        password: '123',
        database: 'students',
        connectionLimit: 1
    }
}

koa操作数据库

const Koa = require('koa')
const mysql2 = require('mysql2')
const Router = require('koa-router')
const router = new Router()
const app = new Koa()
router.get('/', async(ctx) => {
    const config = mysqlConfig()
    const promisePool = mysql2.createPool(config).promise()
    var users = await promisePool.query(`select * from student`)
    console.log(users[0]);
    ctx.body = {
        ok: 1,
        data: users[0]
    }
})
app.use(router.routes()).use(router.allowedMethods())
app.listen(3001)
function mysqlConfig() {
    return {
        host: '127.0.0.1',
        port: 3306,
        user: 'root',
        password: '123',
        database: 'students',
        connectionLimit: 1
    }
}