python mysql dictcursor使用实例

#!/usr/bin/python
# -*- coding: utf-8 -*-
import MySQLdb
import MySQLdb.cursors
import sys

#解决编译器运行，UnicodeEncodeError: 'ascii' codec can't encode characters in position
reload(sys)
sys.setdefaultencoding( "utf-8" )

db= MySQLdb.connect(host="localhost",port = 3306,user="root",passwd="root", db="test",charset='utf8')
cursor = db.cursor(MySQLdb.cursors.DictCursor)

sql = "select * from py_user"
try:
    cursor.execute(sql)
    results = cursor.fetchall()
    # print results
    for row in results:
        name = row['name']
       address = row['address']
     print "姓名：%s，地址：%s" %(name,address)
except:
    print "Error: unable to fecth data"

cursor.close()
# 关闭数据库连接
db.close()