def checkstatus(request):
# print sae.const.MYSQL_HOST
# print sae.const.MYSQL_PORT
print request
mac_addr = request.GET.get('mac')
status = request.GET.get('status')
print status
print mac_addr
conn = MySQLdb.connect(host=sae.const.MYSQL_HOST, user=sae.const.MYSQL_USER, passwd=sae.const.MYSQL_PASS,db=sae.const.MYSQL_DB ,port=int(sae.const.MYSQL_PORT) );
# cursor = conn.cursor()
cursor = conn.cursor(cursorclass = MySQLdb.cursors.DictCursor)
querycmd="SELECT * FROM `device_status` where `mac_addr` = ";
# querycmd="SELECT * FROM `device_status` where `mac_addr` = ";
querycmd=querycmd+" '"+mac_addr+"'"
#count = cursor.execute('SELECT * FROM `device_status` where `mac_addr` = '%s'' % mac_addr )
count = cursor.execute(querycmd)
print "记录数",count
#获取一条记录,每条记录做为一个元组返回
result = cursor.fetchall();
print result
print type(result)
print dir(result)
print "lenth = %s" %len(result)
for r in result:
print r
print r.values()
print r.items()
# for rr in r:
# print "zhanwei"
# print rr
myjson = json.dumps(result)
print myjson
#print 'ID: %s info: %s' % (result[0],result[1])
# print 'ID: %s info: %s' % result
conn.close()
#return render_to_response('download.html', {"filenames":"123"})
data = {"a": "a"}
# return HttpResponse(simplejson.dumps(myjosn, ensure_ascii=False))
return HttpResponse(myjson) ;
# print sae.const.MYSQL_HOST
# print sae.const.MYSQL_PORT
print request
mac_addr = request.GET.get('mac')
status = request.GET.get('status')
print status
print mac_addr
conn = MySQLdb.connect(host=sae.const.MYSQL_HOST, user=sae.const.MYSQL_USER, passwd=sae.const.MYSQL_PASS,db=sae.const.MYSQL_DB ,port=int(sae.const.MYSQL_PORT) );
# cursor = conn.cursor()
cursor = conn.cursor(cursorclass = MySQLdb.cursors.DictCursor)
querycmd="SELECT * FROM `device_status` where `mac_addr` = ";
# querycmd="SELECT * FROM `device_status` where `mac_addr` = ";
querycmd=querycmd+" '"+mac_addr+"'"
#count = cursor.execute('SELECT * FROM `device_status` where `mac_addr` = '%s'' % mac_addr )
count = cursor.execute(querycmd)
print "记录数",count
#获取一条记录,每条记录做为一个元组返回
result = cursor.fetchall();
print result
print type(result)
print dir(result)
print "lenth = %s" %len(result)
for r in result:
print r
print r.values()
print r.items()
# for rr in r:
# print "zhanwei"
# print rr
myjson = json.dumps(result)
print myjson
#print 'ID: %s info: %s' % (result[0],result[1])
# print 'ID: %s info: %s' % result
conn.close()
#return render_to_response('download.html', {"filenames":"123"})
data = {"a": "a"}
# return HttpResponse(simplejson.dumps(myjosn, ensure_ascii=False))
return HttpResponse(myjson) ;