import sqlite3

def create_connection(db_file):

""" 创建数据库连接 """

conn = None

try:

conn = sqlite3.connect(db_file)

print(f"成功连接到数据库 {db_file}")

except Exception as e:

print(e)

return conn

]]>

def create_tables(conn):

""" 创建学生和成绩表 """

cursor = conn.cursor()

cursor.execute('''

CREATE TABLE IF NOT EXISTS students (

id INTEGER PRIMARY KEY AUTOINCREMENT,

name TEXT NOT NULL,

gender TEXT,

major TEXT,

enrollment_year INTEGER

);

''')

cursor.execute('''

数据管理

CREATE TABLE IF NOT EXISTS scores (

student_id INTEGER,

course_id INTEGER,

score REAL,

FOREIGN KEY (student_id) REFERENCES students(id),

FOREIGN KEY (course_id) REFERENCES courses(id)

);

''')

conn.commit()

print("表已创建")

]]>

def insert_test_data(conn):

""" 插入测试数据 """

cursor = conn.cursor()

cursor.execute("INSERT INTO students (name, gender, major, enrollment_year) VALUES (?, ?, ?, ?)",

("张三", "男", "计算机科学", 2020))

cursor.execute("INSERT INTO scores (student_id, course_id, score) VALUES (?, ?, ?)",

(1, 101, 95.5))

conn.commit()

print("数据插入完成")

]]>