Day66-图书管理系统-01
“Day66 图书管理系统（一） 学习笔记”
今日内容概述
- 项目准备
- 图书管理–图书增删改查
- choices参数（数据库字段设计常见）
- MTV与MVC模型
- 多对多关系的三种创建方式
- Ajax操作（重点）
- 前后端传输数据编码格式
- ajax发送json格式数据
- ajax发送文件
- django自带的序列化功能（了解，后面讲路飞学城的时候会将更加牛逼的序列化drf）
- ajax结合sweetalert实现删除按钮的二次确认操作
一、项目准备
1.1 创建day66_BMS项目
1.2 创建数据库
mysql> create database day66;
Query OK, 1 row affected (0.01 sec)1.3 配置连接数据库
编辑app01/init.,py文件
import pymysql
pymysql.install_as_MySQLdb()编辑settings.py文件
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'day66',
'HOST':'127.0.0.1',
'PORT':3306,
'USER':'root',
'PASSWORD':'123123',
'CHARSET':'utf8'
}
}1.4 创建数据表模型
编辑models.py文件
from django.db import models
# Create your models here.
# 创建数据表对象
class Book(models.Model):
title = models.CharField(max_length=32)
price = models.DecimalField(max_digits=8,decimal_places=2)
publish_date = models.DateField(auto_now_add=True)
# 一对多
publish = models.ForeignKey(to='Publish', on_delete=models.CASCADE)
# 多对多
authors = models.ManyToManyField(to='Author')
def __str__(self):
return self.title
class Publish(models.Model):
name = models.CharField(max_length=32)
addr = models.CharField(max_length=64)
email = models.EmailField()
# varchar(254) 该字段类型不是给models看的 而是给后面我们会学到的校验性组件看的
def __str__(self):
return '对象:%s'%self.name
class Author(models.Model):
name = models.CharField(max_length=32)
age = models.IntegerField()
# 一对一
author_detail = models.OneToOneField(to='AuthorDetail', on_delete=models.CASCADE)
class AuthorDetail(models.Model):
phone = models.BigIntegerField() # 电话号码用BigIntegerField或者直接用CharField
addr = models.CharField(max_length=64)
执行同步数据库操作
python .\manage.py makemigrations
python .\manage.py migrate确保数据表已经创建
mysql> show tables;
+----------------------------+
| Tables_in_day66 |
+----------------------------+
| app01_author |
| app01_authordetail |
| app01_book |
| app01_book_authors |
| app01_publish |
| auth_group |
| auth_group_permissions |
| auth_permission |
| auth_user |
| auth_user_groups |
| auth_user_user_permissions |
| django_admin_log |
| django_content_type |
| django_migrations |
| django_session |
+----------------------------+
15 rows in set (0.00 sec)1.5 数据库添加数据
使用navicat给数据库添加数据
# 作者信息表
mysql> select * from app01_authordetail;
+----+-------+------+
| id | phone | addr |
+----+-------+------+
| 1 | 11111 | 一区 |
| 2 | 22222 | 二区 |
| 3 | 33333 | 二区 |
| 4 | 44444 | 四区 |
+----+-------+------+
# 作者表
mysql> select * from app01_author;
+----+--------+-----+------------------+
| id | name | age | author_detail_id |
+----+--------+-----+------------------+
| 1 | 老一头 | 11 | 1 |
| 2 | 老二头 | 22 | 2 |
| 3 | 老三头 | 33 | 3 |
| 4 | 老四头 | 44 | 4 |
+----+--------+-----+------------------+
# 出版社表
mysql> select * from app01_publish;
+----+------------+------+------------+
| id | name | addr | email |
+----+------------+------+------------+
| 1 | 浪迹出版社 | 北京 | [email protected] |
| 2 | 天涯出版社 | 深圳 | [email protected] |
| 3 | 落花出版社 | 上海 | 456@qq,com |
| 4 | 流水出版社 | 广州 | 678@qq,com |
+----+------------+------+------------+
# 书表
mysql> select * from app01_book;
+----+----------+--------+--------------+------------+
| id | title | price | publish_date | publish_id |
+----+----------+--------+--------------+------------+
| 1 | 红楼梦 | 128.00 | 2022-11-17 | 3 |
| 2 | 水浒传 | 68.00 | 2022-11-01 | 2 |
| 3 | 西游记 | 200.00 | 2022-11-02 | 1 |
| 4 | 三国演义 | 60.00 | 2022-11-18 | 4 |
+----+----------+--------+--------------+------------+
# 书—作者表
mysql> select * from app01_book_authors;
+----+---------+-----------+
| id | book_id | author_id |
+----+---------+-----------+
| 1 | 1 | 2 |
| 2 | 1 | 3 |
| 4 | 2 | 1 |
| 7 | 2 | 2 |
| 3 | 2 | 4 |
| 5 | 3 | 3 |
| 6 | 4 | 2 |
+----+---------+-----------+1.6 添加首页
编辑views.py, 定义页面view
from django.shortcuts import render
# Create your views here.
def home(request):
return render(request, 'home.html')编辑urls.py添加解析
from django.contrib import admin
from django.urls import path
from app01 import views
urlpatterns = [
path('admin/', admin.site.urls),
# 首页
path(r'^S', views.home, name='home')
]新建文件template/home.html添加首页
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link href="https://cdn.bootcss.com/twitter-bootstrap/3.4.1/css/bootstrap.min.css" rel="stylesheet">
<script src="https://cdn.bootcss.com/jquery/3.3.1/jquery.min.js"></script>
<script src="https://cdn.bootcss.com/twitter-bootstrap/3.4.1/js/bootstrap.min.js"></script>
{% block css %}
{% endblock %}
</head>
<body>
<nav class="navbar navbar-inverse">
<div class="container-fluid">
<!-- Brand and toggle get grouped for better mobile display -->
<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1" aria-expanded="false">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="#">图书管理系统</a>
</div>
<!-- Collect the nav links, forms, and other content for toggling -->
<div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
<ul class="nav navbar-nav">
<li class="active"><a href="#">图书 <span class="sr-only">(current)</span></a></li>
<li><a href="#">作者</a></li>
<li class="dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">更多 <span class="caret"></span></a>
<ul class="dropdown-menu">
<li><a href="#">Action</a></li>
<li><a href="#">Another action</a></li>
<li><a href="#">Something else here</a></li>
<li role="separator" class="divider"></li>
<li><a href="#">Separated link</a></li>
<li role="separator" class="divider"></li>
<li><a href="#">One more separated link</a></li>
</ul>
</li>
</ul>
<form class="navbar-form navbar-left">
<div class="form-group">
<input type="text" class="form-control" placeholder="Search">
</div>
<button type="submit" class="btn btn-default">Submit</button>
</form>
<ul class="nav navbar-nav navbar-right">
<li><a href="#">Jason</a></li>
<li class="dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">更多操作 <span class="caret"></span></a>
<ul class="dropdown-menu">
<li><a href="#">Action</a></li>
<li><a href="#">Another action</a></li>
<li><a href="#">Something else here</a></li>
<li role="separator" class="divider"></li>
<li><a href="#">Separated link</a></li>
</ul>
</li>
</ul>
</div><!-- /.navbar-collapse -->
</div><!-- /.container-fluid -->
</nav>
<div class="container-fluid">
<div class="row">
<div class="col-md-3">
<div class="list-group">
<a href="#" class="list-group-item active">
首页
</a>
<a href="#" class="list-group-item">图书列表</a>
<a href="#" class="list-group-item">出版社列表</a>
<a href="#" class="list-group-item">作者列表</a>
<a href="#" class="list-group-item">更多</a>
</div>
</div>
<div class="col-md-9">
<div class="panel panel-primary">
<div class="panel-heading">
<h3 class="panel-title">BMS</h3>
</div>
<div class="panel-body">
{% block content %}
<div class="jumbotron">
<h1>欢迎来到亚洲最大的线上读书平台!</h1>
<p>这里有的没有的书籍都有</p>
<p><a class="btn btn-primary btn-lg" href="#" role="button">点击有你好看哟～</a></p>
</div>
<div class="row">
<div class="col-sm-6 col-md-4">
<div class="thumbnail">
<img src="data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEABsbGxscGx4hIR4qLSgtKj04MzM4PV1CR0JHQl2NWGdYWGdYjX2Xe3N7l33gsJycsOD/2c7Z//////////////8BGxsbGxwbHiEhHiotKC0qPTgzMzg9XUJHQkdCXY1YZ1hYZ1iNfZd7c3uXfeCwnJyw4P/Zztn////////////////CABEIALkAsAMBIgACEQEDEQH/xAAZAAEAAwEBAAAAAAAAAAAAAAAAAgMEAQX/2gAIAQEAAAAAzAAAAAAAAAAADvAAAC2vhKaMDs6wE7K2uzqPMadUQC/s9FF8a7qqY0gC+23sc7RLsK6KgGyyblFFWnWVdxRBZqrvlG67zqN/I4uQAG6/T0z30ZcQAL/Wnh1TzaWLzQAetfLPZCadfigA1782fdb5rd51AADW324K80AABr9BHyIgAErb/Zr75WeqIAd2XOTuoj1Tj4AbrQAz5AF21R24A86IHoT5XKYOdZsoLdznQHOo+cDZe50BzpgrD0ZudAc6Y87/xAAZAQEBAQEBAQAAAAAAAAAAAAAAAwIBBAX/2gAKAgIQAxAAAACH0wAAAOOgAAMT7uec80prmd0AxmMstMurUpsOI4liub4jqO70proCEbzCW63ABF1NZhYAOOcQV7voA4ljGbwnvNa730CGJ444DT1W6OPJEOAPRSuiWfPMACuvRT//xAAxEAACAQMCBQIEBAcAAAAAAAABAgMAETESIQQQMEFREyAyYXFyBRRAkRUiIzNCYIH/2gAIAQEAAT8A/wBGtsT1bG1+imDRFibY9gR2wpNehL4FehJ4FGKQf4n2KLkCn2UDoxnciiAaKG5tSxsxtikhRe1z5NEgZIHNWVxdWBFMiuNxRjIOa0AHegCBa96c3PSU3HJBdvpyng9cINVrHkyh1ZT3BFQQiFCoJO9yeTpfccma316aQyZ2WjG3kUoCi1XGL076B5JxWp2O7N+9qV3HwuT9dxSPrGLEZFb+ORRTRgjOCQaeFk3yOiiCIXO7UrFifZMCGU2JBstOzQt/URwGwTQ4hNXcKMVwzo5azb+O9h7HU3uKQt3x5NPbU2nF9vfEQJATTAZLqKMyICF/mNISyKT3HIlydMa3b54H1qLhxGS7MXkOWNOiupVlBB7Gn/DEO6OVr+GSjEy0sTogDPqPc2tyfZH+00ssiiwamkd8npwm8Y+W1Kuo0Bb2Hi+GvYShvtBagQygg3BFxTpbcVObRn57dXh2sxXzSrpHKaHgYV1yoNzk3ZqjVVRQhJXtc3rYjsQaPEKnErwwQ7rnkRepuFZxcPuBsOrw6hIEKi5YXNK4aiQBcmwqT8vOND2YXp5I4gutgoOwJxXrwJpRGVjhUTenlRDYneklRzYHemJAq5jVndsdWDifTGhxdaSSJt1cVO5Z7dhVj571AxZCp7VpWNGKKo27C1G5796Fx3p50RAzZIwKmneY+FGB1gSCCMigwk3HxdxQBJsBUMZRd8miLgg08LqcEiiNIu+wqRzI1/2H6AEjcVHxbrswvXqeVr1B4NF3ONqZ2c3Y/oFR2wpNDh3OSBUUSxsGO5BBoxRSjUO/cUeFHZzQgjTd2qeJJXd12JYmjw7jBBpkdcqR1FUsQAN6SBV3O55kUkrx4JFfm5bfEtPKz5YtQvk83hRsbGiCpIPSij0L8zn3WHj3cQlxrHbPRgTU1zheXenmKOVKgi1QyFw1wBbo52NOuhivQjTQgHLualj9QC2RSIEWw957fXnxC4b/AIffAuqQeBvzGT0W5uupWXyPfw62S/nmvRbB9ky6ZG90X9tPtHNcdFvhPs4j4x9vP//EACQRAAEEAAUFAQEAAAAAAAAAAAEAAgMREBIgMVETISJAQTBx/9oACAECAQE/APYuiVYRl4C6rkJT9CzBXZ0uqu5RcKTbBFbrIeU6yTe6Dk1zdB7AogEcuwjYdygGqSP6DhldVGtWS3nhDArp+YI9PuP4swVk7LbW6XhGRx+oTRncG0+W6yighK5NeHaZXfEGk7IijWhpykHQTQJRNlAkGwib0xG21jKfH8Ij5Yf/xAAiEQEAAgEEAgIDAAAAAAAAAAABAAIREBIgITAxA0ETQFH/2gAIAQMBAT8A/YVraFiN5vYXm8gtnjYNHQ0rg49J/XRY7vqVX7NMOMcrdMdCVTPfOwmcw+PJ3ERxPxmIVXwZQ6jlcytrPgbRVmy56t1KFhyuWb2CPGz9QM8Rw8HwVetbevBX3p//2Q==" alt="...">
<div class="caption">
<h3>Thumbnail label</h3>
<p>...</p>
<p><a href="#" class="btn btn-primary" role="button">Button</a> <a href="#" class="btn btn-default" role="button">Button</a></p>
</div>
</div>
</div>
<div class="col-sm-6 col-md-4">
<div class="thumbnail">
<img src="data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEABsbGxscGx4hIR4qLSgtKj04MzM4PV1CR0JHQl2NWGdYWGdYjX2Xe3N7l33gsJycsOD/2c7Z//////////////8BGxsbGxwbHiEhHiotKC0qPTgzMzg9XUJHQkdCXY1YZ1hYZ1iNfZd7c3uXfeCwnJyw4P/Zztn////////////////CABEIALkAsQMBIgACEQEDEQH/xAAaAAACAwEBAAAAAAAAAAAAAAADBAECBQAG/9oACAEBAAAAAMfulrdwWSHLdNLVrkKsNOijMbdIUuK3BbyoC7eWkZ16Iuza/RmdBCcIElFlkffDwWht1qPh1vFa1Gxnj3BhlZ+G02qIAu31JJcSU6NO44y2AXgJjegCBHTpmZm/Q3WlYtVWx6BEU8jiaFL3cIJGKgIzVO7F4Wpa1qMLFg4A0EXpizHCrRwogEXMTlYgVoibzA9KawrS0zZdhYw1GaAcsE7dxgHDS4grDtpQQVJKLMd0DiGMekqjSgn7ZW3eKqKA0g69b07NbWWV0S1ytM8hHnG0MjeZZGHBmlBaDNcorAwiu+TO1NI895SKj7QYXQiI6Hjzm62ra/eVilY0yJLTWsdr9TO0nTTTErTo0zZArRFSa1KZjDDA6Apa5XRZNZiOZ0KBzjQTp6/oBiaxs6O6IdaumgSevLO7o589k5cU6Z0nj4Kc3m1vaTCQe7LRXNeNw3Y+dxOm3tegOVfpErF3WWF8TN4ndHuolXMETpJIzmMLAz6mt3f/xAAYAQEBAQEBAAAAAAAAAAAAAAABAAIDBP/aAAoCAhADEAAAAO/Mc3PtjVMXTFkSaaHOqqk3gJE25NJlQ1EI5N51MUg0Mym+OOlCkwapHMFPbjXLvaDWHOOmsPO1o6c98uHq59K68XPD0OdY7Ypy5z1yzrkPD0FHp405o1I65Z3jeVOuc2sTI1rlnqJRNWdg1Tg6CUTG8OTROeHbqTVf/8QANhAAAgIBAgQEAwYGAgMAAAAAAQIAEQMSIQQxQVEQEyJxBTJhFCBCgZGxIzNTYnKCFVI0Y6H/2gAIAQEAAT8Al0ItUTYsdIZwCa+JX+0EzMLxZPaJvlaAese0Y17xBVCIdz7xjYimg/e7jg6jUxPrQNcz/JH2acmisfTOGO7TVGMo9pl4d8TaPm7UJi+F58gtyEEX4Pg6vkM/4vhf7/1mLgeHwtqQEN3uPjYqRYNiYsZ81wZopiYE9RMWAbmHlHFNqjCiGHKYn8tq/CeUZgyzMtExvmi/KJwwFtK+s0iaBF2YQOw6zzhNYMLQOLmFafMxj5d9oHJ6RWlwtcbw0CIByuZsVqYy7ReU4TGWDQ4py6y/rEJ5mIxMq8gvvNXQzK2hZgU1rPNv2mktrvq5JnlqIyj7hE0iHGx5GFXTeIdazMuhjE9dATCgxrMvEDkIA55AzRl+kxZhyNg9jMZ5zfXF5TJqyPpgYrQqEgXUy8RRoC5k4nJiNMoMxcQmXlzgO3gTvAVHMwMIQpEVNJNTix6x7ThMQJLEbCNXKAheSgTUe81Q8NiyA2oszHw5wMdzRh9XSNaKID6tUDgwrtH08iJlw4n52Jj4dMZGljzgWhCI+oaQBzO57TiWdMhCs1CqmI59IammPLexBB7HwyocmQCOAiKByiY8jAUIFxnYsbnldiDNDdjFZg2lukBDCEgdIXB2M0IN5akgAbDfwfGGG8OIRUHQQYiRHxlYy9pZERm6CeWW5wYBBix6qYC4+JVddR9Aj5wo9MAGYll27npEZkYqTNZ7zMuoahzEV9hGaG7s7CNkZwdALV2EwE6STsZqheO8xKdOo9YDH3EY1zEVdUVFHhcztQDdRHOtFN7iJsppKPeKjhQFEbHYBcmx22mgdz+sbkfaJUuBR1FmCgJloGFjCxjbmeawAEGb6xeIUHczNkVwKmJ6EGQTzBHy1BqIsrFFMFPKA2YI7iqM1r3nm3qGg8vfnAaMBgNQvULNlygIL8DGIU2eUV0cbMDCBKHgsuFqBMRiTZiepfpGRStVUAqF6jtZ8CgGT8RAhimNlFR8ndgJiz8JhQ+sk9TUbjuHyZdgVvq3g66oqHDk1fhmq1Wk17bkECFnsacRA66iBUfJlU6A1t7THegXzhjtyF9YFTymoxDsIWhNRzcPg6FQGHOMeo/MdRC8Ds7EKDQ6xwbJuNss4TFrPmP8oPpHczXvEzJkLAHccxGW4cf0hRj3i46gNTLlVBZiZXzcShPIGwJnZ1x6lNFTf5GYMmvGrDqJcYnwcvdLKy9zFyJlHp59VmVN47AGmBPtC5TGa1b9NNRmBEKnI4QHnFAAAAoAUBGJG4jsycRqBptUx5BkW+vhUNAWZkznkn6zJ6UZ236ThTWT8pkGrHkHdDPh/EUTib3WavAJtcqVFy1U+12Kaj9TC6C6aNk7maz+U4BbTNkb2gmxPOFi3q63cxvVTzXEOZuwjEtzMagCZlyHIw7DlOFT1EmA713mK9VjpMOUZUDRL+kG8yYQw9LFfafZn/qvL3hNxmMdunhwxIxVfMkzrMx04chrmK/WCJmK/UT7Yv8ATMbi2PJAIeJzH8VQsx5sTMKaiSeQmJQvKA+tfeINI/OcJpUsgJugTYiL1gl/cPfxwisae0AnGHSiL3JMEI+7gT+CD3JMFiKfUPeBixqcKhbIMg/6BXEAIggBIvp3PKWn9RP18DG7eKClHtKO04s3krsAIPA/cClAijooEO8NgMfoZiNODMWUiiGKsOTROLz8mCGfaMx5BRDdB8zmp5uDs0uMYBCJUAiDcTK2t2buT4344l15ca92EYmz4Oax5P8AAwbERWq5jzd4vEaAKazHz6jdkn6zzW8DvAu0y4XRcbMpAdbExcHlfS1oOR3MfGQ1AdJqKjIT0Uw+B5D7nCD+OD2DGFgQR4ZjWHJ9aEMT1AfpFJBIgN8oLEsfWUTAlkACyTQAnDfDseMKco1PPi6WmJ5wwJxYgLsoJ5JBPcipmasDV+N68TOkPhwY3yt2AEJBoxELXOIPoA7t+3hjPMQj1t4Bb5zTEwu50opY/ScDwQwDXkAOT9vD4mL4U+4mFQFrsAP0nEP5eF26hTX57TLwpZAi2SFsQCzGFeIUmMtTgMWvG/1aeQ40U60OQIgxlVrSL+k4lGUJY6tKi7NH2aXA30mpf+sVVUUoAHYePHgnhv8AdZrZXNd5l9SoGbnkH/yzC1OP8RONxaM7Ho/qjix4KsEbfacJj8jhsasKZhZm7EDtBfPrPiROtAe1w9BOprvGFwbiAXNDdvucRWij1M1Mtm4mda/iKaEGXXqYiuoH0hbHlATImoA7RuE4ZrCsymP8Ly3aOrQ8FxQoeTF4E882UL/avqMxomEEYl0tys7tGQPpgGkaVAAEyjS3uJ8T/nIP/WJzaLBKINw33M37nxHOcZyWPyPvPwz8OL/ExOkf5T7ROSQ/Pm9x+0PziL8x95+IewmT+Yv+v7zP8yz4j/5X+iwdZ0nfw6eH/8QAIBEAAgICAgMBAQAAAAAAAAAAAAEQEQIxEiADITAiUf/aAAgBAgEBPwC0ckN2NyoxmizF7LvLsnDh6E6TMdXH5qErH6ELK2y40Nl/CoyafwU0yyhYIfiv2j2vThmGNs8mPFwoeAsEUaPIoowVGauEy10Yziv4UhaGZbin8ctjRxZxUWWtX2fS44PnY5UPqtxQ1QkP0eJ/tdf/xAAiEQACAgICAwEAAwAAAAAAAAAAAQIREDESIQMgQTIiYnH/2gAIAQMBAT8AooSF6telHkSVUcUoW9+zGLC2NXJHk7aQju8N0LtDHFJJji18x+kJHGu/uH6Ltl0l1bHL58P4kLWF60iWui7Ol2zmhLEpti8qj0yLT/xnH+w6JyqLPFLlHvEnhTHN/Bm2ePVZ8jtM8Tq8NWcXmWhbNHJlkn2Q+i1i1mRFesNMTo5L4jk8UNNkdZeniOvbkuFCeW+hojperxYnY3SF3sn+GLQ8/wD/2Q==" alt="...">
<div class="caption">
<h3>Thumbnail label</h3>
<p>...</p>
<p><a href="#" class="btn btn-primary" role="button">Button</a> <a href="#" class="btn btn-default" role="button">Button</a></p>
</div>
</div>
</div>
<div class="col-sm-6 col-md-4">
<div class="thumbnail">
<img src="data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEABsbGxscGx4hIR4qLSgtKj04MzM4PV1CR0JHQl2NWGdYWGdYjX2Xe3N7l33gsJycsOD/2c7Z//////////////8BGxsbGxwbHiEhHiotKC0qPTgzMzg9XUJHQkdCXY1YZ1hYZ1iNfZd7c3uXfeCwnJyw4P/Zztn////////////////CABEIALkAsAMBIgACEQEDEQH/xAAaAAEAAwEBAQAAAAAAAAAAAAAAAgMEAQUG/9oACAEBAAAAAPPAAAAAd4AAOJ6bXaO0VgAX35M1SzXqYQA088+EXHO7PT8/gCy/zYiLnO79/mgNuKuRyKEeT9zDSDu/FyXUYcjCLfr80F98rW3leJzFm5f7HkA0X+jZMjGumGHz7vd8QE/V28WRgjVGHjPe8MHPY1OaI1c5THvl1+p5YH0sYQ1xprU8nilb5oOfSzhKNNvYVVx5TLz+A922Mqs+mfM9bubuIDdvo7oqZtddbkMMQJezPD5tcPW9XLDLkAC/1LclbV2qjzwAJ79kYcjmxAAJT9CNcZ56HAA0+r5VuqmqvN3fhiAc365YaOR5drozQAJ3V7dkYc7XghyIBqsxz9G+POYMV92bjj//xAAZAQEBAQEBAQAAAAAAAAAAAAAAAQIDBAX/2gAKAgIQAxAAAADpkCCgADFxss1NZoDGueqEWzpioOHVRKsl689SJeHZYtS5s3jpmDh3m5FpnWN46Zg4emWCmV6Z68IOPozVRQ7cN4DG+XbWZc3pz6cqAM64dzWe/FACXzd/RzlOG/TwsAutPmek1Po+bBD/xAA2EAACAQMDAAkCAwcFAAAAAAABAgADESEEEjEQEyAwMkFRcYFhkSIzQgUUNENygqFAUFKx0f/aAAgBAQABPwD/AGAKzcKTCCORb/RKjNwItEjhb/4gpi34j8cwikDyBLUjm+76HMq0w35agQUFFgw+Y1J1YjaYQQbEWPe06JOSPj/2F0ojJF/pH1bMTtwI9Zz+ozeYKrDzi6motrGUte45iaujVwSVPkZVo7kDAg28xCLd3RpcO3xK1fbdVjsW6bS0t0AzT6l6bDManTrpuXBjKVJB5Hc0k3tK9TYLCMSZaFZtm2WzCJaWgmlrbTNVSDoKiDI7miNlLceTmVCWabYFhWbZtgXMK8zbCJbmUjZppahamBNRT6uobeE5Xtou9lX1MrGwAlswrNsKm82G3E2m0CwiWhHM9YviE0dSx+ZrKeD9LMPY9ugv4ryucyjpXfJwsNHTocvc+gm0ubUqXyZ1Sek6lPSVaIKHYBeWUYqUyJ1Wnbh7e8bS4uDKlJk5E8ujTmxmqzT90Pb05G5R6tFXrdWqHK5J+IaPWfmn2QYAgpUl4RewZgw0aR5RYdPTGUJU/Qwq/D2YesraYAErDi4lDxTUC1FD7dumdrqfrNKoNd6g4NOEy8B6TLwmFoTDNWu2sZpsuJqfAF+ghySe3+zxUCPuUhbDbHdEIDOoJ9TLi1wYDnoMMvDCR6iA9GtH4hNGCayia17qQD6Qm57VrkD1Mpbm3348oaaqxIUXPJjIp8s+owYlw4U/B6DHwILvgH3MNJDyu7+rMajSP8tYqbTybfWGV031FESmlLgXYzFQbGHMOCR2jKBuzN5FBb5jdAtC58oatuYCGlgBGhMJl4QCYXybRDci/IMJuSfU9vRODpgfMDaYWtOsEBvHJWHcTKZ2qAZvEJjGGDoLDcbRz1dMk+JsDuNA9ndPJl/yI8/F5SjqqZqdSyuKnpGq0eC1veGpQH6xN6nw3PsI9dFfZkt6CKDbMfo4iujXswj1KVO/BPoI7tUYs3cI5R1ccgxXVwGHBgE11AvaomGEGo1gTNZ/nM/ftX5VD9hDX1lY7OtqNu8rzR6YUucseTDxH56NTU/lj+7vKNc0jY5UxHDAEG4mGFo9EZBRWUnIIxDR0540yj5aJRRPCgETEZ4ZWrdWMeL/AK76nUamcfaU9Sp+hgYGECG0vLypqQMJk+sJJNz3yo7i4GPXynVqOW+0poqom0HK35hqMvIMNYehnWMYHG0q6hgZVFIJcJbMweDCpXkd5paArud3gXmOqtT2WAFsW8o6FSVYSjX2AK4uBwZ1lB/1D5xGpLyCIV28kfeGpTHLX9pUc1CMWA4Ep0y5+nnLBl2sMSohRivd0qjUUCj3IiV1f6GOi1BYiPQdeBcdBEKiBb8C8TTE5bAgQAWAsI9YDC5MZi+ScjuqalnUAXjcxmtKFfADn2PQVB5AMNOn/wAF+06umP0L9pYRiFFybSpW3kL+mGAEmw7rRfxK/wBLTU/xD+8fiL4R7TTeA+8PQejU/mf2w+Nffo03jaN4m9z2f//EACMRAAICAQQBBQEAAAAAAAAAAAECABEgAxASMSETIjBBUlH/2gAIAQIBAT8A+YtUszz/AGWYGyZqyVqNHEmzLly9zFNjc9ZXDE6wIo5fUTr49M94MKO1SjvRMVeIwdbnUsQnZF+8+HLdasSqyIZlPHuaeo+ixVwanp6ep5Vp6B/c4pp+WaFn1W9olEAX3ije7jX1cdF1BRjDgxAM5N+jNNebUTEQKKEJtyN//8QAIhEAAQQCAgEFAAAAAAAAAAAAAQACESAQIRJBMQMTMFFh/9oACAEDAQE/APmAUBaUBEWAsRUDShQoyEcjzYjDvNG7UV7TvNO8RRokr1gBFGGW4kqUMBwG09/M0Y6McSoAw93Vw4jLuXVxEiUWh4kLk5uiF7n4pc/QCADBtGJ1WNSmuLTIQMhQPpOPEIkk7RGhn//Z" alt="...">
<div class="caption">
<h3>Thumbnail label</h3>
<p>...</p>
<p><a href="#" class="btn btn-primary" role="button">Button</a> <a href="#" class="btn btn-default" role="button">Button</a></p>
</div>
</div>
</div>
</div>
{% endblock %}
</div>
</div>
</div>
</div></div>
{% block js %}
{% endblock %}
</body>
</html>运行后的界面如下:
二、图书管理系统的增删改查
2.1 图书列表展示页面
实现功能：点击“图书列表”展示当前已有的图书
1、编辑urls.py添加url
urlpatterns = [
path('admin/', admin.site.urls),
# 首页
path('', views.home, name='home'),
# 添加图书展示页
path('book/list/', views.book_list, name="book_list")
]2、编辑views.py添加view
from django.shortcuts import render
from app01 import models # 导入模块
# Create your views here.
def home(request):
return render(request, 'home.html')
# 创建书籍展示页的view
def book_list(request):
# 先查询出所有的书籍信息 传递给html页面
book_queryset = models.Book.objects.all()
return render(request, 'book_list.html', locals())3、创建书籍展示页的html文件templates/book_list.html
{#继承home页面#}
{% extends 'home.html' %}
{#重写已定义的content块#}
{% block content %}
{# 添加按钮#}
<a href="" class="btn btn-success">添加</a>
<br> {# 添加空格#}
<br>
{# 创建表格,使用bootstrp的模板#}
<table class="table table-hover tabular-stripped">
<thead>
<tr>
<th>ID</th>
<th>书名</th>
<th>价格</th>
<th>出版日期</th>
<th>出版社</th>
<th>作者</th>
<th>操作</th>
</tr>
</thead>
<tbody>
{% for book_obj in book_queryset %}
<tr>
<td>{{ book_obj.pk }}</td>
<td>{{ book_obj.title }}</td>
<td>{{ book_obj.price }}</td>
<td>{{ book_obj.publish_date | date:'Y-m-d'}}</td>
<td>{{ book_obj.publish.name }}</td>
<td>
{% for author_obj in book_obj.authors.all %}
{% if author_obj.last %}
{{ author_obj.name }}
{% else %}
{{ author_obj.name }}、
{% endif %}
{% endfor %}
</td>
<td>
<a href="" class="btn btn-primary btn-sm">编辑</a>
<a href="" class="btn btn-danger btn-sm">删除</a>
</td>
</tr>
{% endfor %}
</tbody>
</table>
{% endblock %}4、给图书列表按钮添加链接，修改home.html文件
# 75行
<a href="#" class="list-group-item">图书列表</a>
# 改为
<a href="{% url 'book_list' %}" class="list-group-item">图书列表</a>5、点击图书列表查看效果
2.2 书籍的添加
2.3 书籍的编辑
2.4 书籍的删除
三、Choies参数
四、MTV与MVC模型
五、多对多的三种创建方式
六、Ajax
Day66-图书管理系统-01
http://gsproj.github.io/2022/11/17/03_Python/05_Django/day66笔记-图书管理系统-01/