擅长:python、mysql、java
<p>您不需要这行<code>json_obj = json.loads(r)</code>。<code>r.json()</code>返回一个json响应。在</p>
<p><strong>例如:</strong></p>
<pre><code>json_obj = r.json()
for ord in json_obj["order"]:
print("id:", ord["id"])
print("status_id:", ord["status_order_id"])
print(' -')
cursor.execute("INSERT INTO table_test (id, status_order_id, customer_id) VALUES (%s,%s,%s)", (ord["id"], ord["status_order_id"], ord["customer_id"]))
#close the connection to the database.
mydb.commit()
cursor.close()
</code></pre>