用python设计学生管理系统_python3+django实现学生信息管理系统(增删改查入门级示例)...

【实例简介】

1. 运行 python manager.py runserver

2. 打开网址 http://localhost:8000/manager

3. 运行成功

【实例截图】

f140403cd475035e04d96634d22eaf9a.png

e59e2a50f290e4431d845c4e6febf80c.png

【核心代码】

# -*- coding: utf-8 -*-

from django.http import HttpResponse

from ScoreManager.models import Student

def search_subject(key):

list = []

students = {}

for student in Student.objects.all():

if key == 'chinese':

students[student] = student.chinese

list.append(student.chinese)

elif key == 'math':

students[student] = student.math

list.append(student.math)

elif key == 'english':

students[student] = student.english

list.append(student.english)

elif key == 'physics':

students[student] = student.physics

list.append(student.physics)

elif key == 'chemistry':

students[student] = student.chemistry

list.append(student.chemistry)

elif key == 'summary':

students[student] = student.summary

list.append(student.summary)

list.sort(reverse=True)

response = []

r = ""

for l in list:

for student in students.keys():

if students[student] == l:

r = student.number " " student.name " " key ": " str(l)

response.append(r)

return response

def search_score(key):

students = []

list = []

for student in Student.objects.all():

if student.chinese >= key and student.math >= key and student.english >= key and student.physics >= key and student.chemistry >= key:

students.append(student)

list.append(student.summary)

list.sort(reverse=True)

response = []

r = ""

for l in list:

for student in students:

if student.summary == l:

r = student.number " " student.name " chinese:" str(student.chinese) " math:" str(student.math) " english:" str(student.english) " physics" str(student.physics) " chemistry:" str(student.chemistry) " summary:" str(l)

response.append(r)

return response

def search_student(key):

response = ""

for student in Student.objects.all():

if student.number == key or student.name == key:

response = student.number " " student.name " chinese:" str(student.chinese) " math:" str(student.math) " english:" str(student.english) " physics" str(student.physics) " chemistry:" str(student.chemistry) " summary" str(student.summary)

return response

def add(key):

keys = key.split()

if len(keys) != 8:

return "输入信息错误"

else:

find = False

for student in Student.objects.all():

if student.number == keys[0]:

return "该学生已存在"

if not find:

student = Student(number=keys[0], name=keys[1], chinese=float(keys[2]), math=float(keys[3]), english=float(keys[4]), physics=float(keys[5]), chemistry=float(keys[6]), summary=float(keys[7]))

student.save()

return "添加信息成功"

def change(key):

keys = key.split()

if len(keys) != 8:

return "输入信息错误"

else:

find = False

for student in Student.objects.all():

if student.number == keys[0] or student.name == keys[1]:

find = True

student.number = keys[0]

student.name = keys[1]

student.chinese = float(keys[2])

student.math = float(keys[3])

student.english = float(keys[4])

student.physics = float(keys[5])

student.chemistry = float(keys[6])

student.summary = float(keys[7])

student.save()

return "修改信息成功"

if not find:

return "该学生不存在"

def delete(key):

find = False

for student in Student.objects.all():

if student.number == key or student.name == key:

find = True

student.delete()

return "删除信息成功"

if not find:

return "该学生不存在"

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Django是一个非常受欢迎的Python Web框架,而MySQL是广泛使用的关系型数据库系统。将二者结合起来,可以创建出强大的Web应用程序。以下是一个基于Django和PyMySQL的入门级项目源代码示例,用于展示如何使用Django和MySQL创建简单的Web应用程序。 项目目录结构如下: ```bash project/ ├── manage.py ├── project/ │ ├── __init__.py │ ├── settings.py │ ├── urls.py │ └── wsgi.py ├── app/ │ ├── __init__.py │ ├── admin.py │ ├── apps.py │ ├── models.py │ ├── tests.py │ └── views.py └── requirements.txt ``` 其中,`project/`目录下是项目的设置和配置文件,`app/`目录下是应用程序的代码,`requirements.txt`里则记录了相关依赖。 首先,在`settings.py`文件中添加一些必要的配置: ```python INSTALLED_APPS = [ ... 'app', ] DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'mydatabase', 'USER': 'mydatabaseuser', 'PASSWORD': 'mypassword', 'HOST': '127.0.0.1', 'PORT': '3306', } } ``` 然后,在`models.py`文件中定义我们的数据模型: ```python from django.db import models class Book(models.Model): title = models.CharField(max_length=200) author = models.CharField(max_length=200) publisher = models.CharField(max_length=200) pub_date = models.DateField() def __str__(self): return self.title ``` 接着,在`views.py`文件中编写视图函数: ```python from django.shortcuts import render from .models import Book def book_list(request): books = Book.objects.all() return render(request, 'book_list.html', {'books': books}) ``` 最后,在`urls.py`文件中添加路由: ```python from django.urls import path from . import views urlpatterns = [ path('books/', views.book_list, name='book_list'), ] ``` 这个示例项目就完成了。要启动应用程序,请在终端中运行以下命令: ```bash $ python manage.py runserver ``` 现在,在浏览器中访问`http://127.0.0.1:8000/books/`,即可看到所有书籍的列表。此外,我们还可以添加、编辑和删除书籍记录等功能。 需要注意的是,这个示例项目只是一个入门级的项目,还有很多细节需要注意,如安全性、性能优化等。因此,在实际开发中需要更加细致的思考和实践。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值