让python的mysqldb返回的结果集为字典类型

来源：互联网发布：按键精灵数组直接赋值编辑：程序博客网时间：2024/06/16 06:13

默认mysqldb返回的是元组，这样对使用者不太友好，也不利于维护
下面是解决方法

import MySQLdbimport   MySQLdb . cursors conn = MySQLdb . Connect (    host = ' localhost ' , user = ' root ' ,    passwd = '' , db = ' test ' , compress = 1 ,    cursorclass = MySQLdb . cursors . DictCursor )   # <- importantcursor = conn . cursor ()cursor . execute ( " SELECT name, sometext txt FROM foo " )rows = cursor . fetchall ()cursor . close ()conn . close () for   row in rows :    print   row [ ' name ' ] , row [ ' txt ' ] # bingo! # another (even better) way is: conn = MySQLdb . Connect (    host = ' localhost ' , user = ' root ' ,    passwd = '' , db = ' test ' , compress = 1 )cursor = conn . cursor ( cursorclass = MySQLdb . cursors . DictCursor )# ...# results by field namecursor = conn . cursor ()# ...# ...results by field number

http://blog.csdn.net/suofiya2008/article/details/5690506

0 0