学生信息管理系统

import sqlite3

conn = sqlite3.connect('student.db')

cursor = conn.cursor()

cursor.execute('''CREATE TABLE IF NOT EXISTS students

(id INTEGER PRIMARY KEY, name TEXT, gender TEXT, birth DATE, school TEXT)''')

cursor.execute("INSERT INTO students (name, gender, birth, school) VALUES (?, ?, ?, ?)",

('张三', '男', '2005-05-05', '江苏省某中学'))

conn.commit()

conn.close()