构建‘数字校园’中的‘工程学院’

# 数据库表结构设计示例（SQL语句）

CREATE TABLE students (

student_id INT PRIMARY KEY,

name VARCHAR(100),

major VARCHAR(100)

);

CREATE TABLE courses (

course_id INT PRIMARY KEY,

title VARCHAR(100),

credits INT

);

CREATE TABLE labs (

lab_id INT PRIMARY KEY,

equipment VARCHAR(255),

status ENUM('available', 'in_use')

);

]]>

# Python脚本示例：批量导入学生信息

import sqlite3

def load_students(file_path):

conn = sqlite3.connect('school.db')

cursor = conn.cursor()

with open(file_path, 'r') as file:

for line in file:

data = line.strip().split(',')

cursor.execute("INSERT INTO students VALUES (?, ?, ?)",

(data[0], data[1], data[2]))

conn.commit()

conn.close()

排课管理系统

if __name__ == "__main__":

load_students('students.csv')

]]>