import sqlite3

# 初始化数据库

def init_db():

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

cursor = conn.cursor()

cursor.execute('''

CREATE TABLE IF NOT EXISTS courses (

id INTEGER PRIMARY KEY AUTOINCREMENT,

name TEXT NOT NULL,

teacher TEXT NOT NULL,

time_slot TEXT NOT NULL

)

''')

conn.commit()

conn.close()

# 添加课程

def add_course(name, teacher, time_slot):

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

cursor = conn.cursor()

cursor.execute('INSERT INTO courses (name, teacher, time_slot) VALUES (?, ?, ?)', (name, teacher, time_slot))

conn.commit()

conn.close()

# 查询所有课程

def list_courses():

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

cursor = conn.cursor()

cursor.execute('SELECT * FROM courses')

rows = cursor.fetchall()

for row in rows:

print(f"ID: {row[0]}, Name: {row[1]}, Teacher: {row[2]}, Time Slot: {row[3]}")

conn.close()

if __name__ == "__main__":

init_db()

add_course("Math", "Mr. Smith", "9:00-10:00")

add_course("Science", "Ms. Johnson", "10:00-11:00")

print("Courses added successfully!")

list_courses()

]]>

from kivy.app import App

from kivy.uix.boxlayout import BoxLayout

from kivy.properties import ObjectProperty

class ScheduleApp(App):

def build(self):

return ScheduleLayout()

class ScheduleLayout(BoxLayout):

course_name = ObjectProperty(None)

course_teacher = ObjectProperty(None)

course_time = ObjectProperty(None)

def add_course(self):

add_course(self.course_name.text, self.course_teacher.text, self.course_time.text)

self.course_name.text = ""

self.course_teacher.text = ""

self.course_time.text = ""

def list_courses(self):

list_courses()

if __name__ == '__main__':

ScheduleApp().run()

]]>