擅长:python、mysql、java
<p>您使用的URL似乎与<a href="https://viacep.com.br/" rel="nofollow noreferrer">here</a>不匹配,因此我在下面的代码中替换了它</p>
<p>我还删除了循环,因为两个示例zipcode都没有返回多条记录-如果有zipcode返回多条记录,请添加一条</p>
<p>注意,要插入的数据需要是元组,而不是列表</p>
<p>此外,对于多个记录,您将使用<code>executemany</code>和元组列表</p>
<pre class="lang-py prettyprint-override"><code>import requests
import sqlite3
import json
CEPC = input("Please type the zipcode:")
print("Identifying the ZIP CODE")
Requisicao = requests.get(f"https://viacep.com.br/ws/{CEPC}/json")
if Requisicao.status_code == 200:
data = Requisicao.json()
# Database
con = sqlite3.connect("CEPS.db")
cur = con.cursor()
cur.execute("DROP TABLE IF EXISTS Requisicao")
cur.execute("CREATE TABLE Requisicao (cep int(8), data json)")
cur.execute("insert into Requisicao values (?, ?)", (data["cep"], json.dumps(data)))
con.commit()
con.close()
else:
print(f"Request failed with status code {Requisicao.status_code} ")
</code></pre>