Python连接数据库Sqlite并查询数据显示的示例

Python连接数据库Sqlite并查询数据显示的示例

import sqlite3
def generate_article_links(db_path):
    # 连接数据库
    conn = sqlite3.connect(db_path)
    cursor = conn.cursor()
    # 查询文章信息
    cursor.execute("SELECT id, title, url_path FROM article")
    articles = cursor.fetchall()
    # 生成链接地址
    base_url = "http://www.kan.pub/article/"  # 你的基础URL路径
    article_links = []
    for article in articles:
        article_id, title, url_path = article
        full_url = (
            f"{base_url}{url_path}"  # 假设url_path已经是文章的路径部分，例如 '2021/article-title'
        )
        # article_links.append((article_id, title, full_url))
        article_links.append((full_url))
    # 关闭游标和连接
    cursor.close()
    conn.close()
    return article_links
# 使用函数并打印结果
db_path = "test.sqlite"
links = generate_article_links(db_path)
for link in links:
    print(link)  # 输出格式为 (文章ID, 标题, 完整URL)