import sqlite3

# 创建数据库连接

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

cursor = conn.cursor()

# 创建教师表

cursor.execute('''

CREATE TABLE teachers (

id INTEGER PRIMARY KEY AUTOINCREMENT,

name TEXT NOT NULL,

subject TEXT NOT NULL

)

''')

# 创建学生表

cursor.execute('''

CREATE TABLE students (

id INTEGER PRIMARY KEY AUTOINCREMENT,

name TEXT NOT NULL,

grade INTEGER NOT NULL

)

''')

# 创建教室表

cursor.execute('''

CREATE TABLE classrooms (

id INTEGER PRIMARY KEY AUTOINCREMENT,

room_number TEXT NOT NULL,

capacity INTEGER NOT NULL

)

''')

conn.commit()

conn.close()

]]>

def assign_courses(teachers, students, classrooms):

schedule = {}

for teacher in teachers:

available_rooms = [room for room in classrooms if room['capacity'] >= len(students)]

if available_rooms:

selected_room = min(available_rooms, key=lambda x: x['capacity'])

schedule[teacher] = {

在线排课软件

'room': selected_room,

'students': students

}

classrooms.remove(selected_room)

return schedule

]]>

from flask import Flask, render_template

app = Flask(__name__)

@app.route('/')

def index():

# 假设schedule已经生成

return render_template('schedule.html', schedule=schedule)

if __name__ == '__main__':

app.run(debug=True)

]]>