#!/usr/bin/env python
# _*_ coding:utf-8 _*_
import MySQLdb
import sys
str = raw_input("please input error code:")
conn = MySQLdb.connect(host='127.0.0.1', user='root', passwd='123456', db='error_code',charset='utf8')
cur = conn.cursor()
sql ="select * from error_message where code = " + "'" + str + "'"
cur.execute(sql)
data=cur.fetchall()
print "分类:"+data[0][0].encode("UTF-8"),"错误码:"+data[0][1].encode("UTF-8"),"错误描述:"+data[0][2].encode("UTF-8"),"相关业务方:"+data[0][3].encode("UTF-8")
cur.close()
conn.close()
主要有两点如下:
1、在连接数据库时要指定编码类型,如果不指定,将会报如下错误,就算第二步编码了也会出问题。
charset='utf8'
2、在输出数据的时候需要编码:data[0][0].encode("UTF-8"),如果不编码则会报错:
UnicodeDecodeError: 'ascii' codec can't decode byte 0xe5 in position 0: ordinal not in range(128)