#!/usr/bin/env python3
"""
查询"牛津大学"的adid和adname
"""
import sqlite3

db_path = "\\\\ll\\D\\xtrssvjj\\dpd.db"
conn = sqlite3.connect(db_path)
cursor = conn.cursor()

search_term = "牛津大学"
cursor.execute("SELECT DISTINCT adid, adname FROM srts WHERE adname LIKE ?", (f"%{search_term}%",))
results = cursor.fetchall()

print(f"查询包含 '{search_term}' 的音频：")
for adid, adname in results:
    print(f"adid: {adid}, adname: {adname}")

conn.close()