django项目
pip install -i https://pypi.tuna.tsinghua.edu.cn/simple django==2.2.3 pip install -i https://pypi.tuna.tsinghua.edu.cn/simple mysqlclient
项目:
django-admin startprojects app cd app python manage.py runserver 端口号
settings.py
SESSION_ENGINE = 'django.contrib.sessions.backends.cache' # session保存的引擎
DATABASES = {
'default': {
# 'ENGINE': 'django.db.backends.sqlite3',
# # 'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
'ENGINE': 'django.db.backends.mysql',
'NAME': "hhdb",
'HOST':"127.0.0.1",
'PORT':"3306",
'USER':"root",
'PASSWORD':"123456",
}
}
INSTALLED_APPS = [
'django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'tests',
]
MIDDLEWARE = [
'django.middleware.security.SecurityMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.common.CommonMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',#这行可以注释
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'django.middleware.clickjacking.XFrameOptionsMiddleware',
]
urls.py
from django.contrib import admin
from django.urls import path,include
urlpatterns = [
path('admin/', admin.site.urls),
path('',include("tests.urls")),
]
应用
urls.py
from django.contrib import admin
from django.urls import path
from . import views
urlpatterns = [
path('',views.index),
path('show',views.show),
path('deletecord',views.deletecord),
]
view.py
from django.shortcuts import render,redirect
from django.http import HttpResponse
from . import models
# Create your views here.
def index(request):
if request.method=="POST":
aname=request.POST.get("aname")
apass=request.POST.get("apass")
request.session["aname"]=aname
result=models.AdminInfo.objects.filter(aname=aname,apass=apass)
if result:
return redirect("/show")
else:
return render(request,"index.html",{"msg":"用户名或密码错误"})
return render(request,"index.html")
def show(request):
result=models.ProductInfo.objects.all()
return render(request,"show.html",{"result":result})
def deletecord(request):
id=request.GET.get("id")
print(id)
pro=models.ProductInfo.objects.get(ID=id)
pro.delete()
return HttpResponse("ok")
model.py
from django.db import models
# Create your models here.
class AdminInfo(models.Model):
class Meta:
db_table="adminInfo"
ID=models.AutoField(primary_key=True,db_column="ID")
aname=models.CharField(max_length=20)
apass=models.CharField(max_length=20)
state=models.IntegerField(null=True)
def __str__(self):
return self.aname
class ProductInfo(models.Model):
class Meta:
db_table="productInfo"
ID=models.AutoField(primary_key=True,db_column="ID")
productName=models.CharField(max_length=20)
addDate=models.DateField()
price=models.FloatField()
productDesc=models.CharField(max_length=20)
def __str__(self):
return self.productName
show.html
Title
欢迎您:{{ request.session.uname }}
| 商品编号 | 商品名称 | 上架日期 | 商品单价 | 商品描述 | 编辑操作 |
|---|---|---|---|---|---|
| {{ res.ID }} | {{ res.productName }} | {{ res.addDate}} | {{ res.price }} | {{ res.productDesc }} | 删除 |
index.html
商品信息管理后台登录
商品信息管理后台登录



