Python django之搭建简单图书管理系统_django图书管理项目简单

作者：2023面试高手 | 2024-05-27 03:37:31

踩

django图书管理项目简单

搭建简单图书管理系统

1 创建项目
2 创建APP
3 设置setting.py文件
4 bookms/urls.py配置
5 app01/model.py配置(orm模型)
6 app01/views.py 视图函数
7 templates/addbook.html
8 templates/changebook.html
9 templates/selectbook.html
10 数据库迁移
11 更新数据库
12 静态文件：bootstrap目录
13 运行项目

1 创建项目

# 使用的django版本为2.1.2
django-admin startproject bookms
1
2

2 创建APP

cd bookms
python3 manage.py startapp app01
1
2

3 设置setting.py文件

ALLOWED_HOSTS = ['*']

INSTALLED_APPS = [
    'django.contrib.admin',
    'django.contrib.auth',
    'django.contrib.contenttypes',
    'django.contrib.sessions',
    'django.contrib.messages',
    'django.contrib.staticfiles',
    'app01',
]

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 = 'bookms.wsgi.application'


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

# mysql数据库需要自己定义
DATABASES = {
    'default':
    {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'bookms',		# 数据库的名字
        'USER': 'root',		        # 登录数据库的用户名
        'PASSWORD': '123456',	    # 登录数据库的密码
        'HOST': '127.0.0.1',	    # 数据库的IP地址
        'PORT': '3306',		        # 数据库的端口
    }
}

STATIC_URL = '/static/'
STATICFILES_DIRS = [
    os.path.join(BASE_DIR, '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',
        },
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70

4 bookms/urls.py配置

from django.contrib import admin
from django.urls import path,re_path
from app01 import views

urlpatterns = [
    path('admin/', admin.site.urls),
    path('addbook/', views.addbook),
    path('selectbook/', views.selectbook),
    re_path('books/(\d+)/delete/', views.delbook),
    re_path('books/(\d+)/change/', views.changebook),
]
1
2
3
4
5
6
7
8
9
10
11

5 app01/model.py配置(orm模型)

from django.db import models


class Book(models.Model):
    id = models.AutoField(primary_key=True)
    title = models.CharField(max_length=32,unique=True)
    # state = models.BooleanField()
    pub_date = models.DateField()
    price = models.DecimalField(max_digits=8,decimal_places=2)  # 最大值为999999.99 总共8个数字，其中包含小数点有两个
    publish = models.CharField(max_length=32)
1
2
3
4
5
6
7
8
9
10

6 app01/views.py 视图函数

from django.shortcuts import render,HttpResponse,redirect
from .models import Book


def addbook(request):
    print(Book)
    if request.method.lower() == 'post':
        title = request.POST.get('title')
        price = request.POST.get('price')
        pub_date = request.POST.get('pub_date')
        publish = request.POST.get('publish')

        Book.objects.create(title=title,price=price,pub_date=pub_date,publish=publish)
        return redirect('/selectbook/')
        # return HttpResponse('{}-{}-{}-{}'.format(title,price,pub_date,publish))

    return render(request,'addbook.html')


def selectbook(request):
    book_list = Book.objects.all()
    return render(request,'selectbook.html',locals())


def delbook(request,id):

    Book.objects.filter(id=id).delete()
    return redirect('/selectbook/')


def changebook(request,id):
    book_obj = Book.objects.filter(id=id).first()

    if request.method.lower() == 'post':
        title = request.POST.get('title')
        price = request.POST.get('price')
        pub_date = request.POST.get('pub_date')
        publish = request.POST.get('publish')

        Book.objects.filter(id=id).update(title=title,price=price,pub_date=pub_date,publish=publish)
        return redirect('/selectbook/')

    return render(request,'changebook.html',locals())


# Create your views here.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47

7 templates/addbook.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
    <link rel="stylesheet" href="/static/bs/css/bootstrap.css">
<!--    <link rel="stylesheet" href="/static/bs/css/bootstrap.min.css">-->
<!--    <link href="https://cdn.bootcss.com/twitter-bootstrap/2.3.2/css/bootstrap.min.css" rel="stylesheet">-->
    <style>
        .container{
            margin-top:100px;
        }
        .btn{
           margin-top:10px;
        }
    </style>
</head>
<body>

<center> <h3>添加书籍页面</h3> </center>

<center>
<div class="container">
    <div class="row">
        <div class="col-md-3 col-md-offset-7">
            <form action="/addbook/" method="post">
                {% csrf_token %}

                <div>
                    <label for="">书籍名称</label>
                    <input type="text" class="form-control" name="title">
                </div>
                <div>
                    <label for="">价格</label>
                    <input type="text" class="form-control" name="price">
                </div>
                <div>
                    <label for="">出版日期</label>
                    <input type="date" class="form-control" name="pub_date">
                </div>
                <div>
                    <label for="">出版社</label>
                    <input type="text" class="form-control" name="publish">
                </div>

                <input type="submit" class="btn btn-success pull-right">

            </form>
        </div>
    </div>
</div>
    <a href="/selectbook/" class="btn btn-primary">查询书籍页面</a>
</center>
</body>
</html>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55

8 templates/changebook.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
    <link rel="stylesheet" href="/static/bs/css/bootstrap.css">
<!--    <link rel="stylesheet" href="/static/bs/css/bootstrap.min.css">-->
<!--    <link href="https://cdn.bootcss.com/twitter-bootstrap/2.3.2/css/bootstrap.min.css" rel="stylesheet">-->
    <style>
        .container{
            margin-top:100px;
        }
        .btn{
           margin-top:10px;
        }
    </style>
</head>
<body>

<center> <h3>编辑书籍页面</h3> </center>

<center>
<div class="container">
    <div class="row">
        <div class="col-md-3 col-md-offset-7">
            <form action="" method="post">
                {% csrf_token %}

                <div>
                    <label for="">书籍名称</label>
                    <input type="text" class="form-control" name="title" value="{{ book_obj.title }}">
                </div>
                <div>
                    <label for="">价格</label>
                    <input type="text" class="form-control" name="price" value="{{ book_obj.price }}">
                </div>
                <div>
                    <label for="">出版日期</label>
                    <input type="date" class="form-control" name="pub_date" value="{{ book_obj.pub_date|date:'Y-m-d' }}">
                </div>
                <div>
                    <label for="">出版社</label>
                    <input type="text" class="form-control" name="publish" value="{{ book_obj.publish }}">
                </div>

                <input type="submit" class="btn btn-success pull-right">

            </form>
        </div>
    </div>
</div>
    <a href="/selectbook/" class="btn btn-primary">查询书籍页面</a>
</center>
</body>
</html>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55

9 templates/selectbook.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
    <link rel="stylesheet" href="/static/bs/css/bootstrap.css">
    <link rel="stylesheet" href="/static/bs/css/bootstrap.min.css">
    <link href="https://cdn.bootcss.com/twitter-bootstrap/2.3.2/css/bootstrap.min.css" rel="stylesheet">
    <style>
        .container{
            margin-top:100px;
        }
        .btn{
           margin-top:10px;
        }
    </style>
</head>
<body>

<center> <h3>查看书籍页面</h3> </center>

<center>
<div class="container">
    <div class="row">
        <div class="col-md-3 col-md-offset-7">
            <table class="table table-striped table-bordered">
              <thead>
                <tr>
                  <th>书籍名称</th>
                  <th>价格</th>
                  <th>出版日期</th>
                  <th>出版社</th>
                  <th>删除操作</th>
                  <th>编辑操作</th>
                </tr>
              </thead>
              <tbody>
              {% for book in book_list %}
                <tr>
                  <td>{{ book.title }}</td>
                  <td>{{ book.price }}</td>
                  <td>{{ book.pub_date|date:'Y-m-d' }}</td>
                  <td>{{ book.publish }}</td>
<!--                  <td> <a href="/books/{{ book.id }}/delete/" class="btn btn-danger">删除 </a> </td>-->
                  <td> <a href="/books/{{ book.pk }}/delete/" class="btn btn-danger">删除 </a> </td>
<!--                    book.pk为主键删除-->
                  <td> <a href="/books/{{ book.pk }}/change/" class="btn btn-info">编辑</a>   </td>

                </tr>
              {% endfor %}
              </tbody>
            </table>
        </div>
    </div>
</div>
    <a href="/addbook/" class="btn btn-primary">返回添加页面</a>
</center>
</body>
</html>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59

10 数据库迁移

python3 manage.py makemigrations  # 默认所有修改过的model层转为迁移文件
1

11 更新数据库

python3 manage.py migrate   # 默认将所有的迁移文件都执行,更新数据库
1

12 静态文件：bootstrap目录

下载连接：http://getbootstrap.com/2.3.2/assets/bootstrap.zip
项目根路径：bookms/static/

目录结构为
[root@a37a35a64335 bookms]# tree
.
`-- static
    `-- bs
        |-- css
        |-- img
        `-- js

1
2
3
4
5
6
7
8
9
10
11
12

13 运行项目

python3 manage.py runserver 0.0.0.0:8000
1

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/2023面试高手/article/detail/629653