node.js创建http服务

var http = require(‘http’);//创建服务器的
var fs = require(‘fs’);

var Database_URL = ‘localhost’;
var mysql = require(‘mysql’);
var connection = mysql.createConnection({
host: Database_URL,
user: “root”,
password: “123456”,
database: “test”
});
connection.connect(function(err) {
if (err) throw err;
console.log(“Database Connected!”);
});

var sql1=‘select * from fz’;
connection.query(sql1,function(err,re) {
if(err){
console.log(“erro”);
return;
}
// console.log(re);
//创建服务
var myServer = http.createServer(function(req,res){

date1=JSON.stringify(re)
res.write(date1);
//结束写的操作
res.end();

});

//服务端等着客户端请求需要做一个监听。通过创建的服务。
//监听
myServer.listen(‘8080’,function(err){
if(err){
console.log(err);
throw err;
}
console.log(“服务器已开启。端口号为:8080”);
})

});

---

写数据库
var mqtt = require(‘mqtt’);
var Topic = ‘device/data’;
var Broker_URL = ‘mqtt://127.0.0.1:1883’;
var options = {
clientId: ‘SubMQTT’,
port: 1883,
username: ‘admin’,
password: ‘public’,
keepalive : 60
};
var client = mqtt.connect(Broker_URL, options);
client.on(‘connect’, function mqtt_sub() {
client.subscribe(Topic, {qos:0});
});
client.on(‘message’,function(top,message) {
//console.log(message.toString());
var data = JSON.parse(message.toString())
console.log("key : " + data.key)
console.log("units : " + data.units)
console.log("value : " + data.value)
console.log("ts : " + new Date())
insert_device(data)
});
var Database_URL = ‘192.168.148.129’;
var mysql = require(‘mysql’);
var connection = mysql.createConnection({
host: Database_URL,
user: “wxf”,
password: “123456”,
database: “test”
});
connection.connect(function(err) {
if (err) throw err;
console.log(“Database Connected!”);
});

function insert_device(data) {
var sql = “INSERT INTO ?? (??,??,??,??) VALUES (?,?,?,?)”;
var params = [‘device’, ‘key’, ‘units’, ‘value’, ‘ts’, data.key, data.units, data.value, new Date()];
sql = mysql.format(sql, params);
connection.query(sql, function (error, results) {
if (error) throw error;
console.log("Message stored to database: " + data.key);
});
};