node. JS development----NODEJS Operation MySQL

App.js
[HTML] View plain copy
Initialize Package
var express = require (' Express ');
var path = require (' path ');
var favicon = require (' Serve-favicon ');
var logger = require (' Morgan ');
var cookieparser = require (' Cookie-parser ');
var bodyparser = require (' Body-parser ');
var mysql = require ("MySQL");
var jade = require (' Jade ');
var routes = require ('./routes/index ');

var app = Express ();

Loading engine templates
App.set (' View engine ', ' Jade ');
App.set (' Views ', Path.join (__dirname, ' views '));

Invoke tool
App.use (Logger (' dev '));
App.use (Bodyparser.json ());
App.use (bodyparser.urlencoded ({extended:false}));
App.use (Cookieparser ());
App.use (Express.static (Path.join (__dirname, ' public '));

Routes (app);

Catch 404 and forward to error handler
App.use (function (req, res, next) {
var err = new Error (' not Found ');
Err.status = 404;
Next (ERR);
});

would print StackTrace
if (App.get (' env ') = = = ' Development ') {
App.use (function (err, req, res, next) {
Res.status (Err.status | | 500);
Res.render (' Error ', {
Message:err.message,
Error:err
});
});
}

No stacktraces leaked to users
App.use (function (err, req, res, next) {
Res.status (Err.status | | 500);
Res.render (' Error ', {
Message:err.message,
Error: {}
});
});

App.listen (3000);

[HTML] View plain copy on code to see a snippet derived from my Code slice
var user = require (". /models/user.js ");

Module.exports = function (APP) {
App.post ('/updateusers ', function (req, res, next) {
User.updateusers ({
sql: "Update user SET username=?,password=?,age=?,info=?") WHERE id =? ",
params: [Req.body.username, Req.body.password, Req.body.age, Req.body.info, Req.body.id]
}, fun Ction (data) {
Res.send (data);
});
});

App.post ('/deleteusers ', function (req, res, next) {
User.deleteusers ({
sql: "DELETE from user WHERE I D = "+ req.body.id
}, function (data) {
Res.send (data);
});
});

App.post ('/addusers ', function (req, res, next) {
User.addusers ({
data: {
Username:req.body.user Name,
Password:req.body.password,
Age:req.body.age,
Info:req.body.info
},
sql: "INSERT into US Er SET? "
}, function (data) {
Res.send (data);
});
});
};

Node. JS development----NODEJS Operation MySQL