Title
1.输入信息，在底部输出用户输入的信息（数据存储在数据库中）
urls.py
from django.contrib import admin
from django.urls import path
from first import views
urlpatterns = [
path('admin/', admin.site.urls),
path('info/', views.show_info),
path('userInfo', views.show_userInfo),
]models.py
from django.db import models
# Create your models here.
class userinfo_table(models.Model):
name = models.CharField(max_length=64)
sex = models.CharField(max_length=64)
email = models.CharField(maviews.py
from django.shortcuts import render, HttpResponse
from first import models
# Create your views here.
# import datetime
# def show_info(request):
#
# now_time = datetime.datetime.now()
# request_content = request.method
# return render(request, 'show_info.html', {'time': now_time, 'content': request_content})
# info_list = []
def show_userInfo(request):
if request.method == 'POST':
userName = request.POST.get('name', None) # 拿到前端用户输入的数据
userSex = request.POST.get('sex', None)
userEmail = request.POST.get('email', None)
# userinfo = {'username': userName, 'usersex': userSex, 'useremail': userEmail}
models.userinfo_table.objects.create( # 向数据表中插入数据
name=userName,
sex=userSex,
email=userEmail,
)
# 从数据库中取出数据，就相当于以键值对的方式进行存储，将多条字典数据存储在一个列表中
info_list = models.userinfo_table.objects.all()
# info_list.append(userinfo)
return render(request, 'userInfo.html', {'info_list': info_list})userInfo.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<form action="/userInfo" method="post">
<p>姓名：<input type="text" name="name"></p>
<p>性别：<input type="text" name="sex"></p>
<p>邮箱：<input type="text" name="email"></p>
<p><input type="submit" name="submit"></p>
</form>
<table border="1px">
<tr>
<td>姓名</td>
<td>性别</td>
<td>邮箱</td>
</tr>
{% for info in info_list %}
<tr>
<td>{{ info.name }}</td>
<td>{{ info.sex }}</td>
<td>{{ info.email }}</td>
</tr>
{% endfor %}
</table>
</body>
</html>2.可注册，可登录，用户登录信息存放再数据库中（django）
urls.py
from django.contrib import admin
from django.urls import path
from first import views
urlpatterns = [
path('admin/', admin.site.urls),
path('info/', views.show_info),
# path('userInfo', views.show_userInfo),
path('login', views.login),
path('signIn', views.signIn),
path('firstPage', views.firstPage),
]models.py
from django.db import models
# Create your models here.
# class userinfo_table(models.Model):
#
# name = models.CharField(max_length=64)
# sex = models.CharField(max_length=64)
# email = models.CharField(max_length=64)
class id_and_pwd(models.Model):
userId = models.CharField(max_length=64)
userPwd = models.CharField(max_length=64)views.py
from django.shortcuts import render, HttpResponse
from first import models
# Create your views here.
import datetime
def login(req): # 登录
if req.method == 'POST':
user_id = req.POST.get('Id')
user_pwd = req.POST.get('Pwd')
# models.id_and_pwd.objects.create(
# userId=user_id,
# userPwd=user_pwd
# )
all_userInfo = models.id_and_pwd.objects.all()
for info in all_userInfo:
if user_id == info.userId and user_pwd == info.userPwd:
return HttpResponse('<h1>login succeed!</h1>')
return render(req, 'login.html')
def firstPage(req): # 显示首页
return render(req, 'firstPage.html')
def signIn(req): # 注册
if req.method == "POST":
user_id = req.POST.get('Id')
user_pwd = req.POST.get('Pwd')
models.id_and_pwd.objects.create(
userId=user_id,
userPwd=user_pwd
)
return render(req, 'signIn.html')login.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>login</title>
</head>
<body>
<form action='/login' method="post">
<p>ID:<input type="text" name="Id"></p>
<p>PASSWORD:<input type="password" name="Pwd"></p>
<p><input type="submit" value="submit"></p>
</form>
</body>
</html>singIn.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>login</title>
</head>
<body>
<form action='/signIn' method="post">
<p>ID:<input type="text" name="Id"></p>
<p>PASSWORD:<input type="password" name="Pwd"></p>
<p><input type="submit" value="submit"></p>
</form>
</body>
</html>firstPage.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>firstPage</title>
</head>
<body>
<h1>welcome to study kingdom</h1>
<input type="button" value='log in' onclick="login()">
<input type="button" value='sign in' onclick="sign_in()">
<script>
function login() {
window.location.href = 'http://127.0.0.1:8000/login'; // 点击跳转登录页面
}
function sign_in(){
window.location.href = 'http://127.0.0.1:8000/signIn'; // 点击跳转注册页面
}
</script>
</body>
</html>
# 数据库操作
def change(req):
if req.method == 'POST':
change_id = req.POST.get('id')
change_name = req.POST.get('after_name')
change_email = req.POST.get('after_email')
change_obj = models.UserInfo.objects.get(id=change_id)
change_obj.name = change_name
change_obj.email = change_email
change_obj.save()
return redirect('/userInfoMode/')
edit_id = req.GET.get('id')
if edit_id:
edit_obj = models.UserInfo.objects.get(id=edit_id)
return render(req, 'change.html', {'data_obj': edit_obj})3.数据库中多对多数据的查询方式
{% for book_info in book_obj %}
<tr>
<td>{{ book_info.title }}</td>
{% for author in book_info.author.all %}
<td>{{ author.name }}</td>
{% endfor %}
</tr>
{% endfor %}4.单表查询的下划线的一些方法
# 数据表结构
class Book(models.Model):
id = models.AutoField(primary_key=True)
title = models.CharField(max_length=64)
create_date = models.DateField(auto_now_add=True)
author = models.ManyToManyField(to='Author', related_name='books')
models.Book.objects.filter(id__gt=xx, id__lt=xx)
models.Book.objects.filter(id__in=[1, 2, 3, 4])
models.Book.objects.filter(id__range=[1, 5])
models.Book.objects.filter(title__contains='xx') # 字段中含有该字符串的
models.Book.objects.filter(title__icontains='xx') # 字段中含有该字符串的，不区分大小写
models.Book.objects.filter(title__startswith='xx') # 由该字符串开始的字段
models.Book.objects.filter(title__endswith='xx') # 由该字符串结束的字段
models.Book.objects.filter(create_date__day='xx') # 确定是某一天
models.Book.objects.filter(create_date__month='xx') # 确定是某一月
models.Book.objects.filter(create_date__year='xx') # 确定是某一年5.当使用orm语句执行数据库操作的时候，显示相对应的sql语句
# setting配置
LOGGING = {
'version': 1,
'disable_existing': False,
'handlers': {
'console': {
'level': 'DEBUG',
'class': 'logging.StreamHandler'
}
},
'loggers': {
'django.db.backends': {
'handlers': ['console'],
'propagate': True,
'level': 'DEBUG'
}
}
}
# django代码
import os
import sys
if __name__ == '__main__':
os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'fatal_version.settings')
import django
django.setup()
from app01 import models
ret = models.UserInfo.objects.all()
print(ret)5.ajax计算器
// .html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
{# <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no">#}
{# <link rel="stylesheet" href="/static/bootstrap/css/bootstrap.min.css">#}
{# <link rel="stylesheet" href="https://cdn.bootcss.com/font-awesome/4.7.0/css/font-awesome.min.css">#}
</head>
<body>
<input type="text" name="first_num" id="num1">+
<input type="text" name="second_num" id="num2">=
<input type="text" name="result" id="answer" value={{ res }}>
<input type="button" id="compute" value="submit">
<script class="lazy" data-src="/static/jquery-3.3.1.min.js"></script>
{#<script class="lazy" data-src="/static/bootstrap/js/bootstrap.min.js"></script>#}
<script>
$('#compute').on('click', function(){
$.ajax({
url: '/calculator/',
type: 'POST',
data: {"first_num": $('#num1').val(), "second_num": $('#num2').val()},
success: function(content){
$('#answer').val(content);
}
})
})
</script>
</body>
</html># views.py
# ajax提交(计算器)
def calculator(req):
if req.method == 'POST':
first_num = int(req.POST.get('first_num', None))
second_num = int(req.POST.get('second_num', None))
result = first_num + second_num
return HttpResponse(result)
return render(req, 'calculator.html')6.django数据库自定义表名
# models.py
class Meta:
db_table = "xxxx" # 自定义表名
