一站式网上办事大厅

        from sqlalchemy import create_engine, Column, Integer, String, ForeignKey
        from sqlalchemy.ext.declarative import declarative_base
        from sqlalchemy.orm import sessionmaker

        Base = declarative_base()

        class Student(Base):
            __tablename__ = 'student_info'
            id = Column(Integer, primary_key=True)
            name = Column(String)
            major = Column(String)

        class Course(Base):
            __tablename__ = 'course_schedule'
            id = Column(Integer, primary_key=True)
            course_name = Column(String)
            time = Column(String)
            location = Column(String)
            student_id = Column(Integer, ForeignKey('student_info.id'))

        engine = create_engine('sqlite:///university.db')
        Session = sessionmaker(bind=engine)
        session = Session()

        # 查询某个学生的课表
        student_id = 1
        courses = session.query(Course).filter_by(student_id=student_id).all()
        for course in courses:
            print(course.course_name, course.time, course.location)
      

高职院校排课软件