def add_student(student_info):
            # 學(xué)生信息存儲(chǔ)函數(shù)
            with open('students.txt', 'a') as f:
                f.write(f"{student_info['name']},{student_info['id']},{student_info['major']}\n")
        
        def assign_dormitory(student_id, dormitory_number):
            # 宿舍分配邏輯
            with open('dorms.txt', 'r') as f:
                dorms = eval(f.read())
            if dorms[dormitory_number] < 4:
                dorms[dormitory_number] += 1
                with open('dorms.txt', 'w') as f:
                    f.write(str(dorms))
                return True
            else:
                return False
        
        student_info = {"name": "張三", "id": "20230001", "major": "計(jì)算機(jī)科學(xué)"}
        add_student(student_info)
      

        CREATE TABLE students (
            id INT AUTO_INCREMENT PRIMARY KEY,
            name VARCHAR(50),
            student_id VARCHAR(20),
            major VARCHAR(50)
        );
        
        CREATE TABLE dorms (
            dormitory_number INT PRIMARY KEY,
            current_students INT DEFAULT 0
        );
      

招生信息管理系統(tǒng)