学生信息管理系统

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(255) NOT NULL,

contact_info VARCHAR(255),

department VARCHAR(255)

);

CREATE TABLE teachers (

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(255) NOT NULL,

contact_info VARCHAR(255),

department VARCHAR(255)

);

学生综合服务门户

def add_student(name, contact_info, department):

connection = mysql.connector.connect(

host='localhost',

user='root',

password='yourpassword',

database='school_management'

)

cursor = connection.cursor()

query = "INSERT INTO students (name, contact_info, department) VALUES (%s, %s, %s)"

values = (name, contact_info, department)

cursor.execute(query, values)

connection.commit()

cursor.close()

connection.close()