import sqlite3
def create_db():
conn = sqlite3.connect('teacher_system.db')
c = conn.cursor()
c.execute('''CREATE TABLE IF NOT EXISTS teachers (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
subject TEXT NOT NULL,
years_of_experience INTEGER)''')
conn.commit()
conn.close()
if __name__ == "__main__":
create_db()
]]>
def add_teacher(name, subject, years):
conn = sqlite3.connect('teacher_system.db')
c = conn.cursor()
c.execute("INSERT INTO teachers (name, subject, years_of_experience) VALUES (?, ?, ?)",
(name, subject, years))
conn.commit()
conn.close()
if __name__ == "__main__":
add_teacher('张三', '数学', 10)
]]>