基于‘数字迎新系统’的高校迎新模式在河南的应用实践

        def add_student(student_info):
            # 学生信息存储函数
            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": "计算机科学"}
        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
        );