#導(dǎo)包

from pymysql import Connection

import datetime

import json

#構(gòu)建MySql鏈接對(duì)象

coon = Connection(

host='localhost',

port=3306,

user='root',

password='123456'

)

#獲取游標(biāo)對(duì)象

cursor = coon.cursor()

coon.select_db("py_sql") #選擇數(shù)據(jù)庫

#使用游標(biāo)對(duì)象，在mysql中創(chuàng)建表

cursor.execute("select * from orders")

#獲取查詢結(jié)果

result: tuple = cursor.fetchall()

data_dict = {} #定義一個(gè)字典，用于存儲(chǔ)每行數(shù)據(jù)

for data in result:

data_obj = data[0]

#創(chuàng)建四對(duì)鍵值對(duì),分別存儲(chǔ)date, order_id, money, province對(duì)應(yīng)的數(shù)據(jù)

data_dict['date'] = (data_obj.strftime("%Y-%m-%d"))

data_dict['order_id'] = data[1]

data_dict['money'] = data[2]

data_dict['province'] = data[3]

#以追加寫入的形式創(chuàng)建文件，并讀取字典中的數(shù)據(jù)

with open("D:/第二階段課后作業(yè).txt", "a", encoding="UTF-8") as json_file:

# 指定 ensure_ascii=False 參數(shù)，以確保中文內(nèi)容不被轉(zhuǎn)換為 Unicode 編碼

json.dump(data_dict, json_file, ensure_ascii=False)

#關(guān)閉鏈接

coon.close()