本人菜鸟一枚,请大神请教如何把数据库中查询的值返回给前端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();
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();
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();