一、首先配置orm
1、首先在settings.py中配置（數(shù)據(jù)庫需要手動(dòng)提前先建好）
注釋以下內(nèi)容（47行）
# 'django.middleware.csrf.CsrfViewMiddleware',
重慶分公司
重慶分公司
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'orm_db1',
'HOST':'127.0.0.1',
'PORT':3306,
'USER':'root',
'PASSWORD':'mariadb.123',
}
}2、在__init__.py中添加以下內(nèi)容：
import pymysql pymysql.install_as_MySQLdb()
二、在項(xiàng)目中配置
1、在models.py中創(chuàng)建用戶表與字段填寫
from django.db import models class User(models.Model): id = models.AutoField(primary_key=True) name = models.CharField(max_length=32) password = models.CharField(max_length=32) address = models.CharField(max_length=32) phone=models.CharField(max_length=64,default='120') #______________ 分割線，另做其他使用___________________________ class Publish(models.Model): id = models.AutoField(primary_key=True) name = models.CharField(max_length=32) email = models.EmailField() addr = models.CharField(max_length=64) class Author(models.Model): id = models.AutoField(primary_key=True) name = models.CharField(max_length=32) address = models.CharField(max_length=32) class Book(models.Model): id = models.AutoField(primary_key=True) name = models.CharField(max_length=32) # 21.38 price = models.DecimalField(max_digits=5, decimal_places=2) # 一對多的關(guān)系確立,關(guān)聯(lián)字段寫在多的一方,orm自動(dòng)在publish后面加id,publish_id publish = models.ForeignKey(to='Publish', to_field='id') # 多對多關(guān)系,orm會(huì)自動(dòng)創(chuàng)建第三張表 authors = models.ManyToManyField(to='Author')
1 python3 manage.py makemigrations----記錄一下數(shù)據(jù)庫的變化
2 python3 manage.py migrate----將變化同步到數(shù)據(jù)庫中
2、在總路由添加以后可能要添加的功能路由地址與對應(yīng)的視圖
from app01 import views urlpatterns = [ url(r'^admin/', admin.site.urls), url(r'^user_list/',views.user_list), url(r'^delete/',views.delete), url(r'^add/',views.add), url(r'^edit/',views.edit), ]
3、在視圖功能文件中填寫：views.py
from django.shortcuts import render,HttpResponse,redirect
from app01 import models
# Create your views here.
def user_list(request):
if request.method=='GET':
# 查詢user表中所有數(shù)據(jù).--相當(dāng)于sql select * from app01_user;
# 返回結(jié)果是QuerySet對象(先當(dāng)成列表)
# [user1,user2]
# 單表查詢所有用戶
ret=models.User.objects.all()
# print(type(ret))
# for i in ret:
# print(type(i))
# print(i.name)
return render(request,'user_list.html',{'user_list':ret})
def delete(request):
# get請求攜帶參數(shù):http://127.0.0.1:8000/deleteuser/?id=1
if request.method=='GET':
# 后臺(tái)取值:request.GET.get('id')
id=request.GET.get('id')
# orm刪除記錄
models.User.objects.filter(id=id).delete()
return redirect('/user_list/')
def add(request):
if request.method=='GET':
return render(request, 'add.html')
elif request.method=="POST":
# 前臺(tái)post提交的數(shù)據(jù)取值:
name=request.POST.get('name')
pwd=request.POST.get('password')
addr=request.POST.get('addr')
phe=request.POST.get('phone_a')
# 方式一
# user=models.User(name=name,password=pwd,address=addr)
# user.save() #寫入數(shù)據(jù)庫
# 方式二
models.User.objects.create(name=name,password=pwd,address=addr,phone=phe)
return redirect('/user_list/')
def edit(request):
if request.method=='GET':
id=request.GET.get('id')
# orm查詢單條數(shù)據(jù)
user=models.User.objects.filter(id=id).first()
return render(request,'edit.html',{'user':user})
if request.method=='POST':
id=request.POST.get("id")
name = request.POST.get('name')
pwd = request.POST.get('password')
addr = request.POST.get('addr')
phe = request.POST.get('phone_a')
# orm的修改
models.User.objects.filter(id=id).update(name=name,password=pwd,address=addr,phone=phe)
return redirect('/user_list/')4、在templates目錄中創(chuàng)建以下html文件
add.html
edit.html
user_list.html
add.html