简单的新手问题,我开始使用nodejs,而且我对一般的后端语言也很陌生. 我设法使用express-js中的默认jade引擎将单个字段从数据库发布到网页. /** * Module dependencies. */var express = require('expres
我设法使用express-js中的默认jade引擎将单个字段从数据库发布到网页.
/** * Module dependencies. */ var express = require('express'); var app = module.exports = express.createServer(); var sqlResult; //MySql var mysqlClient = require('mysql').Client, newClient = new mysqlClient(), Database = 'test', Table = 'test_table'; newClient.user ='root'; newClient.password='password'; newClient.connect(console.log('connected to the database.')); newClient.query('USE '+Database); newClient.query( 'SELECT * FROM '+Table, function selectCb(err, results, fields) { if (err) { throw err; } sqlResult = results[0]; console.log(sqlResult['text'], sqlResult['title']); } ); // Configuration app.configure(function(){ app.set('views', __dirname + '/views'); app.set('view engine', 'jade'); app.use(express.bodyParser()); app.use(express.methodOverride()); app.use(express.cookieParser()); app.use(express.session({ secret: 'your secret here' })); app.use(app.router); app.use(express.static(__dirname + '/public')); }); app.configure('development', function(){ app.use(express.errorHandler({ dumpExceptions: true, showStack: true })); }); app.configure('production', function(){ app.use(express.errorHandler()); }); // Routes app.get('/', function(req, res){ res.render('index', { title: sqlResult['title'] }); }); app.listen(3000); console.log("Express server listening on port %d in %s mode", app.address().port, app.settings.env);
我的问题是,如何显示由MySQL查询检索的所有元素的列表?
谢谢 :)
像这样.结果是一个数组,所以你必须循环它for (var i in results){ var sqlResult = results[i]; console.log(sqlResult['text'], sqlResult['title']); }