#!/usr/bin/python
#coding=utf-8
import time
import Adafruit_DHT
from BMP180 import BMP180
import MySQLdb
import datetime
bmp = BMP180()
sensor = Adafruit_DHT.DHT22
pin = 17
conn= MySQLdb.connect(host='localhost',port = 3306,user='root',passwd='*******',db ='tem')
cur = conn.cursor()
while True:
	temp = bmp.read_temperature()
	pressure = bmp.read_pressure()
	altitude = bmp.read_altitude()
	# temp = 0
	# pressure = 0
	# altitude = 0
	humidity, temperature = Adafruit_DHT.read_retry(sensor, pin)
	print humidity, temperature
	if humidity is not None and temperature is not None:
		data={"temp":round(temperature,2),"hum":round(humidity,2),"alt":round(altitude,2),"pre":round((pressure / 100.0),2)}
		print(data)
		created_at=time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time()))
		sqli="insert into env_data (`u_id`,`temp`,`hum`,`alt`,`pre`,`created_at`)values(%s,%s,%s,%s,%s,%s)"
		aa=cur.execute(sqli,("1",round(temperature,2),round(humidity,2),round(altitude,2),round((pressure / 100.0),2),created_at))
		print aa
	conn.commit()
	time.sleep(10)
cur.close()
conn.close()
 
 
 
前台搭配echarts展示或做数据分析 非常完美