黑马程序员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")