黑馬程序員python教程，8天python從入門到精通，學python看這套就
p138 exercise
from data_define import Record
from pymysql import Connection
f=open("D:/222.json","w",encoding="UTF-8")
conn=Connection(
host="localhost",
port=3306,
user="root",
password="123456",
autocommit=True
)
cursor=conn.cursor()
conn.select_db("py_sql")
cursor.execute("SELECT * FROM orders")
result=cursor.fetchall()
for i in result:
record=Record(i[0],i[1],i[2],i[3])
f.write(record.to_json())
f.write("\n")
標簽：
