在python中将sql结果修改为json。

import sqlite3
import json

# 连接到SQLite数据库
conn = sqlite3.connect('example.db')
cursor = conn.cursor()

# 执行SQL查询
cursor.execute("SELECT * FROM example_table")
rows = cursor.fetchall()

# 将查询结果转换为JSON
json_result = []
for row in rows:
    json_result.append(dict(zip([column[0] for column in cursor.description], row)))

# 将列表转换为JSON字符串
json_string = json.dumps(json_result, ensure_ascii=False, indent=4)

print(json_string)

# 关闭数据库连接
cursor.close()
conn.close()

import datetime

def datetime_handler(x):
    if isinstance(x, datetime.datetime):
        return x.isoformat()
    raise TypeError("Unknown type")

json_string = json.dumps(json_result, default=datetime_handler, ensure_ascii=False, indent=4)

json_string = json.dumps(json_result, ensure_ascii=False, indent=4, escape_forward_slashes=False)