我来自一种非常“功能性”的编程风格(PHP,Lua,C),现在正在尝试将我的思维转换为NodeJS使用的MVC模型。目前,这对我来说是一个非常陡峭的学习曲线。
我一直在努力让一个简单的MySQL数组在Jade中打印出来,但一直遇到困难。
app.js
/**
* Module dependencies.
*/
var express = require('express')
, routes = require('./routes')
, user = require('./routes/user')
, http = require('http')
, path = require('path')
, mysql = require('mysql');
var app = express();
// all environments
app.set('port', process.env.PORT || 3000);
app.set('views', __dirname + '/views');
app.set('view engine', 'jade');
app.use(express.favicon());
app.use(express.logger('dev'));
app.use(express.bodyParser());
app.use(express.methodOverride());
app.use(app.router);
app.use(express.static(path.join(__dirname, 'public')));
// development only
if ('development' == app.get('env')) {
app.use(express.errorHandler());
}
app.get('/', routes.index);
app.get('/users', user.list);
//MySQL
var sqlInfo = {
host: '12.34.56.78',
user: 'user',
password: 'pass',
database: 'user'
}
var client = mysql.createConnection(sqlInfo);
client.connect();
client.query( "SELECT * FROM list ORDER BY status ASC LIMIT 25", function(err, row, fields){
if (err) throw err;
else {
var applications = row;
app.render("applications", applications, function(err, html){});
}
});
client.end();
http.createServer(app).listen(app.get('port'), function(){
console.log('Express server listening on port ' + app.get('port'));
});
index.jade
extends layout
block content
div.container
div.content
- if (typeof(applications) !== 'undefined')
ul
- each app in data
li= app.status
- else
p Blank slate mate...
div.footer
我认为我的问题源于app.render/res.render函数……这个函数的概念并没有真正地理解,我一直无法使其像我在许多其他MySQL + NodeJS示例中看到的那样工作。
如果有任何提示或建议,将不胜感激!