写出学生管理系统的Python代码
时间: 2023-03-03 19:49:49 浏览: 50
以下是一个简单的学生管理系统的Python代码示例:class Student:
def __init__(self, name, age):
self.name = name
self.age = ageclass StudentManagementSystem:
def __init__(self):
self.students = []
def add_student(self, student):
self.students.append(student)
def remove_student(self, student):
self.students.remove(student)sms = StudentManagementSystem()
student1 = Student("张三", 18)
student2 = Student("李四", 19)sms.add_student(student1)
sms.add_student(student2)
sms.remove_student(student2)
相关问题
请写出python学生信息管理系统
好的,我可以给你提供一个简单的Python学生信息管理系统的代码示例。
```python
# 定义一个学生类
class Student:
def __init__(self, name, age, gender, major):
self.name = name
self.age = age
self.gender = gender
self.major = major
# 学生信息管理系统类
class StudentManagementSystem:
def __init__(self):
self.student_list = []
# 添加学生信息
def add_student(self, student):
self.student_list.append(student)
print("添加成功!")
# 删除学生信息
def delete_student(self, name):
for student in self.student_list:
if student.name == name:
self.student_list.remove(student)
print("删除成功!")
return
print("未找到该学生!")
# 查找学生信息
def search_student(self, name):
for student in self.student_list:
if student.name == name:
print("姓名:", student.name)
print("年龄:", student.age)
print("性别:", student.gender)
print("专业:", student.major)
return
print("未找到该学生!")
# 修改学生信息
def modify_student(self, name, age, gender, major):
for student in self.student_list:
if student.name == name:
student.age = age
student.gender = gender
student.major = major
print("修改成功!")
return
print("未找到该学生!")
# 显示所有学生信息
def show_student_list(self):
for student in self.student_list:
print("姓名:", student.name)
print("年龄:", student.age)
print("性别:", student.gender)
print("专业:", student.major)
print("")
# 测试代码
if __name__ == '__main__':
# 创建学生信息管理系统对象
sms = StudentManagementSystem()
# 添加学生信息
s1 = Student("Tom", 20, "男", "计算机科学")
sms.add_student(s1)
# 修改学生信息
sms.modify_student("Tom", 21, "男", "软件工程")
# 查找学生信息
sms.search_student("Tom")
# 删除学生信息
sms.delete_student("Tom")
# 显示所有学生信息
sms.show_student_list()
```
上述代码实现了基本的学生信息管理系统功能,包括添加、删除、查找、修改和显示所有学生信息。你可以根据实际需求进行修改和扩展。
请写出学生管理系统mysql+python
好的,以下是一个简单的学生管理系统实现的MySQL+Python代码:
首先,需要在MySQL中创建一个名为“student”的数据库,并创建一个名为“students”的表,表中有id、name、age、gender四个字段:
```mysql
CREATE DATABASE student;
USE student;
CREATE TABLE students (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(20) NOT NULL,
age INT NOT NULL,
gender VARCHAR(4) NOT NULL
);
```
然后,使用Python连接MySQL数据库,并实现以下功能:
1. 添加学生信息
2. 删除学生信息
3. 修改学生信息
4. 查询学生信息
```python
import pymysql
# 连接数据库
db = pymysql.connect(host='localhost', user='root', password='123456', database='student', charset='utf8')
# 获取游标
cursor = db.cursor()
# 添加学生信息
def add_student(name, age, gender):
sql = "INSERT INTO students (name, age, gender) VALUES ('%s', %d, '%s')" % (name, age, gender)
try:
cursor.execute(sql)
db.commit()
print("添加成功!")
except:
db.rollback()
print("添加失败!")
# 删除学生信息
def delete_student(id):
sql = "DELETE FROM students WHERE id = %d" % id
try:
cursor.execute(sql)
db.commit()
print("删除成功!")
except:
db.rollback()
print("删除失败!")
# 修改学生信息
def update_student(id, name, age, gender):
sql = "UPDATE students SET name = '%s', age = %d, gender = '%s' WHERE id = %d" % (name, age, gender, id)
try:
cursor.execute(sql)
db.commit()
print("修改成功!")
except:
db.rollback()
print("修改失败!")
# 查询学生信息
def search_student(name):
sql = "SELECT * FROM students WHERE name = '%s'" % name
try:
cursor.execute(sql)
results = cursor.fetchall()
if len(results) == 0:
print("未找到该学生!")
else:
for row in results:
print("id:%d,姓名:%s,年龄:%d,性别:%s" % (row[0], row[1], row[2], row[3]))
except:
print("查询失败!")
# 添加学生信息
add_student('张三', 18, '男')
# 修改学生信息
update_student(1, '李四', 20, '女')
# 删除学生信息
delete_student(1)
# 查询学生信息
search_student('李四')
# 关闭数据库连接
db.close()
```
以上代码仅为示例,实际应用中还需要进行错误处理、用户交互等优化。