nodejsは簡単なインターフェースを実現します。
1493 ワード
var http = require('http');
var mysql = require('mysql');
var connection = mysql.createConnection({
host : 'rm-bp1w72suk8pc5h6mk.mysql.rds.aliyuncs.com',
user : 'r85u40z94p',
password : 'Mafeng11',
database: 'r85u40z94p'
});
// mysql
connection.connect();
var server = http.createServer(function (req, res) {
// GET http://127.0.0.1:9000/test
var url_info = require('url').parse(req.url, true);
// /test request
if(url_info.pathname === '/test'){
res.writeHead(200, {'Content-Type': 'text/plain'});
connection.query('SELECT * FROM `r85u40z94p`.`user` order by rand() LIMIT 5',function(err,rows,fields){
//
// res.end(rows.constructor);
//
res.end(JSON.stringify(rows));
console.log(rows.constructor);
console.log(typeof(rows));
res.end(rows.join);
console.log(err);
console.log(fields);
});
}
// post , post 。 , 。
else{
req.pipe(res);
}
});
server.listen(9000, '127.0.0.1');
// server mysql
server.on('close',function(){
connection.end();
});
console.log('listening on port 9000');