研究生管理信息系统的开发与需求分析

// 假设我们使用Python和SQLite数据库

import sqlite3

# 创建数据库连接

conn = sqlite3.connect('graduate_management.db')

cursor = conn.cursor()

# 创建研究生表

cursor.execute('''

CREATE TABLE IF NOT EXISTS students (

id INTEGER PRIMARY KEY,

name TEXT NOT NULL,

email TEXT UNIQUE NOT NULL,

major TEXT NOT NULL

)

''')

# 插入一条学生数据

cursor.execute("INSERT INTO students (name, email, major) VALUES (?, ?, ?)", ('Alice', 'alice@example.com', 'Computer Science'))

conn.commit()

conn.close()

]]>

// 使用Flask创建一个简单的API来获取学生信息

from flask import Flask, jsonify

app = Flask(__name__)

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

def get_student(student_id):

conn = sqlite3.connect('graduate_management.db')

cursor = conn.cursor()

cursor.execute("SELECT * FROM students WHERE id=?", (student_id,))

student = cursor.fetchone()

conn.close()

return jsonify({'id': student[0], 'name': student[1], 'email': student[2], 'major': student[3]})

if __name__ == '__main__':

app.run(debug=True)

]]>