我们提供学生信息管理系统招投标所需全套资料,包括学工系统介绍PPT、学生管理系统产品解决方案、
学生管理系统产品技术参数,以及对应的标书参考文件,详请联系客服。
import mysql.connector
def connect_db():
conn = mysql.connector.connect(
host="localhost",
user="root",
password="password",
database="student_system"
)
return conn
def add_student(name, age):
conn = connect_db()
cursor = conn.cursor()
query = "INSERT INTO students (name, age) VALUES (%s, %s)"
values = (name, age)
cursor.execute(query, values)
conn.commit()
cursor.close()
conn.close()
def get_all_students():
conn = connect_db()
cursor = conn.cursor(dictionary=True)
cursor.execute("SELECT * FROM students")
result = cursor.fetchall()
cursor.close()
conn.close()
return result