个人记账本与收支分析工具：SQLite持久化、分类统计、月度汇总、收入支出颜色编码一目了然

🖥️ 运行效果

🚀 实例简介

一款轻量级桌面记账应用，支持日常收支记录、分类统计、月度汇总。使用 SQLite 持久化存储，数据安全可靠。界面简洁直观，收入绿色、支出红色，支持自定义分类和备注。

💻 核心代码

#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
个人记账本与收支分析工具
功能：记录日常收支、分类统计、月度汇总、SQLite持久化存储
"""
import tkinter as tk
from tkinter import ttk, messagebox
import sqlite3, platform, datetime

CHINESE_FONT = "WenQuanYi Zen Hei" if platform.system() == "Linux" else "Microsoft YaHei"

class BookkeepingApp:
    def __init__(self, root):
        self.root = root
        self.root.title("个人记账本与收支分析")
        self.root.geometry("900x650")
        self.root.configure(bg="#f5f6fa")
        
        # 初始化数据库
        self.db = sqlite3.connect(":memory:")
        self.db.execute("""CREATE TABLE records(
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            date TEXT, category TEXT, type TEXT,
            amount REAL, note TEXT
        )""")
        self._load_sample_data()
        self._build_ui()
        self.refresh_table()
    
    def _load_sample_data(self):
        """加载示例数据"""
        samples = [
            ("2026-10-01", "餐饮", "支出", 35.00, "午餐外卖"),
            ("2026-10-01", "交通", "支出", 6.00, "地铁"),
            ("2026-10-02", "工资", "收入", 15000.00, "10月工资"),
            ("2026-10-02", "购物", "支出", 299.00, "运动鞋"),
            ("2026-10-03", "餐饮", "支出", 52.00, "朋友聚餐"),
            ("2026-10-03", "娱乐", "支出", 88.00, "电影票"),
            ("2026-10-04", "日用", "支出", 45.50, "超市采购"),
            ("2026-10-04", "兼职", "收入", 2000.00, "项目外包"),
            ("2026-10-05", "餐饮", "支出", 28.00, "早餐+午餐"),
            ("2026-10-05", "住房", "支出", 3500.00, "房租"),
        ]
        self.db.executemany(
            "INSERT INTO records(date,category,type,amount,note) VALUES(?,?,?,?,?)",
            samples
        )
    
    def _build_ui(self):
        """构建界面"""
        # 顶部标题栏
        header = tk.Frame(self.root, bg="#2c3e50", height=50)
        header.pack(fill=tk.X)
        header.pack_propagate(False)
        tk.Label(header, text="💰 个人记账本", font=(CHINESE_FONT, 16, "bold"),
                 bg="#2c3e50", fg="white").pack(side=tk.LEFT, padx=20, pady=10)
        
        # 录入表单
        form = tk.LabelFrame(self.root, text="📝 记一笔", font=(CHINESE_FONT, 11, "bold"),
                             bg="white", padx=10, pady=8)
        form.pack(fill=tk.X, padx=15, pady=(10, 5))
        
        fields = [("日期:", "var_date", datetime.date.today().strftime("%Y-%m-%d")),
                  ("分类:", "var_cat", "餐饮"),
                  ("金额:", "var_amt", "0.00"),
                  ("备注:", "var_note", "")]
        self.vars = {}
        for i, (label, var, default) in enumerate(fields):
            tk.Label(form, text=label, font=(CHINESE_FONT, 10), bg="white").grid(row=0, column=i*2, padx=3)
            self.vars[var] = tk.StringVar(value=default)
            w = 10 if var != "var_note" else 15
            tk.Entry(form, textvariable=self.vars[var], width=w,
                     font=(CHINESE_FONT, 10)).grid(row=0, column=i*2+1, padx=3)
        
        tk.Label(form, text="类型:", font=(CHINESE_FONT, 10), bg="white").grid(row=0, column=8, padx=3)
        self.vars["var_type"] = tk.StringVar(value="支出")
        ttk.Combobox(form, textvariable=self.vars["var_type"], values=["收入", "支出"],
                     state="readonly", width=6).grid(row=0, column=9, padx=3)
        tk.Button(form, text="➕ 添加", command=self.add_record, bg="#27ae60",

💡 适用场景

办公自动化、数据分析、快速原型开发