你想直接用MySQLdb?
import MySQLdb
import MySQLdb.cursors
db = MySQLdb.connect(host = 'localhost', user = 'root', passwd = '123456', db = 'test',cursorclass = MySQLdb.cursors.DictCursor)
cursor = db.cursor()
cursor.execute('select * from user')
rs = cursor.fetchall()
#结果
# ({'name': "cloud", 'cash': 1000L}, {'name': "luce", 'cash': 2000L}, ...)
#也可以这样
db = MySQLdb.connect(host = 'localhost', user = 'root', passwd = '123456', db = 'test')
cursor = conn.cursor(cursorclass = MySQLdb.cursors.DictCursor)
#具体的指南
http://mysql-python.sourceforge.net/MySQLdb.html