//服务器篇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