Nodejs之HTTP、WEBSOCKET及使用MYSQL

//服务器篇server.js

var express = require('express');
var app = express()
var server = require('http').createServer(app);
var io = require('socket.io')(server);


//以下是用来解析post中的body。
var bodyParser = require('body-parser');
var multer = require('multer'); 

app.use(bodyParser.json()); // for parsing application/json
app.use(bodyParser.urlencoded({ extended: true })); // for parsing application/x-www-form-urlencoded
app.use(multer()); // for parsing multipart/form-data
//end


//HTTP方式访问
//Express 提供了内置的中间件 express.static 来设置静态文件如：图片， CSS, JavaScript 等。
app.use(express.static(__dirname +'/public'));//将在server.js同级的public目录下寻找
//app.get('/:::', function(req, res){...//那么在浏览器就要这么输入localhost:9999/:::?user=111
//app.get('/hello/:name/:tel', function(req, res){...//那么在浏览器就要这么输入localhost:9999/hello/fred/1111

//name和tel存在req的params中

//get ?的参数存在req的query中

//post的数据存在req的body中

//app.get('/a.html', function(req, res){...//那么在浏览器就要这么输入localhost:9999/a.html?user=111，但是如果在public中有a.html那么get和post都不会被触发
app.get('/b.html', function(req, res){
    console.log('get')
    var user_name=req.query.user; 
    res.send('<h1>Welcome Realtime Server'+user_name+'</h1>');
});
// app.post('/a.html',function(req,res){ 
    // var user_name=req.body.user; 
    // var password=req.body.password; 
    // console.log("User name = "+user_name+", password is "+password); 
    // res.send("yes");
// }); 
// app.error(function(err, req, res, next){
    // if (err instanceof NotFound) {
// res.render('404.jade');
    // } else {
// next(err);
    // }
// });
io.on('connection',
    function(socket){ 
    	console.log('a user connected'); 
    	socket.emit('connected','你连上我了')
    }
);
server.listen(9999,function(){ 
    console.log('listening on 9999')
});

//Mysql篇

//使用连接池

var mysql = require('mysql');

var pool = mysql.createPool({
connectionLimit : 10,
host : 'localhost',
user : 'root',
password : '123456',
database : 'db_user'
});


pool.query(
{
sql : 'select * from t_user where t_user.username=? and t_user.password=?',
values : ['aaaaaa','123123']
}
,function(err,rows,keys){
for (var row of rows) {
var result = '';
for(var key of keys){
result += ('' + row[key.name]);
}
console.log(result);
}
});

//不使用连接池

var mysql = require('mysql');

var contennection = mysql.createConnection({
host : 'localhost',
user : 'root',
password : '123456',
database : 'db_user'
});

contennection.connect();

contennection.query('select * from t_user'
,function(err,rows,keys){
for (var row of rows) {
var result = '';
for(var key of keys){
result += ('' + row[key.name]);
}
console.log(result);
}
});
contennection.end();

将js中的对象、数组转成json

JSON.stringify(t)

express中文api文档：http://www.expressjs.com.cn/4x/api.html#app.use