#!/usr/bin/env python3
"""
查询xtrssvjj数据库中srts表的记录
"""
import sqlite3

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

try:
    # 连接数据库
    conn = sqlite3.connect(db_path)
    cursor = conn.cursor()
    
    # 查看srts表中的adid列表，按adid排序
    print("查询srts表中的adid列表:")
    cursor.execute("SELECT DISTINCT adid, adname FROM srts GROUP BY adid ORDER BY adid")
    results = cursor.fetchall()
    
    if results:
        print(f"找到 {len(results)} 个不同的adid:")
        for adid, adname in results:
            print(f"  adid: {adid} - adname: {adname[:50]}...")
    else:
        print("  无记录")
    
    # 关闭连接
    conn.close()
    
except Exception as e:
    print(f"错误: {e}")