#!/usr/bin/env python3
# -*- coding: utf-8 -*-

import sqlite3

db_path = r'\\ll\D\xtrssvjj\db\dpd.db'

try:
    conn = sqlite3.connect(db_path)
    cursor = conn.cursor()
    
    # 检查表结构
    cursor.execute("PRAGMA table_info(ads)")
    columns = cursor.fetchall()
    
    print("ads表结构:")
    for col in columns:
        print(f"  列名: {col[1]}, 类型: {col[2]}")
    
    # 尝试查询一些数据
    cursor.execute("SELECT * FROM ads LIMIT 3")
    rows = cursor.fetchall()
    
    print("\n示例数据:")
    for row in rows:
        print(f"  {row}")
        
finally:
    conn.close()