可以參考菜鳥教程：
http://www.runoob.com/nodejs/nodejs-mysql.html
注意nodejs的數據庫操作是異步的，以用戶登錄為例：
UserDAO.js
~~~
var mysql = require('mysql');
class UserDAO
{
queryUser(name, pwd, cb1, cb2)
{
let connection = mysql.createConnection({
host : 'localhost',
user : 'root',
password : 'root',
port: '3306',
database: 'test',
});
connection.connect();
let sql = "SELECT * FROM userinfo where name =? and pwd = ?";
let addSqlParams = [name, pwd];
connection.query(sql,addSqlParams,function (err, result) {
if(result!='undefined' && result.length!=0)
{
cb1();
}
else
{
cb2();
}
});
connection.end();
}
}
module.exports=UserDAO;
~~~
user.js
~~~
router.post('/login', function(req, res, next) {
let username = req.body.username;
let pwd = req.body.pwd;
var userdao = new UserDAO();
userdao.queryUser(username, pwd, function(){
let u = new userinfo(username, pwd);
//保存session
req.session.account = u;
//設置cookie
res.cookie("account", u, {maxAge: 60000});
res.json(u);
},function(){
res.send("用戶不存在");
});
});
~~~
