图书管理系统简单版

以你之姓@ 2021-11-02 15:02 458阅读 0赞

![1614958-20190720111252156-1381520338.png][]

# 创建model 对象 #

models.py

作者 作者详情 出版社 图书

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()
        authorDetail = models.OneToOneField("AuthorDetail")
    
        def __str__(self):
            return self.name
    
    
    class AuthorDetail(models.Model):
        nid = models.AutoField(primary_key=True)
        birthday = models.DateField()
        telephone = models.CharField(max_length=11)
        addr = models.CharField(max_length=64)
    
    
    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()
    
        def __str__(self):
            return self.name
    
    
    class Book(models.Model):
        nid = models.AutoField(primary_key=True)
        title = models.CharField(max_length=32)
        publishDate = models.DateField()
        publish = models.ForeignKey("Publish")
        authors = models.ManyToManyField("Author")
    
        def __str__(self):
            return self.title

数据库创建一些数据 create\_bluk

import os
    
    if __name__ == '__main__':
        os.environ.setdefault("DJANGO_SETTINGS_MODULE", "tushu.settings")
        import django
    
        django.setup()
        from app01 import models
        import random
    
        l1 = []
        for i in range(1, 101):
            obj = models.Book(
                title='哈哈%s' % i,
                # price=1+i,
                publishDate='2018-01-0%s' % (random.randint(1, 9)),
                publish_id=random.randint(1, 3),
            )
            l1.append(obj)
        models.Book.objects.bulk_create(l1)

# from.py 样式 #

from django import forms
    from app01 import models
    
    
    class MyForm(forms.Form):
        title = forms.CharField(
            max_length=32,
            min_length=2,
            error_messages={
                "required": "内容不能为空",
                "min_length": "长度不能小于2位",
                "max_length": "长度不能大于32位",
            },
            label="书名",
        )
        publishDate = forms.DateField(
            label="出版日期",
            widget=forms.widgets.DateInput(attrs={
        "type": "date"})
        )
        publish = forms.ModelChoiceField(
            label="出版社",
            queryset=models.Publish.objects.all(),
            widget=forms.widgets.Select()
        )
        authors = forms.ModelMultipleChoiceField(
            label="作者",
            queryset=models.Author.objects.all(),
            widget=forms.widgets.SelectMultiple()
        )
    
        def __init__(self, *args, **kwargs):
            super().__init__(*args, **kwargs)
            for field in self.fields:
                self.fields[field].widget.attrs.update({
                    "class": "form-control",
                    # "error_messages": {
                    #     "required": "内容不能为空",
                    # },
                }
                )

# 视图 view #

from django.shortcuts import render, HttpResponse, redirect
    
    # Create your views here.
    from app01 import models
    from form.form import MyForm
    from django.http import JsonResponse
    
    
    def show(request):
        all_books = models.Book.objects.all()
        return render(request, "show.html", {
        "all_books": all_books})
    
    
    def create_book(request):
        if request.method == "GET":
            form_obj = MyForm()
            return render(request, "create_book.html", {
        "form_obj": form_obj})
        else:
            data = request.POST
            form_obj = MyForm(data)
            if form_obj.is_valid():
                data = form_obj.cleaned_data
                author_data = data.pop('authors')
                book_obj = models.Book.objects.create(**data)
                book_obj.authors.add(*author_data)
                return redirect("show")
            else:
                return render(request, "create_book.html", {
        "form_obj": form_obj})
    
    
    def editor_book(request, n):
        book_obj = models.Book.objects.filter(pk=n)
        if request.method == "GET":
            book_obj = book_obj.first()
            all_publish = models.Publish.objects.all()
            all_authors = models.Author.objects.all()
            return render(request, 'editor_book.html',
                          {
         "n": n, "book_obj": book_obj, "all_publish": all_publish, "all_authors": all_authors})
    
        else:
            data = request.POST.dict()
            author_data = request.POST.getlist("authors")
            print(data, "++++++++++++++")
            print(author_data)
            # print(author_data['authors'],'----------------')
            del data["csrfmiddlewaretoken"]
            data.pop("authors")
            book_obj.update(**data)
            book_obj[0].authors.set(author_data)
            return redirect("show")
    
    
    def delete_book(request, n):
        models.Book.objects.filter(pk=n).delete()
        return redirect("show")
    
    
    def ajax_delete_book(request, n):
        data = {
        "status": False}
        if request.method == "POST":
            models.Book.objects.filter(pk=n).delete()
            data["status"] = True
            return JsonResponse(data)
        else:
            return JsonResponse(data)
    
    
        # try:
        #     data['status'] = 1
        #     models.Book.objects.filter(pk=n).delete()
        # except Exception:
        #     data['status'] = 2
        # return JsonResponse(data)

# html 页面 #

show.html

{% load static %}
    <!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <title>show</title>
        <link rel="stylesheet" href="{% static 'bootstrap-3.3.7-dist/css/bootstrap.min.css' %}">
    </head>
    <body>
    <h1>书籍展示</h1>
    
    <div class="container-fluid">
        <div class="row">
            <div class="col-md-8 col-md-offset-2">
                <a class="btn btn-primary" href="{% url 'create_book' %}">添加书籍</a>
                <table class="table table-bordered table-striped table-hover">
                    <thead>
                    <tr>
                        <th>序号</th>
                        <th>书名</th>
                        <th>出版日期</th>
                        <th>出版社</th>
                        <th>作者</th>
                        <th>操作</th>
                    </tr>
                    </thead>
                    <tbody>
                    {
         % for book in all_books %}
                        <tr>
                            <td>{
        { forloop.counter }}</td>
                            <td>{
        { book.title }}</td>
                            <td>{
        { book.publishDate|date:"Y-m-d" }}</td>
                            <td>{
        { book.publish.name }}</td>
                            <td>
                                {
         % for author in book.authors.all %}
                                    {
         { author.name }}
                                    {
         % if forloop.last %}
                                    {
         % else %}
                                        ,
                                    {
         % endif %}
                                {
         % endfor %}
                            </td>
                            <td>
                                <a href="{% url 'editor_book' book.pk %}" class="btn btn-warning">编辑</a>
                                <a href="{% url 'delete_book' book.pk %} " class="btn btn-danger">删除</a>
                                <button class="btn btn-danger ajaxbtn">ajax删除</button>
                                <span class="hidden">{
        { book.pk }}</span>
                            </td>
                        </tr>
                    {
         % endfor %}
                    </tbody>
                </table>
            </div>
        </div>
    </div>
    
    
    <script src="{% static 'js/jquery-3.4.1.js' %}"></script>
    <script src="{% static 'bootstrap-3.3.7-dist/js/bootstrap.min.js' %}"></script>
    
    <script>
        $("tbody").on("click", ".ajaxbtn", function () {
            ths = $(this);
            var deleteId = ths.next().text();
            $.ajax({
                url: "/ajax_delete_book/" + deleteId + "/",
                type: "post",
                data: {
         "csrfmiddlewaretoken": "{
         { csrf_token }}"},
                success: function (data) {
                    ths.parent().parent().remove();
                    var tr_list = $('tbody').children();
                    $.each(tr_list, function (k, v) {
                        $(v).children().eq(0).text(k + 1);
                    })
                }
            })
        })
    
    </script>
    
    </body>
    </html>

create\_book.html

editor\_book.html

![1614958-20190720112839663-337345045.png][]

![1614958-20190720112856207-864975917.png][]

![1614958-20190720112928946-91736436.png][]

转载于:https://www.cnblogs.com/XLHIT/p/11217137.html

[1614958-20190720111252156-1381520338.png]: /images/20211101/373fa1a0fc1f4c79b263545e21f8631b.png
[1614958-20190720112839663-337345045.png]: /images/20211101/ca30641e37df41f8a3a556143f921ba9.png
[1614958-20190720112856207-864975917.png]: /images/20211101/b67ae5ee1dcd47c2ac28144287ea880a.png
[1614958-20190720112928946-91736436.png]: /images/20211101/1a0348e2e37840c7b21a413634455747.png