node.js中koa框架对mysql数据库操作

[qq_39833115]

本人菜鸟一枚，请大神请教如何把数据库中查询的值返回给前端

var mysql = require('mysql');
var connection = mysql.createConnection({
host: 'localhost',
user: 'root',
password: '123456',
port: '3306',
database: 'test',
});

connection.connect();

var sql = 'SELECT * FROM runoob_tbl';
//查
connection.query(sql, function (err, result) {
if (err) {
console.log('[SELECT ERROR] - ', err.message);
return;
}
console.log(result);
//怎么把这个result通过ctx传给前端

});


module.exports = ctx => {


ctx.state.data = result

}

connection.end();

[讨厌走开啦]

启动一个server，定义一个接口，详细请看这里：https://blog.csdn.net/lqlqlq007/article/details/52430332

[風灬雲]

var mysql = require('mysql');
var connection = mysql.createConnection({
host: 'localhost',
user: 'root',
password: '123456',
port: '3306',
database: 'test',
});

connection.connect();


module.exports = async (ctx, next) => {
// 通过 Koa 中间件进行登录之后
// 登录信息会被存储到 ctx.state.$wxInfo
// 具体查看：
let getData = () => {
return new Promise((resolve, reject) => {
var sql = 'SELECT * FROM runoob_tbl';
//查
connection.query(sql, function (err, result) {
if (error) throw error;
resolve(results)
//怎么把这个result通过ctx传给前端
});
})
}
ctx.state.data = await getData()
}
connection.end();