#!/usr/bin/env python3
"""
查询oid=8237的author字段
"""
import sqlite3

db_path = "\\\\ll\\d\\wxvddata\\dpd.db"
conn = sqlite3.connect(db_path)
cursor = conn.cursor()

oid = 8237
cursor.execute("SELECT name, author, signature FROM ads WHERE oid = ?", (oid,))
result = cursor.fetchone()

if result:
    name, author, signature = result
    print(f"oid: {oid}")
    print(f"name: {name}")
    print(f"author: {author}")
    print(f"signature: {signature}")
else:
    print(f"未找到oid={oid}的记录")

conn.close()