Ppb2011 1

var mysql = require('mysql');
//
var http = require('http');
var url = require('url');

var server = http.createServer(function(req, res) {
query = decodeURIComponent(url.parse(req.url).pathname).split('/')[1];//получаем sql запрос
console.log(query);

//Если запрос состоит из строки 'kill', завершаем работу сервиса
if (query === 'kill') {
res.writeHead(200, {"Content-Type": "text/html; charset=UTF-8"});
res.end("<h1>Server кирдык<h1>");
server.close('');
req.connection.destroy('');
console.log("кирдык");
process.exit('');
return;
}

res.writeHead(200, {"Content-Type": "application/json; charset=UTF-8","Access-Control-Allow-Origin":"*",
"Access-Control-Allow-Headers":"Origin, X-Requested-With, Content-Type, Accept"});

var sql = query;
var connection = mysql.createConnection({
host: 'airs.ce5k6a6fvfk2.us-east-1.rds.amazonaws.com',
user: 'userairs',
password: 'userairs',
database : 'airs'
});
connection.connect();
//выполняемзапрос
connection.query(sql,
function(err, rows, fields) {
connection.end();
if (err)
{
console.log('Неверный запрос');
res.writeHead(200, {"Content-Type": "text/html; charset=UTF-8"});
res.end("<h1>Неверный запрос<h1>");
}
else
{
//формируемответ
author ={"autor":"is10-99", "script":"C:\\Dropbox\\edunet\\2014\\is10-99\\nodejsXmlServer\\coffee\\XmlServer.coffee", "versionOf":"2016-05-12", "/SQL":query};
vararr = [author, rows];
res.end(JSON.stringify(arr));
}
}
);

});

server.listen(8080);
console.log('Серверстартовалнапорту 8080')