mysql 获取中文拼音

import pymysql
from pypinyin import pinyin, Style

# 连接 MySQL 数据库
conn = pymysql.connect(host='localhost', user='root', password='password', db='test')
cursor = conn.cursor()

# 查询中文数据
cursor.execute("SELECT name FROM users")
rows = cursor.fetchall()

# 转换为拼音
for row in rows:
    name = row[0]
    pinyin_list = pinyin(name, style=Style.NORMAL)
    pinyin_str = ' '.join(pinyin_list)
    print(f"{name}: {pinyin_str}")

cursor.close()
conn.close()

import requests

def get_pinyin(text):
    url = "https://api.example.com/pinyin"  # 假设这是一个在线拼音转换服务的 API 地址
    params = {'text': text}
    response = requests.get(url, params=params)
    if response.status_code == 200:
        return response.json().get('pinyin')
    else:
        return None

# 示例
name = "中文"
pinyin_str = get_pinyin(name)
print(f"{name}: {pinyin_str}")