[Python] 纯文本查看 复制代码
#!/usr/bin/python
import cgi, os
import commands
#设置输出格式为网页
print """\
Content-Type: text/html\n
"""
#读取get或post参数
form = cgi.FieldStorage()
# Get cmd string here.
cmdstring = form['cmd']
#print cmdstring.value
#form.has_key("cmd")
#实行openwrt(linux命令)
(status, output) = commands.getstatusoutput(cmdstring.value)
#print status
print output
[Python] 纯文本查看 复制代码
#!/usr/bin/python
import cgi, os
import urllib
#生成数据
data = {}
data['date']='2012-04-15'
url_values=urllib.urlencode(data)
#设置天气网址
url='http://qdqx.qingdao.gov.cn/zdz/data.aspx'
full_url=url+'?'+url_values
#Get请求
response=urllib.urlopen(full_url)
result=response.read()
#写入到文本
f = open("text.txt",'wb')
f.write(result)
f.close()
#设置输出格式为网页
print """\
Content-Type: text/html\n
"""
print result
[Python] 纯文本查看 复制代码
#获取mysql数据
def SelectWorklist():
try:
#连接数据库
conn=MySQLdb.connect(host='192.168.1.1',user='root',passwd='znck007',port=3306)
cur=conn.cursor()
conn.select_db('znckapi')#选择数据库名
count=cur.execute('SELECT * FROM api_worklist WHERE status=0 ORDER BY id DESC LIMIT 0,1') #最后1条
#print "count="+str(count)
repost=""
results=cur.fetchall()
if results :
for r in results:
#print str(r[0])+str(r[1])+str(r[2])+str(r[3])+str(r[4])+str(r[5])+str(r[6])
value0="%03d" % int(r[3].strip()) #转成00x格式
value1="%03d" % int(r[4].strip()) #转成00x格式
#更新调用次数，用来判断设备是否
cur.execute('UPDATE api_worklist SET num=num+1 where sid=%s and nid=%s and status=0',snvalue)
conn.commit()#提交
cur.close()#关闭
conn.close()#关闭
return repost
except MySQLdb.Error,e:
print "Mysql Error %d: %s" % (e.args[0], e.args[1])
except:
print "SelectWorklist except..."
return ""
#添加数据到mysql
def InsertWorklist(value):
try:
#连接数据库
conn=MySQLdb.connect(host='192.168.1.1',user='root',passwd='znck007',port=3306)
cur=conn.cursor()
conn.select_db('znckapi')#选择数据库名
now=time.strftime('%Y-%m-%d %H:%M:%S')#当前时间
value0="%03d" % int(value[0].strip()) #转成00x格式
value1="%03d" % int(value[1].strip()) #转成00x格式
snvalue=[value0,value1]
cur.execute('DELETE FROM api_worklist where type=2 and sid=%s and nid=%s and status>0',snvalue) #删除相同数据
invalue=[2,0,value0,value1,value[2],"upload data",1,now,"192.168.1.1",0]
cur.execute('INSERT INTO api_worklist(type,uid,sid,nid,data,note,status,time,ip,num) VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)',invalue) #插入数据
#更新执行成功{ck00x00xupdate}格式
if( value[2]=='update' ):
cur.execute('UPDATE api_worklist SET status=1 where sid=%s and nid=%s',snvalue)
conn.commit()#提交
cur.close()#关闭
conn.close()#关闭
except MySQLdb.Error,e:
print "Mysql Error %d: %s" % (e.args[0], e.args[1])
WriteLog(logpath,"Mysql Error %d: %s" % (e.args[0], e.args[1])) #写日志
except:
print "InsertWorklist except..."
return ""
[Python] 纯文本查看 复制代码
ser = serial.Serial('/dev/ttyUSB0', 115200, timeout=1) #打开串口通信
#ser.write("lABC") #向串口发送字符
while True:
try:
data=ser.readline() #读取一行 读取1个字符read(1)
if data!="" :
#print "serial data <<<"+data
continue
except Exception,e:
print "except Error %s" % (e)
time.sleep(1)
ser.close()
赞一个!赞一个!赞一个!
