图书管理系统

注意事项

1、models 要创建好，规划好自己的表，以及各种表关系

2、url正则要写好

3、settings的配置

4、利用bootstarp 进行布局更漂亮哦

5、注意orm  各种类型的转换还有取值。

6、模板语法

下面上菜

目录结构

G:.
├─.idea
│ ├─dataSources
│ └─inspectionProfiles
├─app01
│ ├─migrations
│ │ └─__pycache__
│ ├─static
│ │ └─css
│ └─__pycache__
├─books
│ └─__pycache__
└─templates

项目代码

settings.py

"""

Django settings for books project.

Generated by 'django-admin startproject' using Django 2.0.2.

For more information on this file, see

https://docs.djangoproject.com/en/2.0/topics/settings/

For the full list of settings and their values, see

https://docs.djangoproject.com/en/2.0/ref/settings/

"""

import os

# Build paths inside the project like this: os.path.join(BASE_DIR, ...)

BASE_DIR = os.path.dirname(os.path.dirname(os.path.abspath(__file__)))

# Quick-start development settings - unsuitable for production

# See https://docs.djangoproject.com/en/2.0/howto/deployment/checklist/

# SECURITY WARNING: keep the secret key used in production secret!

SECRET_KEY = 'm-zu@pls$#8)6njw1ar5#t#tx#fcfhe7(iaygkg(y4l^x@!!ix'

# SECURITY WARNING: don't run with debug turned on in production!

DEBUG = True

ALLOWED_HOSTS = []

# Application definition

INSTALLED_APPS = [

    'django.contrib.admin',

    'django.contrib.auth',

    'django.contrib.contenttypes',

    'django.contrib.sessions',

    'django.contrib.messages',

    'django.contrib.staticfiles',

    'app01.apps.App01Config',

]

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',

]

ROOT_URLCONF = 'books.urls'

TEMPLATES = [

    {

        'BACKEND': 'django.template.backends.django.DjangoTemplates',

        'DIRS': [os.path.join(BASE_DIR, 'templates')]

        ,

        'APP_DIRS': True,

        'OPTIONS': {

            'context_processors': [

                'django.template.context_processors.debug',

                'django.template.context_processors.request',

                'django.contrib.auth.context_processors.auth',

                'django.contrib.messages.context_processors.messages',

            ],

        },

    },

]

WSGI_APPLICATION = 'books.wsgi.application'

# Database

# https://docs.djangoproject.com/en/2.0/ref/settings/#databases

# DATABASES = {

#     'default': {

#         'ENGINE': 'django.db.backends.sqlite3',

#         'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),

#     }

# }

DATABASES = {

    'default': {

        'ENGINE': 'django.db.backends.mysql',

        'NAME': 'books',

        'HOST': '172.16.0.30',

        'PORT': '3306',

        'USER': 'root',

        'PASSWORD': 'zabbix',

    }

}

# Password validation

# https://docs.djangoproject.com/en/2.0/ref/settings/#auth-password-validators

AUTH_PASSWORD_VALIDATORS = [

    {

        'NAME': 'django.contrib.auth.password_validation.UserAttributeSimilarityValidator',

    },

    {

        'NAME': 'django.contrib.auth.password_validation.MinimumLengthValidator',

    },

    {

        'NAME': 'django.contrib.auth.password_validation.CommonPasswordValidator',

    },

    {

        'NAME': 'django.contrib.auth.password_validation.NumericPasswordValidator',

    },

]

# Internationalization

# https://docs.djangoproject.com/en/2.0/topics/i18n/

LANGUAGE_CODE = 'en-us'

TIME_ZONE = 'UTC'

USE_I18N = True

USE_L10N = True

USE_TZ = True

# Static files (CSS, JavaScript, Images)

# https://docs.djangoproject.com/en/2.0/howto/static-files/

STATIC_URL = '/static/'

LOGGING = {

    'version': 1,

    'disable_existing_loggers': False,

    'handlers': {

        'console': {

            'level': 'DEBUG',

            'class': 'logging.StreamHandler',

        },

    },

    'loggers': {

        'django.db.backends': {

            'handlers': ['console'],

            'propagate': True,

            'level': 'DEBUG',

        },

    }

}

urls.py

"""books URL Configuration

The `urlpatterns` list routes URLs to views. For more information please see:

    https://docs.djangoproject.com/en/2.0/topics/http/urls/

Examples:

Function views

    1. Add an import:  from my_app import views

    2. Add a URL to urlpatterns:  path('', views.home, name='home')

Class-based views

    1. Add an import:  from other_app.views import Home

    2. Add a URL to urlpatterns:  path('', Home.as_view(), name='home')

Including another URLconf

    1. Import the include() function: from django.urls import include, path

    2. Add a URL to urlpatterns:  path('blog/', include('blog.urls'))

"""

from django.contrib import admin

from django.urls import path

from app01 import views

from  django.conf.urls import url

urlpatterns = [

    path('admin/', admin.site.urls),

    path('index', views.index),

    url(r'^editbooks/(?P<nid>[0-9]*)/edit$', views.editbooks, name='editbooks'),

    url(r'^books/(?P<nid>[0-9]*)/delete$', views.delete, name='delete'),

    url(r'^books/$', views.books),

    url(r'^addbooks/', views.addbooks, name='addbooks'),

]

views.py

from  django.shortcuts import HttpResponse, render, redirect, HttpResponseRedirect

from .models import *

import decimal

from django.db.models import Avg, Sum, Count, Max, Min, F, Q

def index(request):

    return HttpResponse('ok')

def books(request):

    book_list = Book.objects.all()

    author_list = Author.objects.all()

    publish_list = Publish.objects.all()

    return render(request, 'books.html', {'book_list': book_list, 'author': author_list, 'publish_list': publish_list})

def delete(request, nid):

    book_obj = Book.objects

    print('_________________________________________________________')

    print(nid)

    book_obj.filter(nid=nid).delete()

    print('删除成功')

    return redirect('/books')

def addbooks(request):

    author_list = Author.objects.all()

    publish_list = Publish.objects.all()

    if request.method == 'GET':

        return render(request, 'addbooks.html', {'publish_list': publish_list, 'author_list': author_list})

    else:

        try:

            title = request.POST.get('title')

            price = int(request.POST.get('price'))

            pub_date = request.POST.get('pub_date')

            publish_id = request.POST.get('publish_id')

            autho_id_list = request.POST.getlist('author_id_list')  # 当获取多个数值的时候，使用getlist

            book_obj = Book.objects.create(title=title, price=price, publishDate=pub_date, publish_id=publish_id)

            book_obj.authors.add(*autho_id_list)

        except Exception as e:

            print(e, '数值郭达')

            return redirect('/addbooks')

        return redirect('/books')

def editbooks(request, nid):

    author_list = Author.objects.all()

    publish_list = Publish.objects.all()

    book_nid_obj = Book.objects.get(nid=nid)

    if request.method == 'GET':

        return render(request, 'editbooks.html',

                      {'author_list': author_list, 'book_nid_obj': book_nid_obj,

                       'publish_list': publish_list})

    else:

        # 编辑操作

        title = request.POST.get('title')

        price = int(request.POST.get('price'))

        pub_date = request.POST.get('pub_date')

        publish_id = request.POST.get('publish_id')

        author_id_list = request.POST.getlist('author_id_list')  # 当获取多个数值的时候，使用getlist

        print(request.POST)

        book_obj_ed = Book.objects.filter(nid=nid)

        print(book_nid_obj)  # Book 对象

        print('--------------------------------------------')

        print(book_obj_ed)  # QueySet

        book_obj_ed.update(title=title, price=price, publishDate=pub_date, publish_id=publish_id)

        book_nid_obj.authors.clear()

        book_nid_obj.authors.add(*author_id_list)

        return redirect('/books')

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建立一对一的关系

    authorDetail = models.OneToOneField(to="AuthorDetail", on_delete=models.CASCADE)

class AuthorDetail(models.Model):

    nid = models.AutoField(primary_key=True)

    birthday = models.DateField()

    telephone = models.BigIntegerField()

    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()

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建立一对多的关系,外键字段建立在多的一方

    publish = models.ForeignKey(to="Publish", to_field="nid", on_delete=models.CASCADE)

    # 与Author表建立多对多的关系,ManyToManyField可以建在两个模型中的任意一个，自动创建第三张表

    authors = models.ManyToManyField(to='Author', )

templates

books.html

<!DOCTYPE html>

<html lang="en">

<head>

    <meta charset="UTF-8">

    <title>图书管理系统</title>

</head>

{% load staticfiles %}

<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@3.3.7/dist/css/bootstrap.min.css"

      integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">

<body>

<h1>添加书籍</h1>

<div class="col-md-8 col-md-offset-2 " >

    <a class="btn btn-primary" href="{% url 'addbooks' %}"> 添加书籍</a>

    <table class="table table_striped table-bordered table-hover">

        <thead>

        <tr>

            <th>编号</th>

            <th>名称</th>

            <th>价格</th>

            <th>出版社</th>

            <th>出版日期</th>

            <th>作者</th>

            <th>操作</th>

        </tr>

        </thead>

        <tbody>

        {% for book in book_list %}

            <tr>

                <td>{{ book.nid }}</td>

                <td>{{ book.title }}</td>

                <td>{{ book.price }}</td>

                <td>{{ book.publish.name }}</td>

                <td>{{ book.publishDate | date:'Y-m-d'}}</td>

                <td>

                    {% for auth in  book.authors.all.values %}

                        {% if forloop.last %}

                            <span>{{ auth.name }} </span>

                        {% else %}

                            <span>{{ auth.name }} ,</span>

                        {% endif %}

                    {% endfor %}

                </td>

                <td>

                    <a class=" btn btn-warning data-toggle='button" href="{% url 'editbooks' book.nid %}">编辑

                    </a>

                    <a type="button" class="btn btn-danger data-toggle='button"

                       href="{% url 'delete' book.nid %}">删除</a>

                </td>

            </tr>

        {% endfor %}

        </tbody>

    </table>

</div>

<script src="https://cdn.jsdelivr.net/npm/jquery@1.12.4/dist/jquery.min.js"></script>

<!-- 加载 Bootstrap 的所有 JavaScript 插件。你也可以根据需要只加载单个插件。 -->

<script src="https://cdn.jsdelivr.net/npm/bootstrap@3.3.7/dist/js/bootstrap.min.js"></script>

</body>

</html>

addbooks.html

<!DOCTYPE html>

<html lang="en">

<head>

    <meta charset="UTF-8">

    <title>添加书籍</title>

</head>

{% load staticfiles %}

<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@3.3.7/dist/css/bootstrap.min.css"

      integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">

<body>

<h1>添加书籍</h1>

<div class="col-md-8 col-md-offset-2 ">

    <form class="form-horizontal" role="form" method="post" action="">

        {% csrf_token %}

        <div class="form-group">

            <label>书籍名称</label>

            <input type="text" class="form-control" name="title" placeholder="书籍名称">

        </div>

        <div class="form-group">

            <label>价格</label>

            <input type="text" class="form-control" name="price" placeholder="价格">

        </div>

        <div class="form-group">

            <label for="">出版社</label>

            <select class="form-control" name="publish_id">

                {% for publish in publish_list %}

                    <option value="{{ publish.pk }}">{{ publish.name }}</option>

                {% endfor %}

            </select>

        </div>

        <div class="form-group">

            <label>出版时间</label>

            <input type="date" class="form-control" name="pub_date" placeholder="出版时间">

        </div>

        <div class="form-group">

            <label for="">作者</label>

            <select multiple class="form-control" name="author_id_list">

                {% for author in author_list %}

                    <option  value="{{ author.pk }}">{{ author.name }}</option>

                {% endfor %}

            </select>

        </div>

        <input class="btn btn-success data-toggle='button" formmethod="post" type="submit">

    </form>

</div>

</body>

</html>

editbooks.html

<!DOCTYPE html>

<html lang="en">

<head>

    <meta charset="UTF-8">

    <title>编辑书籍</title>

</head>

{% load staticfiles %}

<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@3.3.7/dist/css/bootstrap.min.css"

      integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">

<body>

<h1>编辑书籍</h1>

<div class="col-md-8 col-md-offset-2 ">

    <form class="form-horizontal" role="form" method="post" action="">

        {% csrf_token %}

        <div class="form-group">

            <label>书籍名称</label>

            <input type="text" class="form-control" value="{{ book_nid_obj.title }}" name="title" placeholder="书籍名称">

        </div>

        <div class="form-group">

            <label>价格</label>

            <input type="text" class="form-control" value="{{ book_nid_obj.price }}" name="price" placeholder="价格">

        </div>

        <div class="form-group">

            <label for="">出版社</label>

            <select class="form-control" name="publish_id">

                {% for publish in publish_list %}

                    <option value="{{ publish.pk }}">{{ publish.name }}</option>

                {% endfor %}

            </select>

        </div>

        <div class="form-group">

            <label>出版时间</label>

            <input type="date" class="form-control" name="pub_date" value="{{ book_nid_obj.publishDate | date:'Y-m-d' }}"

                   placeholder="出版时间">

        </div>

        <div class="form-group">

            <label for="">作者</label>

            <select multiple class="form-control" name="author_id_list">

                {% for author in author_list %}

                    <option value="{{ author.pk }}">{{ author.name }}</option>

                {% endfor %}

            </select>

        </div>

        <input class="btn btn-success data-toggle='button" formmethod="post" type="submit">

    </form>

</div>

</body>

</html>

页面效果

其他功能等我学会了再来

最新文章

  1. 移植eac3音频库
  2. tjkd-html
  3. 安装系统时出现“windows无法安装到这个磁盘。选中的的磁盘采用GPT分区形式”
  4. Linux_rsylogd日志
  5. 20161005 NOIP 模拟赛 T2 解题报告
  6. Android:TextView 自动滚动(跑马灯) （转）
  7. Linux环境安装Jenkins
  8. Java中必须了解的常用类
  9. js调用MVC3自带js验证
  10. [BC]BestCoder Round#86小结
  11. PHP判断日期是不是今天 判断日期是否为当天
  12. Android 开源项目 eoe 社区 Android 客户端（转）
  13. LINUX更改时区和时间
  14. 分布式部署网站---文件系统的存储--ftp上传图片到指定文件服务器
  15. 用Python解答百度测试开发算法面试题
  16. IntentService原理分析
  17. Echarts 一个开源图表设计工具
  18. 08-部署node节点
  19. 【ZH奶酪】为什么Python不需要函数重载？
  20. 20165311 预备作业3 Linux安装及学习

热门文章

  1. java异常相关说明(printStackTrace,fillInStackTrace等)
  2. Java并发包源码学习系列：AbstractQueuedSynchronizer
  3. python之random 、os 、sys 模块
  4. 网络爬虫第一步：通用代码框架（python版）
  5. GitLab的安装及使用
  6. C语言的类型大小
  7. 【MySQL 高级】索引优化分析
  8. self-taught CS resouce recommendation
  9. 【.NET 与树莓派】使用 GPIO 库
  10. selenium自动化 | 通过获取cookies登录