#!/usr/bin/env python3
"""
查询srts表中adid=8237的记录
"""
import sqlite3

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

adid = 8237
cursor.execute("SELECT DISTINCT adname FROM srts WHERE adid = ?", (adid,))
result = cursor.fetchone()

if result:
    adname = result[0]
    print(f"adid: {adid}")
    print(f"adname: {adname}")
else:
    print(f"未找到adid={adid}的记录")

conn.close()