<?python
# 导入必要的库
import sqlite3
from datetime import time
# 创建SQLite数据库连接
conn = sqlite3.connect('course_schedule.db')
cursor = conn.cursor()
# 创建课程表结构
cursor.execute('''
CREATE TABLE IF NOT EXISTS CourseSchedule (
id INTEGER PRIMARY KEY,
course_name TEXT NOT NULL,
teacher_name TEXT NOT NULL,
start_time TIME NOT NULL,
end_time TIME NOT NULL,
day_of_week INTEGER NOT NULL
)
''')
# 定义课程调度函数
def schedule_courses(courses):
# 简单的调度算法，仅做示例
for course in courses:
cursor.execute('INSERT INTO CourseSchedule (course_name, teacher_name, start_time, end_time, day_of_week) VALUES (?, ?, ?, ?, ?)',
(course['name'], course['teacher'], course['start_time'], course['end_time'], course['day_of_week']))
conn.commit()
# 示例数据
courses = [
{'name': '计算机网络', 'teacher': '张三', 'start_time': time(9, 0), 'end_time': time(11, 0), 'day_of_week': 1},
{'name': '数据库原理', 'teacher': '李四', 'start_time': time(14, 0), 'end_time': time(16, 0), 'day_of_week': 2}
]
# 调度课程
schedule_courses(courses)
# 查询课程
cursor.execute('SELECT * FROM CourseSchedule')
print(cursor.fetchall())
?>