87,904
社区成员
发帖
与我相关
我的任务
分享
var express = require('express');
var app = express();
//连接数据库
var mysql = require('mysql');
//配置模块
var settings = require('./settings');
//连接数据库
var connection = mysql.createConnection(settings.db);
connection.connect();
//查询
var selectSQL = 'select * from `mytable`';
//执行SQL,自行替换参数测试
app.set("view engine", 'ejs');
app.set('views',__dirname + '/views');
connection.query(selectSQL, function(err, rows) {
if (err) throw err;
console.log(rows);
});
//关闭连接
connection.end();
app.listen(3000);
var settings={};
settings.db={
host: 'localhost',
user: 'root',
password: 'xxxx',
database:'test'
}
module.exports=settings;
http.createServer(function(req, res){
connection.query(selectSQL, function(err, rows) {
if (err) throw err;
res.writeHead(200,{'Content-Type' : 'text/html'});
res.write(rows);
res.end();
});
看了然后把内容改成这样 输出不了~~是什么问题呢?