搭建简易的物联网服务端和客户端-微博发送信息(十五)

42 阅读1分钟

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