学生信息管理系统

from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy()

class Student(db.Model):

id = db.Column(db.Integer, primary_key=True)

name = db.Column(db.String(80), nullable=False)

age = db.Column(db.Integer, nullable=False)

major = db.Column(db.String(80), nullable=False)

def __repr__(self):

return f''

]]>

from flask import Flask, render_template, request, redirect, url_for

app = Flask(__name__)

app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///students.db'

db.init_app(app)

@app.route('/')

def index():

students = Student.query.all()

return render_template('index.html', students=students)

@app.route('/add_student', methods=['POST'])

def add_student():

name = request.form.get('name')

age = request.form.get('age')

major = request.form.get('major')

new_student = Student(name=name, age=age, major=major)

db.session.add(new_student)

db.session.commit()

return redirect(url_for('index'))

if __name__ == '__main__':

with app.app_context():

db.create_all()

app.run(debug=True)

]]>