图书管理系统功能完善

在views中定义函数

增加函数

def add(request):
number = request.POST[‘number’]
category = request.POST[‘category’]
name = request.POST[‘name’]
author = request.POST[‘author’]
press = request.POST[‘press’]
price = request.POST[‘price’]
create = Book.objects.create(number=number,category=category,name=name,author=author,press=press,price=price)
print(type(create),create)
return redirect(‘…/books’)

查询所有图书函数

def book_list(request):
#查询所有的书籍
books=Book.objects.all()
return render(request, ‘book_list.html’,{‘books’:books})

跳转试图函数

def tianjia(request):
return render(request,‘add.html’,locals())

编辑图书函数

def dit_books(request):
id = request.GET.get(‘id’)
obj_list = Book.objects.filter(id=id)
if not obj_list:
return HttpResponse(‘要编辑的数据不存在’)
obj = obj_list[0]
# 判断请求方式
if request.method == ‘POST’:
# 获取表单里面的数据
book_id = request.POST.get(‘book_id’)
book_number = request.POST.get(‘book_number’)
book_category = request.POST.get(‘book_category’)
book_name = request.POST.get(‘book_name’)
book_author = request.POST.get(‘book_author’)
book_press = request.POST.get(‘book_press’)
book_price = request.POST.get(‘book_price’)
# 在数据库中更改修改的数据
obj.id = book_id
obj.number = book_number
obj.category = book_category
obj.name = book_name
obj.author = book_author
obj.press = book_press
obj.price = book_price
# 将数据保存
obj.save()
books = Book.objects.all()
return render(request, ‘books.html’, locals())
return render(request, ‘dit.html’, {‘obj’: obj})

删除图书函数

def del_delete(request):
id = request.GET.get(‘id’)
Book.objects.filter(id=id).delete()
# 查询所有的书籍
books = Book.objects.all()
return render(request, ‘books.html’, locals())

在templates中新建HTML文件

创建文件

功能实现效果

登录

使用数据库用户登录

显示图书

点击编辑按钮

点击新增按钮

表格插入成功

数据库插入成功

点击删除按钮

数据库里面的内容也被删除