node+koa链接mysql

const Koa = require('koa');
const KoaStaticCache = require('koa-static-cache');
const KoaRouter = require('koa-router');
const mysql = require('mysql2');
const koacors = require('koa-cors')
const KoaBody = require('koa-body');


// 链接数据库
const connection = mysql.createConnection({ 
    host: 'sqlIp',
    user: 'kkbBase',
    password: 'hyt0617',
    database: 'kkb'
}, () => { 
    console.log('mysql连接成功');
});


const app = new Koa();

/** * 静态资源代理 * KoaStaticCache 中间件 */
app.use(KoaStaticCache({ 
    prefix: '/public',
    dir: './public',
    dynamic: true,
    gzip: true
}));


/** * 动态访问 */
const router = new KoaRouter();

router.get('/register', async ctx => { 
    let users = await query(
        "SELECT * FROM `users`"
    );
    ctx.body = users;
})

app.use(koacors());//允许跨域
app.use(router.routes());
app.listen(8888, () => { 
    console.log('服务器启动成功 http://localhost:8888');
});
function query(sql, prepared) { 
    return new Promise((resolve, reject) => { 
        connection.query(
            sql,
            prepared,
            function (err, results, fields) { 
                if (err) { 
                    reject(err);
                } else { 
                    resolve(results);
                }
            }
        );
    })
}

本文地址：https://blog.csdn.net/qq_43604182/article/details/111983354