基于研究生管理信息系统的师范大学技术实现

CREATE DATABASE GraduateManagement;

USE GraduateManagement;

CREATE TABLE Students (

student_id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(50) NOT NULL,

major VARCHAR(50),

email VARCHAR(100)

);

CREATE TABLE Courses (

course_id INT AUTO_INCREMENT PRIMARY KEY,

course_name VARCHAR(100),

credits INT

);

CREATE TABLE Supervisors (

supervisor_id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(50),

department VARCHAR(50)

);

import mysql.connector

conn = mysql.connector.connect(

host="localhost",

user="root",

password="password",

database="GraduateManagement"

)

cursor = conn.cursor()

# 插入学生数据

add_student = ("INSERT INTO Students "

"(name, major, email) "

"VALUES (%s, %s, %s)")

data_student = ('张三', '教育学', 'zhangsan@example.com')

cursor.execute(add_student, data_student)

# 查询所有学生

cursor.execute("SELECT * FROM Students")

students = cursor.fetchall()

for student in students:

print(student)

conn.commit()

cursor.close()

conn.close()