网上办事大厅与学院的信息化融合实践

USE CollegeDB;

CREATE TABLE IF NOT EXISTS Students (

ID INT AUTO_INCREMENT PRIMARY KEY,

Name VARCHAR(100),

Age INT,

Major VARCHAR(100)

);

CREATE TABLE IF NOT EXISTS Teachers (

ID INT AUTO_INCREMENT PRIMARY KEY,

Name VARCHAR(100),

Department VARCHAR(100)

);

CREATE TABLE IF NOT EXISTS Courses (

ID INT AUTO_INCREMENT PRIMARY KEY,

CourseName VARCHAR(100),

TeacherID INT,

FOREIGN KEY (TeacherID) REFERENCES Teachers(ID)

);

import mysql.connector

app = Flask(__name__)

@app.route('/students', methods=['GET'])

def get_students():

conn = mysql.connector.connect(user='root', password='password', host='127.0.0.1', database='CollegeDB')

cursor = conn.cursor()

cursor.execute("SELECT * FROM Students")

students = cursor.fetchall()

conn.close()

return jsonify([{'id': student[0], 'name': student[1], 'age': student[2], 'major': student[3]} for student in students])

if __name__ == '__main__':

数据可视化平台

app.run(debug=True)