import os
from _datetime import datetime
from django.conf import settings
from django.shortcuts import render, redirect
from django.http import HttpResponse
from django.views import View
from .models import *

def login(request):
    if request.method=="POST":
        uname = request.POST.get("aname")
        print(uname)
        pwd = request.POST.get("apass")
        result = AdminInfo.objects.filter(aname=uname,apass=pwd)
        if result:
                # 把用户名存在session中，在其他试图函数或页面中获取用户的信息
                request.session["k1"] = uname
                sid = ProductInfo.objects.all()
                # print(fruits[0].FruitName)
                return render(request, "商品信息.html", {"ProductInfo": sid})
        else:
            return render(request, "登录.html",{"info":"用户名或密码错误"})
    return render(request,"登录.html")

def delete(request):
    id = request.GET.get("data")
    print(request.session.get("k1"))
    print(id)
    result=ProductInfo.objects.get(ID=id)
    print(result)
    if result:
        result.delete()
        return HttpResponse("yes")

from django.contrib import admin
from django.urls import path,include
from . import views

urlpatterns = [
    path('',views.login),

    path('delete', views.delete),
]

from django.db import models

class ProductInfo(models.Model):
    class Meta:
        db_table="ProductInfo"
        managed=False
    ID=models.IntegerField(primary_key=True,db_column="ID")
    productName=models.CharField(max_length=20)
    addDate=models.DateField()
    price=models.CharField(max_length=255)
    productDesc=models.CharField(max_length=20)
class AdminInfo(models.Model):
    class Meta:
        db_table="AdminInfo"
        managed=False
    ID=models.IntegerField(primary_key=True,db_column="ID")
    aname=models.CharField(max_length=20)
    apass=models.CharField(max_length=20)
    state=models.IntegerField(max_length=11)
# Create your models here.

DATABASES = {
    'default': {
        # 'ENGINE': 'django.db.backends.sqlite3',
        # 'NAME': BASE_DIR / 'db.sqlite3',
        'ENGINE': 'django.db.backends.mysql',
        'NAME': "test",
        'HOST': "127.0.0.1",  # 主机ip
        'PORT': "3306",  # 数据库端口号
        'USER': "root",  # 用户名
        'PASSWORD': "123456",  # 密码
    }
}
SESSION_ENGINE = 'django.contrib.sessions.backends.cache' # session保存的引擎

from django.contrib import admin
from django.urls import path,include

urlpatterns = [
    path('admin/', admin.site.urls),
    path('', include("books.urls")),
]

    
    
      




  
    
商品信息后台管理登录
    
    管理员账号：


    管理员密码：


    登陆
      {{ info }}
{#    取消#}
  

    
    
    









欢迎您：{{ request.session.k1 }}

商品信息列表

    {% for row in ProductInfo %}
        
    {% endfor %}


    

        
商品编号
        
商品名称
        
上架日期
        
商品单价(元)
        
商品描述
        
操作
    

            
{{ row.ID }}
            
{{ row.productName }}
            
{{ row.addDate }}
            
{{ row.price }}￥
            
{{ row.productDesc }}
            
{ row.ID }}) ">删除