Django和mysql简单交互,视图编辑

承接自我的上一篇博客:https://blog.csdn.net/oliverkingli/article/details/79705061

我们今天继续完善相关页面关于数据表的可视化操作:

我们先增加一个在Student页面下可以选择Grades的具体对象的功能:

修改models.py

from django.db import models# Create your models here.class Grades(models.Model):g_name &＃61; models.CharField(max_length&＃61;20)g_date &＃61; models.DateTimeField()g_girlnum &＃61; models.IntegerField()g_boynum &＃61; models.IntegerField()isDelete &＃61; models.BooleanField(default&＃61;False)def __str__(self):return self.g_nameclass Students(models.Model):s_name &＃61; models.CharField(max_length&＃61;20)s_gender &＃61; models.BooleanField(default&＃61;True)s_age &＃61; models.IntegerField()s_contend &＃61; models.CharField(max_length&＃61;20)isDelete &＃61; models.BooleanField(default&＃61;False)# 关联外界s_grade &＃61; models.ForeignKey("Grades", on_delete&＃61;models.CASCADE)def __str__(self):return self.s_name
然后在admin.py里加入:

接下来我们对可视化界面进行一些完善,并且添加上中文支持:

完整的admin.py:

from django.contrib import admin# Register your models here.
# 从当前导入模型
from .models import Grades,Studentsclass StudentsInfo(admin.TabularInline):model &＃61; Studentsextra &＃61; 2# 进行注册
class GradesAdmin(admin.ModelAdmin):inlines &＃61; [StudentsInfo]# 列表属性添加# 列表list_display &＃61; [&＃39;pk&＃39;, &＃39;g_name&＃39;, &＃39;g_date&＃39;, &＃39;g_girlnum&＃39;, &＃39;g_boynum&＃39;, &＃39;isDelete&＃39;]# 过滤器list_filter &＃61; [&＃39;g_name&＃39;]# 搜索search_fields &＃61; [&＃39;g_name&＃39;]# 分页list_per_page &＃61; 2# 添加,修改属性,这两个不能同时使用# 规定属性的先后顺序# fields&＃61; [&＃39;g_girlnum&＃39;, &＃39;g_boynum&＃39;, &＃39;g_date&＃39;, &＃39;g_name&＃39;, &＃39;isDelete&＃39;]# 给属性分组fieldsets &＃61; [("num", {"fields":["g_girlnum", "g_boynum"]}),("base", {"fields":["g_name", "g_date", "isDelete"]})]class StudentsAdmin(admin.ModelAdmin):def gender(self):if self.s_gender:return "男"else:return "女"def delete(self):if self.isDelete:return "删"else:return "留"def name(self):if self.s_name:return self.s_namedef age(self):if self.s_age:return self.s_agedef contend(self):if self.s_contend:return self.s_contend# 设置页面列的名称gender.short_description &＃61; "性别"delete.short_description &＃61; "备注"name.short_description &＃61; "姓名"age.short_description &＃61; "年龄"contend.short_description &＃61; "描述"# 列表属性添加# 列表list_display &＃61; [&＃39;pk&＃39;, name, gender, age, contend, delete]# 过滤器list_filter &＃61; [&＃39;s_name&＃39;]# 搜索search_fields &＃61; [&＃39;s_name&＃39;]# 分页list_per_page &＃61; 2# 设置操作执行的布局actions_on_top &＃61; Falseactions_on_bottom &＃61; True# 添加,修改属性,这两个不能同时使用# 规定属性的先后顺序# fields&＃61; [&＃39;g_girlnum&＃39;, &＃39;g_boynum&＃39;, &＃39;g_date&＃39;, &＃39;g_name&＃39;, &＃39;isDelete&＃39;]# 给属性分组fieldsets &＃61; [("num", {"fields":["s_name", "s_contend"]}),("base", {"fields":["s_age", "s_gender", "isDelete"]})]admin.site.register(Grades, GradesAdmin)
admin.site.register(Students, StudentsAdmin)

下面我们使用视图来修改站点的可视化界面:

在myapp1文件夹下的view.py中加入:

from django.shortcuts import render# Create your views here.
from django.http import HttpResponsedef index(request):return HttpResponse("Django is testing.")

在项目根目录的test1里面的urls.py中加入:

"""test1 URL ConfigurationThe &＃96;urlpatterns&＃96; list routes URLs to views. For more information please see:https://docs.djangoproject.com/en/2.0/topics/http/urls/
Examples:
Function views1. Add an import: from my_app import views2. Add a URL to urlpatterns: path(&＃39;&＃39;, views.home, name&＃61;&＃39;home&＃39;)
Class-based views1. Add an import: from other_app.views import Home2. Add a URL to urlpatterns: path(&＃39;&＃39;, Home.as_view(), name&＃61;&＃39;home&＃39;)
Including another URLconf1. Import the include() function: from django.urls import include, path2. Add a URL to urlpatterns: path(&＃39;blog/&＃39;, include(&＃39;blog.urls&＃39;))
"""
from django.contrib import admin
from django.conf.urls import url,include
urlpatterns &＃61; [url(r&＃39;^admin/&＃39;, admin.site.urls),url(r&＃39;^&＃39;, include(&＃39;myapp1.urls&＃39;)),]

再在myapp1文件下创建urls.py

from django.conf.urls import url
from . import viewsurlpatterns &＃61; [url(r&＃39;^$&＃39;, views.index),]