创建项目及app
创建项目mytest
django-admin startproject mytest
进入mytest目录创建app
python manage.py startapp login
效果如图
存入mysql数据库
视图views
from django.shortcuts import render, HttpResponse
from post import models
# Create your views here.
user_list = []
def index(request):
if request.method == 'POST':
username = request.POST.get('username')
password = request.POST.get('password')
# 数据保存到数据库
models.UserInfo.objects.create(user=username, pwd=password)
# 数据库读取数据
user_list = models.UserInfo.objects.all()
print(user_list)
return render(request, 'index.html', {'data': user_list})
models
from django.db import models
# Create your models here.
class UserInfo(models.Model):
user = models.CharField(max_length=32)
pwd = models.CharField(max_length=32)
urls
from django.contrib import admin
from django.urls import path
from post import views
urlpatterns = [
path('admin/', admin.site.urls),
path('index/', views.index)
]
html文件
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>首页</title>
</head>
<body>
<h1>用户输入:</h1>
<form action="/index/" method="post">
{% csrf_token %} <!--加入这行 -->
用户名:<input type="text" name="username" /><br />
密码:<input type="password" name="password" /><br />
<input type="submit" value="提交" />
</form>
<h1>用户展示:</h1>
<table border="1">
<thead>
<tr>用户名</tr>
<tr>密码</tr>
</thead>
<tbody>
{% for item in data %}
<tr>
<td>{{ item.user }}</td>
<td>{{ item.pwd }}</td>
</tr>
{% endfor %}
</tbody>
</table>
</body>
</html>
settings设置
连接数据库
引入库
import pymysql
pymysql.install_as_MySQLdb()
配置
添加app
添加html文件路径
设置静态文件路径
数据库命令
将模型中的表同步到数据库中。
python manage.py makemigrations
python manage.py migrate