擅长:python、mysql、java
<p>不需要指定“硬编码”键值映射,请改用<code>zip()</code>(或<a href="http://docs.python.org/2/library/itertools.html#itertools.izip" rel="nofollow">itertools.izip()</a>)。</p>
<p>另外,收集列表中的行,然后将结果转储到json:</p>
<pre><code>def dictfetchall(cursor):
"""Returns all rows from a cursor as a list of dicts"""
desc = cursor.description
return [dict(itertools.izip([col[0] for col in desc], row))
for row in cursor.fetchall()]
</code></pre>
<p>用法:</p>
<pre><code>results = dictfetchall(cursor)
json_results = json.dumps(results)
</code></pre>
<p>希望能有所帮助。</p>