将获取到的温湿度和其他信息通过微博发布
代码地址：https://github.com/klren0312/stm32_wifi
2017.4.12
微博发送信息
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
