#!/usr/bin/env python3
"""
查询ads表中rowid为8301的记录的url
"""
import sqlite3

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

try:
    # 连接数据库
    conn = sqlite3.connect(db_path)
    cursor = conn.cursor()
    
    # 查询rowid为8301的记录的url字段
    print("查询ads表中rowid=8301的记录:")
    cursor.execute("SELECT rowid, name, url FROM ads WHERE rowid = 8301")
    result = cursor.fetchone()
    
    if result:
        rowid, name, url = result
        print(f"  rowid: {rowid}")
        print(f"  name: {name}")
        print(f"  url: {url}")
    else:
        print("  无匹配记录")
    
    # 关闭连接
    conn.close()
    
except Exception as e:
    print(f"错误: {e}")