import json

# JSON字符串
json_data = '{"name": "John", "age": 30, "city": "New York"}'

# 解析JSON數(shù)據(jù)
data = json.loads(json_data)

# 訪問數(shù)據(jù)
print(data["name"]) # 輸出：John
print(data["age"]) # 輸出：30

import json

# Python字典
data = {
	"name": "John",
	"age": 30,
	"city": "New York"
	}
	
# 將數(shù)據(jù)轉(zhuǎn)換為JSON字符串
json_data = json.dumps(data)

# 輸出JSON字符串
print(json_data) # 輸出：{"name": "John", "age": 30, "city": "New York"}

import json

# 從JSON?件讀取數(shù)據(jù)
with open("data.json", "r") as json_file:
	data = json.load(json_file)

# 訪問數(shù)據(jù)
print(data["name"])

import json

# Python字典
data = {
	"name": "John",
	"age": 30,
	"city": "New York"
	}

# 將數(shù)據(jù)寫?JSON?件
with open("data.json", "w") as json_file:
	json.dump(data, json_file)

import json

# 嵌套的JSON數(shù)據(jù)
json_data = '{"person": {"name": "John", "age": 30}}'

# 解析JSON數(shù)據(jù)
data = json.loads(json_data)

# 訪問嵌套數(shù)據(jù)
print(data["person"]["name"]) # 輸出：John

pip install pyodbc

import pyodbc

# 創(chuàng)建數(shù)據(jù)庫連接字符串  
server = 'your_server_name'  
database = 'your_database_name'  
username = 'your_username'  
password = 'your_password'  
driver= '{ODBC Driver 17 for SQL Server}' # 使用的ODBC驅(qū)動程序名稱可能會因版本而異  
connection_string = f'DRIVER={driver};SERVER={server};DATABASE={database};UID={username};PWD={password}'  
  
# 建立數(shù)據(jù)庫連接  
conn = pyodbc.connect(connection_string)  

# 創(chuàng)建游標(biāo)
cursor = connection.cursor()

# 執(zhí)?SQL查詢
cursor.execute("SELECT * FROM table_name")

# 獲取查詢結(jié)果
results = cursor.fetchall()

# 打印結(jié)果
for row in results:
	print(row)

# 關(guān)閉游標(biāo)
cursor.close()
# 關(guān)閉數(shù)據(jù)庫連接
connection.close()