擅长:python、mysql、java
<p>我不认为光标是正确的,但是
应改为使用for循环:</p>
<pre><code>import sqlite3
conn = sqlite3.connect("database.db")
cur = conn.cursor()
sql = """SELECT fruit,weight FROM fruits"""
cur.execute(sql)
data = cur.fetchall()
fruitweight= {}
for i in data:
fruitweight[i[0]] = i[1]
conn.close()
print(fruitweight)
</code></pre>