django+mysql+插入数据库网页展示内容

淡淡的烟草味﹌ 2022-06-06 08:26 185阅读 0赞

版本：Django version 1.11.6  
python：2.7

# 目录结构 #

![这里写图片描述][SouthEast]

# model #

首先，需要写model，即你需要操作的数据。

# -*- coding: utf-8 -*-
    from __future__ import unicode_literals
    
    from django.db import models
    # Create your models here.
    class message(models.Model): username = models.CharField(max_length=20) password = models.CharField(max_length=15)

# setting中添加 #

![这里写图片描述][SouthEast 1]

同时修改：

# SECURITY WARNING: don't run with debug turned on in production!
    DEBUG = True
    
    ALLOWED_HOSTS = ['*']

![这里写图片描述][SouthEast 2]

这里添加的是数据的地址，端口，用户名及密码，库名。

将下面的注释掉，防止出现错误。  
![这里写图片描述][SouthEast 3]

# 创建数据库 #

![这里写图片描述][SouthEast 4]

运行下面的命令自动创建数据库：

![这里写图片描述][SouthEast 5]

![这里写图片描述][SouthEast 6]

# views.py #

# -*- coding: utf-8 -*-
    from __future__ import unicode_literals
    from django_web import models
    from django.shortcuts import render
    
     #插入函数
    def insert(request):
        if request.method == "POST":
            username = request.POST.get("username", None)
            password = request.POST.get("password", None)
            twz = models.message.objects.create(username=username, password=password)
            twz.save()
        return render(request,'insert.html')
    
    
    #定义展示函数
    def list(request):
        people_list = models.message.objects.all()
        return render(request, 'show.html', {
       "people_list":people_list})

# insert.html #

<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>用户登录</title> </head> <body> <form action="/insert/" method="post"> {% csrf_token %} <input type="text" name="username"/> <input type="password" name="password"/> <input type="submit" value="提交"> </form> </body> </html>

# show.html #

<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> </head> <body> <h1>信息展示</h1> <table> <tr> <th>用户名</th> <th>密码</th> </tr> {% for line in people_list %} <tr> <td>{ {line.username}}</td> <td>{ {line.password}}</td> </tr> {% endfor %} </table> </body> </html>

# urls.py #

from django.conf.urls import url
    from django.contrib import admin
    from django_web import views
    
    urlpatterns = [
        url(r'^insert/$',views.insert),
        url(r'^show/$',views.list),
        url(r'^admin/', admin.site.urls),
    ]

# 运行程序 #

![这里写图片描述][SouthEast 7]

# 网页打开 #

![这里写图片描述][SouthEast 8]

![这里写图片描述][SouthEast 9]

[SouthEast]: /images/20220606/61622c4c456d46c987ead6da8032c926.png
[SouthEast 1]: /images/20220606/c536bafae26440268459cfc2948c749d.png
[SouthEast 2]: /images/20220606/5c296ecb64da4c5da7cef136cf1a48db.png
[SouthEast 3]: /images/20220606/312745fd7dc84224ac65e5562b9d13d5.png
[SouthEast 4]: /images/20220606/e7b04ca726ac469992b83e9b676bb9c8.png
[SouthEast 5]: /images/20220606/34f6f6137c3b48918cd18265b1a357b1.png
[SouthEast 6]: /images/20220606/027fcc29f8ab4965b1a716bf32806309.png
[SouthEast 7]: /images/20220606/44273173ce9645d481466f9339712ae0.png
[SouthEast 8]: /images/20220606/58cb13aba3484fc8b68f6efc65319073.png
[SouthEast 9]: /images/20220606/f45fe053b9644eb0837915e48e6595a8.png