#!/usr/bin/env python3
"""
查询ads表中name包含"牛津大学"的记录
"""
import sqlite3

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

cursor.execute("PRAGMA table_info(ads)")
columns = cursor.fetchall()
column_names = [col[1] for col in columns]

search_term = "牛津大学"
cursor.execute("SELECT * FROM ads WHERE name LIKE ?", (f"%{search_term}%",))
results = cursor.fetchall()

if results:
    print(f"找到包含 '{search_term}' 的记录：")
    for result in results:
        print("\n记录：")
        for i, col_name in enumerate(column_names):
            print(f"{col_name}: {result[i]}")
else:
    print(f"未找到包含 '{search_term}' 的记录")

conn.close()