中級者向け No.21
連絡先帳（検索機能付き）
名前・電話・メール・住所を管理できる連絡先帳。インクリメンタルサーチとvCard形式でのエクスポートを学びます。
📋 目次
1. アプリ概要
名前・電話・メール・住所を管理できる連絡先帳。インクリメンタルサーチとvCard形式でのエクスポートを学びます。
このアプリは中級カテゴリに分類される実践的なGUIアプリです。使用ライブラリは tkinter（標準ライブラリ） で、難易度は ★★☆ です。
Pythonでは tkinter を使うことで、クロスプラットフォームなGUIアプリを簡単に作成できます。このアプリを通じて、ウィジェットの配置・イベント処理・データ管理など、GUI開発の実践的なスキルを習得できます。
ソースコードは完全な動作状態で提供しており、コピーしてそのまま実行できます。まずは実行して動作を確認し、その後コードを読んで仕組みを理解していきましょう。カスタマイズセクションでは機能拡張のアイデアも紹介しています。
GUIアプリ開発は、プログラミングの楽しさを実感できる最も効果的な学習方法のひとつです。アプリを作ることで、変数・関数・クラス・イベント処理など、プログラミングの重要な概念が自然と身についていきます。このアプリをきっかけに、オリジナルアプリの開発にも挑戦してみてください。
2. 機能一覧
- 連絡先帳（検索機能付き）のメイン機能
- 直感的なGUIインターフェース
- 入力値のバリデーション
- エラーハンドリング
- 結果の見やすい表示
- キーボードショートカット対応
3. 事前準備・環境
動作確認環境
Python 3.10 以上 / Windows・Mac・Linux すべて対応
以下の環境で動作確認しています。
- Python 3.10 以上
- OS: Windows 10/11・macOS 12+・Ubuntu 20.04+
4. 完全なソースコード
コードのコピー方法
右上の「コピー」ボタンをクリックするとコードをクリップボードにコピーできます。
app21.py
import tkinter as tk
from tkinter import ttk, messagebox, filedialog
import sqlite3
import os
from datetime import datetime
class App21:
"""連絡先帳（検索機能付き）"""
DB_PATH = os.path.join(os.path.dirname(__file__), "contacts.db")
def __init__(self, root):
self.root = root
self.root.title("連絡先帳")
self.root.geometry("860x560")
self.root.configure(bg="#f8f9fc")
self._init_db()
self._build_ui()
self._load_contacts()
def _init_db(self):
self.conn = sqlite3.connect(self.DB_PATH)
self.conn.execute("""
CREATE TABLE IF NOT EXISTS contacts (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
phone TEXT,
email TEXT,
address TEXT,
birthday TEXT,
company TEXT,
notes TEXT,
group_name TEXT,
created_at TEXT
)
""")
self.conn.commit()
if not self.conn.execute("SELECT 1 FROM contacts").fetchone():
samples = [
("山田太郎", "090-1234-5678", "taro@example.com",
"東京都新宿区", "1990-05-15", "ABC株式会社", "", "仕事"),
("田中花子", "080-9876-5432", "hanako@example.com",
"大阪府大阪市", "1988-12-03", "", "", "友人"),
("佐藤次郎", "070-1111-2222", "jiro@example.com",
"神奈川県横浜市", "", "XYZ商事", "", "仕事"),
]
for s in samples:
self.conn.execute(
"INSERT INTO contacts (name,phone,email,address,birthday,"
"company,notes,group_name,created_at) VALUES (?,?,?,?,?,?,?,?,?)",
(*s, datetime.now().isoformat()))
self.conn.commit()
def _build_ui(self):
title_frame = tk.Frame(self.root, bg="#1976d2", pady=10)
title_frame.pack(fill=tk.X)
tk.Label(title_frame, text="📇 連絡先帳",
font=("Noto Sans JP", 15, "bold"),
bg="#1976d2", fg="white").pack(side=tk.LEFT, padx=12)
ttk.Button(title_frame, text="📤 vCardエクスポート",
command=self._export_vcard).pack(side=tk.RIGHT, padx=8)
# 検索バー
search_frame = tk.Frame(self.root, bg="#e8eef5", pady=6)
search_frame.pack(fill=tk.X)
tk.Label(search_frame, text="🔍 インクリメンタル検索:",
bg="#e8eef5").pack(side=tk.LEFT, padx=8)
self.search_var = tk.StringVar()
search_entry = ttk.Entry(search_frame, textvariable=self.search_var,
width=28, font=("Arial", 11))
search_entry.pack(side=tk.LEFT, padx=4)
self.search_var.trace_add("write", lambda *a: self._load_contacts())
search_entry.focus_set()
tk.Label(search_frame, text="グループ:",
bg="#e8eef5").pack(side=tk.LEFT, padx=(12, 4))
self.group_var = tk.StringVar(value="すべて")
self.group_cb = ttk.Combobox(search_frame, textvariable=self.group_var,
state="readonly", width=12)
self.group_cb.pack(side=tk.LEFT)
self.group_cb.bind("<<ComboboxSelected>>", lambda e: self._load_contacts())
# メインエリア
main = tk.Frame(self.root, bg="#f8f9fc")
main.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# 左: 連絡先リスト
list_frame = ttk.LabelFrame(main, text="連絡先一覧", padding=4)
list_frame.pack(side=tk.LEFT, fill=tk.BOTH, expand=True)
cols = ("name", "phone", "email", "company", "group_name")
self.tree = ttk.Treeview(list_frame, columns=cols,
show="headings", selectmode="browse")
for c, h, w in [("name", "名前", 120), ("phone", "電話", 110),
("email", "メール", 160), ("company", "会社", 110),
("group_name", "グループ", 70)]:
self.tree.heading(c, text=h,
command=lambda c=c: self._sort(c))
self.tree.column(c, width=w, minwidth=40)
sb = ttk.Scrollbar(list_frame, command=self.tree.yview)
self.tree.configure(yscrollcommand=sb.set)
sb.pack(side=tk.RIGHT, fill=tk.Y)
self.tree.pack(fill=tk.BOTH, expand=True)
self.tree.bind("<<TreeviewSelect>>", self._on_select)
# 右: 詳細・編集
right = ttk.LabelFrame(main, text="詳細・編集", padding=10)
right.pack(side=tk.RIGHT, fill=tk.Y, padx=(8, 0))
right.configure(width=260)
fields = [("名前", "name"), ("電話", "phone"), ("メール", "email"),
("住所", "address"), ("誕生日", "birthday"),
("会社", "company"), ("グループ", "group_edit")]
for lbl, attr in fields:
tk.Label(right, text=f"{lbl}:").pack(anchor="w")
var = tk.StringVar()
ttk.Entry(right, textvariable=var, width=26).pack(
anchor="w", pady=1)
setattr(self, f"{attr}_var", var)
tk.Label(right, text="メモ:").pack(anchor="w")
self.notes_text = tk.Text(right, height=3, width=26, font=("Arial", 10))
self.notes_text.pack(anchor="w", pady=1)
btn_f = tk.Frame(right, bg=right.cget("background"))
btn_f.pack(fill=tk.X, pady=6)
for text, cmd in [("➕ 追加", self._add_contact),
("✏️ 更新", self._update_contact),
("🗑️ 削除", self._delete_contact)]:
ttk.Button(btn_f, text=text, command=cmd).pack(side=tk.LEFT, padx=2)
self.status_var = tk.StringVar(value="")
tk.Label(self.root, textvariable=self.status_var,
bg="#dde", font=("Arial", 9), anchor="w", padx=8
).pack(fill=tk.X, side=tk.BOTTOM)
self._selected_id = None
def _load_contacts(self):
q = self.search_var.get().lower()
group = self.group_var.get()
sql = ("SELECT id,name,phone,email,company,group_name "
"FROM contacts WHERE 1=1")
params = []
if q:
sql += (" AND (LOWER(name) LIKE ? OR LOWER(phone) LIKE ? "
"OR LOWER(email) LIKE ? OR LOWER(company) LIKE ?)")
params += [f"%{q}%"] * 4
if group != "すべて":
sql += " AND group_name=?"
params.append(group)
sql += " ORDER BY name COLLATE NOCASE"
rows = self.conn.execute(sql, params).fetchall()
self.tree.delete(*self.tree.get_children())
for row in rows:
cid, *vals = row
self.tree.insert("", "end", iid=str(cid), values=vals)
self.status_var.set(f"{len(rows)} 件")
# グループ一覧更新
groups = self.conn.execute(
"SELECT DISTINCT group_name FROM contacts "
"WHERE group_name != '' ORDER BY group_name").fetchall()
self.group_cb.configure(
values=["すべて"] + [g[0] for g in groups])
def _on_select(self, event):
sel = self.tree.selection()
if not sel:
return
cid = int(sel[0])
self._selected_id = cid
row = self.conn.execute(
"SELECT name,phone,email,address,birthday,company,group_name,notes "
"FROM contacts WHERE id=?", (cid,)).fetchone()
if row:
(name, phone, email, addr, bday,
company, group, notes) = row
self.name_var.set(name)
self.phone_var.set(phone or "")
self.email_var.set(email or "")
self.address_var.set(addr or "")
self.birthday_var.set(bday or "")
self.company_var.set(company or "")
self.group_edit_var.set(group or "")
self.notes_text.delete("1.0", tk.END)
self.notes_text.insert("1.0", notes or "")
def _add_contact(self):
name = self.name_var.get().strip()
if not name:
messagebox.showwarning("警告", "名前を入力してください")
return
self.conn.execute(
"INSERT INTO contacts (name,phone,email,address,birthday,"
"company,group_name,notes,created_at) VALUES (?,?,?,?,?,?,?,?,?)",
(name, self.phone_var.get(), self.email_var.get(),
self.address_var.get(), self.birthday_var.get(),
self.company_var.get(), self.group_edit_var.get(),
self.notes_text.get("1.0", tk.END).strip(),
datetime.now().isoformat()))
self.conn.commit()
self._load_contacts()
def _update_contact(self):
if not self._selected_id:
return
self.conn.execute(
"UPDATE contacts SET name=?,phone=?,email=?,address=?,birthday=?,"
"company=?,group_name=?,notes=? WHERE id=?",
(self.name_var.get(), self.phone_var.get(), self.email_var.get(),
self.address_var.get(), self.birthday_var.get(),
self.company_var.get(), self.group_edit_var.get(),
self.notes_text.get("1.0", tk.END).strip(),
self._selected_id))
self.conn.commit()
self._load_contacts()
def _delete_contact(self):
if not self._selected_id:
return
if messagebox.askyesno("確認", "この連絡先を削除しますか?"):
self.conn.execute("DELETE FROM contacts WHERE id=?",
(self._selected_id,))
self.conn.commit()
self._selected_id = None
self._load_contacts()
def _export_vcard(self):
path = filedialog.asksaveasfilename(
defaultextension=".vcf",
filetypes=[("vCardファイル", "*.vcf"), ("すべて", "*.*")])
if not path:
return
rows = self.conn.execute(
"SELECT name,phone,email,address,company FROM contacts"
).fetchall()
with open(path, "w", encoding="utf-8") as f:
for name, phone, email, addr, company in rows:
f.write("BEGIN:VCARD\nVERSION:3.0\n")
f.write(f"FN:{name}\n")
if phone:
f.write(f"TEL:{phone}\n")
if email:
f.write(f"EMAIL:{email}\n")
if addr:
f.write(f"ADR:;;{addr};;;;\n")
if company:
f.write(f"ORG:{company}\n")
f.write("END:VCARD\n\n")
messagebox.showinfo("完了", f"vCardエクスポート: {len(rows)} 件\n{path}")
def _sort(self, col):
data = [(self.tree.set(k, col), k) for k in self.tree.get_children()]
data.sort()
for idx, (_, k) in enumerate(data):
self.tree.move(k, "", idx)
if __name__ == "__main__":
root = tk.Tk()
app = App21(root)
root.mainloop()
5. コード解説
連絡先帳（検索機能付き）のコードを詳しく解説します。クラスベースの設計で各機能を整理して実装しています。
クラス設計とコンストラクタ
App21クラスにアプリの全機能をまとめています。__init__メソッドでウィンドウの基本設定を行い、_build_ui()でUI構築、process()でメイン処理を担当します。この分離により、各メソッドの責任が明確になりコードが読みやすくなります。
import tkinter as tk
from tkinter import ttk, messagebox, filedialog
import sqlite3
import os
from datetime import datetime
class App21:
"""連絡先帳（検索機能付き）"""
DB_PATH = os.path.join(os.path.dirname(__file__), "contacts.db")
def __init__(self, root):
self.root = root
self.root.title("連絡先帳")
self.root.geometry("860x560")
self.root.configure(bg="#f8f9fc")
self._init_db()
self._build_ui()
self._load_contacts()
def _init_db(self):
self.conn = sqlite3.connect(self.DB_PATH)
self.conn.execute("""
CREATE TABLE IF NOT EXISTS contacts (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
phone TEXT,
email TEXT,
address TEXT,
birthday TEXT,
company TEXT,
notes TEXT,
group_name TEXT,
created_at TEXT
)
""")
self.conn.commit()
if not self.conn.execute("SELECT 1 FROM contacts").fetchone():
samples = [
("山田太郎", "090-1234-5678", "taro@example.com",
"東京都新宿区", "1990-05-15", "ABC株式会社", "", "仕事"),
("田中花子", "080-9876-5432", "hanako@example.com",
"大阪府大阪市", "1988-12-03", "", "", "友人"),
("佐藤次郎", "070-1111-2222", "jiro@example.com",
"神奈川県横浜市", "", "XYZ商事", "", "仕事"),
]
for s in samples:
self.conn.execute(
"INSERT INTO contacts (name,phone,email,address,birthday,"
"company,notes,group_name,created_at) VALUES (?,?,?,?,?,?,?,?,?)",
(*s, datetime.now().isoformat()))
self.conn.commit()
def _build_ui(self):
title_frame = tk.Frame(self.root, bg="#1976d2", pady=10)
title_frame.pack(fill=tk.X)
tk.Label(title_frame, text="📇 連絡先帳",
font=("Noto Sans JP", 15, "bold"),
bg="#1976d2", fg="white").pack(side=tk.LEFT, padx=12)
ttk.Button(title_frame, text="📤 vCardエクスポート",
command=self._export_vcard).pack(side=tk.RIGHT, padx=8)
# 検索バー
search_frame = tk.Frame(self.root, bg="#e8eef5", pady=6)
search_frame.pack(fill=tk.X)
tk.Label(search_frame, text="🔍 インクリメンタル検索:",
bg="#e8eef5").pack(side=tk.LEFT, padx=8)
self.search_var = tk.StringVar()
search_entry = ttk.Entry(search_frame, textvariable=self.search_var,
width=28, font=("Arial", 11))
search_entry.pack(side=tk.LEFT, padx=4)
self.search_var.trace_add("write", lambda *a: self._load_contacts())
search_entry.focus_set()
tk.Label(search_frame, text="グループ:",
bg="#e8eef5").pack(side=tk.LEFT, padx=(12, 4))
self.group_var = tk.StringVar(value="すべて")
self.group_cb = ttk.Combobox(search_frame, textvariable=self.group_var,
state="readonly", width=12)
self.group_cb.pack(side=tk.LEFT)
self.group_cb.bind("<<ComboboxSelected>>", lambda e: self._load_contacts())
# メインエリア
main = tk.Frame(self.root, bg="#f8f9fc")
main.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# 左: 連絡先リスト
list_frame = ttk.LabelFrame(main, text="連絡先一覧", padding=4)
list_frame.pack(side=tk.LEFT, fill=tk.BOTH, expand=True)
cols = ("name", "phone", "email", "company", "group_name")
self.tree = ttk.Treeview(list_frame, columns=cols,
show="headings", selectmode="browse")
for c, h, w in [("name", "名前", 120), ("phone", "電話", 110),
("email", "メール", 160), ("company", "会社", 110),
("group_name", "グループ", 70)]:
self.tree.heading(c, text=h,
command=lambda c=c: self._sort(c))
self.tree.column(c, width=w, minwidth=40)
sb = ttk.Scrollbar(list_frame, command=self.tree.yview)
self.tree.configure(yscrollcommand=sb.set)
sb.pack(side=tk.RIGHT, fill=tk.Y)
self.tree.pack(fill=tk.BOTH, expand=True)
self.tree.bind("<<TreeviewSelect>>", self._on_select)
# 右: 詳細・編集
right = ttk.LabelFrame(main, text="詳細・編集", padding=10)
right.pack(side=tk.RIGHT, fill=tk.Y, padx=(8, 0))
right.configure(width=260)
fields = [("名前", "name"), ("電話", "phone"), ("メール", "email"),
("住所", "address"), ("誕生日", "birthday"),
("会社", "company"), ("グループ", "group_edit")]
for lbl, attr in fields:
tk.Label(right, text=f"{lbl}:").pack(anchor="w")
var = tk.StringVar()
ttk.Entry(right, textvariable=var, width=26).pack(
anchor="w", pady=1)
setattr(self, f"{attr}_var", var)
tk.Label(right, text="メモ:").pack(anchor="w")
self.notes_text = tk.Text(right, height=3, width=26, font=("Arial", 10))
self.notes_text.pack(anchor="w", pady=1)
btn_f = tk.Frame(right, bg=right.cget("background"))
btn_f.pack(fill=tk.X, pady=6)
for text, cmd in [("➕ 追加", self._add_contact),
("✏️ 更新", self._update_contact),
("🗑️ 削除", self._delete_contact)]:
ttk.Button(btn_f, text=text, command=cmd).pack(side=tk.LEFT, padx=2)
self.status_var = tk.StringVar(value="")
tk.Label(self.root, textvariable=self.status_var,
bg="#dde", font=("Arial", 9), anchor="w", padx=8
).pack(fill=tk.X, side=tk.BOTTOM)
self._selected_id = None
def _load_contacts(self):
q = self.search_var.get().lower()
group = self.group_var.get()
sql = ("SELECT id,name,phone,email,company,group_name "
"FROM contacts WHERE 1=1")
params = []
if q:
sql += (" AND (LOWER(name) LIKE ? OR LOWER(phone) LIKE ? "
"OR LOWER(email) LIKE ? OR LOWER(company) LIKE ?)")
params += [f"%{q}%"] * 4
if group != "すべて":
sql += " AND group_name=?"
params.append(group)
sql += " ORDER BY name COLLATE NOCASE"
rows = self.conn.execute(sql, params).fetchall()
self.tree.delete(*self.tree.get_children())
for row in rows:
cid, *vals = row
self.tree.insert("", "end", iid=str(cid), values=vals)
self.status_var.set(f"{len(rows)} 件")
# グループ一覧更新
groups = self.conn.execute(
"SELECT DISTINCT group_name FROM contacts "
"WHERE group_name != '' ORDER BY group_name").fetchall()
self.group_cb.configure(
values=["すべて"] + [g[0] for g in groups])
def _on_select(self, event):
sel = self.tree.selection()
if not sel:
return
cid = int(sel[0])
self._selected_id = cid
row = self.conn.execute(
"SELECT name,phone,email,address,birthday,company,group_name,notes "
"FROM contacts WHERE id=?", (cid,)).fetchone()
if row:
(name, phone, email, addr, bday,
company, group, notes) = row
self.name_var.set(name)
self.phone_var.set(phone or "")
self.email_var.set(email or "")
self.address_var.set(addr or "")
self.birthday_var.set(bday or "")
self.company_var.set(company or "")
self.group_edit_var.set(group or "")
self.notes_text.delete("1.0", tk.END)
self.notes_text.insert("1.0", notes or "")
def _add_contact(self):
name = self.name_var.get().strip()
if not name:
messagebox.showwarning("警告", "名前を入力してください")
return
self.conn.execute(
"INSERT INTO contacts (name,phone,email,address,birthday,"
"company,group_name,notes,created_at) VALUES (?,?,?,?,?,?,?,?,?)",
(name, self.phone_var.get(), self.email_var.get(),
self.address_var.get(), self.birthday_var.get(),
self.company_var.get(), self.group_edit_var.get(),
self.notes_text.get("1.0", tk.END).strip(),
datetime.now().isoformat()))
self.conn.commit()
self._load_contacts()
def _update_contact(self):
if not self._selected_id:
return
self.conn.execute(
"UPDATE contacts SET name=?,phone=?,email=?,address=?,birthday=?,"
"company=?,group_name=?,notes=? WHERE id=?",
(self.name_var.get(), self.phone_var.get(), self.email_var.get(),
self.address_var.get(), self.birthday_var.get(),
self.company_var.get(), self.group_edit_var.get(),
self.notes_text.get("1.0", tk.END).strip(),
self._selected_id))
self.conn.commit()
self._load_contacts()
def _delete_contact(self):
if not self._selected_id:
return
if messagebox.askyesno("確認", "この連絡先を削除しますか?"):
self.conn.execute("DELETE FROM contacts WHERE id=?",
(self._selected_id,))
self.conn.commit()
self._selected_id = None
self._load_contacts()
def _export_vcard(self):
path = filedialog.asksaveasfilename(
defaultextension=".vcf",
filetypes=[("vCardファイル", "*.vcf"), ("すべて", "*.*")])
if not path:
return
rows = self.conn.execute(
"SELECT name,phone,email,address,company FROM contacts"
).fetchall()
with open(path, "w", encoding="utf-8") as f:
for name, phone, email, addr, company in rows:
f.write("BEGIN:VCARD\nVERSION:3.0\n")
f.write(f"FN:{name}\n")
if phone:
f.write(f"TEL:{phone}\n")
if email:
f.write(f"EMAIL:{email}\n")
if addr:
f.write(f"ADR:;;{addr};;;;\n")
if company:
f.write(f"ORG:{company}\n")
f.write("END:VCARD\n\n")
messagebox.showinfo("完了", f"vCardエクスポート: {len(rows)} 件\n{path}")
def _sort(self, col):
data = [(self.tree.set(k, col), k) for k in self.tree.get_children()]
data.sort()
for idx, (_, k) in enumerate(data):
self.tree.move(k, "", idx)
if __name__ == "__main__":
root = tk.Tk()
app = App21(root)
root.mainloop()
LabelFrameによるセクション分け
ttk.LabelFrame を使うことで、入力エリアと結果エリアを視覚的に分けられます。padding引数でフレーム内の余白を設定し、見やすいレイアウトを実現しています。
import tkinter as tk
from tkinter import ttk, messagebox, filedialog
import sqlite3
import os
from datetime import datetime
class App21:
"""連絡先帳（検索機能付き）"""
DB_PATH = os.path.join(os.path.dirname(__file__), "contacts.db")
def __init__(self, root):
self.root = root
self.root.title("連絡先帳")
self.root.geometry("860x560")
self.root.configure(bg="#f8f9fc")
self._init_db()
self._build_ui()
self._load_contacts()
def _init_db(self):
self.conn = sqlite3.connect(self.DB_PATH)
self.conn.execute("""
CREATE TABLE IF NOT EXISTS contacts (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
phone TEXT,
email TEXT,
address TEXT,
birthday TEXT,
company TEXT,
notes TEXT,
group_name TEXT,
created_at TEXT
)
""")
self.conn.commit()
if not self.conn.execute("SELECT 1 FROM contacts").fetchone():
samples = [
("山田太郎", "090-1234-5678", "taro@example.com",
"東京都新宿区", "1990-05-15", "ABC株式会社", "", "仕事"),
("田中花子", "080-9876-5432", "hanako@example.com",
"大阪府大阪市", "1988-12-03", "", "", "友人"),
("佐藤次郎", "070-1111-2222", "jiro@example.com",
"神奈川県横浜市", "", "XYZ商事", "", "仕事"),
]
for s in samples:
self.conn.execute(
"INSERT INTO contacts (name,phone,email,address,birthday,"
"company,notes,group_name,created_at) VALUES (?,?,?,?,?,?,?,?,?)",
(*s, datetime.now().isoformat()))
self.conn.commit()
def _build_ui(self):
title_frame = tk.Frame(self.root, bg="#1976d2", pady=10)
title_frame.pack(fill=tk.X)
tk.Label(title_frame, text="📇 連絡先帳",
font=("Noto Sans JP", 15, "bold"),
bg="#1976d2", fg="white").pack(side=tk.LEFT, padx=12)
ttk.Button(title_frame, text="📤 vCardエクスポート",
command=self._export_vcard).pack(side=tk.RIGHT, padx=8)
# 検索バー
search_frame = tk.Frame(self.root, bg="#e8eef5", pady=6)
search_frame.pack(fill=tk.X)
tk.Label(search_frame, text="🔍 インクリメンタル検索:",
bg="#e8eef5").pack(side=tk.LEFT, padx=8)
self.search_var = tk.StringVar()
search_entry = ttk.Entry(search_frame, textvariable=self.search_var,
width=28, font=("Arial", 11))
search_entry.pack(side=tk.LEFT, padx=4)
self.search_var.trace_add("write", lambda *a: self._load_contacts())
search_entry.focus_set()
tk.Label(search_frame, text="グループ:",
bg="#e8eef5").pack(side=tk.LEFT, padx=(12, 4))
self.group_var = tk.StringVar(value="すべて")
self.group_cb = ttk.Combobox(search_frame, textvariable=self.group_var,
state="readonly", width=12)
self.group_cb.pack(side=tk.LEFT)
self.group_cb.bind("<<ComboboxSelected>>", lambda e: self._load_contacts())
# メインエリア
main = tk.Frame(self.root, bg="#f8f9fc")
main.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# 左: 連絡先リスト
list_frame = ttk.LabelFrame(main, text="連絡先一覧", padding=4)
list_frame.pack(side=tk.LEFT, fill=tk.BOTH, expand=True)
cols = ("name", "phone", "email", "company", "group_name")
self.tree = ttk.Treeview(list_frame, columns=cols,
show="headings", selectmode="browse")
for c, h, w in [("name", "名前", 120), ("phone", "電話", 110),
("email", "メール", 160), ("company", "会社", 110),
("group_name", "グループ", 70)]:
self.tree.heading(c, text=h,
command=lambda c=c: self._sort(c))
self.tree.column(c, width=w, minwidth=40)
sb = ttk.Scrollbar(list_frame, command=self.tree.yview)
self.tree.configure(yscrollcommand=sb.set)
sb.pack(side=tk.RIGHT, fill=tk.Y)
self.tree.pack(fill=tk.BOTH, expand=True)
self.tree.bind("<<TreeviewSelect>>", self._on_select)
# 右: 詳細・編集
right = ttk.LabelFrame(main, text="詳細・編集", padding=10)
right.pack(side=tk.RIGHT, fill=tk.Y, padx=(8, 0))
right.configure(width=260)
fields = [("名前", "name"), ("電話", "phone"), ("メール", "email"),
("住所", "address"), ("誕生日", "birthday"),
("会社", "company"), ("グループ", "group_edit")]
for lbl, attr in fields:
tk.Label(right, text=f"{lbl}:").pack(anchor="w")
var = tk.StringVar()
ttk.Entry(right, textvariable=var, width=26).pack(
anchor="w", pady=1)
setattr(self, f"{attr}_var", var)
tk.Label(right, text="メモ:").pack(anchor="w")
self.notes_text = tk.Text(right, height=3, width=26, font=("Arial", 10))
self.notes_text.pack(anchor="w", pady=1)
btn_f = tk.Frame(right, bg=right.cget("background"))
btn_f.pack(fill=tk.X, pady=6)
for text, cmd in [("➕ 追加", self._add_contact),
("✏️ 更新", self._update_contact),
("🗑️ 削除", self._delete_contact)]:
ttk.Button(btn_f, text=text, command=cmd).pack(side=tk.LEFT, padx=2)
self.status_var = tk.StringVar(value="")
tk.Label(self.root, textvariable=self.status_var,
bg="#dde", font=("Arial", 9), anchor="w", padx=8
).pack(fill=tk.X, side=tk.BOTTOM)
self._selected_id = None
def _load_contacts(self):
q = self.search_var.get().lower()
group = self.group_var.get()
sql = ("SELECT id,name,phone,email,company,group_name "
"FROM contacts WHERE 1=1")
params = []
if q:
sql += (" AND (LOWER(name) LIKE ? OR LOWER(phone) LIKE ? "
"OR LOWER(email) LIKE ? OR LOWER(company) LIKE ?)")
params += [f"%{q}%"] * 4
if group != "すべて":
sql += " AND group_name=?"
params.append(group)
sql += " ORDER BY name COLLATE NOCASE"
rows = self.conn.execute(sql, params).fetchall()
self.tree.delete(*self.tree.get_children())
for row in rows:
cid, *vals = row
self.tree.insert("", "end", iid=str(cid), values=vals)
self.status_var.set(f"{len(rows)} 件")
# グループ一覧更新
groups = self.conn.execute(
"SELECT DISTINCT group_name FROM contacts "
"WHERE group_name != '' ORDER BY group_name").fetchall()
self.group_cb.configure(
values=["すべて"] + [g[0] for g in groups])
def _on_select(self, event):
sel = self.tree.selection()
if not sel:
return
cid = int(sel[0])
self._selected_id = cid
row = self.conn.execute(
"SELECT name,phone,email,address,birthday,company,group_name,notes "
"FROM contacts WHERE id=?", (cid,)).fetchone()
if row:
(name, phone, email, addr, bday,
company, group, notes) = row
self.name_var.set(name)
self.phone_var.set(phone or "")
self.email_var.set(email or "")
self.address_var.set(addr or "")
self.birthday_var.set(bday or "")
self.company_var.set(company or "")
self.group_edit_var.set(group or "")
self.notes_text.delete("1.0", tk.END)
self.notes_text.insert("1.0", notes or "")
def _add_contact(self):
name = self.name_var.get().strip()
if not name:
messagebox.showwarning("警告", "名前を入力してください")
return
self.conn.execute(
"INSERT INTO contacts (name,phone,email,address,birthday,"
"company,group_name,notes,created_at) VALUES (?,?,?,?,?,?,?,?,?)",
(name, self.phone_var.get(), self.email_var.get(),
self.address_var.get(), self.birthday_var.get(),
self.company_var.get(), self.group_edit_var.get(),
self.notes_text.get("1.0", tk.END).strip(),
datetime.now().isoformat()))
self.conn.commit()
self._load_contacts()
def _update_contact(self):
if not self._selected_id:
return
self.conn.execute(
"UPDATE contacts SET name=?,phone=?,email=?,address=?,birthday=?,"
"company=?,group_name=?,notes=? WHERE id=?",
(self.name_var.get(), self.phone_var.get(), self.email_var.get(),
self.address_var.get(), self.birthday_var.get(),
self.company_var.get(), self.group_edit_var.get(),
self.notes_text.get("1.0", tk.END).strip(),
self._selected_id))
self.conn.commit()
self._load_contacts()
def _delete_contact(self):
if not self._selected_id:
return
if messagebox.askyesno("確認", "この連絡先を削除しますか?"):
self.conn.execute("DELETE FROM contacts WHERE id=?",
(self._selected_id,))
self.conn.commit()
self._selected_id = None
self._load_contacts()
def _export_vcard(self):
path = filedialog.asksaveasfilename(
defaultextension=".vcf",
filetypes=[("vCardファイル", "*.vcf"), ("すべて", "*.*")])
if not path:
return
rows = self.conn.execute(
"SELECT name,phone,email,address,company FROM contacts"
).fetchall()
with open(path, "w", encoding="utf-8") as f:
for name, phone, email, addr, company in rows:
f.write("BEGIN:VCARD\nVERSION:3.0\n")
f.write(f"FN:{name}\n")
if phone:
f.write(f"TEL:{phone}\n")
if email:
f.write(f"EMAIL:{email}\n")
if addr:
f.write(f"ADR:;;{addr};;;;\n")
if company:
f.write(f"ORG:{company}\n")
f.write("END:VCARD\n\n")
messagebox.showinfo("完了", f"vCardエクスポート: {len(rows)} 件\n{path}")
def _sort(self, col):
data = [(self.tree.set(k, col), k) for k in self.tree.get_children()]
data.sort()
for idx, (_, k) in enumerate(data):
self.tree.move(k, "", idx)
if __name__ == "__main__":
root = tk.Tk()
app = App21(root)
root.mainloop()
Entryウィジェットとイベントバインド
ttk.Entryで入力フィールドを作成します。bind('
import tkinter as tk
from tkinter import ttk, messagebox, filedialog
import sqlite3
import os
from datetime import datetime
class App21:
"""連絡先帳（検索機能付き）"""
DB_PATH = os.path.join(os.path.dirname(__file__), "contacts.db")
def __init__(self, root):
self.root = root
self.root.title("連絡先帳")
self.root.geometry("860x560")
self.root.configure(bg="#f8f9fc")
self._init_db()
self._build_ui()
self._load_contacts()
def _init_db(self):
self.conn = sqlite3.connect(self.DB_PATH)
self.conn.execute("""
CREATE TABLE IF NOT EXISTS contacts (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
phone TEXT,
email TEXT,
address TEXT,
birthday TEXT,
company TEXT,
notes TEXT,
group_name TEXT,
created_at TEXT
)
""")
self.conn.commit()
if not self.conn.execute("SELECT 1 FROM contacts").fetchone():
samples = [
("山田太郎", "090-1234-5678", "taro@example.com",
"東京都新宿区", "1990-05-15", "ABC株式会社", "", "仕事"),
("田中花子", "080-9876-5432", "hanako@example.com",
"大阪府大阪市", "1988-12-03", "", "", "友人"),
("佐藤次郎", "070-1111-2222", "jiro@example.com",
"神奈川県横浜市", "", "XYZ商事", "", "仕事"),
]
for s in samples:
self.conn.execute(
"INSERT INTO contacts (name,phone,email,address,birthday,"
"company,notes,group_name,created_at) VALUES (?,?,?,?,?,?,?,?,?)",
(*s, datetime.now().isoformat()))
self.conn.commit()
def _build_ui(self):
title_frame = tk.Frame(self.root, bg="#1976d2", pady=10)
title_frame.pack(fill=tk.X)
tk.Label(title_frame, text="📇 連絡先帳",
font=("Noto Sans JP", 15, "bold"),
bg="#1976d2", fg="white").pack(side=tk.LEFT, padx=12)
ttk.Button(title_frame, text="📤 vCardエクスポート",
command=self._export_vcard).pack(side=tk.RIGHT, padx=8)
# 検索バー
search_frame = tk.Frame(self.root, bg="#e8eef5", pady=6)
search_frame.pack(fill=tk.X)
tk.Label(search_frame, text="🔍 インクリメンタル検索:",
bg="#e8eef5").pack(side=tk.LEFT, padx=8)
self.search_var = tk.StringVar()
search_entry = ttk.Entry(search_frame, textvariable=self.search_var,
width=28, font=("Arial", 11))
search_entry.pack(side=tk.LEFT, padx=4)
self.search_var.trace_add("write", lambda *a: self._load_contacts())
search_entry.focus_set()
tk.Label(search_frame, text="グループ:",
bg="#e8eef5").pack(side=tk.LEFT, padx=(12, 4))
self.group_var = tk.StringVar(value="すべて")
self.group_cb = ttk.Combobox(search_frame, textvariable=self.group_var,
state="readonly", width=12)
self.group_cb.pack(side=tk.LEFT)
self.group_cb.bind("<<ComboboxSelected>>", lambda e: self._load_contacts())
# メインエリア
main = tk.Frame(self.root, bg="#f8f9fc")
main.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# 左: 連絡先リスト
list_frame = ttk.LabelFrame(main, text="連絡先一覧", padding=4)
list_frame.pack(side=tk.LEFT, fill=tk.BOTH, expand=True)
cols = ("name", "phone", "email", "company", "group_name")
self.tree = ttk.Treeview(list_frame, columns=cols,
show="headings", selectmode="browse")
for c, h, w in [("name", "名前", 120), ("phone", "電話", 110),
("email", "メール", 160), ("company", "会社", 110),
("group_name", "グループ", 70)]:
self.tree.heading(c, text=h,
command=lambda c=c: self._sort(c))
self.tree.column(c, width=w, minwidth=40)
sb = ttk.Scrollbar(list_frame, command=self.tree.yview)
self.tree.configure(yscrollcommand=sb.set)
sb.pack(side=tk.RIGHT, fill=tk.Y)
self.tree.pack(fill=tk.BOTH, expand=True)
self.tree.bind("<<TreeviewSelect>>", self._on_select)
# 右: 詳細・編集
right = ttk.LabelFrame(main, text="詳細・編集", padding=10)
right.pack(side=tk.RIGHT, fill=tk.Y, padx=(8, 0))
right.configure(width=260)
fields = [("名前", "name"), ("電話", "phone"), ("メール", "email"),
("住所", "address"), ("誕生日", "birthday"),
("会社", "company"), ("グループ", "group_edit")]
for lbl, attr in fields:
tk.Label(right, text=f"{lbl}:").pack(anchor="w")
var = tk.StringVar()
ttk.Entry(right, textvariable=var, width=26).pack(
anchor="w", pady=1)
setattr(self, f"{attr}_var", var)
tk.Label(right, text="メモ:").pack(anchor="w")
self.notes_text = tk.Text(right, height=3, width=26, font=("Arial", 10))
self.notes_text.pack(anchor="w", pady=1)
btn_f = tk.Frame(right, bg=right.cget("background"))
btn_f.pack(fill=tk.X, pady=6)
for text, cmd in [("➕ 追加", self._add_contact),
("✏️ 更新", self._update_contact),
("🗑️ 削除", self._delete_contact)]:
ttk.Button(btn_f, text=text, command=cmd).pack(side=tk.LEFT, padx=2)
self.status_var = tk.StringVar(value="")
tk.Label(self.root, textvariable=self.status_var,
bg="#dde", font=("Arial", 9), anchor="w", padx=8
).pack(fill=tk.X, side=tk.BOTTOM)
self._selected_id = None
def _load_contacts(self):
q = self.search_var.get().lower()
group = self.group_var.get()
sql = ("SELECT id,name,phone,email,company,group_name "
"FROM contacts WHERE 1=1")
params = []
if q:
sql += (" AND (LOWER(name) LIKE ? OR LOWER(phone) LIKE ? "
"OR LOWER(email) LIKE ? OR LOWER(company) LIKE ?)")
params += [f"%{q}%"] * 4
if group != "すべて":
sql += " AND group_name=?"
params.append(group)
sql += " ORDER BY name COLLATE NOCASE"
rows = self.conn.execute(sql, params).fetchall()
self.tree.delete(*self.tree.get_children())
for row in rows:
cid, *vals = row
self.tree.insert("", "end", iid=str(cid), values=vals)
self.status_var.set(f"{len(rows)} 件")
# グループ一覧更新
groups = self.conn.execute(
"SELECT DISTINCT group_name FROM contacts "
"WHERE group_name != '' ORDER BY group_name").fetchall()
self.group_cb.configure(
values=["すべて"] + [g[0] for g in groups])
def _on_select(self, event):
sel = self.tree.selection()
if not sel:
return
cid = int(sel[0])
self._selected_id = cid
row = self.conn.execute(
"SELECT name,phone,email,address,birthday,company,group_name,notes "
"FROM contacts WHERE id=?", (cid,)).fetchone()
if row:
(name, phone, email, addr, bday,
company, group, notes) = row
self.name_var.set(name)
self.phone_var.set(phone or "")
self.email_var.set(email or "")
self.address_var.set(addr or "")
self.birthday_var.set(bday or "")
self.company_var.set(company or "")
self.group_edit_var.set(group or "")
self.notes_text.delete("1.0", tk.END)
self.notes_text.insert("1.0", notes or "")
def _add_contact(self):
name = self.name_var.get().strip()
if not name:
messagebox.showwarning("警告", "名前を入力してください")
return
self.conn.execute(
"INSERT INTO contacts (name,phone,email,address,birthday,"
"company,group_name,notes,created_at) VALUES (?,?,?,?,?,?,?,?,?)",
(name, self.phone_var.get(), self.email_var.get(),
self.address_var.get(), self.birthday_var.get(),
self.company_var.get(), self.group_edit_var.get(),
self.notes_text.get("1.0", tk.END).strip(),
datetime.now().isoformat()))
self.conn.commit()
self._load_contacts()
def _update_contact(self):
if not self._selected_id:
return
self.conn.execute(
"UPDATE contacts SET name=?,phone=?,email=?,address=?,birthday=?,"
"company=?,group_name=?,notes=? WHERE id=?",
(self.name_var.get(), self.phone_var.get(), self.email_var.get(),
self.address_var.get(), self.birthday_var.get(),
self.company_var.get(), self.group_edit_var.get(),
self.notes_text.get("1.0", tk.END).strip(),
self._selected_id))
self.conn.commit()
self._load_contacts()
def _delete_contact(self):
if not self._selected_id:
return
if messagebox.askyesno("確認", "この連絡先を削除しますか?"):
self.conn.execute("DELETE FROM contacts WHERE id=?",
(self._selected_id,))
self.conn.commit()
self._selected_id = None
self._load_contacts()
def _export_vcard(self):
path = filedialog.asksaveasfilename(
defaultextension=".vcf",
filetypes=[("vCardファイル", "*.vcf"), ("すべて", "*.*")])
if not path:
return
rows = self.conn.execute(
"SELECT name,phone,email,address,company FROM contacts"
).fetchall()
with open(path, "w", encoding="utf-8") as f:
for name, phone, email, addr, company in rows:
f.write("BEGIN:VCARD\nVERSION:3.0\n")
f.write(f"FN:{name}\n")
if phone:
f.write(f"TEL:{phone}\n")
if email:
f.write(f"EMAIL:{email}\n")
if addr:
f.write(f"ADR:;;{addr};;;;\n")
if company:
f.write(f"ORG:{company}\n")
f.write("END:VCARD\n\n")
messagebox.showinfo("完了", f"vCardエクスポート: {len(rows)} 件\n{path}")
def _sort(self, col):
data = [(self.tree.set(k, col), k) for k in self.tree.get_children()]
data.sort()
for idx, (_, k) in enumerate(data):
self.tree.move(k, "", idx)
if __name__ == "__main__":
root = tk.Tk()
app = App21(root)
root.mainloop()
Textウィジェットでの結果表示
結果表示にはtk.Textウィジェットを使います。state=tk.DISABLEDでユーザーが直接編集できないようにし、表示前にNORMALに切り替えてからinsert()で内容を更新します。
import tkinter as tk
from tkinter import ttk, messagebox, filedialog
import sqlite3
import os
from datetime import datetime
class App21:
"""連絡先帳（検索機能付き）"""
DB_PATH = os.path.join(os.path.dirname(__file__), "contacts.db")
def __init__(self, root):
self.root = root
self.root.title("連絡先帳")
self.root.geometry("860x560")
self.root.configure(bg="#f8f9fc")
self._init_db()
self._build_ui()
self._load_contacts()
def _init_db(self):
self.conn = sqlite3.connect(self.DB_PATH)
self.conn.execute("""
CREATE TABLE IF NOT EXISTS contacts (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
phone TEXT,
email TEXT,
address TEXT,
birthday TEXT,
company TEXT,
notes TEXT,
group_name TEXT,
created_at TEXT
)
""")
self.conn.commit()
if not self.conn.execute("SELECT 1 FROM contacts").fetchone():
samples = [
("山田太郎", "090-1234-5678", "taro@example.com",
"東京都新宿区", "1990-05-15", "ABC株式会社", "", "仕事"),
("田中花子", "080-9876-5432", "hanako@example.com",
"大阪府大阪市", "1988-12-03", "", "", "友人"),
("佐藤次郎", "070-1111-2222", "jiro@example.com",
"神奈川県横浜市", "", "XYZ商事", "", "仕事"),
]
for s in samples:
self.conn.execute(
"INSERT INTO contacts (name,phone,email,address,birthday,"
"company,notes,group_name,created_at) VALUES (?,?,?,?,?,?,?,?,?)",
(*s, datetime.now().isoformat()))
self.conn.commit()
def _build_ui(self):
title_frame = tk.Frame(self.root, bg="#1976d2", pady=10)
title_frame.pack(fill=tk.X)
tk.Label(title_frame, text="📇 連絡先帳",
font=("Noto Sans JP", 15, "bold"),
bg="#1976d2", fg="white").pack(side=tk.LEFT, padx=12)
ttk.Button(title_frame, text="📤 vCardエクスポート",
command=self._export_vcard).pack(side=tk.RIGHT, padx=8)
# 検索バー
search_frame = tk.Frame(self.root, bg="#e8eef5", pady=6)
search_frame.pack(fill=tk.X)
tk.Label(search_frame, text="🔍 インクリメンタル検索:",
bg="#e8eef5").pack(side=tk.LEFT, padx=8)
self.search_var = tk.StringVar()
search_entry = ttk.Entry(search_frame, textvariable=self.search_var,
width=28, font=("Arial", 11))
search_entry.pack(side=tk.LEFT, padx=4)
self.search_var.trace_add("write", lambda *a: self._load_contacts())
search_entry.focus_set()
tk.Label(search_frame, text="グループ:",
bg="#e8eef5").pack(side=tk.LEFT, padx=(12, 4))
self.group_var = tk.StringVar(value="すべて")
self.group_cb = ttk.Combobox(search_frame, textvariable=self.group_var,
state="readonly", width=12)
self.group_cb.pack(side=tk.LEFT)
self.group_cb.bind("<<ComboboxSelected>>", lambda e: self._load_contacts())
# メインエリア
main = tk.Frame(self.root, bg="#f8f9fc")
main.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# 左: 連絡先リスト
list_frame = ttk.LabelFrame(main, text="連絡先一覧", padding=4)
list_frame.pack(side=tk.LEFT, fill=tk.BOTH, expand=True)
cols = ("name", "phone", "email", "company", "group_name")
self.tree = ttk.Treeview(list_frame, columns=cols,
show="headings", selectmode="browse")
for c, h, w in [("name", "名前", 120), ("phone", "電話", 110),
("email", "メール", 160), ("company", "会社", 110),
("group_name", "グループ", 70)]:
self.tree.heading(c, text=h,
command=lambda c=c: self._sort(c))
self.tree.column(c, width=w, minwidth=40)
sb = ttk.Scrollbar(list_frame, command=self.tree.yview)
self.tree.configure(yscrollcommand=sb.set)
sb.pack(side=tk.RIGHT, fill=tk.Y)
self.tree.pack(fill=tk.BOTH, expand=True)
self.tree.bind("<<TreeviewSelect>>", self._on_select)
# 右: 詳細・編集
right = ttk.LabelFrame(main, text="詳細・編集", padding=10)
right.pack(side=tk.RIGHT, fill=tk.Y, padx=(8, 0))
right.configure(width=260)
fields = [("名前", "name"), ("電話", "phone"), ("メール", "email"),
("住所", "address"), ("誕生日", "birthday"),
("会社", "company"), ("グループ", "group_edit")]
for lbl, attr in fields:
tk.Label(right, text=f"{lbl}:").pack(anchor="w")
var = tk.StringVar()
ttk.Entry(right, textvariable=var, width=26).pack(
anchor="w", pady=1)
setattr(self, f"{attr}_var", var)
tk.Label(right, text="メモ:").pack(anchor="w")
self.notes_text = tk.Text(right, height=3, width=26, font=("Arial", 10))
self.notes_text.pack(anchor="w", pady=1)
btn_f = tk.Frame(right, bg=right.cget("background"))
btn_f.pack(fill=tk.X, pady=6)
for text, cmd in [("➕ 追加", self._add_contact),
("✏️ 更新", self._update_contact),
("🗑️ 削除", self._delete_contact)]:
ttk.Button(btn_f, text=text, command=cmd).pack(side=tk.LEFT, padx=2)
self.status_var = tk.StringVar(value="")
tk.Label(self.root, textvariable=self.status_var,
bg="#dde", font=("Arial", 9), anchor="w", padx=8
).pack(fill=tk.X, side=tk.BOTTOM)
self._selected_id = None
def _load_contacts(self):
q = self.search_var.get().lower()
group = self.group_var.get()
sql = ("SELECT id,name,phone,email,company,group_name "
"FROM contacts WHERE 1=1")
params = []
if q:
sql += (" AND (LOWER(name) LIKE ? OR LOWER(phone) LIKE ? "
"OR LOWER(email) LIKE ? OR LOWER(company) LIKE ?)")
params += [f"%{q}%"] * 4
if group != "すべて":
sql += " AND group_name=?"
params.append(group)
sql += " ORDER BY name COLLATE NOCASE"
rows = self.conn.execute(sql, params).fetchall()
self.tree.delete(*self.tree.get_children())
for row in rows:
cid, *vals = row
self.tree.insert("", "end", iid=str(cid), values=vals)
self.status_var.set(f"{len(rows)} 件")
# グループ一覧更新
groups = self.conn.execute(
"SELECT DISTINCT group_name FROM contacts "
"WHERE group_name != '' ORDER BY group_name").fetchall()
self.group_cb.configure(
values=["すべて"] + [g[0] for g in groups])
def _on_select(self, event):
sel = self.tree.selection()
if not sel:
return
cid = int(sel[0])
self._selected_id = cid
row = self.conn.execute(
"SELECT name,phone,email,address,birthday,company,group_name,notes "
"FROM contacts WHERE id=?", (cid,)).fetchone()
if row:
(name, phone, email, addr, bday,
company, group, notes) = row
self.name_var.set(name)
self.phone_var.set(phone or "")
self.email_var.set(email or "")
self.address_var.set(addr or "")
self.birthday_var.set(bday or "")
self.company_var.set(company or "")
self.group_edit_var.set(group or "")
self.notes_text.delete("1.0", tk.END)
self.notes_text.insert("1.0", notes or "")
def _add_contact(self):
name = self.name_var.get().strip()
if not name:
messagebox.showwarning("警告", "名前を入力してください")
return
self.conn.execute(
"INSERT INTO contacts (name,phone,email,address,birthday,"
"company,group_name,notes,created_at) VALUES (?,?,?,?,?,?,?,?,?)",
(name, self.phone_var.get(), self.email_var.get(),
self.address_var.get(), self.birthday_var.get(),
self.company_var.get(), self.group_edit_var.get(),
self.notes_text.get("1.0", tk.END).strip(),
datetime.now().isoformat()))
self.conn.commit()
self._load_contacts()
def _update_contact(self):
if not self._selected_id:
return
self.conn.execute(
"UPDATE contacts SET name=?,phone=?,email=?,address=?,birthday=?,"
"company=?,group_name=?,notes=? WHERE id=?",
(self.name_var.get(), self.phone_var.get(), self.email_var.get(),
self.address_var.get(), self.birthday_var.get(),
self.company_var.get(), self.group_edit_var.get(),
self.notes_text.get("1.0", tk.END).strip(),
self._selected_id))
self.conn.commit()
self._load_contacts()
def _delete_contact(self):
if not self._selected_id:
return
if messagebox.askyesno("確認", "この連絡先を削除しますか?"):
self.conn.execute("DELETE FROM contacts WHERE id=?",
(self._selected_id,))
self.conn.commit()
self._selected_id = None
self._load_contacts()
def _export_vcard(self):
path = filedialog.asksaveasfilename(
defaultextension=".vcf",
filetypes=[("vCardファイル", "*.vcf"), ("すべて", "*.*")])
if not path:
return
rows = self.conn.execute(
"SELECT name,phone,email,address,company FROM contacts"
).fetchall()
with open(path, "w", encoding="utf-8") as f:
for name, phone, email, addr, company in rows:
f.write("BEGIN:VCARD\nVERSION:3.0\n")
f.write(f"FN:{name}\n")
if phone:
f.write(f"TEL:{phone}\n")
if email:
f.write(f"EMAIL:{email}\n")
if addr:
f.write(f"ADR:;;{addr};;;;\n")
if company:
f.write(f"ORG:{company}\n")
f.write("END:VCARD\n\n")
messagebox.showinfo("完了", f"vCardエクスポート: {len(rows)} 件\n{path}")
def _sort(self, col):
data = [(self.tree.set(k, col), k) for k in self.tree.get_children()]
data.sort()
for idx, (_, k) in enumerate(data):
self.tree.move(k, "", idx)
if __name__ == "__main__":
root = tk.Tk()
app = App21(root)
root.mainloop()
例外処理とmessagebox
try-except で ValueError と Exception を捕捉し、messagebox.showerror() でユーザーにわかりやすいエラーメッセージを表示します。入力バリデーションは必ず実装しましょう。
import tkinter as tk
from tkinter import ttk, messagebox, filedialog
import sqlite3
import os
from datetime import datetime
class App21:
"""連絡先帳（検索機能付き）"""
DB_PATH = os.path.join(os.path.dirname(__file__), "contacts.db")
def __init__(self, root):
self.root = root
self.root.title("連絡先帳")
self.root.geometry("860x560")
self.root.configure(bg="#f8f9fc")
self._init_db()
self._build_ui()
self._load_contacts()
def _init_db(self):
self.conn = sqlite3.connect(self.DB_PATH)
self.conn.execute("""
CREATE TABLE IF NOT EXISTS contacts (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
phone TEXT,
email TEXT,
address TEXT,
birthday TEXT,
company TEXT,
notes TEXT,
group_name TEXT,
created_at TEXT
)
""")
self.conn.commit()
if not self.conn.execute("SELECT 1 FROM contacts").fetchone():
samples = [
("山田太郎", "090-1234-5678", "taro@example.com",
"東京都新宿区", "1990-05-15", "ABC株式会社", "", "仕事"),
("田中花子", "080-9876-5432", "hanako@example.com",
"大阪府大阪市", "1988-12-03", "", "", "友人"),
("佐藤次郎", "070-1111-2222", "jiro@example.com",
"神奈川県横浜市", "", "XYZ商事", "", "仕事"),
]
for s in samples:
self.conn.execute(
"INSERT INTO contacts (name,phone,email,address,birthday,"
"company,notes,group_name,created_at) VALUES (?,?,?,?,?,?,?,?,?)",
(*s, datetime.now().isoformat()))
self.conn.commit()
def _build_ui(self):
title_frame = tk.Frame(self.root, bg="#1976d2", pady=10)
title_frame.pack(fill=tk.X)
tk.Label(title_frame, text="📇 連絡先帳",
font=("Noto Sans JP", 15, "bold"),
bg="#1976d2", fg="white").pack(side=tk.LEFT, padx=12)
ttk.Button(title_frame, text="📤 vCardエクスポート",
command=self._export_vcard).pack(side=tk.RIGHT, padx=8)
# 検索バー
search_frame = tk.Frame(self.root, bg="#e8eef5", pady=6)
search_frame.pack(fill=tk.X)
tk.Label(search_frame, text="🔍 インクリメンタル検索:",
bg="#e8eef5").pack(side=tk.LEFT, padx=8)
self.search_var = tk.StringVar()
search_entry = ttk.Entry(search_frame, textvariable=self.search_var,
width=28, font=("Arial", 11))
search_entry.pack(side=tk.LEFT, padx=4)
self.search_var.trace_add("write", lambda *a: self._load_contacts())
search_entry.focus_set()
tk.Label(search_frame, text="グループ:",
bg="#e8eef5").pack(side=tk.LEFT, padx=(12, 4))
self.group_var = tk.StringVar(value="すべて")
self.group_cb = ttk.Combobox(search_frame, textvariable=self.group_var,
state="readonly", width=12)
self.group_cb.pack(side=tk.LEFT)
self.group_cb.bind("<<ComboboxSelected>>", lambda e: self._load_contacts())
# メインエリア
main = tk.Frame(self.root, bg="#f8f9fc")
main.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# 左: 連絡先リスト
list_frame = ttk.LabelFrame(main, text="連絡先一覧", padding=4)
list_frame.pack(side=tk.LEFT, fill=tk.BOTH, expand=True)
cols = ("name", "phone", "email", "company", "group_name")
self.tree = ttk.Treeview(list_frame, columns=cols,
show="headings", selectmode="browse")
for c, h, w in [("name", "名前", 120), ("phone", "電話", 110),
("email", "メール", 160), ("company", "会社", 110),
("group_name", "グループ", 70)]:
self.tree.heading(c, text=h,
command=lambda c=c: self._sort(c))
self.tree.column(c, width=w, minwidth=40)
sb = ttk.Scrollbar(list_frame, command=self.tree.yview)
self.tree.configure(yscrollcommand=sb.set)
sb.pack(side=tk.RIGHT, fill=tk.Y)
self.tree.pack(fill=tk.BOTH, expand=True)
self.tree.bind("<<TreeviewSelect>>", self._on_select)
# 右: 詳細・編集
right = ttk.LabelFrame(main, text="詳細・編集", padding=10)
right.pack(side=tk.RIGHT, fill=tk.Y, padx=(8, 0))
right.configure(width=260)
fields = [("名前", "name"), ("電話", "phone"), ("メール", "email"),
("住所", "address"), ("誕生日", "birthday"),
("会社", "company"), ("グループ", "group_edit")]
for lbl, attr in fields:
tk.Label(right, text=f"{lbl}:").pack(anchor="w")
var = tk.StringVar()
ttk.Entry(right, textvariable=var, width=26).pack(
anchor="w", pady=1)
setattr(self, f"{attr}_var", var)
tk.Label(right, text="メモ:").pack(anchor="w")
self.notes_text = tk.Text(right, height=3, width=26, font=("Arial", 10))
self.notes_text.pack(anchor="w", pady=1)
btn_f = tk.Frame(right, bg=right.cget("background"))
btn_f.pack(fill=tk.X, pady=6)
for text, cmd in [("➕ 追加", self._add_contact),
("✏️ 更新", self._update_contact),
("🗑️ 削除", self._delete_contact)]:
ttk.Button(btn_f, text=text, command=cmd).pack(side=tk.LEFT, padx=2)
self.status_var = tk.StringVar(value="")
tk.Label(self.root, textvariable=self.status_var,
bg="#dde", font=("Arial", 9), anchor="w", padx=8
).pack(fill=tk.X, side=tk.BOTTOM)
self._selected_id = None
def _load_contacts(self):
q = self.search_var.get().lower()
group = self.group_var.get()
sql = ("SELECT id,name,phone,email,company,group_name "
"FROM contacts WHERE 1=1")
params = []
if q:
sql += (" AND (LOWER(name) LIKE ? OR LOWER(phone) LIKE ? "
"OR LOWER(email) LIKE ? OR LOWER(company) LIKE ?)")
params += [f"%{q}%"] * 4
if group != "すべて":
sql += " AND group_name=?"
params.append(group)
sql += " ORDER BY name COLLATE NOCASE"
rows = self.conn.execute(sql, params).fetchall()
self.tree.delete(*self.tree.get_children())
for row in rows:
cid, *vals = row
self.tree.insert("", "end", iid=str(cid), values=vals)
self.status_var.set(f"{len(rows)} 件")
# グループ一覧更新
groups = self.conn.execute(
"SELECT DISTINCT group_name FROM contacts "
"WHERE group_name != '' ORDER BY group_name").fetchall()
self.group_cb.configure(
values=["すべて"] + [g[0] for g in groups])
def _on_select(self, event):
sel = self.tree.selection()
if not sel:
return
cid = int(sel[0])
self._selected_id = cid
row = self.conn.execute(
"SELECT name,phone,email,address,birthday,company,group_name,notes "
"FROM contacts WHERE id=?", (cid,)).fetchone()
if row:
(name, phone, email, addr, bday,
company, group, notes) = row
self.name_var.set(name)
self.phone_var.set(phone or "")
self.email_var.set(email or "")
self.address_var.set(addr or "")
self.birthday_var.set(bday or "")
self.company_var.set(company or "")
self.group_edit_var.set(group or "")
self.notes_text.delete("1.0", tk.END)
self.notes_text.insert("1.0", notes or "")
def _add_contact(self):
name = self.name_var.get().strip()
if not name:
messagebox.showwarning("警告", "名前を入力してください")
return
self.conn.execute(
"INSERT INTO contacts (name,phone,email,address,birthday,"
"company,group_name,notes,created_at) VALUES (?,?,?,?,?,?,?,?,?)",
(name, self.phone_var.get(), self.email_var.get(),
self.address_var.get(), self.birthday_var.get(),
self.company_var.get(), self.group_edit_var.get(),
self.notes_text.get("1.0", tk.END).strip(),
datetime.now().isoformat()))
self.conn.commit()
self._load_contacts()
def _update_contact(self):
if not self._selected_id:
return
self.conn.execute(
"UPDATE contacts SET name=?,phone=?,email=?,address=?,birthday=?,"
"company=?,group_name=?,notes=? WHERE id=?",
(self.name_var.get(), self.phone_var.get(), self.email_var.get(),
self.address_var.get(), self.birthday_var.get(),
self.company_var.get(), self.group_edit_var.get(),
self.notes_text.get("1.0", tk.END).strip(),
self._selected_id))
self.conn.commit()
self._load_contacts()
def _delete_contact(self):
if not self._selected_id:
return
if messagebox.askyesno("確認", "この連絡先を削除しますか?"):
self.conn.execute("DELETE FROM contacts WHERE id=?",
(self._selected_id,))
self.conn.commit()
self._selected_id = None
self._load_contacts()
def _export_vcard(self):
path = filedialog.asksaveasfilename(
defaultextension=".vcf",
filetypes=[("vCardファイル", "*.vcf"), ("すべて", "*.*")])
if not path:
return
rows = self.conn.execute(
"SELECT name,phone,email,address,company FROM contacts"
).fetchall()
with open(path, "w", encoding="utf-8") as f:
for name, phone, email, addr, company in rows:
f.write("BEGIN:VCARD\nVERSION:3.0\n")
f.write(f"FN:{name}\n")
if phone:
f.write(f"TEL:{phone}\n")
if email:
f.write(f"EMAIL:{email}\n")
if addr:
f.write(f"ADR:;;{addr};;;;\n")
if company:
f.write(f"ORG:{company}\n")
f.write("END:VCARD\n\n")
messagebox.showinfo("完了", f"vCardエクスポート: {len(rows)} 件\n{path}")
def _sort(self, col):
data = [(self.tree.set(k, col), k) for k in self.tree.get_children()]
data.sort()
for idx, (_, k) in enumerate(data):
self.tree.move(k, "", idx)
if __name__ == "__main__":
root = tk.Tk()
app = App21(root)
root.mainloop()
6. ステップバイステップガイド
このアプリをゼロから自分で作る手順を解説します。コードをコピーするだけでなく、実際に手順を追って自分で書いてみましょう。
-
1ファイルを作成する
新しいファイルを作成して app21.py と保存します。
-
2クラスの骨格を作る
App21クラスを定義し、__init__とmainloop()の最小構成を作ります。
-
3タイトルバーを作る
Frameを使ってカラーバー付きのタイトルエリアを作ります。
-
4入力フォームを実装する
LabelFrameとEntryウィジェットで入力エリアを作ります。
-
5処理ロジックを実装する
_calculate()メソッドに計算・処理ロジックを実装します。
-
6結果表示を実装する
TextウィジェットかLabelに結果を表示する_show_result()を実装します。
-
7エラー処理を追加する
try-exceptとmessageboxでエラーハンドリングを追加します。
7. カスタマイズアイデア
基本機能を習得したら、以下のカスタマイズに挑戦してみましょう。少しずつ機能を追加することで、Pythonのスキルが飛躍的に向上します。
💡 ダークモードを追加する
bg色・fg色を辞書で管理し、ボタン1つでダークモード・ライトモードを切り替えられるようにしましょう。
💡 データのエクスポート機能
計算結果をCSV・TXTファイルに保存するエクスポート機能を追加しましょう。filedialog.asksaveasfilename()でファイル保存ダイアログが使えます。
💡 入力履歴機能
以前の入力値を覚えておいてComboboxのドロップダウンで再選択できる履歴機能を追加しましょう。
8. よくある問題と解決法
❌ 日本語フォントが表示されない
原因：システムに日本語フォントが見つからない場合があります。
解決法：font引数を省略するかシステムに合ったフォントを指定してください。
❌ ウィンドウのサイズが変更できない
原因：resizable(False, False)が設定されています。
解決法：resizable(True, True)に変更してください。
9. 練習問題
アプリの理解を深めるための練習問題です。難易度順に挑戦してみてください。
-
課題1：機能拡張
連絡先帳（検索機能付き）に新しい機能を1つ追加してみましょう。どんな機能があると便利か考えてから実装してください。
-
課題2：UIの改善
色・フォント・レイアウトを変更して、より使いやすいUIにカスタマイズしてみましょう。
-
課題3：保存機能の追加
入力値や計算結果をファイルに保存する機能を追加しましょう。jsonやcsvモジュールを使います。