一键发布消息到多个微博的服务器,搭建简易的物联网服务端和客户端-微博发送信息（十五）...

微博发送信息

1.配置数据库

var mysql = require('mysql');

//数据库配置

var conn = mysql.createConnection({

host:'localhost',

user:'root',

password:'root',

database:'nodemysql',

port:3306

});

//连接数据库

conn.connect();

2.微博发送

从数据库中获取到最新的传感器信息,然后通过微博发送

conn.query('SELECT * FROM pet',function(err,rows,fields){

var indoor;

if (rows[rows.length-1].indoor == 1) {

indoor = "on the home";

}else{

indoor = "not on the home";

}

//组成信息字符串

var tem = " temperature:" + rows[rows.length-1].tem +"'C || Pet:"+indoor

+" || humidity:"+ rows[rows.length-1].hum + "% || by ZZES_IOT";

//微博发送json

var para = {

"access_token":"2.00IlvKmF05EX2B7c5e17d246vKldGE",

"status":tem

}

//微博发送

Weibo.Statuses.update(para,function(data){

console.log(data);

})

})

3.现象结果

(1)后台打印的log

QQ截图20170412082224.png

(2)微博效果

QQ截图20170412083821.png

@治电小白菜20170412