[問題] Node如何把MySQL查詢結果存到var再render
route.js:
-------------------------------------------------
var express = require('express');
var mysql = require('mysql');
var router = express.Router();
var connection = mysql.createConnection({
host: 'localhost',
user: 'root',
password: '********',
database: 'MyDatabase'
});
router.get('/', function (req, res) {
var sql = 'SELECT * FROM MyTable;';
connection.query(sql, function (err, rows) {
if (err)
console.log(err);
res.render('index', {
title: 'Index',
model: rows
});
});
});
module.exports = router;
------------------------------------------------
我想問有沒有辦法把query的結果存到一個var result;
試過這樣做但是非同步還沒查好下一行程式就繼續了
目的只想把route.js作純粹的路由
但因為要等查詢完成再render
route.js和db.js程式碼就必須混在一起
沒辦法做到關注點分離
請教各位,謝謝!
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 120.105.116.41
※ 文章網址: https://www.ptt.cc/bbs/Ajax/M.1459322011.A.EB6.html
※ 編輯: amazing2014 (120.105.116.41), 03/30/2016 15:14:05
→
03/30 18:06, , 1F
03/30 18:06, 1F
→
03/30 18:06, , 2F
03/30 18:06, 2F
→
03/30 18:13, , 3F
03/30 18:13, 3F
→
03/30 18:34, , 4F
03/30 18:34, 4F
推
03/30 22:58, , 5F
03/30 22:58, 5F
→
03/30 22:58, , 6F
03/30 22:58, 6F
→
03/30 22:58, , 7F
03/30 22:58, 7F
→
03/30 22:58, , 8F
03/30 22:58, 8F
→
03/31 18:24, , 9F
03/31 18:24, 9F