用代码生成一个学籍管理系统
时间: 2024-05-14 21:18:27 浏览: 4
这是一个比较复杂的项目,需要考虑很多方面,包括数据结构、数据库设计、用户界面等等。以下是一个简单的学籍管理系统的代码示例,仅供参考。
首先,我们需要定义几个类来表示学生、课程、教师等对象:
```python
class Student:
def __init__(self, id, name, age, gender, department):
self.id = id
self.name = name
self.age = age
self.gender = gender
self.department = department
self.courses = {}
def add_course(self, course):
self.courses[course.id] = course
def remove_course(self, course_id):
if course_id in self.courses:
del self.courses[course_id]
class Course:
def __init__(self, id, name, teacher):
self.id = id
self.name = name
self.teacher = teacher
self.students = {}
def add_student(self, student):
self.students[student.id] = student
def remove_student(self, student_id):
if student_id in self.students:
del self.students[student_id]
class Teacher:
def __init__(self, id, name, age, gender, department):
self.id = id
self.name = name
self.age = age
self.gender = gender
self.department = department
self.courses = {}
def add_course(self, course):
self.courses[course.id] = course
def remove_course(self, course_id):
if course_id in self.courses:
del self.courses[course_id]
```
然后,我们需要设计数据库来存储学生、课程、教师等信息。这里我们使用 SQLite3 数据库,存储方式为关系型数据库。
```python
import sqlite3
conn = sqlite3.connect('students.db')
c = conn.cursor()
# Create student table
c.execute('''CREATE TABLE students
(id INT PRIMARY KEY NOT NULL,
name TEXT NOT NULL,
age INT NOT NULL,
gender TEXT NOT NULL,
department TEXT NOT NULL)''')
# Create course table
c.execute('''CREATE TABLE courses
(id INT PRIMARY KEY NOT NULL,
name TEXT NOT NULL,
teacher_id INT NOT NULL,
FOREIGN KEY (teacher_id) REFERENCES teachers(id))''')
# Create teacher table
c.execute('''CREATE TABLE teachers
(id INT PRIMARY KEY NOT NULL,
name TEXT NOT NULL,
age INT NOT NULL,
gender TEXT NOT NULL,
department TEXT NOT NULL)''')
# Create student-course relationship table
c.execute('''CREATE TABLE student_course
(student_id INT NOT NULL,
course_id INT NOT NULL,
FOREIGN KEY (student_id) REFERENCES students(id),
FOREIGN KEY (course_id) REFERENCES courses(id))''')
conn.commit()
conn.close()
```
接下来,我们需要定义一些函数来操作数据库,包括添加、删除、查询等操作。
```python
def add_student(id, name, age, gender, department):
conn = sqlite3.connect('students.db')
c = conn.cursor()
c.execute("INSERT INTO students VALUES (?, ?, ?, ?, ?)",
(id, name, age, gender, department))
conn.commit()
conn.close()
def add_course(id, name, teacher_id):
conn = sqlite3.connect('students.db')
c = conn.cursor()
c.execute("INSERT INTO courses VALUES (?, ?, ?)",
(id, name, teacher_id))
conn.commit()
conn.close()
def add_teacher(id, name, age, gender, department):
conn = sqlite3.connect('students.db')
c = conn.cursor()
c.execute("INSERT INTO teachers VALUES (?, ?, ?, ?, ?)",
(id, name, age, gender, department))
conn.commit()
conn.close()
def add_student_course(student_id, course_id):
conn = sqlite3.connect('students.db')
c = conn.cursor()
c.execute("INSERT INTO student_course VALUES (?, ?)",
(student_id, course_id))
conn.commit()
conn.close()
def delete_student(id):
conn = sqlite3.connect('students.db')
c = conn.cursor()
c.execute("DELETE FROM students WHERE id=?", (id,))
c.execute("DELETE FROM student_course WHERE student_id=?", (id,))
conn.commit()
conn.close()
def delete_course(id):
conn = sqlite3.connect('students.db')
c = conn.cursor()
c.execute("DELETE FROM courses WHERE id=?", (id,))
c.execute("DELETE FROM student_course WHERE course_id=?", (id,))
conn.commit()
conn.close()
def delete_teacher(id):
conn = sqlite3.connect('students.db')
c = conn.cursor()
c.execute("DELETE FROM teachers WHERE id=?", (id,))
c.execute("DELETE FROM courses WHERE teacher_id=?", (id,))
conn.commit()
conn.close()
def get_student(id):
conn = sqlite3.connect('students.db')
c = conn.cursor()
c.execute("SELECT * FROM students WHERE id=?", (id,))
result = c.fetchone()
if result:
student = Student(result[0], result[1], result[2], result[3], result[4])
c.execute("SELECT course_id FROM student_course WHERE student_id=?", (id,))
courses = c.fetchall()
for course_id in courses:
course = get_course(course_id[0])
student.add_course(course)
conn.close()
return student
else:
conn.close()
return None
def get_course(id):
conn = sqlite3.connect('students.db')
c = conn.cursor()
c.execute("SELECT * FROM courses WHERE id=?", (id,))
result = c.fetchone()
if result:
teacher = get_teacher(result[2])
course = Course(result[0], result[1], teacher)
c.execute("SELECT student_id FROM student_course WHERE course_id=?", (id,))
students = c.fetchall()
for student_id in students:
student = get_student(student_id[0])
course.add_student(student)
conn.close()
return course
else:
conn.close()
return None
def get_teacher(id):
conn = sqlite3.connect('students.db')
c = conn.cursor()
c.execute("SELECT * FROM teachers WHERE id=?", (id,))
result = c.fetchone()
if result:
teacher = Teacher(result[0], result[1], result[2], result[3], result[4])
c.execute("SELECT id FROM courses WHERE teacher_id=?", (id,))
courses = c.fetchall()
for course_id in courses:
course = get_course(course_id[0])
teacher.add_course(course)
conn.close()
return teacher
else:
conn.close()
return None
```
最后,我们可以编写一个简单的用户界面来测试我们的学籍管理系统。
```python
print("Welcome to the Student Management System!")
while True:
print("Please select an option:")
print("1. Add student")
print("2. Add course")
print("3. Add teacher")
print("4. Add student to course")
print("5. Remove student from course")
print("6. Remove student")
print("7. Remove course")
print("8. Remove teacher")
print("9. View student")
print("10. View course")
print("11. View teacher")
print("12. Exit")
choice = int(input())
if choice == 1:
id = int(input("Enter student id: "))
name = input("Enter student name: ")
age = int(input("Enter student age: "))
gender = input("Enter student gender: ")
department = input("Enter student department: ")
add_student(id, name, age, gender, department)
print("Student added successfully.")
elif choice == 2:
id = int(input("Enter course id: "))
name = input("Enter course name: ")
teacher_id = int(input("Enter teacher id: "))
add_course(id, name, teacher_id)
print("Course added successfully.")
elif choice == 3:
id = int(input("Enter teacher id: "))
name = input("Enter teacher name: ")
age = int(input("Enter teacher age: "))
gender = input("Enter teacher gender: ")
department = input("Enter teacher department: ")
add_teacher(id, name, age, gender, department)
print("Teacher added successfully.")
elif choice == 4:
student_id = int(input("Enter student id: "))
course_id = int(input("Enter course id: "))
add_student_course(student_id, course_id)
print("Student added to course successfully.")
elif choice == 5:
student_id = int(input("Enter student id: "))
course_id = int(input("Enter course id: "))
student = get_student(student_id)
student.remove_course(course_id)
print("Student removed from course successfully.")
elif choice == 6:
id = int(input("Enter student id: "))
delete_student(id)
print("Student removed successfully.")
elif choice == 7:
id = int(input("Enter course id: "))
delete_course(id)
print("Course removed successfully.")
elif choice == 8:
id = int(input("Enter teacher id: "))
delete_teacher(id)
print("Teacher removed successfully.")
elif choice == 9:
id = int(input("Enter student id: "))
student = get_student(id)
if student:
print("Student id:", student.id)
print("Name:", student.name)
print("Age:", student.age)
print("Gender:", student.gender)
print("Department:", student.department)
print("Courses:")
for course in student.courses.values():
print(course.name)
else:
print("Student not found.")
elif choice == 10:
id = int(input("Enter course id: "))
course = get_course(id)
if course:
print("Course id:", course.id)
print("Name:", course.name)
print("Teacher:", course.teacher.name)
print("Students:")
for student in course.students.values():
print(student.name)
else:
print("Course not found.")
elif choice == 11:
id = int(input("Enter teacher id: "))
teacher = get_teacher(id)
if teacher:
print("Teacher id:", teacher.id)
print("Name:", teacher.name)
print("Age:", teacher.age)
print("Gender:", teacher.gender)
print("Department:", teacher.department)
print("Courses:")
for course in teacher.courses.values():
print(course.name)
else:
print("Teacher not found.")
elif choice == 12:
print("Thank you for using the Student Management System!")
break
else:
print("Invalid choice. Please try again.")
```
以上代码仅供参考,实际项目中可能需要更复杂的设计和实现。