Nodejs Perfect example for post & get

"use strict";

var http = require('http'),

express = require('express'),

mysql = require('mysql'),

parser = require('body-parser'),

dateTime = require('node-datetime');

var dts = dateTime.create();

var formatteddate = dts.format('Y/m/d');

// Database Connection

var connection = mysql.createConnection({

host : 'XXXXXXXXXX',

user : 'XXXXXXXXXX',

password : 'XXXXXXXXXX',

database : 'XXXX',

multipleStatements: true

});

try {

connection.connect();

} catch(e) {

console.log('Database Connetion failed:' + e);

}

var app = express();

app.use(parser.json());

app.use(parser.urlencoded({ extended: true }));

app.set('port', process.env.PORT || 8080);

app.get('/',function(req,res){

res.send("ref. Administrator");

});

app.get('/data',function(req,res){

    connection.query("SELECT count(user_id) as cnt from u_master where status=1", function (error, rows) {

if(error) {

        res.json({"Error" : true, "Message" : "Error executing MySQL query"});

} else {

        res.json({"Error" : false, "Message" : "Success ", "Login" : rows});

}

    });

});

app.get('/branchlist',function(req,res){

connection.query("SELECT * from b_master where status=1 order by branch_name asc", function (error, rows) {

        if(error) {

res.json({"status" : "error","bCount":rows.length,"blist":"There is no fresh data"});

} else {

res.json({"status" : "ok", "bCount":rows.length,"blist":rows});

}

    });

});

app.post('/login', function (req,res) {

    var response = [];

    if (typeof req.body.username !== 'undefined') {

        var name = req.body.username;

res.json(name);

    } else {

        response.push({'result' : 'error', 'msg' : 'Please fill required details'});

        res.setHeader('Content-Type', 'application/json');

    res.status(200).send(JSON.stringify(response));

    }

});

http.createServer(app).listen(app.get('port'), function(){

    console.log('Server listening on port ' + app.get('port'));

});