擅长:python、mysql、java
<p>你可以这样做:</p>
<pre><code>import sqlite3
with sqlite3.connect('/Users/andy/andy') as conn:
cursor = conn.execute('select fruit, weight from fruits')
D = dict()
for row in cursor.fetchall():
D[row[0]] = row[1]
print(D)
</code></pre>