高校科研管理系统在理工大学的应用与实现

CREATE TABLE students (

id INT PRIMARY KEY AUTO_INCREMENT,

name VARCHAR(255) NOT NULL,

email VARCHAR(255) UNIQUE NOT NULL,

department VARCHAR(255)

);

]]>

import mysql.connector

def get_all_students():

db = mysql.connector.connect(

host="localhost",

user="root",

password="password",

database="research_system"

)

cursor = db.cursor()

cursor.execute("SELECT * FROM students")

students = cursor.fetchall()

db.close()

return students

]]>

CREATE TABLE projects (

id INT PRIMARY KEY AUTO_INCREMENT,

name VARCHAR(255) NOT NULL,

leader VARCHAR(255),

status VARCHAR(255)

);

]]>

def add_project(name, leader, status):

db = mysql.connector.connect(

host="localhost",

user="root",

password="password",

database="research_system"

)

cursor = db.cursor()

query = "INSERT INTO projects (name, leader, status) VALUES (%s, %s, %s)"

values = (name, leader, status)

cursor.execute(query, values)

db.commit()

db.close()

]]>