锦中迎新管理系统

CREATE TABLE Students (

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(100) NOT NULL,

student_id VARCHAR(20) UNIQUE NOT NULL,

major VARCHAR(100),

phone_number VARCHAR(15)

);

from sqlalchemy import create_engine, Column, Integer, String

from sqlalchemy.ext.declarative import declarative_base

from sqlalchemy.orm import sessionmaker

Base = declarative_base()

class Student(Base):

__tablename__ = 'students'

id = Column(Integer, primary_key=True)

name = Column(String(100), nullable=False)

student_id = Column(String(20), unique=True, nullable=False)

major = Column(String(100))

phone_number = Column(String(15))

engine = create_engine('mysql+pymysql://username:password@localhost/dbname')

Session = sessionmaker(bind=engine)

session = Session()

实训实习管理系统

new_student = Student(name='张三', student_id='123456', major='计算机科学', phone_number='13800000000')

session.add(new_student)

session.commit()