django dtl增删改查

新增

views.py
from django.shortcuts import render, HttpResponse
from test01.models import Book   //导入model中的book表

def index(request):
    book1 = Book(name='三国演义', author='罗贯中', price='100') 
    book2 = Book(name='西游记', author='吴承恩', price='200')
    book3 = Book(name='水浒传', author='施耐庵', price='300')
    book4 = Book(name='红楼梦', author='曹雪芹', price='400')
    book1.save()
    book2.save()
    book3.save()
    book4.save()
    book = Book.objects.all()
    print(book)
    return HttpResponse('ok')

models.py
from django.db import models

class Book(models.Model):
    id = models.AutoField(primary_key=True)
    name = models.FileField('书籍名称', max_length=100, null=False, default='')
    author = models.FileField('书籍作者', max_length=100, default='')
    price = models.FloatField('书籍价格', default='')

    def __str__(self):
        return "<book:({a},{b},{c},{d})>".format(a=self.id, b=self.name, c=self.author, d=self.price)

删除

from django.shortcuts import render, HttpResponse
from test01.models import Book


# Create your views here.
def index(request):
    book8 = Book.objects.get(id=8)  
    book8.delete()
    print(book8)
    return HttpResponse('ok')

常用查询

1. 根据主键进行查找：使用主键进行查找。可以使用objects.get方法。然后传递id=xx的方式进行查找

def index(request):
    book = Book.objects.get(id=7)

    print(books)
    return HttpResponse('ok')

2. 根据其他字段进行查找：可以使用objects.filter方法进行查找

def index(request):
    books = Book.objects.filter(name='三国演义', id=1)
    # book = Book.objects.all()
    print(books)
    return HttpResponse('ok')

3. 显示全部的数据，objects.all方法进行查找

def index(request):
    book = Book.objects.all()
    print(books)
    return HttpResponse('ok')

修改数据

def index(request):
    book = Book.objects.get(id=2)
    book.price = 800
    book.save()
    return HttpResponse('ok')