# 导入必要的库
import sqlite3
# 创建数据库连接
conn = sqlite3.connect('job_management.db')
cursor = conn.cursor()
# 创建求职者表
cursor.execute('''
CREATE TABLE IF NOT EXISTS job_seeker (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
email TEXT UNIQUE,
phone TEXT
)
''')
# 插入示例数据
cursor.execute("INSERT INTO job_seeker (name, email, phone) VALUES (?, ?, ?)",
('Alice', 'alice@example.com', '123456789'))
conn.commit()
]]>