#!/usr/bin/env python#-*- coding: utf-8 -*-import httplibimport jsonimport MySQLdb#從數據庫中獲取access_tokenaccess_token=""try:    conn=MySQLdb.connect(host='192.168.1.1',user='root',passwd='root',db='db_weixin',port=3306)    cur=conn.cursor()    cur.execute('select access_token from weixin_public')    result=cur.fetchone()    #PRint result    #print result[0]    access_token=result[0]    cur.close()    conn.close()except MySQLdb.Error,e:    print "Mysql Error %d: %s" % (e.args[0], e.args[1])    #根據接口推送消息    if not access_token is None:    conn = httplib.HTTPConnection("api.weixin.QQ.com:80")#微信接口鏈接    headers = {"Content-type":"application/json"} #application/x-www-form-urlencoded    params = ({'touser' : "oEGZ4johnKOtayJbnEVeuaZr6zQ0",#用戶openid    'template_id' : 'AtFuydv8k_15UGZuFntaBzJRCsHCkjNm1dcWD3A-11Y',#Word1" : {"value" : "訪問時間 2015-04-05 15:30:59 訪問ip 192.168.1.2", "color" : "#173177"},        "keyword2" : {"value" : "訪問鏈接 http://www.710.so", "color" : "#173177"},        "remark" : {"value" : "訪問頻率 10/s", "color" : "#173177"}        }    }    )    conn.request("POST", "/cgi-bin/message/template/send?access_token="+access_token, json.JSONEncoder().encode(params), headers)#推送消息請求    response = conn.getresponse()    data = response.read()#推送返回數據    if response.status == 200:        print 'success'        print data    else:        print 'fail'    conn.close()