(编辑:jimmy 日期: 2024/12/27 浏览:2)
安装源
pip install django2.2
pip install mysqlclient1.4.6
使用pyharm 创建django 项目
在settings.py中设置数据库链接
DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'km', 'USER': 'root', 'PASSWORD': 'n4', 'HOST': 'na.cc', 'PORT': '3306' } }
在settings.py里面配置好端口:ALLOWED_HOSTS = ['*']
配置语言 LANGUAGE_CODE = ‘zh-hans'
配置时区TIME_ZONE = ‘Asia/Shanghai'
设置时间 USE_TZ = False
创建APP
startapp wuzhengteng
在apps中添加 ‘wuzhengteng',
在models.py中配置数据库
from django.db import models # Create your models here. class User(models.Model): id = models.AutoField(primary_key=True) name = models.CharField(max_length=10) tel = models.CharField(max_length=11) def __str__(self): return self.name
在manage.py中执行
# 收集数据不同 makemigrations # 写入数据库 migrate # 创建超级管理员 createsuperuser
将查询写入admin
from django.contrib import admin from wuzhengteng.models import User # Register your models here. class UserAdmin(admin.ModelAdmin): list_display = ['id', 'name', 'tel'] admin.site.register(User, UserAdmin)
检查数据库是否创建成功
http://127.0.0.1:8000/admin
登入后
配置前台的用户查看界面
url路径
from django.contrib import admin from django.urls import path from django.views.generic import TemplateView from wuzhengteng import views #打开views urlpatterns = [ path('admin/', admin.site.urls), path('', views.user, name='home') # 添加指向到views ]
配置views
from django.shortcuts import render from .models import User # 连接数据库 # Create your views here. def user(request): all_user = User.objects.all() # 查询全部 return render(request, 'index.html', { 'all_user': all_user, # 将来结果返回html页面 })
前端页面
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>test</title> </head> <body> <table border="1"> <tr> <td>用户</td> <td>手机</td> </tr> {% for post in all_user %} <tr> <td>{{post.name}}</td> <td>{{post.tel}}</td> </tr> {% endfor %} </table> </body> </html>
测试访问127.0.0.1:8000
添加用户界面
配置路由 path(‘scan', views.scan, name=“scan”)
views中插入
web页面scan.htm
def scan(request): result = '' if request.method == 'POST': name = request.POST.get('name') tel = request.POST.get('tel') print(tel) db = User() db.name = name db.tel = tel db.save() result = 'success' return render(request, 'scan.html', {'result': result}) else: return render(request, 'scan.html')
web页面scan.html
<!DOCTYPE html> <html lang="en" xmlns="http://www.w3.org/1999/html"> <head> <meta charset="UTF-8"> <title>扫码登入</title> </head> <body> <div style="width: 210px;margin:0 auto"> <form method="post"> {% csrf_token %} <label for="name">姓名:</label> <input type="text" name="name" style="width: 150px"><br><br> <label for="tel">电话:</label> <input type="text" name="tel" style="width: 150px"><br><br> <input type="reset"> <input type="submit"> </form> {% if result %} <p style="text-align: center">添加成功</p> {% endif %} </div> </body>
前端抽奖界面
url中添加
path(‘luck', views.luck, name=“luck”)
views中添加
def luck(request): all_user = User.objects.all() return render(request, 'luck.html', { 'all_user': all_user, })
setting里面设置静态路径
STATIC_URL = '/static/' STATICFILES_DIRS=( os.path.join(BASE_DIR,"static"), )
前端页面