當前位置：首頁 > 运维知识 > windows >内容正文

windows

练习-多表图书管理系统

發布時間：2024/4/15 windows 35 豆豆

生活随笔收集整理的這篇文章主要介紹了练习-多表图书管理系统小編覺得挺不錯的,現在分享給大家,幫大家做個參考.

urls

from django.contrib import admin from django.urls import path,re_path from book import viewsurlpatterns = [path('admin/', admin.site.urls),re_path('books/add/$',views.add_book),re_path('books/$',views.books),re_path('books/(\d+)/change/$',views.change_book),re_path('books/(\d+)/delete/$', views.delete_book) ]

models

from django.db import models# Create your models here. class Author(models.Model):nid = models.AutoField(primary_key=True)name=models.CharField(max_length=32)age=models.IntegerField() class Publish(models.Model):nid=models.AutoField(primary_key=True)name=models.CharField(max_length=32)city=models.CharField(max_length=32)email=models.EmailField()class Book(models.Model):nid=models.AutoField(primary_key=True)title=models.CharField(max_length=32)publishDate=models.DateField()price=models.DecimalField(max_digits=5,decimal_places=2)publish=models.ForeignKey(to="Publish",to_field="nid",on_delete=models.CASCADE)authors=models.ManyToManyField(to="Author")

views

from django.shortcuts import render,HttpResponse,redirect from .models import Publish, Authorfrom book.models import *# Create your views here.def add_book(request):if request.method == "POST":title=request.POST.get("title")price=request.POST.get("price")pub_date=request.POST.get("pub_date")publish_id=request.POST.get("publish_id")authors_id_list=request.POST.getlist("authors_id_list") #getlist 應用在checkbox，select book_obj=Book.objects.create(title=title,price=price,publishDate=pub_date,publish_id=publish_id)book_obj.authors.add(*authors_id_list)return redirect("/books/")publish_list = Publish.objects.all()author_list = Author.objects.all()return render(request, "addbook.html", {"author_list": author_list,"publish_list": publish_list,})def books(request):book_list=Book.objects.all()return render(request,"books.html",{'book_list':book_list})def change_book(request,edit_book_id):edit_book_obj = Book.objects.filter(pk=edit_book_id).first() #編輯的對象if request.method == "POST":title = request.POST.get("title")price = request.POST.get("price")pub_date = request.POST.get("pub_date")publish_id = request.POST.get("publish_id")authors_id_list = request.POST.getlist("authors_id_list") # getlist 應用在checkbox，select Book.objects.filter(pk=edit_book_id).update(title=title,price=price,publishDate=pub_date,publish_id=publish_id)# edit_book_obj.authors.clear()# edit_book_obj.authors.add(*authors_id_list) edit_book_obj.authors.set(authors_id_list) #set:先清空，再添加值return redirect("/books/")publish_list=Publish.objects.all()author_list=Author.objects.all()return render(request,"editbook.html",{"edit_book_obj":edit_book_obj,"publish_list":publish_list,"author_list":author_list})def delete_book(request,delete_book_id):Book.objects.filter(pk=delete_book_id).delete()return redirect("/books/")

addbook.html

<!DOCTYPE html> <html lang="en"> <head><meta charset="UTF-8"><title>Title</title><link rel="stylesheet" href="/static/bs/css/bootstrap.css"> </head> <body> <h3>添加書籍</h3> <div class="container"><div class="row"><div class="col-md-6 col-md-offset-3"><form action="" method="post">{% csrf_token %}<div class="form-group"><label for="">名稱</label><input type="text" name="title" class="form-control"></div><div class="form-group"><label for="">價格</label><input type="text" name="price" class="form-control"></div><div class="form-group"><label for="">出版日期</label><input type="date" name="pub_date" class="form-control"></div>
單選框：select+for循環+option
option 元素定義下拉列表中的一個選項（一個條目）。
<div class="form-group"><label for="">出版社</label><select name="publish_id" id="" class="form-control" >{% for publish in publish_list %}<option value="{{ publish.pk }}">{{ publish.name }}</option>{% endfor %}</select></div>
　　　　　　　　　　復選框：需要注意，select加上multiple（復選框），其余與單選框相同<div class="form-group"><label for="">作者</label><select name="authors_id_list" id="" multiple class="form-control">{% for author in author_list %}<option value="{{ author.pk }}">{{ author.name }}</option>{% endfor %}</select></div><input type="submit" class="btn btn-default"></form></div></div> </div></body> </html>

books.html

editbook.html

<!DOCTYPE html> <html lang="en"> <head><meta charset="UTF-8"><title>Title</title><link rel="stylesheet" href="/static/bs/css/bootstrap.css"> </head> <body> <h3>編輯書籍</h3> <div class="container"><div class="row"><div class="col-md-6 col-md-offset-3"><form action="" method="post">{% csrf_token %}<div class="form-group"><label for="">名稱</label><input type="text" name="title" class="form-control" value="{{ edit_book_obj.title }}"></div><div class="form-group"><label for="">價格</label><input type="text" name="price" class="form-control" value="{{ edit_book_obj.price }}"></div><div class="form-group"><label for="">出版日期</label><input type="date" name="pub_date" class="form-control"value="{{ edit_book_obj.publishDate|date:"Y-m-d" }}"></div><div class="form-group"><label for="">出版社</label><select name="publish_id" id="" class="form-control" value="{{ edit_book_obj.publish }}">{% for publish in publish_list %}{% if edit_book_obj.publish == publish %}<option selected value="{{ publish.pk }}">{{ publish.name }}</option>{% else %}<option value="{{ publish.pk }}">{{ publish.name }}</option>{% endif %}{% endfor %}</select></div><div class="form-group"><label for="">作者</label><select name="authors_id_list" id="" multiple class="form-control">{% for author in author_list %}{% if author in edit_book_obj.authors.all %}<option selected value="{{ author.pk }}">{{ author.name }}</option>{% else %}<option value="{{ author.pk }}">{{ author.name }}</option>{% endif %}{% endfor %}</select></div><input type="submit" class="btn btn-default"></form></div></div> </div></body> </html>

轉載于:https://www.cnblogs.com/hexiaorui123/p/10590783.html

總結

以上是生活随笔為你收集整理的练习-多表图书管理系统的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。

图书管理系统

上一篇： WCF中双工协议
下一篇：良好的JavaScript编码风格（语法