锦中迎新管理系统

def __init__(self, name, id, major):

self.name = name

self.id = id

self.major = major

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(50),

student_id VARCHAR(20) UNIQUE,

major VARCHAR(50)

);

def add_student(student):

connection = pymysql.connect(host='localhost', user='root', password='password', database='school')

try:

with connection.cursor() as cursor:

sql = "INSERT INTO students (name, student_id, major) VALUES (%s, %s, %s)"

数据中台建设方案

cursor.execute(sql, (student.name, student.id, student.major))

connection.commit()

finally:

connection.close()

connection = pymysql.connect(host='localhost', user='root', password='password', database='school')

try:

with connection.cursor() as cursor:

sql = "SELECT * FROM students WHERE student_id=%s"

cursor.execute(sql, (student_id,))

result = cursor.fetchone()

return result

finally:

connection.close()