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

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

默认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
原创粉丝点击