Django 数据库的增删改查（十二）

9.2 数据库（增）

---

• 简单数据源建立

from django.db import models

# Create your models here.


class Usertest(models.Model):
    id = models.AutoField(primary_key=True)
    username = models.CharField(max_length=20)
    age = models.IntegerField(null=True, default=0)

• 数据模型初始化

makemigrations

• 数据库同步数据模型

migrate

• views.py

from django.shortcuts import render

# Create your views here.
from django.views import View
from apps.models import Usertest


class userInfo(View):
    def get(self, request):
        # 创建数据
        
        # 方法一
        Usertest.objects.create(username='小钟', age='21')
        
        # 方法二
        user = Usertest(username='小红', age='20')
        user.save()
        
       # 方法三
        users = Usertest
        users.username = '张三'
        users.age = '22'
        users.save()
        
        return render(request, 'userInfo.html')
    

9.3 数据库（删）

---

• views.py

from django.shortcuts import render

# Create your views here.
from django.views import View
from apps.models import Usertest


class userInfo(View):
    def get(self, request):
        user = Usertest.objects.get(id=1)
        user.delete()
      
        return render(request, 'userInfo.html')
    

9.4 数据库（改）

---

• views.py

from django.shortcuts import render

# Create your views here.
from django.views import View
from apps.models import Usertest


class userInfo(View):
    def get(self, request):
        
        # 更新数据
        Usertest.objects.filter(id=1).update(age='18') 		# filter(id=1) 需要先过滤出要更新的字段 相当于 where id=1
      
        return render(request, 'userInfo.html')
    

9.5 数据库（查）

---

• views.py

from django.shortcuts import render

# Create your views here.
from django.views import View
from apps.models import Usertest


class userInfo(View):
    def get(self, request):
       
        # 按条件查询
        user = Usertest.objects.get(id=1)
        
        # 查询所有
        user = Usertest.objects.all()
        print(user)
        
        # 查询记录如果没有就创建
        user = Usertest.objects.get_or_create(username='小芳', age='15')
        
        # 更新数据
        Usertest.objects.filter(id=1).update(age='18') 		# filter(id=1) 需要先过滤出要更新的字段 相当于 where id=1
      
        return render(request, 'userInfo.html')