python连接mysql数据库

def get_data_failed(request):
# print "访问get_data_by"
city_name =request.GET.get('city_name')
client = request.GET.get('client')
versions = request.GET.get('versions')
event_day1 = request.GET.get('event_day1')
event_day2 = request.GET.get('event_day2')


# event_day1 = event_day1.replace("-","")
# event_day2 = event_day2.replace("-","")
# print "第47行",
# print event_day1,event_day2
try:
db = MySQLdb.connect(
host="100.90.112.17",
user="root",
passwd="123456",
db="hawaii",
charset='utf8',
port=8000
)
cur = db.cursor()
exesql = sql_faile.replace('{date1}',event_day1).replace('{date2}',event_day2).replace('{client}',client).replace('{versions}',versions).replace('{city_name}',city_name)
# print "第61行",
# print exesql
cur.execute(exesql)
results = cur.fetchall()
# print results
db.close()
except Exception as ex:
print ex
order_info_list = []
# print exesql
for row in results:
# print row
order_info = {}
order_info["event_day"] = row[1]
order_info["city_name"] = row[2]
order_info["driver_app_type"] = row[3]
order_info["driver_appversion"] = row[4]
order_info["maptype"] = row[5]
order_info["navi_begin_order_num"] = row[6]
order_info["navi_success_order_num"] = row[7]
order_info["open_failed_rate"] = row[8]
order_info["devi_begin_order_num"] = row[9]
order_info["devi_success_order_num"] = row[10]
order_info["devi_failed_rate"] = row[11]
order_info["unique_open_failed_rate"] = row[14]
order_info_list.append(order_info)
# print "第94行",
# print order_info_list  
return HttpResponse(simplejson.dumps(order_info_list), content_type="application/json")