学生信息管理系统

CREATE TABLE Student (

student_id INT PRIMARY KEY,

name VARCHAR(100),

major VARCHAR(100),

grade INT

);

CREATE TABLE Scholarship (

scholarship_id INT PRIMARY KEY,

name VARCHAR(100),

amount DECIMAL(10,2),

description TEXT

);

CREATE TABLE Scholarship_Application (

application_id INT PRIMARY KEY AUTO_INCREMENT,

student_id INT,

scholarship_id INT,

status ENUM('Pending', 'Approved', 'Rejected'),

FOREIGN KEY (student_id) REFERENCES Student(student_id),

FOREIGN KEY (scholarship_id) REFERENCES Scholarship(scholarship_id)

);

from flask import Flask, request, jsonify

from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)

app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql+pymysql://username:password@localhost/db_name'

db = SQLAlchemy(app)

class Student(db.Model):

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

name = db.Column(db.String(100))

major = db.Column(db.String(100))

grade = db.Column(db.Integer)

class Scholarship(db.Model):

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

name = db.Column(db.String(100))

amount = db.Column(db.DECIMAL(10,2))

description = db.Column(db.Text)

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

def apply_scholarship():

data = request.json

new_application = Scholarship_Application(

student_id=data['student_id'],

scholarship_id=data['scholarship_id'],

status='Pending'

)

db.session.add(new_application)

db.session.commit()

return jsonify({"message": "Application submitted successfully."}), 201

if __name__ == '__main__':

app.run(debug=True)