#!/usr/bin/env python3
"""
查询包含"师徒一场"的记录
"""
import sqlite3

# 数据库路径
db_path = "\\\\ll\\D\\xtrssvjj\\dpd.db"

try:
    conn = sqlite3.connect(db_path)
    cursor = conn.cursor()
    
    print("xtrssvjj数据库srts表中包含'师徒一场'的记录:")
    cursor.execute("SELECT DISTINCT adid, adname FROM srts WHERE adname LIKE '%师徒一场%'")
    results = cursor.fetchall()
    
    for adid, adname in results:
        print(f"  adid={adid}")
        print(f"  adname={adname}")
        print()
    
    conn.close()
    
except Exception as e:
    print(f"错误: {e}")