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

conn = sqlite3.connect('dpd.db')
cursor = conn.execute("SELECT rowid, name, tts, ttscnt, totsrts, pub, pub2wxcflag FROM ads LIMIT 3")
columns = [description[0] for description in cursor.description]
print("查询结果的字段：")
print("-" * 60)
for i, col in enumerate(columns):
    print(f"{i+1}. {col}")
print("\n前3条数据：")
print("-" * 60)
for row in cursor:
    print(row)
cursor.close()
conn.close()